In QuickBooks Online (QBO), you can pull up the Accounts payable ageing summary report. Let me show you how.
This report shows you the total amount of your unpaid bills, grouped by days past due by supplier. Just follow these steps to pull up the report:
Please see attached screenshot for reference.
I'm linking an article just in case you need help in running a report with supplier totals.
That'll do it. Let me know if you have further questions about the report. I'll be here to keep helping. Take care.
You can run the accounts payable ageing detail or the supplier balance detail and customise it to your requirements.
Sorry, but you can't. I want an Aged Creditors, by all suppliers, individually presented, aged 30/60/90 etc, totalled and then totalled by each period. I do not want to drill down, choose one supplier at a time or export to Excel.
The Supplier balance detail does not total each period. See my example below. Good old fashioned, standard, Aged Creditors!
Supplier Date Current 30 60 90 Total
ABC 1/6/19 100.00 100.00
ABC 10/7/19 100.00 100.00
100.00 100.00 200.00
BLAH 1/8/19 50.00 50.00
BLAH 15/8/19 25.00 25.00
Hello there, @tygerlula1.
There are a lot of customisation setup available on QBO report. However, your request for a report by all suppliers, individually presented, aged 30/60/90, totaled and then totaled by each period isn't available. We advise exporting and do the calculation on Excel.
I understand how your suggestion and idea for QuickBooks functionality would be useful in the system. Please know that I’m taking note of your feedback and passing it along here on my end. I'll surely forward this request to our product engineers, so that this may be considered for future upgrades.
For the meantime, you can visit our QBO Blog for additional reference while working with QuickBooks. You can also register to our Newsletter to receive email updates about what new changes are being rolled out.
If you have any follow up questions, please let me know by commenting below. Have a good one.