RIrillet
Reports

Retrieves trial balance report

Changed on

Returns a trial balance report for the specified date range. Required parameters: from_date and to_date (ISO-8601 format YYYY-MM-DD). Both must be provided or the call will fail. Example: from_date=2024-01-01, to_date=2024-12-31.

get/reports/trial-balance

Request

Query parameters

from_datestring date required

Start date for the report period. Uses ISO-8601 format (YYYY-MM-DD).

to_datestring date required

End date for the report period. Uses ISO-8601 format (YYYY-MM-DD).

subsidiary_idstring uuid

Subsidiary to be used when filtering data

book_idstring uuid nullable

Book ID to report on. Primary books return primary-only figures; adjustment-overlay books return the combined primary and adjustment view.

Response

OK

currencystring required

Currency code following ISO-4217

Example response

{
  "period": {
    "from_date": "2024-01-01",
    "to_date": "2024-01-31"
  },
  "currency": "USD",
  "accounts": [
    {
      "code": "1000",
      "name": "Cash",
      "beginning_balance": {
        "amount": "1.01",
        "currency": "USD"
      },
      "debit_total": {
        "amount": "1.01",
        "currency": "USD"
      },
      "credit_total": {
        "amount": "1.01",
        "currency": "USD"
      },
      "debit_fx_total": {
        "amount": "1.01",
        "currency": "USD"
      },
      "credit_fx_total": {
        "amount": "1.01",
        "currency": "USD"
      },
      "ending_balance": {
        "amount": "1.01",
        "currency": "USD"
      }
    }
  ],
  "totals": {
    "beginning_balance": {
      "amount": "1.01",
      "currency": "USD"
    },
    "debit_total": {
      "amount": "1.01",
      "currency": "USD"
    },
    "credit_total": {
      "amount": "1.01",
      "currency": "USD"
    },
    "debit_fx_total": {
      "amount": "1.01",
      "currency": "USD"
    },
    "credit_fx_total": {
      "amount": "1.01",
      "currency": "USD"
    },
    "ending_balance": {
      "amount": "1.01",
      "currency": "USD"
    }
  }
}

Changes