Hello, I run an external program that tracks all account balances over time, including hidden accounts. These hidden accounts always have a current balance of zero. When some transactions are missing from the export (i.e., ones that reside entirely in hidden accounts), the balance figures on these accounts are no longer accurate.
There is currently no way to export balances (current or historical), so I need to calculate them based on historical transactions and join the account tree and historical balances for analysis and reporting. I take your point that un-hiding accounts is inconvenient but feasible. That being said, since we can export the account tree to CSV for all accounts (hidden or otherwise), it seems reasonable to want to export all transactions in all accounts, regardless of hidden status, too. Best, Felix ________________________________ From: sunfis...@yahoo.com <sunfis...@yahoo.com> Sent: February 26, 2025 11:20 PM To: Felix Yu <fe...@felixyu.me> Cc: gnucash-user@gnucash.org <gnucash-user@gnucash.org> Subject: Re: [GNC] Hidden Account Transactions Export Felix, I would expect the behavior that you describe. Transactions have at least two entries in double entry accounting. If you've selected an account with a transaction that links to a hidden account, not showing that transaction would leave holes in the report. One thing: why it is you have active transactions that interact with hidden accounts? The use cases I know for hiding accounts only involve accounts that are no longer active-- for example, a closed account. Once hidden, such an account is no longer intended for active use. Transactions between visible and hidden accounts would seem to contradict this. Alternatively, I ask why it is you "regularly" export these transactions? Again, once an account is no longer in use, I can't see why you need to regularly access the data in those accounts. Third, why is un-hiding accounts not feasible? It may be inconvenient, but it is not "unfeasible." I will note that you can add the hidden attribute as a checkbox to the Chart of Accounts page, which you can use to quickly change this setting for any account. Just be sure to change the View setting to show hidden accounts. David T. On Feb 26, 2025, at 11:42 PM, Felix Yu <fe...@felixyu.me<mailto:fe...@felixyu.me>> wrote: Hello, I regularly use the Export Transactions to CSV function in GNUCash for financial analyses on other platforms. My standard work flow is as follows: 1. Choose Export Settings (Options: Use Quotes - unchecked, Simplified Layout - unchecked; Comma separator) 2. Account Selection - Select All accounts; Select All dates However, I am noticing some strange behaviours around hidden accounts, specifically: * When exporting transactions, hidden accounts are not selectable, but their transactions appear if split with non-hidden acounnts. However, transactions entirely within hidden accounts are not exported at all * I understand that un-hiding accounts resolves the issue, however, that may not be a feasible solution and goes against the purpose of hiding accounts (presumably for clutter management) * Is there a way to work around the issue? Is it possible to add a "Select All, Visible and Hidden" button on the Account Selection page (given the Select All accounts button is more like, Select All Visible accounts as of now) Thank you! ________________________________ 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. _______________________________________________ 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.
