Skip to main content
October 28, 2023
Question

Unapplied payments that appear in accounts receivable aging report

  • October 28, 2023
  • 2 replies
  • 0 views

I am stuck and wondering how to fix a problem. Here is the situation I found in the books.  Accounts receivable aging shows a negative number for a customer who made a purchase back in 2022.  It appears to be an unapplied payment.  When I look at the customer account detail, the invoice was issued in September and still shows past due, but does not appear on the account receivable aging.  The payment was processed in December but shows in the customer account detail as unapplied. The customer account balance is zero.  The payment does appear in the accounts receivable aging.  When I open the payment and try to apply it to the invoice, I cannot seem to get the open invoice to appear so I can check the box and apply it.  For reference, the payment occurred in Deposited Quick Book payments and was correctly transferred as a deposit to the business owners checking account.  I would sure appreciate any guidance.  Thank you.

2 replies

October 28, 2023

Thank you for posting here in the Community, RK68.

 

Can you share more details about your concern? We just want to make sure that we're giving you the right steps and information to sort this out.

 

It would be greatly appreciated if you could provide a screenshot of your accounts receivable aging report, along with any relevant information on bill payments and invoices.  

 

Keep me updated in the comments below. Hope to hear from you soon. Take care always!

Rainflurry
October 28, 2023

@RK68 

 

When you go to Receive Payment (New > Receive Payment), do you not see the invoice under Outstanding Transactions and the unapplied payment under Credits?  That is where you should be able to apply the payment to the invoice. 

 

If not, go to the invoice and run a Transaction journal report (More > Transaction journal).  Is there an A/R debit for the invoice total?  

RK68Author
October 29, 2023

Thank you for reaching out on my question! Do not see the invoice number to apply to, and system will not bring up open invoice when I search.  Transaction journal shows debit to undeposited funds and a credit to accounts receivable.

Rainflurry
October 29, 2023

@RK68 

 

"Transaction journal shows debit to undeposited funds and a credit to accounts receivable,"

 

Are you sure that's the transaction journal for the invoice?  That looks like the journal for the payment.  An invoice should have a debit to A/R, not a credit.