The problem I have with gnucash is handling over data to an accountant to do yearly tax etc... for a small business.
I have written https://github.com/dorfsmay/gnucash_general_journal and it help somehow but it still is a lot of work for them and can be confusing if they're not willing to spend the time on it + time they spend is money they charge me.
I plan to change this to output to OFX sheets separating the different accounts, hoping it helps.
I'm surprised there are no standard for accounting data and would love to hear from accountants what would help them importing data in their systems.
Assuming you have posted everything to the correct accounts, the Trial Balance should be all they need. (Trial balance is a summary of the total on each account - checking that it sums to 0 is the key advantage of double entry book keeping.) If it doesn't, then perhaps the account structure isn't granular enough?
For the report you use, why don't you send a traditional general ledger and let them pivot it in excel by account (columns) and transaction number (rows)?
I have written https://github.com/dorfsmay/gnucash_general_journal and it help somehow but it still is a lot of work for them and can be confusing if they're not willing to spend the time on it + time they spend is money they charge me.
I plan to change this to output to OFX sheets separating the different accounts, hoping it helps.
I'm surprised there are no standard for accounting data and would love to hear from accountants what would help them importing data in their systems.