Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
T_Brunt
Level 1

Clearing Old Receivables Balances

I've noticed that my aging reports have a credit balance opened in the 90 day or older column. I've attached a screen shot. I went to check a Payment (type) that was posted 3/12/21 for $0.64 cents and found it on a journal entry. I created an invoice on 9/26/22 to apply the credit to and it is not giving me the option. Instead, when I click on apply credit, the 0.64 cents was not available. It was originally listed as leave the credit to be used later. Do I need to reverse that somehow?

 

3 Comments 3
KlentB
Moderator

Clearing Old Receivables Balances

I'll guide you in clearing the receivables, T_Brunt.

 

Linking the journal entry to the invoice will help reduce the remaining customer balance. But before you can do this, you'll want to make sure that the affected account of the journal entry is Accounts Receivable. This way, the amount will show how once you apply it to the invoice. Here's how:

 

  1. Go to the Lists menu.
  2. Choose Chart of Accounts, then locate the account holding the journal entry.
  3. Open the transaction, then make sure that the affected account is Accounts Receivable.
  4. Click Save & Close when you're done.
  5. Go to the Customers menu, then select Receive Payments.
  6. Pick a customer from the Received from drop-down menu.
    Click the Discounts and Credits icon, then select the journal entry in the Available Credits section,
  7. Hit Done, then select Yes if you see a prompt to confirm the transfer. 
  8. Select Save & Close.

I'm also adding this article to help manage your credit memo or refund checks in QuickBooks Desktop: Give your customer a credit or refund.

 

Visit the Community again if you need additional assistance in dealing with your other customer transactions. Looking forward to answering more questions from you. Have a great day!

T_Brunt
Level 1

Clearing Old Receivables Balances

I tried the steps provided and it didn't work. I'm not sure the AR account I need is active. It's listed under Pharmacy Customer Other but I don't see that under a code on the COA.

AbegailS_
QuickBooks Team

Clearing Old Receivables Balances

Hi there, @T_Brunt.

 

I appreciate you for trying out the steps that my colleague provided and for providing some updates. I'm here to add some information that can help you clear your receivables.

 

The account receivable used may be inactive. That's why credit wont show. If so, it will create a journal entry then QuickBooks will move it to another account while the remaining transaction will stay in the financial report.

Clearing Accounts Receivable (A/R) can be a little tricky. I'd recommend reaching out to your accountant to ensure that everything is recorded accurately and to avoid messing up your accounting data.

 

If you're not affiliated with one, you can utilize our Find an Accountant tool to look for one in your area. 

 

For more details about writing off vendor balances, feel free to read this article: Write off customer and vendor balances

 

Moreover, I’ve added this helpful resource for future reference in case you’ll want to write off bad debt in QBDT: Write off bad debt in QuickBooks Desktop

 

Feel free to keep me posted on your progress with clearing off balances in QuickBooks Desktop, or if you need anything else with QBDT-related tasks. I'm determined to help you succeed. Keep safe always.

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

Need to get in touch?

Contact us