End-of-year offer Planner for the price of Reporter for two years, set up for you during a free 30-day trial. Ten places, start by 31 January.
Solutions · Month-end close

The variance report
that answers "why?"

Every close ends the same way: a number moved, and someone senior wants to know why. SwiftBalance turns that from a week of spreadsheet archaeology into a click — decompose the movement, drill to the rows behind it, and capture the explanation next to the number.

Start freeSee the platform
Sales overview: the month and year to date against last year, with KPI tiles and variances
The report

Actual vs budget vs prior,
at every level.

One template shows the whole story — any two scenarios side by side, variances computed at every node of your hierarchy, favourable and adverse styled automatically. Next month's upload refreshes it without touching the layout.

  • 01Any scenario pair — Actual vs Budget, vs Prior Year, vs Forecast
  • 02Variances at every hierarchy level, from entity down to account
  • 03Conditional formatting for thresholds and materiality
  • 04One-click export to styled .xlsx for the board pack
Net sales price, volume and mix bridge: the change split into units, price and mix effects
Why this number? → Net sales
Why this number? on net sales: the formula, its inputs and a button to show the rows used
The why

Decompose the movement,
then drill into it.

A bridge shows which categories drove the total. Click any bar and SwiftBalance ranks the contributors underneath it — by cost centre, product, region, any dimension — until you're looking at the rows that caused it.

  • 01Variance bridges from baseline to comparison, category by category
  • 02Price × Volume × Mix decomposition for rate-and-quantity metrics
  • 03Top-contributor ranking with cumulative % at every drill level
  • 04Straight through to the underlying transactions
Sales overview with the Comments panel open: a note on September net sales explains the rise against last year, pinned to that cell
The explanation

The commentary lives with the number.

The explanation you chased through email last month? It's pinned to the cell — threaded, @-mentionable, and still there when next period's data arrives. AI commentary drafts the first pass from the decomposition itself.

  • 01Threaded comments pinned to account + period
  • 02@-mention teammates — email and in-app notifications
  • 03AI-generated variance narrative, grounded in the decomposition
  • 04Comments survive every refresh and every export
How it works

From trial balance to explained variance in three moves.

01

Upload

Drop the actuals and budget extracts you already produce. Periods and scenarios are detected on load.

→ actuals_2026_07.csv
→ budget_2026.xlsx
✓ scenarios matched
02

Template

Shape the P&L once — rows, subtotals, scenario columns, variance columns. Formatting is part of the template.

[GROUP] Revenue
[Σ] Gross Profit
[Δ] Act vs Bud · %
03

Explain

Open the bridge on any movement, drill to the drivers, pin the explanation. The pack exports itself.

Opex · +4.01M fav
→ drill → Payroll
✓ commented · exported

Common questions

Do I have to rebuild the report every month?

No — that's the point. The template holds the layout, scenarios and formatting. Each period you upload the new extract and every report reading from that data refreshes.

Can it compare more than two scenarios?

Yes. Actual, Budget, Prior Year and Forecast can sit side by side in one template, each pair with its own variance columns.

What does the drill-through actually show?

The underlying data rows behind the cell you clicked, with the report's filters and the drill path applied — so the number and its rows always tie.

Does it replace our Excel board pack?

It produces it. Every report exports to styled .xlsx — formatting, hierarchy and variance columns intact — so the pack looks the way it always has, without the week of assembly.

Close the month.
Keep the explanations.

Start free with your latest trial balance and budget, or book a 20-minute walkthrough.

Start free Book a walkthrough