Annual Budget Template for Finance Teams
Four documents and five sheets, seeded from your own ledger, where the budget will not close until every dollar of change names an assumption.
Free download · No account needed
Assumption Bridge
[Entity] — the identity that has to hold
On revenue, on gross margin, and on operating expense. Separately, and each one to zero.
| budget − actual | = | sum of the numbered assumptions |
Whatever is left over is the residual. It sits at the top of the sheet, in dollars and as a share of the change, until it is zero. It is not a contingency line and it is not a rounding allowance.
Every assumption carries these, or it is not an assumption
| Field | What goes in it |
|---|---|
| Number | Assigned once, kept for the life of the budget |
| Version | A revision keeps the number and gains a version |
| Quantity | The countable thing. Heads, accounts, pounds, stores |
| Rate | The per unit amount. Price, wage, premium, margin |
| Starts | The month the change begins. Not the year |
| Annual and phased | Both, where they differ. The bridge uses the phased one |
| Evidence class | One of four, below |
Four evidence classes
| Signed document | Contract, lease, amendment, notice. Name it |
| Measured from our own actuals | Name the period and the report |
| Third party quote or renewal | Name the counterparty and the date |
| Management judgement | No external evidence. Allowed, and disclosed |
The residual is read in both directions
| Positive | The budget holds dollars no assumption explains |
| Negative | The assumptions claim dollars the budget does not carry |
Most budget reviews only ever look for the first one. The second is where double counting and a full year cost against a phased plan both hide.
Every annual budget template is the same twelve month grid: categories down the side, months across the top, formulas in the totals. The grid is not the problem. The problem is that it opens empty, so the first number in every cell is invented, and once a figure sits in a cell it stops being a claim anyone has to defend. By March nobody remembers whether the marketing line was measured, quoted or guessed, and the person who typed it has moved on.
Here every account opens at what it actually cost, read from the ledger, so only the lines that move need explaining. Budget minus actual has to equal the sum of the numbered assumptions, separately on revenue, on gross margin and on operating expense. Aldergate Roasters, an illustrative wholesale coffee roaster, bridged 41,280,000 of FY2026 actuals to a first pass FY2027 budget of 47,650,000 and found 1,143,000 of the increase, 17.9 percent of it, with no assumption behind it at all.
Of that, 618,000 was a real own label program nobody had written down. The other 525,000 could not state its evidence and came out, so the budget fell. The Commission's own view is that a projection should have a reasonable basis, and auditors are told to weigh the support for significant assumptions behind forward numbers. Cost the new roles in the headcount plan before they reach this bridge.
What's in the pack
Assumption Bridge sheet
One row per assumption across all three bridges, with the quantity, the rate, the start month, the annual and phased amounts, the evidence class and the document behind it. The residual sits at the top of each bridge. This is the file the rest of the pack exists to serve.
Assumptions Book
The reasoning, versioned in place beside the model. Where the budget was seeded from, the three bridges and their residuals, every assumption by number, the evidence summary, the version history, and the challenges answered so far with their arithmetic.
Space rule
Budget minus actual equals the sum of the numbered assumptions, on revenue, gross margin and operating expense separately. The residual is read in both directions, no contingency line is permitted, and an assumption is versioned rather than edited. It governs every prompt in the space.
Department Instructions
Ready to send to budget owners. It asks for four fields per change rather than a number in a cell: what changes, the quantity, the rate, the month it starts. It also says plainly why a total with no assumption comes back.
P and L Budget sheet
Prior year actual, budget, change and the four quarters, on revenue by stream, cost of sales, gross profit, three operating expense lines and operating income. Seeded from the ledger, so the opening state is real.
Headcount Plan sheet
Every role with its base, the load factor, the annual loaded cost, the start month and the phased cost in the budget year, as separate columns. The phased column is what the bridge uses. Set the loaded rate itself in the headcount cost model.
Capex Plan sheet
Item, cost, life, in service month, full year and budget year depreciation, and whether the spend is committed under a signed document. The net depreciation increment ties to one named assumption. Price the individual case in the capex request tool.
Budget vs Prior Year sheet
Every line with its change, its percentage, the assumption numbers that moved it and its own residual column. A line whose residual is not zero is visible here before anyone opens the memo.
Budget Memo
The recommendation, how the budget was built, what the bridge caught in both directions, the evidence class summary with the judgement assumptions named, headcount and capex, and a section on what is deliberately not in the budget.
Budget Presentation
Eight slides plus six appendices, each naming the sheet it reads from. No figure is retyped, so the deck cannot disagree with the memo. Slide four is what the bridge caught, which is what makes the zero on slide three believable.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent seed it from your own ledger, or download the blank Word and CSV files instantly with no account.
- 2
Send the ledger before anything else
The current year at account level. A trial balance export is a normal start. Add the payroll register, because the merit assumption needs the continuing salary base rather than total payroll.
- 3
Let the seed run, then send the instructions out
Every account opens at its actual and the budget briefly equals last year, which is the correct starting state. Department Instructions goes to your owners while the finance work continues.
- 4
Attribute the changes, then drive the residual to zero
Each dollar of change gets a numbered assumption with an evidence class. Then the residual is worked in both directions until all three bridges close, and only after that are the memo and the presentation written.
Frequently asked questions
Is this template free?
Completely. Take the Word documents and CSV sheets with no signup, no card and no trial. Edit with AI is an optional second path for anyone who would rather the agent seed the budget from their own ledger than remap every account by hand. More packs sit in the template library.
What is the residual, and why not just add a contingency line?
The residual is the budget dollars no assumption explains. A contingency line is the same dollars with a label on top, so it closes the arithmetic without answering the question. If you want a contingency, make it a real assumption with an amount and an owner, in the judgement class, where a reviewer sees it.
A department sent me a number with no assumption behind it. Now what?
It goes back, and Department Instructions says so in advance so it is not a surprise. A total cannot be bridged, so it lands in the residual and blocks submission. Asking for the four fields takes minutes. Reverse engineering someone else's number in month seven takes considerably longer.
How is this different from a budget spreadsheet?
A spreadsheet gives you the grid, the formulas and the twelve columns, which this pack also has. What it adds is the constraint underneath: the model opens at your actuals rather than empty, and it will not close while any dollar of change has no named assumption and no evidence class.
Does it handle the mid-year reforecast?
No, and deliberately. This space builds the budget and then answers challenges against the book it wrote. Whether a variance is big enough to rebuild is handled in the reforecast trigger review. Carrying a twelve month view forward monthly instead is the rolling forecast pack.
What format are the downloaded files?
Four .docx documents covering the assumptions book, the department instructions, the memo and the presentation outline, plus five .csv sheets, all in one zip. Everything opens natively in Word, Pages, Google Docs, Excel, Numbers and Sheets with no conversion step.
What does Edit with AI actually do?
It opens a free River account with this pack installed as a private workspace, primed to read your ledger, seed every account at its actual and build the bridges. Send nothing and it writes nothing. The approved budget then feeds the board financial package.
Start the budget at what last year actually cost
Download the blank pack as Word and CSV files, or open this exact pack in River and let the agent seed every account from your own ledger.
Edit with AI