Please make it possible for system to generate cash basis profit and loss. With the database, it should be possible to exclude AP, and AR, and unearned revenue accounts and related entries.
Current solution is to use cash receipts query and cash payments query to generate two excel files of cash activity. Excel file then uses formulas to combine amounts by account and date, for month and YTD columns.
Drawbacks so far:
that journal entries cannot be used to correct receipts or payments. Changes must be in Cash receipts or Accounts payable modules in order to have the queries correct.
that deposits cannot be voided
that deposit (payments) cannot be zero, or negative (no negative because the query doesn't differentiate positive or negative amount as that is set by the debit or credit classification on entry)
I use a one cent deposit to correct errors on deposits. Invoice payments can be voided and corrected normally.