finov.ioDocumentationHome

Trial balance

API Documentation / Resources / Reports

Finovio trial balance showing debit credit and balance columns by account
Review cumulative account balances through the selected as-at date.

Get a trial balance report

GET /v1/tenants/{tenant_id}/subsidiaries/{subsidiary_id}/reports/trial-balance

Required OAuth scope: reports:read

Returns closing debit and credit balances for posted accounts through as_at.

Parameter Meaning Default
basis Accrual or settlement-based cash projection accrual
account_id Restrict output to one account All accounts

The complete report has equal total_debit and total_credit. When an account filter is supplied, totals describe only the selected account.

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: accrual, cash
account_id query No string (uuid)

Request

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

Responses

Status Description
200 Trial balance report.
400 A required exchange rate or report input is unavailable.
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": "trial_balance",
    "basis": "accrual",
    "as_at": "2026-07-31",
    "currency_code": "NZD",
    "rows": [
      {
        "account_id": "a110c7ae-3208-4f93-a64c-d2ba9dd82c31",
        "code": "1100",
        "name": "Accounts receivable",
        "debit": "28400.0000",
        "credit": "0.0000"
      },
      {
        "account_id": "a110c7ae-3208-4f93-a64c-d2ba9dd82c35",
        "code": "3100",
        "name": "Retained earnings",
        "debit": "0.0000",
        "credit": "28400.0000"
      }
    ],
    "total_debit": "28400.0000",
    "total_credit": "28400.0000",
    "generated_at": "2026-08-10T17:10:00Z"
  }
}