GNOME Bugzilla – Bug 739188
Export to CSV omits Liability accounts
Last modified: 2018-06-29 23:35:33 UTC
Created attachment 289330 [details] shows the chart of accounts behind the CSV export dialog File; Export; Export Transactions to CSV; Forward; Liability/Equity; expand the Liabilities list. The list of sub-accounts shown should include four but omits the third, So it inlcudes the GST Collected account but not GST Paid account. The only difference I can see between these two is that GST Collected is of Account Type A/Payable whereas GST Paid is of Account Type A/Receivable. Otherwise, they are in the same place in the accounts tree, and its unclear to me why GST Paid would not be included in the Liabilities list. Just for clarity, the GST Paid account also does not appear in the sub-accounts under Equity, nor any of the lists you can browse if you select the Asset, Income or Expense radio buttons instead of the Liability/Equity radio button.
I can duplicate this but am not sure it is a bug, from the code, Liability/Equity lists contains the following :- ACCT_TYPE_CREDIT, ACCT_TYPE_LIABILITY, ACCT_TYPE_EQUITY, ACCT_TYPE_PAYABLE Under Asset you should find ACCT_TYPE_RECEIVABLE so it would appear that your 'GST Paid' account should be under an assert type account. This code can also be found in the dialog-tax-info.c source file. I am no financial expert and can not comment on whether your account structure is correct but might be worth asking on the user list or await someone else to comment on this bug. Also be aware that when you are exporting the transactions, you will end up with multiple rows per transaction and may require further manipulation to get them in a format you can use.
A/Receivable is not a liability, it's an asset. So strictly speaking this is not a bug. However looking at your screen shot and considering your use case it looks like the csv export assistant would be even more useful if you could select multiple account classes at once instead of only one. That is if you could indicate you want to export asset accounts *and* liability accounts in one go. The most elegant solution would probably be to replace the radio buttons with check boxes so a user can select more than one class during export. Coding wise this would require a check that at least one class is selected and the take the union of account types selected to display the accounts.
(In reply to comment #2) > A/Receivable is not a liability, it's an asset. So strictly speaking this is > not a bug. Thanks Geert, but please note that I could not find GST Paid under the Assets either. It should be in one place or the other!
Created attachment 294859 [details] [review] Remove the Account type filter This patch removes the account type filter so that it make it much easier to export different account types at the same time. This may need to be applied after the export patch in bug 738462
Committed to master. Thanks for the patch Bob.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=739188. Please update any external references or bookmarks.