Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Basically, I have a report created that I just want one addition column to show, which is aging. I can't find how to add that column to the report. I was able to add it to several reports that I created when we used to use QuickBooks Desktop, but can't find it in the Online version. It would also be nice if I'm able to have maximum aging days appear in the group totals row.
I have already looked at the A/R Aging Detail Report and that does not solve my problem. Even on that report I can't get a column that shows the number of days for a specific invoice, just the aging period that it fits into. Even if I could customize the periods to 1 day each with like 2000 periods (which I can't find a way to modify anyways), I need the report grouped by customer so it wouldn't help.
I've also looked at the older Accounts Receivable Aging Detail Report, but it doesn't allow me to add some of the specific columns that I need to include.
I'll ensure you'll able to generate a report that contains aging details in QuickBooks Online (QBO), Bryan.
Adding an Aging column to a report is unavailable in QuickBooks Online (QBO). The program has its own aging report for Accounts Receivable and Accounts Payable that you can access to view outstanding transactions of your customers or vendors.
You can add other columns and filter the A/R Aging detail report to see all the overdue invoices. I know that you've already accessed this however, since you're unable to add an Aging column to any report, adding further modification might help you see the data you need. When ready, refer to these steps:
You can read this article for reference: Run an accounts receivable aging report.
Additionally, you can send a report you've modified by email on a recurring schedule. For detailed instructions, check out this article: Set schedule and email information for a memorized report.
I'm always here ready to lend a hand if you have other concerns tracking the aging transactions of your customers. Please keep me posted. Have a good one.
Did you read my post at all or just the subject? If you read it, you'd have known that I've already tried everything that you just described and it does not give me the type of information I am looking for.
Hello there, Bryan.
I believe that you're fully aware that adding an aging column to your personalized report is unavailable in QuickBooks Online (QBO).
I encourage sending your suggestions directly to our Product Development Team. They will carefully consider this option to ensure it meets your business needs effectively.
To send a feature recommendation, you can follow the steps below:
You can trace requests for features through the QuickBooks Online Feature Requests website.
As this feature is currently unavailable in QBO, we can export your report to Excel and add the aging column as a workaround. Furthermore, when reviewing the report and you notice some missing data, the file is in a protected view. Just click on Enable Editing to view the full report.
In addition, you can also scan this article to know more about exporting other than reports in QBO: Export your reports, lists, and other data from QuickBooks Online.
If you have further inquiries regarding your reports, leave a comment below. I’ll jump back right in to assist you.
Having the same issue, Bryan! Sent a request, FWIW. Here's hoping!
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