Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
junius1
Level 1

Cash Basis P/L includes discounted/written off Invoices in Sales line

Why do discounted/written off invoices appear on sales in the P/L Report under cash basis accounting in Quickbooks Desktop?

 

We have uncollectible invoices and I have written off these invoices by discounting the invoices charging it to bad debt. When I generate the P/L Statement under cash basis, these invoices appeared in the Sales line item.

 

How to generate a P/L report that does not include these written off/discounted invoices?

 

Thanks for the help!

1 Comment 1
Rainflurry
Level 15

Cash Basis P/L includes discounted/written off Invoices in Sales line

@junius1 

 

"We have uncollectible invoices and I have written off these invoices by discounting the invoices charging it to bad debt. When I generate the P/L Statement under cash basis, these invoices appeared in the Sales line item."

 

Since cash basis accounting does not have bad debt, when you write off an invoice to bad debt, the invoice is getting paid and that books the income and the corresponding bad debt expense as of the date you apply the credit memo on cash basis.  So, you can either zero out the invoice (take a screenshot if you want and attach it to the zeroed out invoice in case the customers pays at a later date) or create a credit memo that zeros out the invoice by mapping the items on the credit memo to the same accounts as the invoice.  Be careful not to put any inventory items on the credit memo as that will put them back into inventory.  Or, if you want to preserve the invoice, you can continue doing it the way you're doing it and make an adjusting journal entry at period-end to reduce income and the corresponding bad debt expense.      

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us