cancel
Showing results for 
Search instead for 
Did you mean: 
KarlW_30
Level 3

AP Aging Detail Report based on invoice date

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?

Solved
Best answer March 26, 2019

Best Answers
MaryLandT
Moderator

AP Aging Detail Report based on invoice date

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.

View solution in original post

5 Comments 5
MaryLandT
Moderator

AP Aging Detail Report based on invoice date

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.

WG494
Level 1

AP Aging Detail Report based on invoice date

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
QuickBooks Team

AP Aging Detail Report based on invoice date

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!

SusyC
Level 1

AP Aging Detail Report based on invoice date

What if you are using the app? I am having a similar issue. Days past due are not reflecting correctly in the AP aging detail report. How do I fix this? 

 

MichelleBh
Moderator

AP Aging Detail Report based on invoice date

Thank you for joining on this thread, @SusyC.

 

Let's get your mobile app up and running by resetting the QuickBooks Application. This is the same as clearing the cache from your web browser. Let me guide you on how:

 

For Android device:

 

  1. From More Options, then select the Settings tab. 
  2. Choose the Refresh Data menu.
  3. Hit Yes

 

For iOs: 

 

 

  1. Go to the Help menu.
  2. Select Reset App Data.
  3. Click OK.

 

After that, please re-access the AP aging detail report to verify if it's already performing well. If the issue keeps going, let's uninstall and reinstall the app. To uninstall, please touch and hold the app, then click the Delete app button or Uninstall tab. Nothing to worry about uninstalling the app because it won't delete the transactions and subscriptions you have. 

 

Once done, you can now reinstall the app. For the detailed steps, please check this article: How to download the QuickBooks Online mobile app.

 

To know more about the features available using the mobile app, check out this link: GET HELP.

 

Don't hesitate to leave a comment below if you have a follow-up question in your account. I'm always here to help. Keep safe. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us