Skip to Content
BookkeepingCreating Reports

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:

ParameterDescription
end_datetimeRequired. 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.
basisOptional. 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:

FieldDescription
nameThe Ledger name.
ledger_id, sort_codeThe Ledger it belongs to.
ledger_typeasset, liability, equity, revenue or expense.
debitThe balance if the Ledger carries a debit balance, otherwise 0.
creditThe balance if the Ledger carries a credit balance, otherwise 0.
has_entriesWhether 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_entries set to false. 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 Accept header of application/vnd.openxmlformats-officedocument.spreadsheetml.sheet to receive the report as a spreadsheet.
Questions? Reach out via our Contact form.

On this page