Skip to content
logo Knowledgebase
Page Language

The Accounts Payable Aging report

Created on  | Last modified on 

Summary

How to use the Accounts Payable Aging report in Sage Accounting.

Description

Use the Accounts Payable Aging report to track how much you owe vendors at any time. The report helps you monitor:

  • Amounts owed to vendors
  • Duration of outstanding debts
  • Vendors owed the most money
  • Due dates for purchase invoices (Detailed report)
  • Vendor credit limits

Resolution

What the report tells you

The report lists unpaid invoices minus any unrefunded credit notes. It shows the total amount owed and the payment due date, including tax if applicable.

Aging periods by days
Criteria
< 30 days 0 – 29 days
< 60 days 30 – 59 days
< 90 days 60 – 89 days
< 120 days 90 – 119 days
Older 120 days or older

For example, on 10 July, invoices dated 11 June to 10 July show in < 30 days; 11 May to 10 June show in < 60 days.

Aging periods by calendar month
Categorize unpaid transactions by month
Current Transactions dated in the current month
1 month Transactions dated last month
2 months Transactions dated two months ago
3 months Transactions dated three months ago
Older Transactions are older than three months

 For example, if today's date is 10 July, categorize July invoices as Current and June invoices as 1 Month.

▼How to change your aging periods
  1. From Settings, Business settings, select Record and transaction settings.
  2. Choose from Aging by days or by calendar months.

 

Run the report

For all vendors
  1. Go to Reports, All reports.
  2. Select Accounts Payable.
  3. Choose how to sort the report:
    By Name To see the amount you owe each vendor alphabetically.
    By Outstanding To see the amount you owe the most money to first.
  4. Select Calculate.
For a single vendor

Enter the vendor name in the Search box.

Up to a specific date
  1. Run the report for a past date to show the total owed then.
  2. Enter the required date and click Calculate.
Include details of unpaid invoices

Choose Detailed to include a list of unpaid invoices.

Per group of vendors or other analysis type
  1. From More, choose the Analysis Type and Category.
  2. Click Calculate.

Print or export the report

Select Export and choose CSV or PDF. Save or print from your internet browser menu.

Common issues

Negative amounts on the Accounts Payable Aging Report

Negative amounts indicate outstanding credit notes not yet applied to invoices or refunded. Apply credit notes to invoices via Contacts.

The balance on a vendor record and the Accounts Payable Aging Report don't match

Differences usually arise from future-dated transactions included in vendor balances but not in the report. Choose the correct date for the report.

Related Solutions