Skip to Content
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:

ParameterDescription
start_datetimeOptional. The reference date the aging is measured from, in ISO-8601 format. Defaults to now.
vendor_idOptional. Limit the report to one Vendor.
statusOptional. 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_datetime out for today's picture. The default is the current moment, which is what a payment run needs.
  • Use start_datetime to 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_id to limit the report to that Vendor. To list the Bills behind a balance, use List all Bills with status=open and a due date range, and group the Bills by vendor_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 status filter alone is almost always right.
Questions? Reach out via our Contact form.

On this page