Accounts Payable

The Accounts Payable aging report shows what your company owes to each supplier, broken down by how overdue each amount is. Use it to prioritise payments and monitor your outstanding payables position.

Accessing Accounts Payable

Navigate to Finance > Accounts Payable from the main menu.

Running a report

Accounts Payable is an on-demand report. Configure the date and click Run to generate it.

Set the As Of date (defaults to today).
Click Run.

Metrics

Once the report is generated, the following are shown:

Metric	Description
As Of	The date the report is calculated as of
Supplier Count	The number of suppliers with outstanding balances
Total Payable	The total outstanding amount owed to all suppliers

Table columns

Column	Description
Supplier Name	The name of the supplier
Invoice Count	The number of outstanding invoices for this supplier
Current	Invoices that are not yet overdue
1–30 Days	Invoices 1 to 30 days past due
31–60 Days	Invoices 31 to 60 days past due
61–90 Days	Invoices 61 to 90 days past due
91–120 Days	Invoices 91 to 120 days past due
120+ Days	Invoices more than 120 days past due
Total	The total outstanding balance for the supplier

Only amounts greater than zero are shown in each aging bucket. A summary row is pinned to the bottom of the table showing the totals across all suppliers for each aging bucket.

Understanding the aging buckets

Aging is calculated from the invoice due date relative to the As Of date. An invoice is placed in the appropriate bucket based on how many days have elapsed since its due date:

Current — the due date is on or after the As Of date.
1–30 Days — the due date was 1 to 30 days before the As Of date.
31–60 Days — 31 to 60 days overdue, and so on.

If an invoice does not have a due date set, it is treated as current.

Sorting

Click any column header to sort the report by that column.