Skip to content
Demiton

Trial balance

Debit and credit balance per general ledger account.

Part of Financials in the register catalog.

Register ID
trial_balanceUse this name to ask for the register. The API calls it a shelf ID.
Each record is
An eventSomething that happened at a point in time.
Status
AvailableFilled today from connected systems, uploads or public data.
Data
OrganisationPrivate to each organisation's own workspace.
Version
v1Current version.

Connectors

Connected today

Demiton keeps this register current from these systems now.

On the roadmap

Systems in the planned connector rollout that can fill this register. Partial means the system holds only some of its fields.

  • MYOB Acumatica
  • MYOB BusinessPartial

Fields

13 fields: 7 required, 6 optional.

Required

Every record carries these fields.

source_systemText

The system the snapshot was read from.

Example: D365_BUSINESS_CENTRAL

external_idText

The source system's own account identifier.

Example: 1100

account_numberText

The G/L account number.

Example: 1100

snapshot_atDate and timeISO 8601, with time zone

The instant the snapshot was captured.

Example: 2026-06-30T23:59:00

balanceDecimal numberUnit: by-coordinate (currency)

The account's closing balance at the snapshot.

Example: 612400

net_changeDecimal numberUnit: by-coordinate (currency)

Movement in the account for the period.

Example: 84500

Optional

Present when the source system records them.

currencyText

Currency of the monetary amounts.

Example: AUD

account_categoryText

The account's primary classification.

Example: Assets

account_nameText

The account's human label.

Example: Trade Debtors

account_typeText

The BC account-type code.

Example: Posting

account_sub_categoryText

The finer classification.

Example: Current Assets

last_modified_atDate and timeISO 8601, with time zone

When the source last changed the account record.

Example record

A sample from Bridgeworks Group, Demiton's demonstration company. The values are illustrative; the shape is exactly what the contract describes.

trial_balance.example.json
{
"account_category": "Assets",
"account_name": "Trade Debtors",
"account_number": "1100",
"account_sub_category": "Current Assets",
"account_type": "Posting",
"balance": 612400,
"currency": "AUD",
"external_id": "1100",
"legal_entity_id": "BWG-AU",
"net_change": 84500,
"snapshot_at": "2026-06-30T23:59:00",
"source_system": "D365_BUSINESS_CENTRAL"
}

Use this contract

The contract is a standard JSON Schema (draft 2020-12) document, so any JSON Schema validator can check a record against it. Keywords starting with x-demiton- add Demiton's own meaning, such as units and requiredness, and validators ignore them.

Schema URL
https://docs.demiton.io/registers/trial_balance/v1.json
Show the full JSON Schema

Loading the schema…

Talk to the team

Tell us what you run - your ERP, field, payroll and document systems - and we will show you the registers Demiton would keep current from them, on your data, in a 30-minute call.

Book a 30-minute callStart free