How to Create a Business Budget From Scratch

Learning how to create a business budget from scratch is mostly a matter of order: start with revenue drivers, then costs, then cash, then test the result against your goals. Many first budgets fail because they start with a profit target and work backwards, or because they copy last year with a growth percentage and no logic. This guide gives an eight-step method with a worked example that includes a break-even calculation and a sensitivity test. It is a practical companion to budgeting and forecasting and to what is a business budget.

Before you start

Gather:

• Last two to three years of income statements and balance sheets, by month if possible
• The latest cash balance and a list of debts, with payment schedules
• Contracts that affect cost or revenue: leases, supplier agreements, customer contracts
• Headcount list with pay and planned changes
• Your goals for the year: growth, profit, cash, investment
• Known one-off items: launches, moves, equipment replacements

Decide the budget period (usually 12 months), the level of detail (monthly is typical) and who must contribute.

Step 1: Set the goals

Write down three to five targets. For example: grow revenue 12 percent, hold gross margin at 38 percent, end the year with at least two months of operating costs in cash. Targets give the process a direction and give you something to test the numbers against.

Step 2: Build revenue from drivers

A revenue budget needs a logic that you can explain and change.

Add seasonality: spread the annual number by month using last year's pattern, adjusted for known changes. See adjusting forecasts for seasonality.

Step 3: Plan direct costs

Direct costs follow volume. Estimate cost per unit from supplier prices, labor standards and freight. If cost of goods is 62 percent of revenue, document why. Review supplier price changes you already know about.

Step 4: Plan operating expenses

Build expenses by department and by line, with an owner for each.

Separate fixed costs from variable ones. Fixed costs do not move when sales change in the short run; variable costs do.

Step 5: Add capital spending, financing and taxes

List equipment and system purchases with timing. Add loan interest and principal, owner distributions and estimated taxes. See capital budget vs. operating budget.

Step 6: Build the cash view

Convert the profit plan to cash. Adjust for customer payment timing, inventory purchases, supplier terms, capital spending and debt service. Check the lowest cash point of the year. If it is below your minimum, change the plan or arrange financing. For a deeper treatment see cash flow management.

Step 7: Test the budget

A budget that has not been stressed is a hope.

• Break-even: how much must you sell to cover fixed costs?
• Sensitivity: what happens if volume is 10 percent lower or costs 5 percent higher?
• Reasonableness: do growth rates and margins fit your history and market?
• Goal check: does the result meet the targets in step 1?

Step 8: Review, approve and publish

Share the draft with department heads, challenge assumptions, resolve conflicts, get approval and load the final budget into your reporting. Document the assumptions. See how to document budget assumptions and budget approval workflow.

A worked example

A hypothetical product business sells one item. Monthly plan:

Results:

• Revenue = 1,000 × $50 = $50,000
• Variable costs = 1,000 × $30 = $30,000
• Contribution margin = $50,000 - $30,000 = $20,000 ($20 per unit, 40 percent of revenue)
• Operating profit = $20,000 - $12,000 = $8,000
• Annual operating profit = $8,000 × 12 = $96,000

Break-even

Break-even units = fixed costs / contribution margin per unit = $12,000 / $20 = 600 units a month. The business has a margin of safety of 400 units, or 40 percent of planned volume ((1,000 - 600) / 1,000).

Sensitivity

A 10 percent volume drop reduces profit by 25 percent ($2,000 of $8,000), because fixed costs stay. A $2 price cut with a 5 percent volume gain loses $1,100 of profit a month, so the discount needs more volume than that to pay. This kind of testing turns the budget from a list of numbers into a decision tool. For the economics behind it, see unit economics.

Phasing the annual number by month

A budget has to reflect when things happen. Suppose the product business above expects annual units of 12,000, with seasonality indexes based on last year's pattern.

Check: 2,550 + 3,000 + 2,700 + 3,450 = 11,700, not 12,000. The indexes must average 1.0. The fix is to scale them: 12,000 / 11,700 = 1.0256, so each month's units rise by about 2.6 percent. A simple check, that the monthly numbers add up to the annual figure and the indexes average 1.0, catches many budget errors before they spread.

A headcount budget example

Payroll is usually the largest cost, so it deserves a table of its own.

Notice that the two new hires cost less in the first year than their annual rate because of start dates, but cost the full amount in the next year. A budget that ignores the "annualization" effect understates the following year's payroll by $48,450 for these two roles ($58,560 × 3/12 + $67,100 × 6/12 = $14,640 + $33,550).

Assumptions sheet

Keep one tab for assumptions with these columns: assumption, value, source, owner, date last reviewed. Examples: price increase of 3 percent from April (source: sales plan), freight cost per unit of $2.40 (source: carrier quote), employer tax and benefits at 22 percent of salary (source: payroll provider). When a number changes, you change it in one place and the whole budget follows.

Pre-approval checklist

• Does revenue reconcile to the sales plan and to capacity?
• Do monthly totals add up to the annual numbers?
• Is every cost line owned by a named person?
• Does the budget meet the goals set at the start, and if not, is the gap explained?
• Does the cash view stay above the minimum balance in every month?
• Has someone outside the team reviewed the formulas?
• Are the assumptions documented?

Tools

A spreadsheet is enough for most businesses. Use one tab for assumptions, one for revenue, one for expenses, one for the summary and one for cash. Keep inputs separate from calculations, and never type numbers into formula cells. See budgeting in Excel and annual business budget template.

Common mistakes

• Starting from a profit target and plugging the numbers.
• Using last year's actuals without removing one-offs.
• Ignoring seasonality.
• Leaving cash timing out.
• Building the budget in finance alone. See how to get department heads to own their budgets.
• No sensitivity test.
• No documentation of assumptions.

Related guides

Read budget vs. forecast to understand how the budget and the forecast work together during the year, and operating budget: components and a worked example for a fuller operating budget.

FAQs

How do I create a business budget from scratch?

Set goals, build revenue from drivers, plan direct and operating costs, add capital and financing, build the cash view, test the result and get approval.

What do I need to start a budget?

Past financial statements, current cash and debt, contracts, headcount, goals and known one-off items.

How detailed should my first budget be?

Monthly by major line is enough. Add detail where costs are large or uncertain.

How do I budget revenue if I have no history?

Use drivers such as expected customers, conversion and price, and test the assumptions with market evidence. See forecasting sales for a new product with no history.

How often should I revise the budget?

Keep the original for reference, and use a forecast to update expectations when conditions change materially.