Skip to main content
May 27, 2020
Question

Cash basis - why do credit memos show up as negative income if the original invoice never showed up in income?

  • May 27, 2020
  • 2 replies
  • 0 views
Using the cash basis of accounting, invoices do not show up in income until payment is received. If I write them off using a credit memo (because I won't receive payment), the credit memo is giving me a negative income on the profit & loss statement. This doesn't seem correct. Should I write the invoices off using a different method?

2 replies

MaryLandT
May 27, 2020

Hello there, mindy14,

 

I'm here to clear things out for you about writing off bad debt in QuickBooks Online.

 

Credit memos will show up as negative income if you're using the same item on the invoice. You need to create a bad debt item and use expense account to track uncollectible receivable. This amount will appear on the Profit and Loss report under the Bad Debts expense account.

 

Hence, there are four steps you need to consider when recording bad debts:

 

Step 1: Create a bad debts expense account

  1. Go to Settings ⚙, select Chart of Accounts.
  2. At the upper right, click New to create a new account.
  3. From the Account Type ▼ drop-down menu, click Expenses.
  4. From the Detail Type ▼ drop-down, select Bad debts.
  5. In the Name field, enter “Bad debts.”
  6. Click Save and Close.

Step 2: Create a bad debt item

  1. Go to Settings ⚙, choose Products and Services.
  2. At the upper right, select New, and then Non-inventory.
  3. In the Name field, enter “Bad debts.”
  4. From the Income account ▼ drop-down, select Bad debts.
  5. Click Save and Close.

Step 3: Create a credit memo for the bad debt

  1. Click + New.
  2. Select Credit memo.
  3. Select the customer from the Customer ▼ drop-down.
  4. In the Product/Service section, select Bad debts.
  5. In the amount column, enter the amount you want to write off.
  6. In the Message displayed on statement box, enter “Bad Debt.”
  7. Click Save and Close.

Step 4: Apply the credit memo to the invoice

  1. Select + New.
  2. Under Customers, select Receive payment.
  3. From the Customer ▼ drop-down, select the appropriate customer.
  4. From the Outstanding Transactions section, mark the invoice.
  5. From the Credits section, mark the credit memo.
  6. Click Save and Close.

Once done, you can run an Account QuickReport to check all the receivables you tagged as bad debt. Here's how:

  1. Go to Settings ⚙.
  2. Select Chart of Accounts.
  3. In the Action column of the bad debts account, select Run report.

In case you want to get a QuickBooks-certified bookkeeper, check out the QuickBooks Live Bookkeeping page. They'll help categorize transactions and reconcile your bank statements every month so your books are always 100% accurate.

 

Should you need anything else, don't hesitate to comment below. I'm always around to help.

 

Thank you and stay safe!

February 21, 2022

My problem is the opposite.  I want to write off a customer invoice that we are sending to collections.  I did exactly what you said to do and I when I run the profit and loss report is shows up as income.  We never collected this money so I don't think it should show up as income.  What am I doing wrong

February 21, 2022

Hi there, @Jennut77.

 

Thank you for reaching out to us and following the steps provided by my colleague. I can help you more in recording the bad debt.

 

You have to make sure to select an expense account when creating bad debt. This is for the credit memos not to be under income.

 

If you've already verified the account type and the P&L report is still showing wrong information, I'd recommend reaching out to your accountant. Since all businesses are unique, they can ensure the correct account is used and to provide additional guidance.

 

Here's an article you can read for more details: Write off bad debt in QuickBooks Online.

 

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

I'm still here to help you further if you have additional question about bad debt. Just click the "Reply" button or mention my name. I'll wait for your response.

January 5, 2024

Hi Mindy, I am having the same problem and confused because not accounting expert. We are receiving statements on a cash basis and they are being negatively impacted by the use of credit memos to pay current invoices. This does not involve bad debt. Did you find a way to show the credit memo income somehow on the cash statements. If I go to accrual, it does not fix it, which is odd to me. Thx.