Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
AJ68
Level 1

AP Aging

We paid an invoice due on 3/1 on 2/15. When I ran the AP aging report for month-end close on Friday, 3/4 the AP aging wasn't reflecting this negative amount for the payment made prior to the due date. I noted the difference between AP aging and AP balance on the GL as reconciling item.

However, when it was reviewed on Monday, 3/7 AP aging started reflecting this invoice amount as negative amount in 1-30 days column. 

I am curious what happened and if I am missing something. 

1 Comment 1
Rea_M
Moderator

AP Aging

You're on the right track in pulling up the A/P Aging report in QuickBooks Online (QBO), @AJ68. I'm here to share further details as to how the said report provides the data you need and manage your transactions accordingly.

 

A/P Aging (Summary and Detail) reports will display your unpaid bills, grouped by days past due. They won't include bills with a Paid status. While they may seem unable to reflect the negative amount of the payment you made before the due date, the said report is still correct because the bill (paid invoice) is no longer open.

 

If necessary, you can customize the A/P Aging report to the As of Report Date and the Days per aging period info. This way, the report will provide the data you need. I've attached a screenshot below for your reference.

 

 

Also, to further guide you in getting your Aging reports to match with your financial data (Balance Sheet and Trial Balance) in QBO, I'd recommend checking out these articles:

 

 

Let me know in the comments if you have other reporting (A/P Aging) concerns and questions about managing expense transactions in QBO. I'll gladly help. Take care, and I wish you continued success, @AJ68.

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

Need to get in touch?

Contact us