Statement drilldown
API Documentation / Resources / Reports

List transactions behind a statement amount
GET /v1/tenants/{tenant_id}/subsidiaries/{subsidiary_id}/reports/statement-drilldown
Required OAuth scope: reports:read
Returns the posted transactions contributing to one account amount on a profit and loss, balance sheet, or trial balance.
| Statement | Date arguments |
|---|---|
profit_and_loss |
from_date and to_date |
balance_sheet |
as_at, or an explicit from_date and to_date |
trial_balance |
as_at, or an explicit from_date and to_date |
account_id is always required. Date arguments are mutually coherent:
supply as_at for a point-in-time view or both period dates, not a
partial range.
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. |
statement |
query | Yes | string: profit_and_loss, balance_sheet, trial_balance | |
account_id |
query | Yes | string (uuid) | |
from_date |
query | No | string (date) | |
to_date |
query | No | string (date) | |
as_at |
query | No | string (date) | |
basis |
query | No | string: accrual, cash | |
search |
query | No | string | |
page |
query | No | integer | |
per_page |
query | No | integer |
Request
GET /v1/tenants/{tenant_id}/subsidiaries/{subsidiary_id}/reports/statement-drilldown HTTP/1.1
Host: api.finov.io
Authorization: Bearer {access_token}
Responses
| Status | Description |
|---|---|
200 |
A page of transactions behind the selected statement amount. |
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": [
{
"journal_id": "553aa91a-e8c2-4c6f-b800-07a2b92efdb1",
"date": "2026-07-15",
"source": "invoice",
"source_id": "f54ca5ce-c915-417b-9514-818ba58a21cb",
"description": "Advisory services",
"amount": "-1500.0000"
}
],
"summary": {
"account_id": "a110c7ae-3208-4f93-a64c-d2ba9dd82c31",
"statement_amount": "-84250.0000",
"currency_code": "NZD"
},
"meta": {
"current_page": 1,
"per_page": 30,
"last_page": 1,
"total": 1
}
}