Skip to Content
BookkeepingCreating Reports

General Ledger

Overview

The General Ledger is the complete record of every entry in a Business's books for a period, grouped by Ledger. For each Ledger it lists the lines posted to it, in date order, with a running balance.

It is the full version of the Ledger Statement. The Ledger Statement shows one Ledger at a time. The General Ledger shows all of them at once, which is what an accountant or an auditor usually asks for.

How to Generate a General Ledger

Call Retrieve the General Ledger Report with:

ParameterDescription
start_datetimeRequired. The start of the period, inclusive, in ISO-8601 format.
end_datetimeRequired. The end of the period, exclusive. 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.
curl --request GET \
  --url "https://api.sandbox.getasset.com/v0/business/biz_GA6EG2qFxA97NZHtxeLPUy/reports/general-ledger?start_datetime=2026-01-01T00:00:00Z&end_datetime=2026-04-01T00:00:00Z" \
  --header 'Authorization: Bearer <token>'

The report needs the report:read scope.

What the report returns

The response has a list of ledgers and a data_truncated flag. Each entry in ledgers has the Ledger, and its lines:

FieldDescription
ledgerThe Ledger's id, name and sort_code.
linesThe lines posted to the Ledger in the period, oldest first.

Each line has:

FieldDescription
dateThe date of the Journal Entry.
journal_entry_idThe Journal Entry the line belongs to.
memoThe Journal Entry's description.
split_ledgersThe other Ledgers in the same Journal Entry, so you can see where the other side went.
debit_creditWhether the line is a debit or a credit.
amountThe amount of the line.
balanceThe Ledger's running balance after the line. It starts from the Ledger's balance at start_datetime, so it is correct even when the period doesn't begin at the start of the books.

Only Ledgers with activity in the period appear. They are in the order of the Chart of Accounts.

Large periods are cut off. The report reads up to 10,000 Journal Entries, oldest first. If the period has more, data_truncated is true, and the newest entries are missing. Shorten the period, for example one month at a time, to get everything.

General Ledger Best Practices

  • Check data_truncated. Never present a truncated report as complete.
  • Use shorter periods for busy Businesses. A month or a quarter keeps most Businesses under the limit.
  • Use the Ledger Statement for one Ledger. It is paginated and is the better fit for an on-screen drill-down.
  • 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