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:
| Parameter | Description |
|---|---|
start_datetime | Required. The start of the period, inclusive, in ISO-8601 format. |
end_datetime | Required. 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:
| Field | Description |
|---|---|
ledger | The Ledger's id, name and sort_code. |
lines | The lines posted to the Ledger in the period, oldest first. |
Each line has:
| Field | Description |
|---|---|
date | The date of the Journal Entry. |
journal_entry_id | The Journal Entry the line belongs to. |
memo | The Journal Entry's description. |
split_ledgers | The other Ledgers in the same Journal Entry, so you can see where the other side went. |
debit_credit | Whether the line is a debit or a credit. |
amount | The amount of the line. |
balance | The 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
Acceptheader ofapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetto receive the report as a spreadsheet.