Profit and loss (v2)

Name: Profit and loss
Creator: Demiton
License: https://creativecommons.org/licenses/by/4.0/

Profit and loss is one of Demiton's published registers for Australian civil construction. Profit and loss for a period. 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: profit_and_lossUse 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: AvailableFilled today from connected systems, uploads or public data.
Data: OrganisationPrivate to each organisation's own workspace.
Version: v2 (2.0.1)Superseded by v3.

Download JSON Schema See an example record

Standards

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

AS 4000AS 4000:2025 General Conditions of ContractAustralia · 2025 · clause cl 37.2 (per commentary) · paywalled, from a secondary description
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
Security of paymentBuilding and Construction Industry Security of Payment Act 2009 (SA)Australia · current · clause claimed amount states GST treatment · public summary
Security of paymentBuilding and Construction Industry Security of Payment Act 2009 (Tas)Australia · in force 2025-10-11 · clause ss 17-19 · verified against full text
Security of paymentBuilding and Construction Industry (Security of Payment) Act 2021 (WA)Australia · current · clause ss 24-25 · verified against full text
Construction Contracts Act 2002 (NZ)Construction Contracts Act 2002 (NZ), 2002 No 46New Zealand · as at 5 Oct 2023 (incl. Retention Money Amendment Act 2023) · clause ss 20, 21, 18J-18K · verified against full text
HGCRA 1996 Part IIHousing Grants, Construction and Regeneration Act 1996 (UK), Part IIUnited Kingdom · current · clause ss 110, 110A, 111, 113 · verified against full text
AIA G702/G703AIA G702-1992 / G703-1992United States · 1992 base editions · public summary

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
ProcorePartial

Fields

13 fields: 4 required, 9 optional.

Required

Every record carries these fields.

project_idText

The project (BC job) the snapshot belongs to; the fact's subject anchor.

Example: BWG-2025-001

actual_amountDecimal number

Actual cost to date (BC Total_Cost)

Example: 1620000

budget_amountDecimal number

The project budget at the snapshot (BC Total_Budget)

Example: 2850000

financial_periodText

The accounting period the snapshot covers.

Example: 2026-06

Optional

Present when the source system records them.

job_noText

The Business Central job number the fact was read for; the join key between the fact and the project spine.

summaryText

The one-line human-readable financial position, for citation/search.

Example: Emerald Street Rejuvenation is 56.8% cost-complete agains…

currencyCurrency codeISO 4217, e.g. AUD

The currency the amounts are in; today the field names hard-code AUD and the writer passes currency_code="AUD"

Example: AUD

variance_amountDecimal number

budget_amount - (actual_amount + commitments_amount)

Example: 820000

gross_margin_pctDecimal numberUnit: percent (%)

gross_margin_amount / revenue * 100

Example: 18.2

commitments_amountDecimal number

Open purchase-commitment value (BC Total_Commitments)

Example: 410000

gross_margin_amountDecimal number

Revenue less actual cost (Total_Revenue(abs) - Total_Cost)

Example: 360000

contract_value_amountDecimal number

The contracted value of the job (BC Total_Contract_Value)

Example: 2980000

claimed_to_date_amountDecimal number

Value invoiced to date (BC Total_Invoiced)

Example: 1690000

Example record

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

{
  "actual_amount": 1620000,
  "bc_job_no": "BWG-2025-001",
  "budget_amount": 2850000,
  "claimed_to_date_amount": 1690000,
  "commitments_amount": 410000,
  "contract_value_amount": 2980000,
  "currency": "AUD",
  "financial_period": "2026-06",
  "gross_margin_amount": 360000,
  "gross_margin_pct": 18.2,
  "project_id": "BWG-2025-001",
  "source_system": "D365_BUSINESS_CENTRAL",
  "summary": "Emerald Street Rejuvenation is 56.8% cost-complete against a $2.85M budget with an 18.2% gross margin.",
  "variance_amount": 820000
}

Version history

v3 (current)
v2
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.

https://docs.demiton.io/registers/profit_and_loss/v2.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 fill from them, on your data, in a 30-minute call.

Book a 30-minute call Start free