Question

Unpaid Bills Report - Past Due Days Don't Change w/ Custom Date

Forum|Forum|5 years ago
June 23, 2021
4 replies
34 views

I ran an Unpaid Bills report with a date of 06/23. One bill was overdue by 7 days. I then ran an Unpaid Bills report with a custom date of 06/29. That same bill should then be overdue by 13 days, yes? In the report, however, it is still only showing 7 days. How can I fix this so that the number of days is correct as of the date I enter?

I have tried changing the Aging Method from Current to Report Date, but it doesn't help. No amount of customization changes that 7 days to the 13 it should be.

QuickBooks Online

T

TirzahC

Level 4

Welcome to the Community. I'm here to lend a hand with the report you need for your unpaid bills in QuickBooks Online,marlenab.

Past due amounts are payments that have not been made by its cutoff time at the end of its due date. When you run the Unpaid Bills report, it should be based on the current date. Also, you'll need to toggle the aging method.

The Due Date column will show you the list of the unpaid bills depending on how to sort them.

If the issue persists and seems to act unusual, stored cache files on your browser can sometimes cause this to happen. I recommend logging in to your QuickBooks account using a private browser. This is to rule out the possibility of a webpage issue, and private browsing doesn't store local files or cache.

Use these keyboard shortcuts based on the browser you're using.

For Firefox or Microsoft Edge, press Ctrl + Shift + P.
For Chrome, press Ctrl + Shift + N.
For Safari, hold down Command + Shift + N.

If it works, I recommend go back to your regular browser and clear the cache. Also, you can use other supported browsers.

If you would like to customize your QuickBooks reports and save what you've customized, you can check these article anytime to get more tips on how to do it:

I'm also including a helpful link that highlights the basics about reports, how to run them, customize them, print them and much more.

Please don't hesitate to add a post/comment below if you have any other QuickBooks questions. I'll be always here to help you.

M

marlenabAuthor

Thank you for your suggestion, TirzahC, but clearing the cache and using a private browser did not work.

Toggling the Aging Method to Report Date and using a Custom Date of 06/29 does not change the Past Due number as it should. We do this with QBD no problem -- QBO is not giving us an accurate report, however.

We run bills on Tuesday and mail checks on Friday. We do an Unpaid Bills report as of the following Tuesday so we can catch bills that might be late due to the time it takes USPS to deliver mail.

If I run the report with a Custom Date, the number of days a bill is Past Due should change. Why else would the option to have a Custom Date exist?

If I run the Unpaid Bills report as of a week before the bill is due, there should be a negative number to show that it's early. If I run the Unpaid Bills report as of the day the bill is due, there should be a 0 to indicate that it's exactly on time. If I run the Unpaid Bills report as of a week past the due date, it should show the bill as being 7 days late.

Nothing I do, however, changes the Past Due number of days. It's always showing the number of days as of the current date, regardless of how I change the settings.

Example of the Past Due number of days staying the same is attached. You can see how the report fails to adjust the number of days "as of" the Custom Date.

Sign up

Login with SSO

Let's get you signed in

Login with SSO