Right now when I pull the average days to pay report it shows me everything. Assuming that because their is a 'paid date' column I figured I would be able to filter that to a specific month - however every attempt at that does not produce the right information. Any ideas how to achieve this?
I see this is your first question so let me take the time to welcome you here to the Intuit community, @aheftler.
I can help walk you through filtering the Average Days to Pay report to a specific month in QuickBooks Desktop (QBDT).
1. On that report, click Customize Report at the upper left.
2. Go to The Filters tab, then on the Choose Filter field, pick Paid Through on the Filter drop-down.
3. Select a date range on the drop-down list or on From and To, then OK.
Just in case, you can also check out this article for future reference: Customize reports in QuickBooks Desktop.
That's it! Please let me know how it goes in the comment section. I'm always here should you have any follow-up questions or concerns. Take care and have a great rest of the week.
Yes, I attempted that however it only yielded a total of 3 vendors and 6 payments when in actuality there was more than 30 vendors that we received payments from in January.
I exported the full report to excel and filtered the paid date to show only 2019, however it is quite cumbersome and the data and formulas all become skewed.
Any other ideas?
There isn’t a direct way to filter Average Days to Pay report by month. As a workaround you can take note of the invoice numbers used for a certain month and use them to filter the report. For instance, for the month of December, you’ve used invoice numbers 250 to 350.
You can also request your preferred way of customizing the report through feedback. Just go to Help, choose Send Feedback Online and select Product Suggestion.
Please visit us again anytime you need help with QuickBooks.
The paid through filtering works fine on the detail report, however the summary report does not filter properly. The number of days on the report is for all transactions, and then drilling down to a specific customer, the detail is the correct filtering but the report does not tie to the detail. Any suggestions on how to correct this?
Hi there, @Micahel Rhyce.
Thanks for joining this thread. Allow me to help provide some insights about customizing reports in QuickBooks Desktop.
In order to show the same information both Detail and Summary report would work, make sure to customize it with the same filters such as Accounting method, Customer's name, Paid through and etc.
I'd like to ask some additional information such as the screenshots of both filtered reports so I can determine the difference.
For additional reference, you can check this article on how to customize reports in QuickBooks Desktop.
Please let me know how it goes by clicking the Reply button below. I'll be around to help.
Even if I enter a filtered date range, the report still goes all the way back to our start date of transactions. I entered June 1, 2018 through May 30, 2019 and the report still included 2016 activity.
You can filter the Date and the Dues Date altogether to show the correct data on the report.
To filter your report, you can follow the steps below:
That's it. The report now shows your transactions by date of creation and their due date.
You can also visit our Help Articles to learn more "How do I" steps.
Don't hesitate to let me know if you have any other concerns. I'll be sure to get back to you.
I appreciate the screenshot you've provided, @NavIngersoll.
I had replicated your concern to see the information you're referring to.
The date parameters in the report refer to the date when the transactions are created. The Average Days to Pay displays information on how many days a customer pay their dues. To calculate this, you'll have to know when it was actually paid.
Instead of using the Average Days to Pay report, you can run the A/R Aging Detail report. This also displays complete details on the average days your customers were able to pay their outstanding balance for a specific date range.
On the other hand, the accounting method used in your QuickBooks account affects the data that reflects in your report.
If you've set your accounting method into the Accrual method, ensure to choose the same method in generating your reports. An accrual-basis report shows income regardless of whether your customers have paid your invoices and expenses regardless of whether you have paid all your bills. You can change your QuickBooks accounting preferences and make sure that your reports match with it.
Once done, all your reports will default to Accrual basis. You can refer to this article for more information about the difference between cash and accrual basis, you can check this article: Differentiate Cash and Accrual basis.
Leave a comment below if you have other questions about managing your transactions and reports in your QuickBooks account. I'm always here to help.
@IamjuViel thanks for your response!
I had the accrual on under customer preferences clicked already in the summary reports basis.
Any other thoughts why payments are being included when outside the date parameters
Hi there, NavIngersoll.
Yes, you can customize the report by the specific date. Let me show you how to do that.
You can also check this article to know more about customizing the reports in QuickBooks Desktop.
Please click the Reply button if you have questions in mind. I'm here to back you up. Take care.
@MarsStephanieL thank you for your reply!
I am familiar with customizing reports, however this is my issue. I enter the the dates 1/1/2019-12/31/2019 and the report is still pulling in payments from 2020. I just don't understand this glitch. Has anyone else ever had issues with this?
Hello there, @NavIngersoll.
Let me provide additional information about the payments that will show up in your reports.
The Average Days to pay report will list all paid invoices and statement charges under Accrual Basis. QuickBooks will calculate the days to pay as the difference between the invoice or statement charge date and the paid date.
If the invoice has been paid later this year, the report will still pulling up the payments from 2020. As a workaround, we can pull up A/R Aging Detail report. It will display complete details on the average days your customers were able to pay their outstanding balance for a specific date range.
On the other hand, if there are any features you’re having trouble locating or any that aren’t working as they should, these articles will come in handy: QuickBooks Desktop Help Articles.
I'm just here if you need more help. Take good care.