AI Business Tools

How to Create a Budget in Excel for Your Small Business

Learn how to create a budget in Excel with a simple three-tab setup, working formulas, and a filled example you can copy for your own business this week.

EntraWorld Team

·

September 30, 2026

·

6 min read

A quiet desk by a tall window at dusk with a closed laptop, a mug, and a notebook, a city skyline beyond

Learning how to create a budget in Excel takes about an hour, and it gives you a clear answer to the question every founder asks sooner or later: can we afford this? A good business budget is not a wall of numbers. It is one sheet that shows what you expect to earn, what you expect to spend, and how far reality drifts from the plan each month.

You do not need advanced skills or paid add-ons. Three tabs, four formulas, and a habit of updating them are enough to run a business on. This guide walks through the setup, shows a filled example, and covers the small details that keep a spreadsheet useful after the first month.

Decide what the budget needs to answer

Before you open Excel, write down the two or three decisions the budget should support. Maybe it is whether you can hire a part-time contractor in the spring. Maybe it is how much cash you need to hold back for taxes. A budget built around real decisions stays short, because every line earns its place.

Then pick your time frame. Most small businesses work best with a monthly budget planner for the next 12 months, updated at the end of each month. SBA's guidance on startup costs recommends planning for at least a year of monthly expenses, and calls five years ideal. Go longer if you are building toward a loan application or a long-term plan.

How to create a budget in Excel, step by step

The structure below keeps inputs, calculations, and raw data separate, which is what stops a spreadsheet from turning into a tangle.

  1. Create three tabs. Name them Budget, Transactions, and Lists. The budget tab is what you read. The transactions tab is where every expense gets logged. The lists tab holds your category names.
  2. Build the category list first. On Lists, type your categories down column A: rent, software, insurance, contractors, marketing, owner pay, and so on. Keep it to 10 to 15 categories. Too many categories make logging a chore and you will stop.
  3. Set up the transactions log. On Transactions, use four columns: Date, Month, Category, and Amount. Month holds the first day of that month (for example, 2026-11-01), which makes monthly totals easy to calculate.
  4. Lay out the budget grid. On Budget, put categories down the left side and months across the top. Add three columns per month: Budgeted, Actual, and Variance.
  5. Tag each category as fixed or variable. Add a Type column so you can see how much of your spending you control month to month.

Separate fixed and variable costs

Fixed costs stay the same however much you sell. SBA lists rent, salaries, insurance, and depreciation as examples, and calls costs that mix both types semi-variable. Variable costs rise and fall with activity: contractors, shipping, payment processing, ad spend.

The split matters because fixed costs set your floor. In the example below, fixed costs run $6,450 a month, so you know exactly how much revenue you need before anything else counts as profit.

Add the formulas that do the work

Four formulas cover almost everything a small business budget needs.

  • Monthly actuals: Microsoft's SUMIFS function adds values that meet more than one condition. With categories in column C and months in column B of your log, this formula totals one category for one month: =SUMIFS(Transactions!$D:$D, Transactions!$C:$C, $A5, Transactions!$B:$B, B$4).
  • Variance: Budgeted minus Actual for expenses, and Actual minus Budgeted for income. A positive number always means the result beat the plan.
  • Totals: =SUM(B5:B16) down each column.
  • Cushion: Budgeted total times 0.10 on its own line.

That last one is worth a moment. SBA suggests adding roughly 10 percent to a break-even analysis to cover unexpected costs. The same logic works in a budget: a visible cushion line means a surprise repair bill dips into a planned buffer instead of wrecking the month.

Use drop-downs so categories stay clean

Typos break formulas. If one expense is logged as "Software" and another as "software subscriptions," your totals will not match. Fix it with a drop-down: select the Category column on the log, open the Data tab, choose Data Validation, set Allow to List, and point the source at your category range on the Lists tab. Microsoft documents the steps in its guide to creating a drop-down list.

A budget example you can copy

Here is one month for a two-truck lawn care company with an owner and a seasonal crew. The numbers are illustrative, so swap in your own.

CategoryTypeBudgetedActualVariance
Customer revenueIncome$18,000$16,900-$1,100
Truck paymentsFixed$1,300$1,300$0
InsuranceFixed$650$650$0
FuelVariable$1,400$1,250+$150
Crew wagesVariable$6,800$6,300+$500
Equipment repairsVariable$500$1,150-$650
MarketingVariable$400$400$0
Owner payFixed$4,500$4,500$0
Cushion (10%)Reserve$1,555$0n/a

Budgeted spending comes to $15,550 before the cushion, and $17,105 with it, which leaves $895 of planned profit. Rain washed out several workdays, so revenue came in $1,100 short, and fuel and crew wages ran under for the same reason. A mower repair pushed equipment costs $650 over. Actual spending landed at $15,550, right on plan, and the month still closed with $1,350 of profit without touching the cushion.

The repair line is the one to watch. A month-end review that takes ten minutes tells you whether to set aside more for equipment or replace an aging mower before the busy season.

Build your first numbers faster with AI

The hardest part of a first budget is the revenue line, because you are estimating something that has not happened yet. EntraWorld's AI financial projections tool helps you draft revenue and cost assumptions in minutes, based on your business type and plan. You can then carry those figures into your Excel budget and refine them against real invoices as the months pass. For more on how forecasts and budgets fit together, see our guide to a financial projections template.

Keep your company expenses spreadsheet honest

A budget only works if the actuals are accurate. Set up habits that make accuracy easy:

  • Log expenses weekly. Fifteen minutes on Friday saves three hours at month-end.
  • Keep business spending in a business account. It makes the transactions log a copy-and-paste job instead of detective work. If you have not set one up yet, our guide to opening a business bank account covers it.
  • Save receipts digitally. A photo in a folder named by month is enough.
  • Reconcile monthly. Compare your log total to your bank statement. If they differ, find the gap while the month is still fresh.

If you want a ready-made layout to start from, our business budget spreadsheet walkthrough pairs well with this guide. And once your budget is running, a cash flow statement shows the timing side that budgets do not: when money actually lands and leaves.

Review it on a schedule

Set a recurring 30-minute block on the last business day of each month. Update actuals, check each variance, and ask one question of every line that is off by more than 10 percent: is this a one-time event or a new normal? If it is a new normal, change next month's budget.

Once the habit holds, knowing how to create a budget in Excel pays off in early warnings. You will spot trends sooner, such as software costs creeping up, a client who always pays late, or a marketing channel that stopped paying off.

A budget gives you a plan, and the plan frees you to make bolder moves with confidence. Join EntraWorld free to draft your projections, shape your business plan, and carry those numbers straight into the spreadsheet you just built.

Ready to build your idea?

Start free. The first 5,000 Premium memberships include a full year of every tool.

Join EntraWorld free →