cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Is it at all possible to run an actual Aged Creditors report by supplier and period.?

The reports on here are of no use without the aid of a calculator. An Aged Creditors report should be by Supplier and period. The periods usually run 30/60/90/120 days and show the total outstanding for each period. I used to be able to get this report on the Desktop version. Why is it not available on the Online version. Accounting hasn't changed!
5 REPLIES 5
Moderator

Re: Is it at all possible to run an actual Aged Creditors report by supplier and period.?

Hi tygerlula1,

 

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:

  1. Go to Reports.
  2. Type in Accounts payable ageing summary in the search field.
  3. Set the date range under Report period.
  4. Under Ageing, choose the Ageing method to see the open balances. You can also select Current to see all outstanding balances.
  5. Set the number of days in the Days per ageing period field.
  6. Click on Run report.

Please see attached screenshot for reference.

 

1.PNG

 

2.PNG

 

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.

Experienced Member

Re: Is it at all possible to run an actual Aged Creditors report by supplier and period.?

Thank you, but I need the report in detail. 

QuickBooks Team

Re: Is it at all possible to run an actual Aged Creditors report by supplier and period.?


Hi tygerlula1

 

You can run the accounts payable ageing detail or the supplier balance detail and customise it to your requirements.

Experienced Member

Re: Is it at all possible to run an actual Aged Creditors report by supplier and period.?

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!

 

EG. 

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

                                                 75.00                                                                      75.00

QuickBooks Team

Re: Is it at all possible to run an actual Aged Creditors report by supplier and period.?

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.