Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 12, 2020
Question

Removing Old Vendor Invoices/Credit Memos

I have discovered some old vendor invoices and credit memos from prior years that I know have been paid and or used on the vendor side of the equation. The accountant prior to me did not keep track of what was paid and used very well at all. The result is I have many open invoices and credit memos from prior years in my QuickBooks that don't belong there.

 

I was thinking about creating one large credit memo to removed all the invoices at the same time. However because they are from prior years I am nervous if this would impact our prior years tax returns?  I know I don't want to delete or void them since they are from a prior year, so I am trying to figure out the best, cleanest way to handle them. 

 

As far as these old credit memos from prior years are concerned I really don't know what to do with them since I don't want to delete or void them either and mess up our prior years tax returns.  I guess I could create a fake vendor invoice in the amount of all these credit memos and apply them all to it?

 

Thanks for all your input!

9 replies

MaryLurleenM
Level 6
June 12, 2020

You'll want to write them off as bad debt, Txroofer.

 

Writing off a bad debt ensures your accounts receivable and net income stay up-to-date. This is when you're unable to collect the fees.

 

Let me show you how it works in QuickBooks Desktop:

 

Step 1: Add an expense account to track the bad debt

  1. Click Lists on the menu.
  2. Select Chart of Accounts.
  3. Select the Account menu and then New.
  4. Select Expense, then Continue.
  5. Enter an Account Name, for example, Bad Debt.
  6. Select Save and Close.

Step 2: Close out the unpaid invoices

  1. Click Customers menu.
  2. Select Receive Payments.
  3. Enter the name of the customer in the Received from field.
  4. For Payment amount, enter $0.00.
  5. Select Discounts and credits.
  6. In the Amount of Discount field, enter the amount you'd like to write off.
  7. For Discount Account, select the account you added in step 1, and select Done.
  8. Select Save and Close.

You'll want to run the  Accounts Receivable Aging Detail report after to check the customer's open balances.

 

Let me know if you need anything else.

TxrooferAuthor
June 14, 2020

I am talking about invoices from vendors not to customers. 

December 9, 2021

I know this question is old, but perhaps I can provide a different scenario.  Back when I didn't realize what I was doing, I deleted vendor invoices that had payments already applied against that invoice.  QB doesn't understand when you do this, so guess what happens?  It is no longer applied as an expense, but it remains as a "floating credit" against your accounts payable.  So let's say your A/P on your balance sheet says your balance is $35,000.  Your "vendor bill" section says $40,000. But then you see on your Vendors List under "vendor center" a negative balance from a vendor for $5,000 from 3 years ago (let's say).  Well, it's negative 5,000 because you know for a fact you paid that vendor 3 years ago. When you click on that vendor info to see why the balance is (5,000) you realize that it has a "Bill Pmt" but there is NO BILL to offset that payment because it was DELETED.  You have to re-create that bill for whatever current tax year you are in, because you never actually expensed it the year you were supposed to!  And you can't create the bill for the year it actually belonged because it's too late, the taxes were already done and it wasn't actually accounted for.  

 

Create a Journal Entry for the current tax year, DEBIT the amount of the credit for whatever the expense was supposed to be,  then on the credit side, you will choose "Accounts Payable" and then make sure you apply it against the vendor it originally belonged to. Finally, you will go back to VENDOR PAY BILLS, now you will see the bill from the JE you just made, and you will "apply the credit" that had been floating.  Now that floating credit/negative balance will be gone and that reduces your income for the current year since you never actually used it the previous year.  

 

If you still see a difference with the balance sheet AP balance and the Vendor Bill Section, run a report on the AP in the balance sheet section for ALL dates and sort by VENDOR.  If you see vendors with negative balances, there is another solution to Re-create or create invoices for Payments previously made to those vendors.  

Attorney/Accountant for 15 years, using QB for 15 years.  Hope this helps and makes sense! PS: I use the accrual method.