Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
In Quickbooks online, is there a report where the current column in the accounts receivable aging can be broken down for weekly cash forecasting?
Solved! Go to Solution.
Good afternoon, @annjoep11.
I appreciate you coming to the Community with your question about Accounts Receivable Aging report and the current column.
I can see how beneficial this could be for your business. However, you'll need to submit feedback to our Product Developers so they can consider adding a feature like this in the near future. Here's how:
Feel free to reply back if you have any other questions. Have a wonderful day!
Good afternoon, @annjoep11.
I appreciate you coming to the Community with your question about Accounts Receivable Aging report and the current column.
I can see how beneficial this could be for your business. However, you'll need to submit feedback to our Product Developers so they can consider adding a feature like this in the near future. Here's how:
Feel free to reply back if you have any other questions. Have a wonderful day!
You can run an A/R Aging Detail Report. That report shows the due date of all current invoices.
I want to age the current column. I can get the detail. I want to know if the cash is coming in next week or 60 days from now
The ability to forecast cash inflow for the upcoming week or 60 days is a valuable enhancement to the A/R Aging Detail report, Ann.
Customizing the Current column of the A/R Aging Detail report is unavailable in QuickBooks Online (QBO). The report is intended to display overdue invoices rather than forecast cash flow from outstanding invoices.
Rest assured that the Product Development Team is continuously improving the program. They're constantly introducing updates and improvements to cater to the diverse business needs of all users.
While this isn't possible, I suggest utilizing the Planner tool in QBO. It allows you to view projected cash flow for the future. For the detailed steps on how this feature works, please see this article: Cash flow planner in QuickBooks Online.
Alternatively, you can manually open the invoice under the Current section to view if the cash is coming in next week or 60 days from now. Otherwise, add the Terms column in the A/R Aging Detail report. Then, manually calculate the number of days before the expected payment.
I also encourage submitting a feature request to share your ideas about enhancing the reports in QBO:
Additionally, I've added this article to help you gently remind customers about invoice due dates to ensure they can pay you on time: Send invoice reminders automatically or manually in QuickBooks Online.
I'm always ready to help if you still have other questions about personalizing reports and recording invoice payments. You can reply to this thread or start a new one to let me know.
"I want to know if the cash is coming in next week or 60 days from now."
A/R aging reports are designed to show aged (past due invoices), not projected cash flow from outstanding invoices. For that, go to Dashboards > Planner. You can export to Excel if needed.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here