Building an Annual Budget From Scratch: 6 Steps for Non-Accountants
- Why Most SMB Budgets Fail by February
- Step 1: Pull Two Years of Actuals From Xero
- Step 2: Set a Revenue Target Based on Reality
- Step 3: Build Your Cost Budget From Fixed and Variable Costs
- Steps 4–6: Gross Profit, Net Profit, and Cash Flow
- Worked Example: A Garden Centre's First Real Budget
- Keeping the Budget Alive Past February
Most small business owners either skip the annual budget entirely or produce one in January that's forgotten by March. A working budget — built in six steps from your actual trading history — gives you a financial target for every month of the year, a baseline for variance analysis, and a credible document for your bank or investors. AskBiz and Xero make this a one-afternoon exercise, not a month-long ordeal.
- Why Most SMB Budgets Fail by February
- Step 1: Pull Two Years of Actuals From Xero
- Step 2: Set a Revenue Target Based on Reality
- Step 3: Build Your Cost Budget From Fixed and Variable Costs
- Steps 4–6: Gross Profit, Net Profit, and Cash Flow
Why Most SMB Budgets Fail by February#
The typical small business budget is built by taking last year's revenue, adding 10%, and calling it done. No monthly breakdown, no cost analysis, no consideration of seasonal patterns. When February turns out to be 30% below January (because it always is, in retail and hospitality), the budget shows a massive shortfall and the owner stops looking at it. By March, the budget is an embarrassing document in a drawer. The fix isn't more sophisticated modelling — it's building a budget that reflects how the business actually trades, not how the owner wishes it would.
Step 1: Pull Two Years of Actuals From Xero#
In Xero, run a Profit & Loss report for the last two complete years, broken down by month. Export to Excel. This is your foundation. Look for seasonal patterns: which months are consistently strong, which are weak? For a restaurant, December is probably 40% above the annual average. January is probably 25% below. These patterns almost always repeat — your budget should reflect them, not assume flat trading across 12 months. AskBiz can pull this historical data and apply the seasonal index to your revenue forecast automatically.
Step 2: Set a Revenue Target Based on Reality#
Take your total revenue for last year. Ask: what is realistically different this year? New product line (+12% revenue)? Lost a major client (−15%)? New location opening in Q3 (+8% from September)? Apply those adjustments to your historical monthly pattern. Your annual revenue target now has a monthly breakdown that reflects both your growth assumptions and your seasonal reality. Resist the temptation to assume Q1 will trade like Q4 because you're optimistic — the forecast will be wrong within three weeks and you'll abandon it.
Step 3: Build Your Cost Budget From Fixed and Variable Costs#
Separate costs into fixed (rent, insurance, software subscriptions, salaried staff — the same every month regardless of revenue) and variable (materials, hourly wages, packaging, payment processing fees — scale with revenue). Fixed costs are easy: multiply the monthly amount by 12. Variable costs: calculate as a percentage of revenue from last year's actuals, then apply that percentage to your monthly revenue forecast. If materials were 34% of revenue last year and you don't expect that to change, your monthly materials budget is 34% of your monthly revenue target.
Steps 4–6: Gross Profit, Net Profit, and Cash Flow#
Step 4: Calculate gross profit per month (revenue minus variable costs). Step 5: Calculate net profit per month (gross profit minus fixed costs). Step 6: Adjust for cash timing — your P&L budget assumes cash and revenue move together, but they don't. If you invoice 30-day terms, January revenue arrives in February. Build a simple cash conversion adjustment: shift your revenue receipts forward by your average debtor days. This gives you a budget P&L and a budget cash flow — two different documents that together tell the complete financial story of your planned year.
Worked Example: A Garden Centre's First Real Budget#
A Kent garden centre with £620,000 annual revenue had never built a formal budget — the owner "just knew" trading was strongest March to June and quiet in November and December. Pulling two years of Xero P&L data confirmed the pattern precisely: April alone was 16% of annual revenue, while November and December combined were only 8%. Applying that seasonal index to a flat 6% growth target produced a monthly budget that finally matched reality — previous ad hoc targets had assumed roughly equal monthly trading, which made every winter month look like a crisis and every spring month look like an unearned win. With the corrected budget, the owner could see that January's £24,000 target (not the old flat-average £51,000) was genuinely achievable, and stopped panicking about a "shortfall" that was actually just seasonality.
Keeping the Budget Alive Past February#
The single biggest reason annual budgets get abandoned is that nobody looks at them after the January planning session. Put a recurring 30-minute slot in the calendar — the first working day of each month — to pull actuals against budget for the month just closed. This is not a full re-forecast; it's a quick gut-check: are we broadly on track, and if not, why? AskBiz automates the comparison so this becomes a five-minute review of a pre-built report rather than an hour rebuilding a spreadsheet. Businesses that keep this monthly rhythm going report using their budget as an active decision tool by June; businesses that skip more than two consecutive months almost never pick the habit back up.
People also ask
How long does it take to build an annual budget for a small business?
With two years of Xero data and AskBiz to structure the analysis, a solid annual budget takes four to six hours for a single-site SMB. Set aside a Saturday morning and you'll have it done before lunch.
Should I involve my accountant in the budget process?
Yes — for a review, not the build. Prepare the draft yourself using your operational knowledge, then share with your accountant for a one-hour review. They'll catch any tax or accounting assumptions you've missed. You'll own the operational assumptions. That partnership produces a better budget than either of you would build alone.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Try AskBiz Free — Build Your Annual Budget and Track It vs Actuals in Your Dashboard
Pull two years of Xero data, build your annual budget, and get weekly variance alerts — all in one platform. Free 14-day trial, no card required.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes