Skip to main content
June 1, 2025
Question

Cash Basis profit and Loss

  • June 1, 2025
  • 2 replies
  • 0 views

When I enter a journal entry for bad debt (an Invoice not paid by the Client), it still appears on the Cash basis profit and loss statement, which it should not.


Can someone help me with how to command QuickBooks to exclude JEs from getting into the Cash Basis Profit Loss. 

2 replies

June 1, 2025

Let me provide you with insights into why bad debt is being recorded in the cash basis Profit and Loss (P&L) report, JayP3.

 

When you record bad debts in a journal entry (JE) as an expense, it appears in the P&L statement because it represents a loss from uncollectible accounts that reduces your net income.

 

This happens because the bad debt expense reflects the amount of revenue that was initially recognized but is now considered uncollectible, so it must be matched with the related revenue in the same period to comply with the matching principle in accounting. P&L reflects all recognized expenses at the point of their entry, meaning anything recorded as an expense like writing off a bad debt using a JE will appear, even if you haven’t paid any cash.

 

You can export your reports to Excel if you want to use them outside of QuickBooks: Export your reports to Excel from QuickBooks Online.

 

If you have further questions about QBO, please return here. We're ready to assist you.

BigRedConsulting
June 1, 2025

@JayP3 

RE: When I enter a journal entry for bad debt (an Invoice not paid by the Client), it still appears on the Cash basis profit and loss statement, which it should not.

 

Why do you think it should not appear? Note that a cash basis P&L is not a cash flow report. It will include many things that are not actual cash, such as accrued interest, depreciation of assets, and so on. The only difference between an accrual P&L and a cash-basis P&L is how A/R and A/P activity is treated.  All financial activity that uses income/expense type accounts (those that appear on the P&L) contained in all other balance sheet accounts types is included.