
A small business budget is a financial plan compared with actual results every month. This guide covers how to prepare one in 5 steps, from sales to cash, how to track variances with a worked example, and 4 mistakes that make it worthless.
A small business budget is not a spreadsheet prepared at the start of the year and then forgotten. It is a financial plan compared with actual results every month, to show where the company is drifting and why.
A small company needs it even more than a large one, because its margin for error on cash is narrower.
How to Prepare a Small Business Budget in 5 Steps
1. The sales budget
The starting point is expected sales for each product or service by month, based on:
- Last year’s performance.
- Contracts already in place.
- The marketing plan.
- Seasonality and inflation.
2. Cost of sales
The cost of materials or goods and direct labour per unit, allowing for price changes during the year.
3. Fixed expenses
- Rent and administrative salaries.
- Subscriptions and professional fees.
- Social insurance contributions, calculated within the insurable wage limits in force.
- The annual raise required by Egypt’s Labour Law No. 14 of 2025, at no less than 3% of the insurable wage.
4. Capital spending
The assets to be bought, when they will be bought, and how they will be financed.
5. The cash budget
Everything above is converted into monthly collection and payment dates. The aim is to identify the months in which the company will need financing before they arrive.
How Is a Small Business Budget Tracked Each Month?
A simple schedule is enough. For each line it shows four figures: budget, actual, variance and variance percentage, followed by the reason for the variance.
Attention goes only to large variances, such as those above 10%.
Worked example
A company budgeted March sales of EGP 400,000 and marketing expenses of EGP 20,000:
- Actual sales: EGP 340,000. Variance: EGP 60,000 unfavourable, or 15%. This is above the threshold and should be investigated.
- Actual marketing: EGP 21,000. Variance: EGP 1,000 over, or 5%. This is within the threshold and needs no action.
What if conditions change during the year?
The forecast for the remaining months is updated. This is known as a rolling forecast. Holding on to figures that reality has overtaken makes the comparison meaningless.
4 Mistakes That Make a Small Business Budget Worthless
- An over-ambitious sales budget on which real commitments such as hiring and leases are then built.
- Leaving out taxes, social insurance and raises when estimating expenses.
- Preparing the budget in the finance department alone, without department heads, so they feel no ownership of it.
- Skipping the monthly review, which turns the budget into a document with no effect on decisions.
Downloadable template
Download: Budget and monthly follow-up (Excel, in Arabic)
A monthly budget for the year and a follow-up sheet that pulls the plan for the selected month, calculates variances and highlights the material ones.
References
- Labour Law No. 14 of 2025
- NOSI: minimum and maximum insurable wage raised from 1 January 2026
- Egyptian Accounting Standards issued by Minister of Investment Decree No. 110 of 2015, as amended