BookkeepingCreating Reports
Aged Payables Report
Overview
The Aged Payables Report shows what a Business owes its vendors for Bills that are past due, grouped by how late they are. It is the payables counterpart of the Aged Receivables Report.
A Bill is included once its due date has passed and it still has an unpaid balance. A Bill that isn't due yet is not in the report.
Key components, for each Vendor:
- Vendor ID and Vendor Name
- Overdue 0–30 – Amount past due by up to 30 days.
- Overdue 31–60 – Amount past due by 31–60 days.
- Overdue 61–90 – Amount past due by 61–90 days.
- Overdue 90+ – Amount past due by more than 90 days.
- Total Outstanding – The sum of the Vendor's overdue Bills.
Amounts are in the Business' home currency. A Bill in another currency is converted at the rate it was booked at. See Multicurrency.
How to Generate an Aged Payables Report
Call Retrieve the Aged Payables Report with:
| Parameter | Description |
|---|---|
start_datetime | Optional. The reference date the aging is measured from, in ISO-8601 format. Defaults to now. |
vendor_id | Optional. Limit the report to one Vendor. |
status | Optional. One or more Bill statuses, comma-separated: open, paid or voided. Defaults to open. |
curl --request GET \
--url "https://api.sandbox.getasset.com/v0/business/biz_GA6EG2qFxA97NZHtxeLPUy/reports/aged-payables" \
--header 'Authorization: Bearer <token>'The report needs the report:read scope. The response is a list with one line for each Vendor that has overdue Bills.
Aged Payables Best Practices
- Leave
start_datetimeout for today's picture. The default is the current moment, which is what a payment run needs. - Use
start_datetimeto choose the aging date. Only Bills due on or before it are counted, and each is aged from its due date to that date. - Run it for one Vendor. Pass
vendor_idto limit the report to that Vendor. To list the Bills behind a balance, use List all Bills withstatus=openand a due date range, and group the Bills byvendor_id. The list can't be filtered by Vendor. - Don't expect paid Bills. A Bill only counts while it has an unpaid balance, so leaving the
statusfilter alone is almost always right.
Questions? Reach out via our Contact form.