Skip to main content
January 25, 2023
Question

How to clear accounts receivables from prior years in QB Desktop

  • January 25, 2023
  • 2 replies
  • 0 views

I have a new client and the database has a problem with the Accounts Receivables.  The Balance Sheet and the AR Summary do not tie.  There are entries going back as far as 2008 that should not be on the books.  Several of these are caused by CC Refunds however those are showing up as if the customers have unpaid invoices rather than credits.  The account that was selected in the CC Refund screen was Undeposited Funds and the AR Account is Accounts Receivable.  What I would have expected to happen was this to generate a credit in the system that was then applied to an outstanding invoice.   That should have cleared the account however the Credit Card Refund was created and a Credit Memo on the same day for the exact same amount.  I can not figure out how the AR Aging show that this customer still owes money rather than a credit balance?   Furthermore, not only do they not owe these funds I need to get it cleared off the ledger without causing issues in the present day.   I am attaching one example of the AR Summary Balance line, then I selected the entry that is the second part of the PDF and the last part is the Customer transaction page so you can see what I am seeing.  I have been on the phone with the accountants hotline and they are at a loss as well.  Anyone come across this and figure out how to fix this issue? 

2 replies

January 26, 2023

Hi there, FMB01. 

 

Let me share with you some information about clearing Accounts Receivables in QuickBooks Desktop (QBDT).

 

if you're seeing customers with net zero balances, it is usually caused by an invoice that's not linked to payment or credit. To apply for the credit, here's how:
 

  1. Click the Customers tab, then Receive Payments.
  2. Enter the customer name in the Received From drop-down.
  3. In the Payment Amount field, enter the payment you received from the customer.
  4. Press the More button, then Add New Payment Method button.
  5. Set up your payment method then click OK.
  6. Mark the invoices you want to receive the payment.
  7. Hit Save & Close.

 

However, if no payments aren't showing, you'll need to record them as bad debt and write them off.  

 

Here's how to add an expense account to track the bad debt:

 

  1. Go to the Lists menu.
  2. Select Chart of Accounts.
  3. Click the Account menu at the bottom left, then select New.
  4. Select Expense, then Continue.
  5. Enter an Account Name. 
  6. Click Save and Close.

 

Once done, we can start over to close out the unpaid invoice. 

 

  1. Go to the Customers menu.
  2. Select Receive Payments.
  3. Enter the name of the customer in the Received field.
  4. For the 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 bad debt account, and select Done.
  8. Click Save and Close.

 

Feel free to use this link on how to record common customer transactions in QuickBooks Desktop

 

I'll be here if you have other questions about handling your sales transactions in QuickBooks. I'll be here to help. Have a good one!

FMB01Author
January 26, 2023

These are not zero balances on the AR Summary.

January 26, 2023

I appreciate you posting back to the thread, @FMB01.
 

I'd like to know if the suggested processes above were able to help you with clearing accounts receivable from prior years or if you have clarification or any other concerns to assist you further.
 

I'll be waiting for your reply. Take care, and have a good one!

Rainflurry
January 26, 2023

@FMB01 

 

If you double-click on the $350.00 on the A/R Aging Summary, then double-click on one of the entries on the A/R Aging Quick Zoom Report, it will pull up the A/R ledger for that customer so you can see where the $350 A/R debit balance comes from.  

FMB01Author
January 26, 2023

Yes, that is how I determined these were caused by a Credit Card Refund.  This does not help me correct and clear the receivables.