Financial management · 16 min read · Updated: 2026-10-12

Annual budget planning for SMEs: from a one-page plan to monthly variance tracking

A budget isn't a contest to predict the future; it's a yardstick that helps you spot early what isn't going to plan during the year. In this article we build an SME budget in five steps, then compare it with the actuals every month.

In short

• An annual budget has three parts: the revenue forecast, the expense budget and the cash budget, and each becomes a management tool once it's split into months.
• A revenue forecast built from drivers such as number of customers, order frequency, quantity and price, rather than adding a percentage to last year's turnover, is both more accurate and easier to discuss.
• The profit budget and the cash budget can give different results for the same month; a business that sells on credit terms can lose cash in a profitable month.
• Preparing three scenarios, base, pessimistic and optimistic, shows which assumption has the biggest impact on profit and cash.
• A budget's value comes from monthly variance tracking: comparing actuals with the budget and writing down the cause of any difference above 5-10% is a good enough start.

Last March, while reviewing the first quarter, Atlas Kahve's founder Deniz Hanım noticed something: sales were "going well", but she didn't know well compared to what. There was no target and no plan, only the same month last year. And because of inflation, the same month last year said almost nothing.

A budget is exactly the answer to that "compared to what?" question. October and November are the best months to build next year's budget: you have most of the year's actuals in hand and enough time to start January ready. By the end of this article you'll have a template you can copy into a spreadsheet and a variance routine you'll repeat every month.

Part 1 · Definition What is an annual budget, and why does an SME need one?

An annual budget is a numerical plan that shows, month by month, the income a business expects over the next 12 months, the expenses it will incur and its cash inflows and outflows. Unlike the thick binders of large corporations, an SME budget can, and should, fit in a single table.

A budget's real job isn't forecasting, it's comparison. If your sales in March are 8% below budget, you know it in March, not in December. You make pricing, campaign, hiring or investment decisions with that early warning.

1. October — Gather this year's actuals
2. November — Assumptions and scenarios
3. December — Split the budget into months, approve
4. Every month — Compare with actuals
5. Every quarter — Update the forecast

The first step is gathering this year's actuals. The best forecast starts from an honest reading of the past.

Part 2 · Preparation What data should you gather before you start the budget?

The first step in budget preparation is extracting the last 12 months of sales, expense and collection data, month by month and line by line. This data is both the starting point for your assumptions and the only source that shows seasonality.

Data preparation before budgeting

• Extract the last 12 months' monthly sales by customer group or product group.
• Extract the last 12 months' expenses by category; classify any uncategorised documents.
• Note the average collection period and the payment habits of your 10 largest customers.
• Pin down headcount and the monthly cost per employee.
• Write down the new-year amounts and increase dates of contract-based expenses such as rent, insurance and loans.
• List the investments, hires and new products planned for the new year.

The data is ready. Now on to the hardest and most important line of the budget: revenue.

Part 3 · Revenue How do you forecast revenue?

A revenue forecast calculates next year's sales by breaking them down into drivers such as number of customers, order frequency, order size and price. The "last year plus 30%" method is quick but doesn't tell you what will change; the driver method lets you see month by month which assumption is holding and which isn't.

Each driver can be discussed on its own: the sales team owns the new café target, operations owns consumption per café and the founder owns pricing policy. When a variance appears during the year, it's immediately clear which driver didn't hold.

The same method applies to every sales channel. For Atlas Kahve's four channels, the table looked like this:

Once the revenue figure is on the page, most business owners breathe a sigh of relief. But the real question is how much of that revenue you'll keep.

Part 4 · Expenses How do you build an expense budget? A template table

An expense budget plans variable expenses, which rise and fall with sales, separately from fixed expenses, which are paid regardless of sales. Variable expenses are written as a percentage of revenue, fixed expenses as amounts based on contracts and headcount.

• Variable expenses: raw materials, packaging, shipping, marketplace commission. For Atlas Kahve, cost of goods sold was taken as roughly 60% of revenue.
• Fixed expenses: salaries and SGK (social security) contributions, rent, software, insurance, accounting services. They're entered by month along with their increase dates.
• Semi-fixed expenses: energy, maintenance, marketing. Known changes are added to last year's average.
• Financing costs: loan interest and fees, according to the loan schedule.

Notice two things in the table. First, sales weren't split evenly across the months: in coffee, the winter months are quieter and spring and autumn busier. Take the seasonality from last year's monthly breakdown. Second, "Other operating expenses" is a single line; starting this simple in the first year is better than not starting at all.

Operating profit shows 133,000 TL in January. But will there be 133,000 TL more in the bank at the end of January? This is exactly where most businesses' budgets go wrong.

Part 5 · Cash Why are the profit budget and the cash budget different?

A cash budget places the amounts in the revenue and expense budget not in the month the invoice is issued, but in the month the money actually comes in or goes out. Credit sales, supplier payment terms, tax and SGK payment schedules and loan instalments are what separate the two budgets.

While January is budgeted at 133,000 TL operating profit, cash falls by 15,000 TL. The reason is that December purchases and tax payments fall due in January. The figures are illustrative; confirm tax payment dates with your mali müşavir (certified financial advisor).

Keeping the cash budget monthly is enough for the annual plan. If you want to see the next few months in weekly detail, put the 13-week table from the cash flow management article next to this budget.

Part 6 · Scenarios What if sales fall short? A three-scenario budget

A scenario budget shifts the main assumptions in a pessimistic and an optimistic direction and shows how profit and cash are affected. The aim isn't to know which scenario is right, but to decide today what you'll do if the pessimistic one plays out.

The most valuable column in the table is the last one. If what you'll do when the pessimistic scenario starts to materialise is written down in advance, you have a checklist instead of panic when it's time to decide. Also decide when you'll pull the trigger: for example, "if sales are 8% below budget for two months in a row".

Part 7 · Tracking How do you track budget variances every month?

Budget variance tracking means comparing actual figures with the budget at the end of each month, calculating the difference as an amount and a percentage, and writing down the cause and the action for any difference above a set threshold. For SMEs, a threshold of 5-10% is a good starting point.

Every line in the table has a one-sentence explanation. The value of a variance report isn't in the numbers but in those sentences: when you look back a year later, these notes tell you which assumption was systematically wrong.

A 30-minute monthly variance routine

1. Close the month

   First make sure invoices, expenses and collections have all been entered. Variance analysis on incomplete data produces false alarms. We explained the order in the month-end closing checklist article.

2. Pull the actuals

   Set the period to the relevant month in the Sales, Income and expense and Cash flow reports; bring the sales and expense data into your table with Download CSV.

   

3. Calculate the difference

   Write down the amount and percentage variance for each line. Flag the ones above the threshold.

4. Write down the cause and the action

   Add a one-sentence cause and an owner to every flagged line. Separate one-off variances from lasting ones.

5. Update the forecast at quarter-end

   Reflect lasting variances in the "year-end forecast" column and check whether any pessimistic-scenario actions have been triggered.

A budget isn't measured by whether it holds at year-end, but by how many decisions it helps you make early during the year.

This year, for the first time, Deniz Hanım will start with a target in the first week of January, not in March. While preparing the budget, don't forget to put the year-end close on the same calendar: the counts and reconciliations in the year-end closing guide article make your new budget's opening figures accurate.

Pull the first line of your budget today Select the last 12 months in the income and expense report, download the monthly sales and expense breakdown as CSV and fill in the actuals column of your 2027 budget template. Open the income and expense report

Author: Heyşirket Editorial Team