River
Y CombinatorBacked by Y Combinator
Log InStart Free
FREE TEMPLATE

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.

Edit with AIDownload (.docx + .csv)

Free download  ·  No account needed

What you get

Pack of 9 files: 4 documents, 5 spreadsheets

Annual Budget Template for Finance Teams
  • Assumptions BookDocument
  • Department InstructionsDocument
  • Budget MemoDocument
  • Budget PresentationDocument
  • Assumption BridgeSpreadsheet
  • P and L BudgetSpreadsheet
  • Headcount PlanSpreadsheet
  • Capex PlanSpreadsheet
  • Budget vs Prior YearSpreadsheet
RiverAnnual Budget Template for Finance Teams

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

FieldWhat goes in it
NumberAssigned once, kept for the life of the budget
VersionA revision keeps the number and gains a version
QuantityThe countable thing. Heads, accounts, pounds, stores
RateThe per unit amount. Price, wage, premium, margin
StartsThe month the change begins. Not the year
Annual and phasedBoth, where they differ. The bridge uses the phased one
Evidence classOne of four, below

Four evidence classes

Signed documentContract, lease, amendment, notice. Name it
Measured from our own actualsName the period and the report
Third party quote or renewalName the counterparty and the date
Management judgementNo external evidence. Allowed, and disclosed

The residual is read in both directions

PositiveThe budget holds dollars no assumption explains
NegativeThe 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.

Four of the pack's files, worked through for one budget year

The Assumption Bridge, Budget vs Prior Year, Headcount Plan and one challenge answered from the book.

Annual Budget Template for Finance Teams
RiverBridge

Assumption Bridge

Aldergate Roasters, Inc. FY2026 actual to FY2027 budget. An illustrative wholesale coffee roaster.

Revenue, first pass

#AssumptionQuantityRateStartsAmountEvidence class
A-01Wholesale price increase34,100,0002.4%Mar682,000Signed document
A-02Volume, existing accounts412 accts3.1%Jan1,057,100Measured
A-03Twelve accounts signed in Q412 accts215,417 eaFeb2,585,000Signed document
A-04Halloway Markets contract ends1 acct1,412,000Jan(1,412,000)Signed document
A-05Two new retail locations2 stores820,000 eaApr1,640,000Signed document
A-06Foodservice volume2,000,00012%Jan240,000Measured
A-07Mix shift to single origin1,240,000 lb0.35 / lbJan434,900Measured
 Attributed   5,227,000 
 Change, 41,280,000 to 47,650,000   6,370,000 
 RESIDUAL   1,143,00017.9% of the increase

How the revenue residual closed

ResolutionAmountWhat happened
A-08 written up618,000A real own label program for two grocery chains. Letter of intent signed 3 Dec 2026
Removed(525,000)No evidence offered on challenge. The budget total fell to 47,125,000
 0Change 5,845,000, attributed 5,845,000

Operating expense, first pass

#AssumptionAnnualIn budgetEvidence class
B-01Merit, 3.5% on 6,933,257242,664242,664Measured
B-02Eleven new hires1,186,2801,186,280Measured
B-03Health premium renewal, 9.4%148,000148,000Third party notice
B-04Roastery lease escalator74,00074,000Signed document
B-05Software renewals96,00096,000Third party notice
B-06Marketing program step up100,100100,100Judgement
B-07FY2026 legal settlement ends(220,000)(220,000)Judgement
B-08Depreciation, net of roll off135,000135,000Measured
 Attributed 1,762,044 
 Change, 11,740,000 to 13,090,000 1,350,000 
 RESIDUAL (412,044)Negative

Negative means the assumptions claim more than the budget carries. B-02 was stated at the eleven hires' full year loaded cost while the plan starts them across ten different months. Restated at the phased cost of 774,236, the bridge closes: attributed 1,350,000, residual zero. The 412,044 is what the budget would have been overstated by, and no positive residual check would have found it.

Gross margin, split before it is attributed

PartAmountNeeds assumptions?
Growth carried at the FY2026 rate of 36.0%2,104,200No. Mechanical
Rate change, 80 bps on budget revenue377,000Yes, all of it
Gross profit change2,481,200 
#AssumptionbpsAmountEvidence class
C-01Green coffee contracted to Sep 202745212,000Third party contract
C-02A-01 price increase reaching margin32151,000Measured
C-03Inbound freight surcharge(18)(85,000)Third party notice
C-04Roast yield gain on the new loader2199,000Measured
 Attributed80377,000Residual 0

Margin is attributed in basis points, not dollars. Eighty basis points add to the rate change exactly; four individually rounded dollar amounts miss it by a dollar, and a bridge off by a dollar from rounding looks identical to one off by a dollar because something is unexplained.

Rivervs Prior Year

Budget vs Prior Year

Every line carries the assumptions that moved it and its own residual.

LineFY2026 actualFY2027 budgetChange%AssumptionsResidual
Wholesale revenue34,100,00038,065,0003,965,00011.6%A-01 to A-04, A-07, A-080
Retail revenue5,180,0006,820,0001,640,00031.7%A-050
Foodservice revenue2,000,0002,240,000240,00012.0%A-060
Total revenue41,280,00047,125,0005,845,00014.2%A-01 to A-080
Cost of sales26,419,20029,783,0003,363,80012.7%C-01 to C-040
Gross profit14,860,80017,342,0002,481,20016.7%C-01 to C-040
Gross margin36.0%36.8%0.8pp 80 bps attributed0
Sales and marketing4,320,0004,963,442643,44214.9%B-01, B-02, B-03, B-05, B-060
Operations and G and A6,180,0006,828,558648,55810.5%B-01 to B-05, B-07, B-080
Product and R and D1,240,0001,298,00058,0004.7%B-01, B-03, B-050
Total operating expense11,740,00013,090,0001,350,00011.5%B-01 to B-080
Operating income3,120,8004,252,0001,131,20036.2%All twenty0

What the budget rests on

Evidence classAssumptionsGross dollarsShare
Signed document67,011,00063.7%
Measured from our own actuals83,133,90028.5%
Third party quote or renewal notice4541,0004.9%
Management judgement, no external evidence2320,1002.9%
Total2011,006,000100%

Two of the twenty assumptions rest on judgement alone, carrying 320,100 gross. Both are named on the slide and in the memo, because a reviewer who finds that number themselves treats it as something you hid.

RiverHeadcount

Headcount Plan

The sheet behind B-02. Eleven hires, loaded at 1.262, phased by start month.

P and L lineRoleBaseLoadedStartMonths paidPhased cost
Sales and marketingDirector of wholesale accounts138,000174,156Mar10145,130
Sales and marketingRegional account manager, Midwest92,000116,104Feb11106,429
Sales and marketingRegional account manager, Southeast92,000116,104Aug548,377
Operations and G and APlant manager116,000146,392Sep448,797
Operations and G and AProduction shift lead72,00090,864Feb1183,292
Operations and G and ARoaster operator56,00070,672Sep423,557
Operations and G and AQuality technician60,00075,720Mar1063,100
Sales and marketingStore manager, Fairmount66,00083,292Oct320,823
Sales and marketingAssistant store manager, Fairmount50,00063,100Mar1052,583
Operations and G and AController124,000156,488May8104,325
Operations and G and AStaff accountant74,00093,388Mar1077,823
Total, eleven hires  1,186,280  774,236
Difference, the B-02 first pass error412,044

The annual run rate and the phased cost are different numbers and both belong on the sheet. The bridge uses the phased one. A budget review that only sees the annual column cannot tell the two apart, which is exactly how the 412,044 got into the first pass.

Capex Plan, the sheet behind B-08

ItemCostLifeIn serviceFY2027 depreciationStatus
Second roast line loader and destoner690,00010 yrMar57,500Committed
Packaging line changeover tooling248,0005 yrFeb45,467Committed
Fairmount store buildout415,00010 yrJun24,208Committed
Delivery vehicles, three192,0005 yrApr28,800Committed
Warehouse management system275,0003 yrMay61,111Uncommitted
Warehouse racking and pick modules156,0007 yrMay14,857Uncommitted
Green coffee moisture and density analyser84,0005 yrFeb15,400Uncommitted
Roastery electrical service upgrade140,00015 yrJul4,666Uncommitted
Total, eight items2,200,000  252,0091,545,000 committed
Less assets reaching end of life   (117,009)Fixed asset register
Net increment carried in B-08   135,000B-08
RiverMonth seven

Month seven, a challenge answered from the book

A-01 challenged 14 July 2027

Wholesale revenue is running behind. The question in the room is whether the price increase was ever realistic.

What the book recorded at the time

FieldA-01 v1, entered 8 Dec 2026
AssumptionWholesale price increase of 2.4 percent
Quantity34,100,000 of wholesale revenue
Rate2.4 percent
StartsMarch, 10 of 12 months
Amount in budget682,000
Evidence classSigned document
DocumentBoard-approved pricing memo, 14 Oct 2026

The gap, decomposed

AssumedActualGap
Quantity34,100,00034,100,000none
Rate2.4%2.4%none
Timing1 March1 May2 months
Dollar effect682,000545,600136,400

The full year value of a 2.4 percent increase on 34,100,000 is 818,400. Ten months of it is 682,000, which is what the budget carried. The letters went out on 1 May rather than 1 March, so eight months of it is 545,600. The shortfall is 136,400 and all of it is timing.

The answer: the increase landed at exactly the rate assumed, on exactly the revenue base assumed. It started two months late. Nothing about the pricing decision was wrong and nothing needs re-arguing, because the evidence class recorded in December already says the rate came from a board-approved memo rather than from optimism.

Action: A-01 v2 restates the start month as May, carries 545,600, and records why. Version 1 stays readable. The 136,400 goes to the reforecast as a timing variance, not a pricing failure.

Without the quantity, rate and timing fields this is a forty minute meeting that ends in an opinion. With them it is three lines of arithmetic, and the two outcomes lead to completely different decisions: a rate that missed means repricing, a start month that slipped means chasing the letters out earlier next time.

Edit with AI

What's in the pack

01

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.

02

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.

03

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.

04

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.

05

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.

06

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.

07

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.

08

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.

09

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.

10

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. 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. 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. 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. 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.

Sources

  1. eCFR17 CFR 229.10 — (Item 10) General (opens in a new tab)
  2. PCAOBSupport for significant assumptions (opens in a new tab)

Written by

Chandler Supple

Co-founder & CEO, River

Chandler has spent the last six years working in AI, building tools for millions of users and Fortune 100 companies. In 2025, he co-founded River to build a new kind of operating system for AI agents.

LinkedInGitHubX

Reviewed by

Brian Joseff, Co-founder, River

LinkedInX

Related workspaces

Headcount planning and cost template

Where the loaded cost per role gets settled before it reaches the headcount plan.

Budget reforecast trigger checklist

Whether a variance against this budget is big enough to rebuild the forecast.

Capital expenditure request and payback

The individual case behind a line on the capex plan, priced against doing nothing.

More free templates

Budget Review Meeting Agenda Template

Free budget review meeting agenda template that flags a variance only past a dollar and percent threshold, then sizes its discussion time to match.

Department Budget Request Template

Free department budget request template that pre-fills each manager's own prior-year actuals, then holds any total or material change with no reason on file.

Headcount Planning and Cost Template

Free headcount planning template: cost every hire against the real wage bases and premium tiers, not a flat multiplier. Word and CSV, no signup.

Rolling 12 Month Forecast Template

Free rolling forecast template. Twelve forward months that roll instead of being rebuilt, and every revision classed as news or as re-estimation.

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