[GNC] Exporting transactions to CSV

[Stellios & Sally]

@ 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 <wm at ilipsis.net> 
Sent: 12 March 2026 15:29
To: Stellios & Sally <sz.sdz.077 at gmail.com>; 'David Carlson' <david.carlson.417 at gmail.com>
Cc: gnucash-user at 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.417 at gmail.com>
> Sent: 11 March 2026 23:22
> To: Stellios & Sally <sz.sdz.077 at gmail.com>
> Cc: gnucash-user at 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.077 at gmail.com <mailto:sz.sdz.077 at 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 at gnucash.org <mailto:gnucash-user at 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.
>
>
>
>
>