Building an Annual Budget From Scratch: 6 Steps for Non-Accountants
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.
Take your total revenue for last year.
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.
Data-backed guides on AI, eCommerce, and SME strategy — straight to your inbox.
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.
- 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.
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