finov.ioDocumentationHome

Statement drilldown

API Documentation / Resources / Reports

Supporting transactions for Service Sales in the profit and loss report
The drilldown lists the journals behind the selected account balance.

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
  }
}