How to Build a Business Budget From Scratch

If you ask me to build a business budget from scratch, I have two questions before I touch Excel: how does this business make money, and what does it cost to deliver what we’re selling? I know. Very glamorous. No one has ever put those questions on a motivational office poster.

A budget is an operating plan translated into numbers. It should tell us what we expect to sell, what resources we need, when money comes in and when it goes out. A spreadsheet full of last year’s figures plus 10% might be quick, but I wouldn’t call it a plan without a few follow-up questions.

First, get a clean starting point

I’d gather recent financial statements, payroll information, major contracts, debt obligations and customer payment terms. I’d separate recurring activity from one-time events. A large legal bill or unusual project last year doesn’t become a permanent monthly expense just because a formula copied it forward.

For a new business, I’d start with explicit estimates based on prices, capacity and expected demand. I’d label those assumptions clearly. There’s no shame in estimating; the problem starts when we forget which numbers were guesses.

Build revenue from what the business can deliver

Let’s use a hypothetical U.S. consulting firm with four consultants. Each expects 1,200 billable hours a year at an average realized rate of $175. That’s $840,000 in annual revenue capacity: four times 1,200 times $175.

Notice I said capacity. It isn’t guaranteed sales. Having 1,200 billable hours available doesn’t mean customers will form a polite queue outside the office demanding to purchase all of them.

I’d test demand, utilization and start dates separately. If one consultant starts six months late, we lose roughly 600 potential billable hours, or $105,000 in revenue capacity. The annual total changes even if the rate never does.

Then budget costs according to how they behave

I’d separate direct delivery costs, fixed overhead, volume-sensitive costs and discretionary projects. Payroll often changes in steps as we hire people. Rent usually doesn’t fall just because sales have a slow Tuesday. And annual software renewals have an annoying habit of arriving whether or not we’ve planned for them.

Suppose those four consultants cost $110,000 each annually, fully loaded. That’s $440,000 in delivery payroll. Subtracting it from $840,000 of revenue capacity leaves $400,000 before other delivery costs and overhead. It is not net income, and I’d rather make that distinction now than explain it at the bank later.

Don’t forget the cash calendar

Profit and cash are related, but they are not twins. Customers may pay 45 days after an invoice while payroll comes due every two weeks. Equipment and deposits may require cash long before they generate revenue.

I’d build a monthly cash view alongside the income statement. That means opening cash, expected collections, payments, debt service, taxes and capital purchases. A business can be profitable on paper and still struggle to make Friday’s payroll. That’s a rather memorable way to discover the difference.

Stress-test the assumptions before approval

What happens if utilization falls? If a customer pays late? If a hire starts early or the rate increase doesn’t stick? I’d show a base case and a downside case, assign owners to the important assumptions and make sure the cash balance stays visible.

Once approved, I’d preserve the budget as our original benchmark and update a separate forecast as reality changes. Otherwise we’ll spend the year moving the goalposts and congratulating ourselves for hitting them.

My goal isn’t a perfect first budget. It’s a plan that lets someone make a better decision next month. If we can also avoid naming the file Budget_FINAL_final2.xlsx, I’ll consider that a bonus.

Financial examples are hypothetical.