Skip to main content
K
KarlW_30
March 26, 2019
Solved

AP Aging Detail Report based on invoice date

  • March 26, 2019
  • 1 reply
  • 0 views

I have a question regarding the AP Aging Detail report. We have a vendor that, although terms are really based on 30 days per invoice date,  says we are a certain # of days past due based on the date of the invoice.

 

If I want the number of days past due on the Aging Detail report to reflect the invoice date, is changing the terms of that vendor to "Due on receipt" my best option? Or is there another alternative?

Best answer by MaryLandT

Hello there, @KarlW_30,

 

Yes, you can only show the number of days past due based on the invoice date if you use the Due on receipt term. The A/P Aging Detail report calculates the days based on when the invoice is due.

 

If you need to customize the report to see the due date column, I'll guide you through the steps.

 

Here's how:

  1. Open the A/P Aging Detail report.
  2. Click Customize.
  3. Under the Rows/Column drop-down menu, enable Due Date by putting a check mark in the box.
  4. Click Run report.

You can read through this article to learn more about customizing report: How to customize reports.

 

Keep me posted if there's anything I can help you with your QuickBooks Online account. I'm always here in the Intuit Community to help.

1 reply

MaryLandT
MaryLandTAnswer
March 26, 2019

Hello there, @KarlW_30,

 

Yes, you can only show the number of days past due based on the invoice date if you use the Due on receipt term. The A/P Aging Detail report calculates the days based on when the invoice is due.

 

If you need to customize the report to see the due date column, I'll guide you through the steps.

 

Here's how:

  1. Open the A/P Aging Detail report.
  2. Click Customize.
  3. Under the Rows/Column drop-down menu, enable Due Date by putting a check mark in the box.
  4. Click Run report.

You can read through this article to learn more about customizing report: How to customize reports.

 

Keep me posted if there's anything I can help you with your QuickBooks Online account. I'm always here in the Intuit Community to help.

W
WG494
March 3, 2020

As of 3/3/20, the QB online aging report shows the incorrect report. I ran aging report as of 1/31/20, the custom report still include the February 2020 invoices. QB please fix your issue. Thanks.

JasroV
JasroV
March 3, 2020

Hi there, @WG494.

 

Let's try to access your QuickBooks Online (QBO) account via a private or incognito window. This way, we can check if this issue is due to stored cache from the browser. Stored cache for a while can affect the performance of your QBO experience.

 

To start, here are the keyboard shortcuts to open a private or incognito window: 

  • Google Chrome: Ctrl + Shift + N
  • Internet Explorer & Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P 

If you're able to run the report without issues, then we'll need to delete the cache stored from the browser. This will prevents unusual behavior from your browser.

 

However, if this doesn't work, I recommend using another supported browser. This way, we can also check if this is a browser-related issue.

 

Also, you can check this article to learn more about customizing reports in QBO: Customize reports in QuickBooks Online.

 

I also recommend checking this great article that can guide you exporting reports to Excel: Export your reports to Excel from QuickBooks Online.

 

Should you need further assistance, you're always welcome to post here anytime. Have a great day!

Terms & ConditionsAccessibility statement