Hi, I need help configuring GnuCash so I can prepare a single clean report for my tax advisor.
My setup: Two GnuCash files: One for Private finances One for Business finances Each file maps one real bank account (Assets) and its corresponding credit card (Liabilities). Transactions are categorized into expense and income accounts. For illustration, the structure looks roughly like this: Private.gnucash ├── Assets │ └── Bank Account (Private) ├── Liabilities │ └── Credit Card (Private) ├── Expenses │ ├── Leisure & Hobbies │ ├── Basic Needs (Eating Out, Health, Clothing, Groceries) │ ├── Mobility │ ├── Travel (various trips) │ └── Other Expenses ├── Income │ ├── Salary │ └── Other └── Equity Business.gnucash ├── Assets │ └── Business Bank Account ├── Liabilities │ └── Credit Card (Business) ├── Expenses │ ├── VAT │ ├── Social Insurance │ ├── Bank Fees │ ├── Freelancers │ ├── Services │ ├── Infrastructure │ ├── Marketing │ └── Travel ├── Income │ └── Client Projects └── Equity The requirement from my tax advisor: One Excel (or CSV) sheet with all income and expenditure. Flat structure only: one historical line per transaction, from 1 January to 31 December. No subtables, no grouped breakdowns, no pie charts. Just a simple ledger-style list. It must include all individual credit card transactions, not just the monthly settlement from the bank account. Why this is important: In Excel/CSV in the past, the main problem was that credit card activity collapsed into one monthly batch payment. My tax advisor cannot work with that, he needs every underlying transaction (subscriptions, groceries, travel, hotels, etc.). I expect GnuCash to solve this: the credit card liability accounts should hold all detailed transactions, and these should appear as expenses in the exported report. My question: How can I generate an Income & Expense report (or equivalent flat export) in GnuCash that: Lists all income and all expenses as one continuous table (full year). Includes all detailed credit card transactions. Can be exported as CSV/Excel for my tax advisor? Thanks in advance for any practical guidance! _______________________________________________ gnucash-user mailing list [email protected] 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.
