1
Define the budget period and structure
Choose whether the budget covers a calendar year, fiscal year, or a shorter rolling period. Decide whether you will break it down monthly, quarterly, or both β monthly is standard for most small businesses.
π‘ Monthly columns are worth the extra setup time β quarterly budgets miss seasonal cash crunches that only show up month by month.
2
List every revenue stream separately
Enter each product line, service type, or customer segment as its own row. For each, enter your projected monthly revenue based on price, volume, and expected growth rate.
π‘ Start from last year's actuals if available, then apply a documented growth assumption. If you have no history, use a bottom-up estimate: units sold Γ price.
3
Calculate cost of goods sold for each revenue stream
Assign the direct costs β materials, direct labor, third-party production β tied to each revenue line. Calculate gross margin for each stream so you can see which products or services are most profitable.
π‘ If gross margin varies significantly across streams, flag the lowest-margin lines for a pricing or cost review before finalizing the budget.
4
Enter all fixed operating expenses
List every recurring cost that does not change with volume: rent, base salaries, insurance, software subscriptions, and loan repayments. Verify each amount against current contracts and invoices.
π‘ Pull your last 12 months of bank statements and categorize every expense β most business owners discover 2β3 forgotten subscriptions during this step.
5
Estimate variable operating expenses
For each variable cost category, express the cost as a percentage of revenue or a per-unit rate, then multiply by your projected revenue or volume. Include commissions, ad spend, and payment processing fees.
π‘ Budget ad spend as a fixed dollar amount with a defined return target (e.g., 4Γ ROAS) rather than as an uncapped percentage β this prevents runaway spend in high-revenue months.
6
Plan capital expenditures separately
List any planned asset purchases with their cost and acquisition date. Record only the depreciation expense in the P&L; show the full cash outflow in the cash flow section.
π‘ If a capex purchase is conditional on hitting a revenue milestone, note the trigger explicitly so the decision is documented and reviewable.
7
Build the cash flow projection
Take your profit plan and adjust for timing: add the collections lag on receivables, note the timing of large payables, and insert any loan draws or repayments. Confirm the closing cash balance stays positive every month.
π‘ Any month where closing cash drops below one month of fixed expenses is a danger zone β model a mitigation action (line of credit draw, delayed capex) alongside the warning.
8
Set up variance tracking and schedule monthly reviews
Enter actuals against each budget line at month-end, calculate variances, and schedule a 30-minute monthly review to investigate anything more than 10% off plan.
π‘ Assign one person β owner, CFO, or bookkeeper β as the single owner of the monthly budget review. Shared ownership means it never gets done.