Budget vs actual (v1)

You are viewing version 1

This contract has been superseded. See the current version (v2).

Budget vs actual is one of Demiton's published registers for Australian civil construction. Budget against actual spend for the organisation, by expense category. Demiton keeps it current from the systems a contractor already runs and publishes the record's shape as a versioned JSON Schema, so the same question works whichever system produced the record.

Part of Financials in the register catalog.

Register ID

budget_vs_actualUse this name to ask for the register. The API calls it a shelf ID.

Each record is

A stateThe current value of something, replaced when it changes.

Status

DeclaredDefined, and fills when a source produces its first record.

Data

OrganisationPrivate to each organisation's own workspace.

Version

v1 (1.0.3)Superseded by v2.

Download JSON SchemaSee an example record

Standards

This register's contract was designed against these standards and laws. Holding these records does not by itself certify compliance.

• GST Act 1999 (Cth)A New Tax System (Goods and Services Tax) Act 1999 (Cth)Australia · current (ATO guidance updated 25 Aug 2025) · clause s 29-70 (tax invoices); ATO tax invoice guidance · public summary

Connectors

Connected today

Demiton keeps this register current from these systems now.

• Business Central
• Dynamics 365 Finance & Operations
• Xero

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
• Oracle Aconex
• Procore

Fields

9 fields: 5 required, 4 optional.

Required

Every record carries these fields.

actual_amountDecimal number

Net actual GL spend for the category in the period, debits less credits.

Example: 172340.55

budget_amountDecimal number

Budgeted spend for the category in the period.

Example: 185000

legal_entity_idText

The legal entity whose GL the budget and the actuals belong to; the fact's subject anchor.

Example: BWG-QLD-01

expense_categoryText

The classification the budget line and the actual GL movement share, so the two are comparable.

Example: Labour

financial_periodText

The accounting period the budget and the actuals cover.

Example: 2026-07

Optional

Present when the source system records them.

currencyCurrency codeISO 4217, e.g. AUD

The currency the two amounts are in; today the measure names hard-code AUD.

Example: AUD

amount_basisText

Whether budget_amount and actual_amount include GST.

Example: excl_gst

variance_amountDecimal number

budget_amount − actual_amount for the category.

Example: 12659.45

budget_entry_countWhole numberUnit: count

Number of source budget rows folded into the row.

Example: 4

Example record

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

budget_vs_actual.example.json

{
  "actual_amount": 172340.55,
  "amount_basis": "excl_gst",
  "budget_amount": 185000,
  "budget_entry_count": 4,
  "currency": "AUD",
  "expense_category": "Labour",
  "financial_period": "2026-07",
  "legal_entity_id": "BWG-QLD-01",
  "source_system": "D365_BUSINESS_CENTRAL",
  "variance_amount": 12659.45
}

Version history

• v2 (current)
• v1

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/budget_vs_actual/v1.json

Show the full JSON Schema

Loading the schema…