Books
Get the Books or VAT sheet
Returns the spreadsheet-style read model over the canonical general ledger: summary cards, column definitions, and rows for the selected tab and range. Amounts inside rows are integer cents. Paginate with limit/offset (limit 0 = unpaginated, max 200 per page).
get/sheet
Request
- Base URLhttps://api.app.lastaccountingcompany.com/portal
- AuthHTTP bearer
- TypeScriptA function with typed inputs. Its response is checked against the schema.
Query parameters
tab'books' | 'vat' required
Which sheet to return.
rangestring required
Period selector: YYYY-MM, YYYY-Qn, YYYY, all, this_month, or last_6_months.
customer_idstring
Target company. Optional — API keys are pinned to one company, and single-company sessions default to it.
limitinteger
Rows per page. 0 = unpaginated. Maximum 200.
offsetinteger
Row offset for pagination.
sort'' | 'newest' | 'oldest' | 'amount' | 'category' | 'status'
Row ordering. Empty string = default order.
Response
Sheet payload.
Changes
No recorded changes to this operation across all 1 revision of this API.