← All examples

EDJAS spec for HM Treasury PESA 2025, Table 1.1 (Total Managed Expenditure).

A three-tier ledger: CURRENT / CAPITAL EXPENDITURE sections, budget categories (Resource DEL, Resource departmental AME, ...), line items, and "Total ..." rows, across six years (four outturn + two plans). The header row is the years; the label column has a blank corner cell. The template classifies section headings (no figures), "Total ..." subtotals, and ordinary line items for styling.

The specification

The whole of pesa.toml, applied to the unmodified pesa.xlsx.

[extract]
title  = "'Table_1_1'!A1"
unit   = "'Table_1_1'!G2"
header = "['Table_1_1'!A4:G4]"
rows   = "['Table_1_1'!A6:G53]"

The JSON it produces

See the extracted JSON — exactly what edjas pesa.xlsx pesa.toml prints, which is the thing the report below is only one rendering of.

The report it produces

pesa.xlsx — a central-government expenditure ledger

Public Expenditure Statistical Analyses 2025 — Chapter 1 (Departmental budgets), HM Treasury (Accredited Official Statistics). Table 1.1, Total Managed Expenditure, is a three-tier ledger — CURRENT/CAPITAL EXPENDITURE sections, budget categories, line items, and Total … roll-ups — over six years. Collection: GOV.UK.

Downloaded from GOV.UK.