[GNC] Reports on cash basis when using invoices/business functions

[flywire]

AI search summary of previous discussion:

GnuCash user mailing list thread
https://lists.gnucash.org/pipermail/gnucash-user/2025-March/115845.html
discusses cash vs. accrual basis reporting challenges, particularly for
business features like invoices/bills.

Key Comments Summary:
* OP Query: User seeks true cash-basis reports (recognize income/expenses
only on payment date) without altering accrual-ledger transactions,
frustrated by standard reports including uncleared AR/AP splits.
* Responses on Limitations: Filtering AR/AP doesn't work due to lot-links;
unpaid invoices show as income prematurely. No native "cash toggle"
exists—requires custom SQL reports or transaction edits.
* Workarounds Suggested: Use Transaction Report with filters for payment
splits only (bank-to-income on cleared lots); Advanced Reports with "Cash
Basis" options (experimental); export to CSV for Excel pivots.
* Dev Input: John Ralls notes accrual is core design; cash reporting needs
lot-query rewrite (open bug #386533). Recent 5.x changes improve filtering
but not fully GAAP cash flow.
* Consensus: Avoid business features for pure cash books; use direct
journal entries instead. Full fix requires report engine overhaul.

Thread ends unresolved, pointing to [deactivated site] uservoice for
feature votes.

Regards

>