Docs Sign in Start building

Read the company's trial balance

company.trial_balance

Lists every ledger account of the company in the request's environment, each Product's accounts and the company's own beside them, the tenant_master_mirror and platform_mirror accounts, each pool's float and its bank-charges account, with what TigerBeetle has posted on it at the end of asOf (UTC), or now when asOf is omitted. Answers as CSV (`text/csv`, `Content-Disposition` filename, `Content-Digest` SHA-256) with columns account, product, role, binding, book, currency, normal_balance, debit and credit, amounts as decimals at each currency's exponent; send `Accept: application/json` for this JSON object, amounts in minor units. `ledgers` totals the debit and credit columns per book and currency; they are equal on a sound ledger. `custody` sets what the Products and the company hold in cash against the bank's mirrors. Postgres names the accounts and TigerBeetle gives every balance, read by id in batches no larger than its lookup limit. Nothing is posted. Callers: the account owner's CLI login, or an agent token with products:read, or a personal access token with finance:read.

GET /v1/company-trial-balance

Principal user_session. Idempotency not_required. Environment either.

Input

FieldInTypeDescription
asOfquerystringThe UTC day to read the balances at the end of; balances now when omitted.
X-Hyperscale-Environmentheadersandbox | live

Output

FieldTypeDescription
environment requiredsandbox | live
asOf requiredstringThe UTC day whose end the balances stand at.
contentType required"text/csv"
filename requiredstring
content requiredstring
sha256 requiredstring
sizeBytes requiredinteger
accountCount requiredinteger
ledgers requiredobject[]One total per book and currency, as TigerBeetle keeps them.
custody requiredobject[]The cash book per currency, set against the bank's mirrors.
accounts requiredobject[]

Request sample

Only a signed-in person may call this: the CLI after hyperscale auth login, or curl with a personal access token (hyperscale_pat_...) with finance:read or an agent token with products:read. The agent's grant must span every Product the call reads. A Product key cannot, so the SDK, which signs in with a Product key or a customer session, has no sample for it.

curl

curl --request GET 'https://hyperscale0.ai/v1/company-trial-balance' \
  --header "Authorization: Bearer $HYPERSCALE_TOKEN" \
  --header 'X-Hyperscale-Environment: sandbox'

CLI

hyperscale api call company.trial_balance

Errors

CodeHTTPCause
approval_rejected403A person rejected the call or returned it to the maker, so it never runs.
approval_required202The call waits for decisions: an agent's call over its grant waits on its delegator, and a program action under `requires approval` waits on distinct people other than the maker.
environment_mismatch403The session was issued for sandbox or live and the request targets the other environment.
internal_error500Hyperscale hit an unexpected server-side condition and hid internal implementation details from this audience.
invalid_request400The request does not match the API reference.
method_not_allowed405The route exists, but not for the request's HTTP method.
missing_required_permission403The signed-in member's current role does not grant the permission required for this operation.
missing_required_scope403The credential is valid but does not grant one or more operation scopes.
not_found404No Hyperscale route matched the requested path and method.
oauth_client_not_admitted403The bearer is an OAuth client token, and this operation does not admit the oauth2_client principal.
product_access_suspended403The Product is disabled or closed, so its credentials are suspended in every environment.
product_activation_required403The live Product or required live capability is not active yet.
rate_limited429The credential sent more than its limit in the current 60-second window: 600 requests per API key or session, 1,200 per IP address. Every response carries `x-ratelimit-limit`, `x-ratelimit-remaining` and `x-ratelimit-reset` (Unix seconds).
resource_not_found404The requested resource does not exist in the credential's visible scope.
resource_reader_unavailable503A generated read model could not serve the request at this moment.
state_conflict409The operation conflicts with the current durable state of the resource.
tenant_mismatch403The request mixed tenant-owned identifiers across tenant boundaries.
tenant_not_found404The credential resolved to a tenant Hyperscale cannot find.
unauthorized403The request did not include a valid Hyperscale bearer credential for this environment.
agent_token_expired401The agent token is real, but its grant ended. A grant lasts 30 days, or 7 days unused. `details.expiresAt` holds the date in ISO 8601 and `details.agentName` names the agent.
agent_token_replaced401The account owner ran `hyperscale agent setup` again for this agent, which replaced this token with a newer one. `details.agentName` names the agent and `details.replacedAt` holds the date.
device_login_expired401The bearer is the account owner's own device login from `hyperscale auth login`, not an agent token. Its access token lasts an hour and the CLI refreshes it; the login itself ends after 30 days, or 7 days unused. `details.expiresAt` holds when it ended in ISO 8601.
invalid_credentials401Hyperscale could not accept the account or credential request. Signup, login, and bearer authentication use one 401 for every case they reject, so the response exposes no credential-specific reason or registered-email verdict. The single exception is a key that is real but homed in the other environment: because the presented secret already matched a stored key, the message names the mismatch instead of leaving a working credential looking unknown. A bearer that matched nothing gets text that fits its prefix (an agent token, a refresh token, a personal access token, a session or no Hyperscale token at all), which says only what the caller sent, never whether a credential like it exists.
session_expired401The session behind this request has ended. A console session ends 30 days after sign-in, or after 12 hours with no request. An admin or customer session ends 24 hours after sign-in, or after 15 minutes with no request. A personal access token ends at the `expiresAt` set when it was created.
session_required401This operation needs a person signed in through the browser or the `hyperscale` CLI. A Product API key cannot call it. The request carried no session, or its token matched no live session.
session_revoked401The session or personal access token behind this request was ended before its expiry. Sign-out, `user.session.revoke`, a password reset, a role change, removal from the team, user suspension and `personal_access_token.revoke` all end sessions.
tenant_status_forbidden409The company is suspended or closed, so every credential bound to it is refused, reads included. `details.tenantId` names the company.

All operations