cancel
Showing results for 
Search instead for 
Did you mean: 
marlenab
Level 1

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

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.  

4 Comments 4
TirzahC
QuickBooks Team

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

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.

marlenab
Level 1

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

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. 

marlenab
Level 1

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

Please see attached for a visual of the problem I'm having with QBO. 

 

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

 

We're switching to QBO and it does not give correct information when entering custom dates like QBD did.  I need to know how I can fix that. 

 

Clearing the cache did not change the report at all.  Toggling the Aging Method either way did not produce a change either.

 

If I run an Unpaid Bills report as of a week before a bill is due, the Past Due number of days should be negative to show that the bill is early.  If I run the report as of the actual due date, the Past Due number of days should be zero to show it's on time.  If I run the report as of a week after the due date, the Past Due number of days should be 7 to show that it's late.

 

No amount of customization, however, changes the number of Past Due days.  It always reports the number of days as of the current date.  Why have the ability to choose a Custom date if the report will only ever show the Past Due as of the current date?  

AlcaeusF
Moderator

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

Hi @marlenab,

 

I know how beneficial being able to track the bill past dues accurately in the Online version. Allow me to chime in and share some information about the capability of the report in QuickBooks Online.

 

The Custom report period is only applicable to the create date of your transactions. Bills entered prior to the date you set in the report will not be included.

 

Also, the Past Due column is working as designed in the Online version. It calculates the figures based on the bill date of the transactions up to the current date. The aging method options won't affect this column as well.

 

Though, it would be beneficial to have a report same in the QuickBooks Desktop version, too. Our engineers might be working to bring this feature over to this platform in the future.

 

As we asses, I recommend sending feedback directly to our product engineers. This way, they can review the feedback and check if it's possible to follow the same setup in Desktop.

 

Here's how:

 

  1. Click the Gear icon in the upper-right corner.
  2. Select Feedback under Profile.
  3. Enter your feedback.
  4. Hit Next1.JPG

 

I've also attached an article you can use to know how to export and email reports in QuickBooks: Run reports in QuickBooks Online.

 

Drop me a comment below if you need further assistance with the information you need to extract from QuickBooks Online. Have a great day.

Need to get in touch?

Contact us