Business Budget Sheet: A Filled Sample Budget

Hey folks, it's Ren here.

In our shop, January is loud.

The order notifications stack up on my phone faster than I can swipe them away, and the sales report for the month looks like a typo.

Then May arrives, and the same phone sits quietly on the desk for hours.

Nothing is wrong in May. It is the same shop, the same products and the same customers. The year just does not sell evenly, and most small businesses are the same.

That is why a business budget sheet that divides the year by 12 looks tidy in a spreadsheet and feels wrong by March.

"Never take your eyes off the cash flow because it's the lifeblood of business." — Richard Branson

📒 What is a business budget sheet?

A business budget sheet is a spreadsheet that plans the year ahead for a business: expected sales, the costs of making them, the fixed costs of staying open, what the owner takes home and what is left as profit.

It is different from your books. The books record what already happened. The budget is the plan you compare them against.

Most small business budgets need the same six blocks, whatever the industry.

Block	What goes in it	Why it matters
Sales	Each income source on its own line, net of discounts and refunds	Shows which stream is actually carrying the business
Variable costs	Costs that rise with sales: platform and payment fees, advertising, materials	Written as a share of sales, they adjust themselves
Fixed costs	Costs that arrive every month regardless: software, insurance, rent, contractors	This is the floor the business must clear every month
Owner pay	What you pay yourself, as a fixed line	Leaving it out makes every month look more profitable than it is
Tax set-aside	A share of profit moved aside as it is earned	Turns the tax bill into a monthly habit instead of a shock
Profit	Sales minus every line above	The number the whole sheet exists to protect

Excel and Google Sheets both handle this easily. The hard part is not the formulas. It is deciding what goes in each month.

🧾 What does a sample business budget look like?

A sample business budget is easiest to read as a full year with every line shown as a share of sales, so here is one for a small online business selling $120,000 a year.

The business pays a platform about 10% in fees, spends 15% of sales on advertising, uses a part-time contractor and pays its owner $3,000 a month.

Line	Year	Share of sales
Net sales (after discounts and refunds)	$120,000	100%
Platform and payment fees	$11,998	10%
Advertising	$18,001	15%
Owner pay	$36,000	30%
Contractor help	$16,800	14%
Software and subscriptions	$3,000	2.5%
Accountant	$1,800	1.5%
Insurance	$1,440	1.2%
Total costs	$89,039	74.2%
Profit before tax	$30,961	25.8%
Tax set-aside at 20% of profit (example rate)	$6,192	5.2%

Please do not read these shares as targets. They are one illustrative business, and margins swing widely between a service business, a shop and a trade. The point is the shape: every line has a dollar amount and a share of sales, so you can see which line moves the profit most.

Here, owner pay is the biggest single cost at 30% of sales, and advertising is the biggest cost that moves with sales. A 5% cut in advertising spend is worth $900 a year. A 5% lift in sales, with fees and advertising rising alongside, is worth $4,500.

The 20% tax line is an example rate only. Your rate depends on where you live and how the business is set up, so check it with your accountant before you rely on it.

📉 Why does dividing the year by 12 break a business budget?

Dividing yearly sales by 12 breaks a business budget because almost no business sells evenly, so the flat plan overstates the quiet months and understates the busy ones.

Our own shop is a good example. I counted every order since March 2023, one per order, which comes to 74,228 orders. Then I indexed 2024 and 2025 by month, so an average month equals 100.

January sits at 172 and December at 141. Together those two months carry 26.1% of the year's orders. May is the quietest at 74.

That leaves 9 of 12 months selling below the average month. A budget that gives every month one twelfth of the sales target is too optimistic for three quarters of the year.

Now put that pattern into the sample budget. The yearly total stays at $120,000, but each month gets its own share of sales.

Month	Order index	Planned sales	Fees and ads	Fixed costs	Profit
January	172	$17,186	$4,297	$4,920	$7,969
February	84	$8,393	$2,098	$4,920	$1,375
March	85	$8,493	$2,123	$4,920	$1,450
April	80	$7,993	$1,998	$4,920	$1,075
May	74	$7,394	$1,848	$4,920	$626
June	76	$7,594	$1,898	$4,920	$776
July	92	$9,192	$2,298	$4,920	$1,974
August	98	$9,792	$2,448	$4,920	$2,424
September	96	$9,592	$2,398	$4,920	$2,274
October	108	$10,791	$2,698	$4,920	$3,173
November	95	$9,492	$2,373	$4,920	$2,199
December	141	$14,088	$3,522	$4,920	$5,646

The flat plan says the business makes $2,580 every month. The seasonal plan agrees on the year, but February to June makes $5,302 in total, against $12,900 in the flat plan.

That is $7,598 the owner thinks is coming and is not. May alone makes $626, a quarter of the flat number.

This is the gap most business budget templates never show you, because they ask for one sales figure and divide it. The business is profitable all year and still feels broke from February to June, the same way a household on weekly pay can be ahead for the month and short on a Friday.

The fix is simple once you can see it. Hold back part of January's surplus as a buffer, and set owner pay at a level the quiet stretch can carry. Our shop is one shop, so treat its pattern as an example and use your own sales history for the index.

🛠️ How do you set up a business budget sheet?

You set up a business budget sheet by starting from last year's real numbers and spreading next year across the months, which takes an afternoon the first time.

1. Pull twelve months of real numbers. Bank statements, sales reports and bills tell you what the business actually earned and spent.
2. Split costs into variable and fixed. Variable costs, such as platform fees and advertising, move with sales; fixed costs, such as software and insurance, do not.
3. Write each variable cost as a share of sales. A 10% fee line then grows and shrinks with every month on its own.
4. Spread next year's sales by last year's pattern. Give each month its share of the year instead of dividing the target by 12.
5. Set owner pay and the tax set-aside from the lean months. If the quiet stretch can carry them, the busy months build the buffer.
6. Compare budget to actual every month. Note the gap on each line and change the plan when a gap repeats twice.

Owner pay is the line people most often leave out. If you pay yourself from whatever is left, the budget will always look healthier than your bank account does.

Once the year is built, the monthly view is where the sheet earns its keep. In the bookkeeping file below, the year runs July to June, and the monthly profit bars make the uneven months obvious at a glance.

That is the sample data shipped with the file, not a real business, but it shows the same thing our orders do: November is the strong month in that sample, and the profit bars move a lot more than a flat line would.

📊 How do you compare budget to actual?

You compare budget to actual by putting the planned and real number side by side for each line, every month, and only acting on gaps that repeat.

A single bad month is noise. The same line running over two months in a row is a signal, and that is when the plan should change.

Comparing whole quarters helps too, because one quarter smooths out a slow week. In the sample comparison dashboard below, three quarters sit side by side: Q4 2025 brings in the most at $26,190, yet its profit margin of 52% sits between Q3 at 53% and Q1 2026 at 51%.

That is a useful pattern to watch for in your own numbers. More sales do not always mean a better quarter if costs grow faster than income.

If you only want the planning side, the Ultimate Small Business Budget covers income, expenses, tax and a cash flow forecast in one sheet for $27.

⚠️ Mistakes that sink a small business budget

• Dividing the sales target by 12. Fix it: spread sales by last year's monthly pattern, so the quiet months are planned as quiet.
• Leaving owner pay out. Fix it: add it as a fixed line and set it from what the lean months can carry.
• Budgeting at list price. Fix it: plan sales net of discounts, refunds and platform fees, because that is what reaches the bank.
• Waiting for the tax bill. Fix it: move the set-aside each month as profit arrives, not in the month the bill does.
• Never comparing budget to actual. Fix it: book a monthly check and change a line once its gap repeats.

If the quiet months worry you more than the yearly total, the business cash flow spreadsheet guide builds a 13-week runway so you can see the tight weeks coming.

🧰 Which other business sheets sit beside the budget?

A business budget sheet is the plan, and a few smaller sheets feed it the real numbers.

• Business bookkeeping spreadsheet: the monthly books your budget is compared against.
• Profit and loss spreadsheet: the actual profit, line by line, for sole traders.
• Self-employed budget spreadsheet: how to pay yourself a steady wage from uneven income.
• Quarterly estimated tax spreadsheet and tax planning spreadsheet: the set-aside, worked out and funded early.
• Tax deduction spreadsheet, tax organizer spreadsheet and business mileage tracker: the records your accountant asks for.
• Invoice tracker and freelance invoice tracker: when the money you earned actually arrives.
• 1099 expense tracker, expense reimbursement tracker and petty cash spreadsheet: the small costs that slip past a budget.
• Etsy seller bookkeeping spreadsheet: real profit after marketplace fees.

🎯 Your action steps this week

• Download last year's sales by month and work out each month's index, where an average month is 100.
• List every cost and mark it variable or fixed.
• Write variable costs as a share of sales and fixed costs as monthly amounts, including your own pay.
• Spread next year's sales target by your index and find your leanest three months.
• For a team or department view of the same plan, the company budget template guide shows how to split the budget by area.
• Book a monthly budget-versus-actual check in the first week of each month.

❓ Frequently asked questions

What should a small business budget sheet include?

A small business budget sheet should include sales by source, the costs that rise with sales, fixed monthly costs, owner pay, a tax set-aside and the profit left over. Laying each line out by month, not just for the year, shows the lean months before they arrive.

How do I make a business budget for the first time?

Start from last year's bank statements, not from a target. List every cost, mark which ones move with sales, then spread next year's sales across the months using last year's pattern. Set owner pay from the quiet months and review the sheet once a month.

What percentage of revenue should go to expenses?

There is no single right percentage, because margins vary widely by industry and business model. Work out your own split from your records, then watch it month to month. The sample budget here spends 74.2% of sales and keeps 25.8% as profit before tax.

Can I use a business budget sheet in Excel and Google Sheets?

Yes. A business budget sheet is rows of categories, months and simple formulas, so it works the same way in Excel and Google Sheets. Pick the one your accountant or bookkeeper already uses so the numbers move between you easily.

January will always be louder than May in our shop. The budget cannot change that, but it can stop May from coming as a surprise.

Plan the quiet months first, and the busy ones take care of themselves.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.