Re: [GNC] Exporting transactions to CSV

[Wm Tarr]

I question the value of a TB in modern accounting systems where every 
transaction is balanced anyway.  It isn't like you need the figures to 
create your balance sheet or anything purposeful.  I doubt anyone that 
has many currency tx uses the TB as they throw it out.

Wm
On 2026-03-12 17:39, Stellios & Sally wrote:
@ Wm
I hope you are right. I will check Bugzilla. Even if you are right, trial 
balance errors are disconcerting because the Cr/Dr difference is carried 
forward. If that difference changes over time I'm left wondering if there is 
another inconsistency in my accounts or another TB error.

-----Original Message-----
From: Wm Tarr <w...@ilipsis.net>
Sent: 12 March 2026 15:29
To: Stellios & Sally <sz.sdz....@gmail.com>; 'David Carlson' 
<david.carlson....@gmail.com>
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Exporting transactions to CSV

The chances are there is nothing wrong with your transactions other than that 
the TB report doesn't understand them.  To be clear the problem is almost 
certainly the Trial Balance report. If you have access to bugzilla (I don't) 
there is a ton of history about it in there.

Wm

On 2026-03-12 00:43, Stellios & Sally wrote:
Thanks for your comment. You are correct – they preserve the integrity of 
double entry accounting for multi-currency and securities accounts. I also 
agree that there is generally no need to export those transactions.

   

I use several currencies and hold overseas investments traded in those 
currencies. Therefore, I need to record transactions and holdings of securities 
in foreign currencies along with their local GBP value. Therefore, I depend 
upon the trading accounts; the integrity of my accounts is critical.

   

I have several trial balance errors in my accounts and the offending 
transactions involve currency and investment transactions. There is no 
imbalance in the offending journals, even so the errors remain with no obvious 
remedy. I was hoping that by exporting and examining the trading transactions 
more closely I could then identify and correct the errors.

   

GNC does more than financial accounting for money amounts. It also provides an 
inventory management and accounting for non-currency investments, for example, 
stocks and mutual funds. Whilst the monetary value of those investments appears 
in the security and brokerage accounts, GNC doesn’t appear to offer a “trial 
balance” of the holdings.

   

I hope this helps to explain my requirement for trading data.

   

From: David Carlson <david.carlson....@gmail.com>
Sent: 11 March 2026 23:22
To: Stellios & Sally <sz.sdz....@gmail.com>
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Exporting transactions to CSV

   

Trading accounts do not contain any significant information  that is not 
already in the underlying security and brokerage accounts.  In fact, they are 
just a restatement of that data so there is no need to export them.

   

On Wed, Mar 11, 2026 at 6:09 PM Stellios & Sally <sz.sdz....@gmail.com 
<mailto:sz.sdz....@gmail.com> > wrote:

Hi folks



I am exporting my entire accounts data to CSV with the following steps:



1.      File > Export > Export Transactions to CSV
2.      Custom ex[port settings > Comma
3.      Account Selection: All accounts selected with all dates selected
4.      Etc



GNC then generates the CSV transaction file. However, the file omits all
Trading accounts and their entices even though I selected those accounts.
Can someone please tell me how to export Trading transactions.



I'm using GNC 5.14 build 2025-12-20; Windows 64-bit



Thanks

_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.