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, then code, then dictionary, then fuzzy, then 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

GEThttps://app.speybooks.com/api/v1/opening-balances/statusGet opening balance status POSThttps://app.speybooks.com/api/v1/opening-balances/uploadUpload opening balances GEThttps://app.speybooks.com/api/v1/opening-balances/{id}Get opening balance details DELETEhttps://app.speybooks.com/api/v1/opening-balances/{id}Delete an opening balance import POSThttps://app.speybooks.com/api/v1/opening-balances/{id}/confirmConfirm opening balances PATCHhttps://app.speybooks.com/api/v1/opening-balances/{id}/mapMap opening balance accounts POSThttps://app.speybooks.com/api/v1/opening-balances/{id}/voidVoid 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 Objectjson

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