Opening Balances

Import opening balances from a trial balance CSV using the Opening Balance Closure Engine (OBCE). The pipeline parses debit/credit rows, auto-maps accounts using a 5-tier strategy (exact → code → dictionary → fuzzy → unmapped), validates the balance equation, and creates an immutable migration journal on confirm.

The singleton constraint ensures only one active opening balance journal per organisation. To re-import, void the existing journal first.

All monetary values in API responses are formatted as pounds (e.g. "1500.00"). Internal storage uses pence (integer minor units).

Clearing Mode (v5.6.0): When enabled, Trade Debtors maps to 1198 (MC_AR) and Trade Creditors maps to 2198 (MC_AP), enabling the TMADD 6.0 zero-sum invariant for outstanding document imports.

→ The Opening Balances object

Endpoints

GET https://app.speybooks.com/api/v1/opening-balances/status Get opening balance status POST https://app.speybooks.com/api/v1/opening-balances/upload Upload opening balances GET https://app.speybooks.com/api/v1/opening-balances/{id} Get opening balance details DELETE https://app.speybooks.com/api/v1/opening-balances/{id} Delete an opening balance import POST https://app.speybooks.com/api/v1/opening-balances/{id}/confirm Confirm opening balances PATCH https://app.speybooks.com/api/v1/opening-balances/{id}/map Map opening balance accounts POST https://app.speybooks.com/api/v1/opening-balances/{id}/void Void opening balances

Endpoints

GET /v1/opening-balances/status POST /v1/opening-balances/upload GET /v1/opening-balances/{id} DELETE /v1/opening-balances/{id} POST /v1/opening-balances/{id}/confirm PATCH /v1/opening-balances/{id}/map POST /v1/opening-balances/{id}/void

The Opening Balances Object json

{
  "id": "dimp_2",
  "filename": "trial-balance-march-2026.csv",
  "totalRows": 24,
  "status": "pending",
  "cutoverDate": "2026-02-28",
  "openingBalanceMode": "clearing",
  "canConfirm": true
}