Trial Balance
Overview
The Trial Balance lists every Ledger of a Business with its balance at a point in time, split into a debit column and a credit column. Because every Journal Entry has equal debits and credits, the two columns add up to the same total. When they don't, something is wrong in the books.
It is the report an accountant starts from. It shows every account in one place, before it is arranged into the Balance Sheet and the Profit and Loss Report.
How to Generate a Trial Balance
Call Retrieve the Trial Balance Report with:
| Parameter | Description |
|---|---|
end_datetime | Required. The end of the period, exclusive, in ISO-8601 format. To include a whole day, send midnight at the start of the next day, such as 2026-04-01T00:00:00Z for a period ending March 31. A time without a time zone is read as UTC. |
basis | Optional. modified_cash, the default, or accrual. |
curl --request GET \
--url "https://api.sandbox.getasset.com/v0/business/biz_GA6EG2qFxA97NZHtxeLPUy/reports/trial-balance?end_datetime=2026-04-01T00:00:00Z" \
--header 'Authorization: Bearer <token>'The report needs the report:read scope.
What the report returns
The response is a list with one line per Ledger, in the order of the Chart of Accounts:
| Field | Description |
|---|---|
name | The Ledger name. |
ledger_id, sort_code | The Ledger it belongs to. |
ledger_type | asset, liability, equity, revenue or expense. |
debit | The balance if the Ledger carries a debit balance, otherwise 0. |
credit | The balance if the Ledger carries a credit balance, otherwise 0. |
has_entries | Whether the Ledger has any Journal Entries. |
Each Ledger appears in one column only. Total the debit values and the credit values to get the two column totals.
Fiscal years. Income and expense Ledgers show the current fiscal year only. Earlier fiscal years are rolled into Retained Earnings, the way a year-end close would, so the report balances without a closing entry.
Foreign currency. A Business with foreign-currency balances gets one extra line, Unrealized Currency Gain/Loss, with no ledger_id. It is calculated for the report and isn't posted. See Multicurrency.
Trial Balance Best Practices
- Check that the columns match. Total the debits and credits before relying on the report.
- Hide Ledgers with
has_entriesset tofalse. The report returns every Ledger, including ones that are never used. - Enable drill-downs. Use the Ledger Statement to show the entries behind a balance.
- Export it. Send an
Acceptheader ofapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetto receive the report as a spreadsheet.