Every feature, explained

A deep-dive into the capabilities that make Benchmark Budgeting the right choice for any organisation's financial planning.

The Budget Grid

The core of the application — a high-performance, spreadsheet-like grid that lets your team view and enter budget figures with the ease of Excel and the reliability of a proper database backend.

Multiple Budget Types

Supports Monthly (12 columns), Quarterly (4 columns), and custom yearly layouts. Each budget type is configured by your administrator — including custom column labels, comparison columns (LY Budget, YTD Actual), and whether to show an Annual Total column.

Intelligent Auto-Save

Cell edits are automatically saved 800ms after you stop typing. A save indicator in the header confirms the save. Changes that fail (e.g. network error) show a clear error message — nothing is silently lost.

Keyboard-First Navigation

Tab to move right, Shift+Tab to move left, Enter to confirm and move down, arrow keys for navigation. Undo/redo with Ctrl+Z and Ctrl+Y. Keyboard shortcuts are discoverable via the ? key.

Budget Profiling

Spread an annual total across months using equal distribution, custom percentages, or a saved seasonal profile template. The profiling modal shows a live preview before applying. A "flat" budget can be converted to profiled in one click.

Excel Import & Export

Export the current grid view (with all active filters applied) to a formatted Excel file. Bulk-import budget data via a structured .xlsx template — the system validates each row and reports errors clearly.

Carry Forwards

At year-end, carry forward uncommitted budget amounts from the current year into the next. The carry-forward process is tracked and reversible, with a full audit trail.

Budget Grid — Operating 2025/26
Monthly Quarterly
Account
Annual
LY Budget
Jul
▼ Infrastructure Services
$12,420,000
$11,800,000
$1,035,000
$6,240,000
$5,980,000
$520,000
$717,600
$687,700
$59,800
$2,840,000
$2,640,000
$236,667
$1,120,000
$980,000
$93,333
▶ Community Services (collapsed)
$8,910,000
$8,420,000
$742,500
Grand Total
$42,840,000
$40,320,000
$3,570,000
Row type legend
Editable data row
Amber — allocated out (shared cost)
Blue — allocated in (received share)
Subtotal / group header

Full workforce cost modelling

Labour costs are typically 60–70% of an organisation's operating budget. The Labour Panel gives your HR and finance teams precise control over every position, salary segment, oncost, and allowance.

Labour Panel — Roads Dept / Salaries & Wages
Export + Add Position
Positions
3
Total FTE
2.6
Gross Salary
$284,200
With Oncosts
$341,040
Roads Coordinator
1.0 FTE · Jul–Jun · Grade 9 Step 2
$163,400
incl. oncosts
Method
Rate Table
Rate
$72.60/hr
Annual
$142,000
Superannuation 11.5%$16,330
Payroll Tax 5.45%$7,739
Workers Comp 0.9%$1,278
Road Worker (2× 0.8 FTE)
Aug–Jun · Grade 4
$177,640
incl. oncosts
Allowance: Tool $800 Allowance: Uniform $420

Salary Segments

Each position can have multiple date-ranged salary segments — for example a staff member at Step 3 from July, promoted to Step 5 from January. The system calculates the blended annual cost automatically.

Award Rate Tables

Configure 2D rate lookup tables based on your enterprise agreements — classification on one axis, step on the other. Staff members are assigned a classification and step, and the hourly rate is retrieved automatically.

Oncost Profiles

Different departments often have different oncost rates (e.g. different workers' comp risk categories). Oncost profiles let you define rate sets per department, applied automatically when labour in that department is calculated.

Allowances

Vehicle allowances, tool allowances, uniform allowances — each type is linked to a specific budget account. Configure whether oncosts apply to each allowance type. Multiple allowances per position are supported.

Calculated Columns

Add custom formula columns to the Labour Panel for analysis — e.g. "Annual Cost per FTE" or "Oncost %" — using the Labour Calculated Columns configuration in Organisation Settings.

Labour Export / Import

Export the full labour dataset for a budget to Excel for review or offline editing. Import it back in using the structured template. Ideal for bulk position uploads at the start of a new budget year.

Structured multi-step budget approvals

Replace email chains and spreadsheet status trackers with a purpose-built approval workflow engine. Define reusable templates, attach them to any budget version, and track progress in real time.

Reusable Workflow Templates

Create templates once in Organisation Settings (e.g. "Standard Operating Budget Approval") with as many steps as you need. Attach the same template to multiple budgets — each gets its own independent workflow instance.

Advance & Reject

Authorised users can advance the workflow to the next step or reject it back to a previous step. A mandatory comment is required on rejection, giving the submitter clear feedback on what needs to change.

In-App Notifications

Users are notified automatically at each step transition. The notification bell in the header shows a badge count. Notifications include the budget name, action taken, and a direct link to the budget in question.

Budget Locking

A budget can be locked to prevent edits during approval. Locks can be applied at the whole-budget level or at individual period level (e.g. lock July–September once actuals are confirmed). Only admins can lock/unlock.

Full Audit Trail

Every advance, rejection, comment, and lock/unlock is recorded in the audit log with user identity and timestamp. The workflow history panel on each budget card shows the complete step-by-step history.

Workflow — 2026/27 Adopted Budget
In Progress
Template
Standard Operating Budget Approval
Step 2 of 4
Department Preparation

Completed by J. Smith · 14 May 2026

Done
2
Finance Team Review

Assigned to Finance & Admin Team

Active
3
CFO Approval

Awaiting step 2 completion

Pending
4
Executive Approval

Final approval step

Pending

Complete financial statement reporting

Built-in reports for all core financial statements, with configurable account mapping, drill-down grouping, and one-click Excel export. Save report configurations for reuse across budget cycles.

Income Statement — FY2025/26
Budget vs Actual Export
Account
Budget
Actual
Var
INCOME
$18,240,000
$18,840,000
+$600K
$14,100,000
$14,280,000
+$180K
$2,840,000
$3,180,000
+$340K
$1,300,000
$1,380,000
+$80K
EXPENDITURE
$17,620,000
$17,910,000
−$290K
$9,840,000
$10,020,000
−$180K
$4,920,000
$4,880,000
+$40K
NET RESULT
$620,000
$930,000
+$310K

Full Financial Statement Suite

Income Statement, Statement of Financial Position (Balance Sheet), Cash Flow Statement, Statement of Changes in Equity, and Comprehensive Income Statement — all included and ready to configure.

Account Mapping

Each statement has a configurable mapping screen where you assign your GL accounts to the correct report line items. Mapping is saved and reused every time you run the report.

Saved Report Configurations

Create named report configurations with specific budgets, organisational levels, comparison columns, and row filters. Re-run any saved report with one click — ideal for monthly management reporting.

Drill-Down & Filtering

Group headers are collapsible — collapse all directorates to see a high-level view, then expand individual departments to drill into the detail. Runtime filters can be applied without altering the saved configuration.

Excel Export

Every report can be exported to a formatted .xlsx file with proper formatting, grouping levels, and summary rows. The export respects the current collapse state and applied filters.

Distribute shared costs intelligently

Define allocation drivers (floor space, headcount, FTE) with values per cost centre, then create rules that automatically distribute shared budget amounts — like IT, HR, or building costs — across the consuming departments.

Named Allocation Drivers

Create drivers like "Floor Space m²", "Headcount", or "FTE" with a value entered for each cost centre. Drivers update automatically when your org structure changes, or you can update them manually each budget year.

Allocation Rules

A rule links a source budget row (the shared cost) to a driver and a set of target cost centres. The system calculates each target's share based on their proportion of the total driver value.

Visual Indicators in Grid

Allocated amounts appear as sub-rows directly beneath the parent account. Amber rows show amounts allocated out; blue rows show amounts allocated in. This makes it instantly clear which cost centres are net absorbers or net contributors.

One-Click Recalculate

Run all allocation rules at once with "Recalculate All" from the Budget Management page, or recalculate individual rules from Organisation Settings. Changes to source amounts recalculate on demand.

Cost Allocation — IT Services
Driver: FTE
Source: IT Services / Software & Licences — $240,000
📤 IT Services (source) Total pool −$240,000
Allocation to cost centres (FTE driver)
📥 Infrastructure Services 42.0 FTE (35%) +$84,000
📥 Community Services 36.0 FTE (30%) +$72,000
📥 Corporate Services 30.0 FTE (25%) +$60,000
📥 Governance & CEO 12.0 FTE (10%) +$24,000
Total FTE: 120 · Check: $84K + $72K + $60K + $24K = $240,000 ✓

Sync directly from your financial system

Stop manually exporting from one system and importing into another. Benchmark Budgeting's ETL engine connects directly to your financial system to sync org structures, budget data, and actuals on a schedule.

What Gets Synced

The ETL engine can sync three things: (1) organisational elements (your chart of accounts, cost centres, departments), (2) budget amounts from your financial system, and (3) actual transaction data for comparison against budget.

Scheduled or On-Demand

Configure ETL jobs to run on a schedule (e.g. nightly at 2am) or trigger them manually from the ETL Sync page. The sync log shows exactly what was added, updated, or skipped — with row-level detail for troubleshooting.

Transformer Pipeline

Each adapter follows an Extract → Transform → Load pipeline. The transform layer maps your source system's field names and codes to Benchmark Budgeting's schema, with configurable mappings per tenant.

CSV/Excel Fallback

For systems without a native adapter, the import page accepts a structured .xlsx file. The system validates each row, reports errors (unknown account codes, missing cost centres), and shows a preview before committing.

ETL Sync Log — TechOne Finance One
Completed
2,847
Rows loaded
14
New elements
3
Warnings
02:00:01 INFO Starting TechOne sync job — tenant: metro_corp
02:00:03 INFO Fetching org elements — page 1/6 (500 rows)
02:00:08 OK Org elements synced: 2,847 rows, 14 new, 0 deleted
02:00:09 INFO Fetching transactions for FY2026, months 1–9
02:00:18 WARN 3 transactions reference unknown account: 91000, 91001, 91002
02:00:22 OK Sync complete in 21.4s — next run: tomorrow 02:00

Budget automation via natural language

The AI assistant — powered by Anthropic's Claude — understands your budget's structure and translates instructions into structured, reviewable plans. Think of it as an expert budget analyst that knows your data inside out.

Context-Aware Understanding

Before generating a plan, the assistant loads your organisation's chart of accounts, budget structure, and existing budget values. This means instructions like "increase operational costs" are understood in the context of your actual data — not a generic template.

Structured Mutation Plans

The AI returns a structured plan — not just text. The plan specifies exactly which rows will be modified, by what operation (multiply, add, set), and by what amount. You see the complete plan before anything is applied.

Scope Targeting

Instructions can target "all rows", "all Labour rows", "all rows in a specific grouping", or specific account IDs. The AI interprets natural language like "increase staff costs" to mean the appropriate labour grouping in your chart of accounts.

Clarification When Needed

When instructions are ambiguous, the assistant asks a clarifying question rather than guessing. For example, "which budget year do you mean?" or "by 'all projects', do you mean capital or operating?"

Privacy & Security

The assistant sends budget structure metadata to the Claude API — not individual financial dollar values. User input is sanitised to prevent prompt injection. The AI feature can be disabled per tenant for organisations that prefer not to use external AI services.

AI Assistant — Budget Mutation Examples
Example instruction
"Roll forward the 2025/26 adopted budget to 2026/27 and apply a 3.8% CPI increase to all non-salary lines"
Generated plan:
Copy budget 2025/26 → new "2026/27 Draft v1" · All non-Labour rows × 1.038 · Labour rows unchanged
Example instruction
"Reduce materials and consumables by 15% for a savings scenario"
Generated plan:
Rows in grouping "Materials & Consumables" × 0.85 · Estimated saving: $186,400
Example instruction
"Add $50,000 to account 43210 (Special Events) evenly spread across Q3 and Q4"
Generated plan:
Account 43210 · Add $8,333/month across Jan–Jun · Annual total +$50,000

Enterprise-grade security at every layer

Financial data is sensitive. Benchmark Budgeting is designed with defence-in-depth — multiple independent security controls so a single misconfiguration cannot expose your data.

Multi-Tenant Isolation

Each tenant has its own PostgreSQL database. Zero shared tables. A bug cannot expose one organisation's data to another. AsyncLocalStorage routes every query to the correct pool.

Session-Based Auth

Sessions stored server-side in PostgreSQL via connect-pg-simple. No sensitive data in browser-side cookies. Configurable session expiry. TOTP-based MFA available.

Granular RBAC

10 distinct permissions, configurable custom roles, and data scope restriction per user to specific directorates, departments, or cost centres.

Full Audit Log

Every user action — budget edits, role changes, approvals, imports — is recorded with user identity, timestamp, and change detail. Non-repudiable and immutable.

Security Headers

Helmet.js enforces security headers: CSP, HSTS, X-Frame-Options, X-Content-Type-Options. CORS is restricted to configured origins only.

Rate Limiting

Express-rate-limit with Redis backend protects all API endpoints from brute-force and DoS attacks. Login endpoints have stricter per-IP limits.

Powerful admin controls, simply managed

Tenant administrators and super admins have comprehensive tools for configuring the system, managing users, and maintaining the organisation's data — all within the application, no server access required.

⚙️ Organisation Settings

  • Budget level hierarchy (Directorate → Department → Cost Centre → Account)
  • Budget types with custom column layouts
  • Labour oncost types, allowance types, rate tables
  • Allocation drivers and rules
  • Workflow templates for budget approvals
  • Budget comment types

👥 Users & Permissions

  • Create and manage user accounts with roles
  • Custom role definitions with granular permissions
  • Data scope restriction per user or group
  • Budget locks management across all budgets
  • Active workflow overview across all budgets
  • Chronological audit log with search and filter

📋 Budget Management

  • Create, copy, and version budget records
  • Lock/unlock individual budgets or periods
  • Attach and manage approval workflows
  • Budget snapshots — restore previous states
  • Forecast budgets with Sync Actuals

🔧 Element Maintenance

  • Maintain chart of accounts, cost centres, departments
  • Configure groupings (e.g. account type, function)
  • Set display order, codes, and descriptions
  • Labour account tagging (Salary, Oncost types)
  • Document library management

See it working with your data

We'll configure a demonstration environment using your organisation's actual structure and chart of accounts — so you can see exactly how Benchmark Budgeting fits your workflow.