finov.ioDocumentationHome

Aged payables

API Documentation / Resources / Reports

Finovio aged payables report showing current and overdue supplier balances
Compare current supplier bills with balances in the overdue aging buckets.

Get an aged payables report

GET /v1/tenants/{tenant_id}/subsidiaries/{subsidiary_id}/reports/aged-payables

Required OAuth scope: reports:read

Groups authorised, unvoided supplier documents with an open balance by contact and aging bucket.

Parameter Meaning Default
as_at Snapshot date, inclusive Required
basis Age from invoice date or due date due_date
contact_id Restrict to one supplier All suppliers
currency_code Restrict document currency All currencies

Supplier credits retain their sign. The report excludes draft, void, paid, and future-dated documents.

Parameters

Name In Required Type Description
tenant_id path Yes string (uuid) UUID of the authorized company group.
subsidiary_id path Yes string (uuid) UUID of the subsidiary whose ledger is reported.
as_at query Yes string (date)
basis query No string: invoice_date, due_date
contact_id query No string (uuid)
currency_code query No string

Request

GET /v1/tenants/{tenant_id}/subsidiaries/{subsidiary_id}/reports/aged-payables HTTP/1.1
Host: api.finov.io
Authorization: Bearer {access_token}

Responses

Status Description
200 Aged payables report.
401 Access token is missing, expired, revoked, or invalid.
403 Token lacks reports:read or the granted accounting context.
404 A requested subsidiary, account, contact, or bank account is not available in the grant.
422 One or more report parameters failed validation.

200 example

HTTP/1.1 200 OK
Content-Type: application/json

{
  "data": {
    "report": "aged_payables",
    "as_at": "2026-07-31",
    "basis": "due_date",
    "currency_code": "NZD",
    "rows": [
      {
        "contact_id": "5f078069-b2db-462e-a375-84f490971703",
        "contact_name": "Harbour Supplies Limited",
        "current": "4200.0000",
        "days_1_30": "1250.0000",
        "days_31_60": "0.0000",
        "days_61_90": "0.0000",
        "days_90_plus": "0.0000",
        "total": "5450.0000"
      }
    ],
    "total": "5450.0000",
    "generated_at": "2026-08-10T17:20:00Z"
  }
}