Cash basis profit and loss

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.

  • Guest
  • Aug 11 2016
  • Future consideration
  • Attach files
  • Guest commented
    18 Sep, 2020 07:05pm

    Has this been resolved yet, I see it was from 2016 and I still don't know how to find this functionality.

  • Guest commented
    21 Aug, 2020 06:41pm

    I really need this functionality to forecast cash flow. This is an option in even the most basic quickbooks software....please add this ASAP