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

Adrien Monteleone adrien.monteleone at lusfiber.net
Mon Mar 30 17:09:10 EDT 2026


There are threads dealing with how to do this using the Business 
Features, but I don't have them handy. The workarounds rely on the 
timing of posting and running the reports. I don't recall specifically, 
but some manual entries may indeed be useful.

Regards,
Adrien

On 3/29/26 3:14 PM, flywire wrote:
> 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.



More information about the gnucash-user mailing list