Paid Invoice Shows as Unpaid in the A/R Aging Report?

AaronE · ‎March 07, 2022

Hello community,
One of my clients has been charged for an invoice and payment has gone through, but it's still in my Accounts Receivable report? Everything seems successful, the payment and invoice refer to each other, and if I try to create a new "Receive Payment" with that client they have no open invoices. I've attached a combined snippit of my A/R Register (bottom image) showing that the invoice has been paid and has a $0.00 open balance, and my A/R Aging Summary (top image) showing the full amount still due.
How is it possible that a $0.00 invoice is still in my A/R Register, and why is it showing as unpaid in the Aging report?

Kevin_C · ‎March 09, 2022

I appreciate you for getting back on this thread and providing a screenshot, @AaronE. I'm here to clarify a few things for you about how the A/R Aging Summary report works in QuickBooks Online (QBO).

You'll want to make sure that the date you've set in the Report Period includes the date when you made an Invoice Payment.

If the issue persists, you can also perform some troubleshooting steps as this concern could be a browser-related issue. First, let's try accessing your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

Google Chrome: press Ctrl + Shift + N
Mozilla Firefox: press Ctrl + Shift + P
Microsoft Edge: press Ctrl + Shift + P
Safari: press Command + Shift +N

If everything is fine, kindly proceed with clearing your cache. This way, you can access QuickBooks with a clean slate. You can also switch to a different supported browser to see if that has something to do with it.

Also, can you please provide an updated screenshot for us again? This way, we can properly address your concern.

Additionally, you can refer to this article if you want to know more about how you can personalize your reports: Customize Reports in QuickBooks Online. Just in case you want to memorize the report you've customized, feel free to check out this article for the detailed steps and information: Memorize Reports in QuickBooks Online

If there’s anything else you need help with running reports in QBO, feel free to drop by in the Community space. It’s always my pleasure to assist you. Have a great day ahead and stay safe!

View solution in original post

AlexV · ‎March 07, 2022

Hello AaronE!

Thanks for reaching out to us. Let me assist you in running the accounts receivable aging report.

Although the invoice is paid, it'll still appear on your accounts receivable aging report since the report is based on the payment date. For example, if you recorded a payment on March 2 but the invoice is dated March 1, it'll show if the reporting period is until March 1 but will be removed if you run the report until March 2. Just make sure to select the correct Report period when you pull up the A/R Aging report.

I added this link if you need more help in running, customizing, and saving a report: Run reports in QuickBooks Online.

Keep on posting here and we'll respond as soon as we can. Have a great day!

AaronE · ‎March 09, 2022

Thanks for your response! The reporting period is up to date though, is there something else that could be going wrong?
The reporting period is as of today, 03/09. The payment occurred on the date the invoice was due, 03/01. I've attached a snippit of my report settings, if that helps any. I went through the same motions as payments for my other clients who are no longer showing on the report. It seems to be a unique problem between that invoice and the report.

Kevin_C · ‎March 09, 2022

I appreciate you for getting back on this thread and providing a screenshot, @AaronE. I'm here to clarify a few things for you about how the A/R Aging Summary report works in QuickBooks Online (QBO).

You'll want to make sure that the date you've set in the Report Period includes the date when you made an Invoice Payment.

If the issue persists, you can also perform some troubleshooting steps as this concern could be a browser-related issue. First, let's try accessing your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

Google Chrome: press Ctrl + Shift + N
Mozilla Firefox: press Ctrl + Shift + P
Microsoft Edge: press Ctrl + Shift + P
Safari: press Command + Shift +N

If everything is fine, kindly proceed with clearing your cache. This way, you can access QuickBooks with a clean slate. You can also switch to a different supported browser to see if that has something to do with it.

Also, can you please provide an updated screenshot for us again? This way, we can properly address your concern.

Additionally, you can refer to this article if you want to know more about how you can personalize your reports: Customize Reports in QuickBooks Online. Just in case you want to memorize the report you've customized, feel free to check out this article for the detailed steps and information: Memorize Reports in QuickBooks Online

If there’s anything else you need help with running reports in QBO, feel free to drop by in the Community space. It’s always my pleasure to assist you. Have a great day ahead and stay safe!

AaronE · ‎March 11, 2022

I figured out the problem, it had somehow set the payment date to 3/15/22 instead of the date of input (3/1/22). I'm not sure why the payment was stated to be received 14 days after payment had cleared the bank, but it looks like that was the issue. Thank you for all your help!

Topics

Training

Community

Resources

Paid Invoice Shows as Unpaid in the A/R Aging Report?