Posted on 3 June 2025
Free Small Business Budget Template Excel, Word and PDF
- Plans income and expenses across 12 months, with budget and actual figures side by side
- Groups income by sales, services, subscriptions, rentals and investments, and expenses by operations, payroll and office overhead
- Shows over- or underspending by category to help catch budget gaps before they reduce profit
- Summarizes annual income, expenses, profit or loss and variance for tax preparation, investor reviews and future budgets
A business budget template is a spreadsheet that compares planned income and expenses with actual monthly results, helping businesses spot budget gaps and adjust spending before cash problems arise.
Last updated: November 4, 2026
What it is
A small business budget template you fill in once a year and check once a month. It plans your income and costs, reads what really happened, and tells you which lines need your attention.
When you need it
Before the year starts, before a loan meeting, or the first time your bank balance surprises you.
What's inside
An annual plan, a seasonal spread, a transactions log, monthly actuals, a monthly review, a year summary, a cash check and a printable budget.
Formats
Excel, Google Sheets, Word and PDF. The business budget template Excel file and the Google Sheets copy work the same way.
Want to see it filled in first?
Make your own copy of the filled sample in Google Sheets.
What Is the Business Budget Template?
It's the 25th. Payroll goes out on Friday. The sales were good this month, so why does the bank account look like that?
That question is the reason budgets exist.
A business budget template is a ready-made spreadsheet for planning a company's income and costs month by month, logging what actually happens, and comparing the two. It shows where you are over or under budget, and what that does to your profit and your cash.
You may know it by another name. A small business budget template if you run a shop or a studio. A company budget template if someone in finance asked for one. A small business budget spreadsheet if you built your first one at the kitchen table. A monthly budget template for small business owners who review every month. Same job.
what you expect
what happened
line by line
before it costs you
Notice where that ends. A budget isn't a document you finish in January and bury in a folder. It's a loop, and every month you skip is a month your plan stops being true.
Budget vs Forecast vs Cash Flow vs Profit and Loss
These four get mixed up constantly, and the mix-up gets expensive. Each one answers a different question.
| Document | The question it answers | Looks | Changes |
|---|---|---|---|
| Budget | What do we intend to earn and spend? | Forward | Set yearly, reviewed monthly |
| Forecast | Based on where we are now, where will we land? | Forward | Updated monthly or quarterly |
| Cash flow statement | When does money actually enter and leave the bank? | Either way | As money moves |
| Profit and loss | Did we make money over this period? | Backward | Closed each period |
A budget is your intention, a forecast is your best guess, and a profit and loss is what really happened.
Need the formal backward view? Use the income and expense statement. Need a detailed week by week cash view? The cash flow forecast template goes deeper than the Cash Check sheet here.
Which Budget Template Fits Your Business?
The right starting point depends on what you are trying to answer.
| If your situation is... | Use this | Where to find it |
|---|---|---|
| You sell products and want the whole year planned | This business budget template, with Cost of Goods Sold filled in | Annual Plan sheet |
| You sell services and hold no stock | This small business budget spreadsheet, with Cost of Goods Sold left blank | Annual Plan sheet |
| You need a monthly budget template for small business reviews | Pick a month and read one screen | Monthly Review sheet |
| You only want to compare budget with actual | The dedicated budget vs actual template | A separate download |
| You only want to log what you spend | The business expenses spreadsheet | A separate download |
| You want to work on paper | The printable company budget template | Word and PDF files, or the Printable Budget sheet |

What Does a Business Budget Template Contain?
Strip away the formatting and every good budget comes down to the same parts.
| Part | What goes in it | Why it matters |
|---|---|---|
| Income | Product sales, services, recurring fees, rent, other income | Shows which stream is carrying the business |
| Cost of goods sold | Stock, freight, packaging, direct labor, payment fees | Rises with sales, and sets your gross profit |
| Fixed costs | Rent, salaries, insurance, software, loan interest | Due even in a terrible month |
| Variable costs | Marketing, utilities, contractors, travel, shipping | The costs you can usually turn down fastest |
| Contingency | A small percent of income set aside | Stops one surprise from wrecking the plan |
| Cash items | Owner draws, tax payments, loan principal, equipment | They leave the bank but never touch profit |
| Actuals | What really came in and went out | Without them, the plan is a wish list |
| Variance | The gap between plan and reality | Tells you where to look first |
The line that matters most is the one people skip: actuals. A plan with no actuals feels organized and tells you nothing. Everything useful on this page depends on that column being filled in.
What the Enerpize Business Budget Template Includes
We started from the old sheet, a single page of budget and actual columns, and kept asking what an owner would need next. These are the answers. The business budget template Excel file runs on formulas with no macros, so it opens in Excel and Google Sheets without a security warning. Yellow cells are yours. Everything else calculates.
A Plan That Knows December Isn't January
Dividing a year by 12 is how good budgets go wrong. In our filled sample, last year's sales were $858,000 and December brought in 13.4% of them. Add 6% growth and an even split says $75,790 a month. The Seasonal Spread sheet says $121,900 for December and $61,500 for January.

A Calendar That Starts When You Do
Your budget year doesn't have to begin in January. Pick April, March or any other month in Settings, and every sheet rolls to match, including the month you select for review.
A Receipt Drawer That Sorts Itself
Paste your bank and card lines into Transactions and pick a category. The sheet does the adding up. A Check column catches anything it can't count, such as a date outside your budget year. Our sample has one on purpose: a $48 bank charge with no category, flagged in red instead of quietly vanishing.

A Smoke Alarm That Ignores Burnt Toast
Flag everything and you stop reading flags. So a line only earns "Review" when it misses by both your percent limit and your amount limit. In the sample, Software Subscriptions ran 28% over, but that's only $179, so it stays a Small Miss. Marketing ran 38% over by $1,710. That one gets flagged.

A Bank Balance With Headlights
A profitable plan can still run out of money, because owner draws, loan repayments, tax and equipment never appear in profit. Cash Check adds them back and finds your lowest month. The Latest View swaps in actuals as you log them, so the warning moves when reality does.

A Rainy Day Line That Fills Itself
Set a percent in Settings and Contingency calculates from your budgeted income each month. When a surprise hits, log it there. Our sample business budget used $3,430 of its $12,196 so far this year, including a $2,650 roof repair.
The Whole Year on One Page
Year Summary lines up every month, marks each one Ahead or Behind, and charts the result. Bring this page to your accountant or your bank.

Fixed, Variable and One-Off Costs: Where Each Line Goes
Put a cost in the wrong section of your small business budget template and your totals still add up, but they stop telling the truth. Use this as a quick sorting guide.
| Type | How it behaves | Examples | Your move when money is tight |
|---|---|---|---|
| Cost of Goods Sold | Rises and falls with what you sell | Stock, freight, packaging | Renegotiate suppliers, or check your pricing |
| Fixed | Same amount, good month or bad | Rent, salaries, insurance | Hard to change quickly, so review before you commit |
| Variable | Moves with activity and choices | Marketing, travel, utilities | Your first and fastest lever |
| Contingency | Unknown until it happens | Emergency repairs | Protect it until you truly need it |
| Cash, Not in Profit | Leaves the bank, skips profit | Owner draws, tax, loan principal | Plan the timing, because these create tight months |
Depreciation isn't on the list. It reduces accounting profit, but no cash leaves the bank when you record it, so this budget works in cash terms and leaves it to your accountant.
Business Budget Examples
Looking for a business budget example or a sample business budget? Here are three. Each business budget example covers one month. The first comes from our filled sample, and the other two are illustrative figures to show how the shape changes by business type. Don't copy the numbers. Copy the thinking.
| One month | Product business | Service business | New online shop |
|---|---|---|---|
| Income | $74,550 | $44,000 | $9,000 |
| Cost of goods sold | $24,350 | $5,000 | $3,600 |
| Gross profit | $50,200 | $39,000 | $5,400 |
| Fixed costs | $34,880 | $26,000 | $3,450 |
| Variable costs | $6,360 | $3,000 | $3,300 |
| Contingency | $1,118 | $880 | $270 |
| Net profit | $7,842 | $9,120 | Loss of $1,620 |
| Net margin | 10.5% | 20.7% | Loss of 18% |
Read across and three different stories appear. The product business lives or dies on its margin after stock. The service business has few direct costs, so salaries become the whole game. The online shop is losing $1,620 a month, which is fine if you planned it. With $30,000 in the bank, that business budget example gives you about 18 months to fix it.
Example: A Filled Business Budget Template
Want to see the small business budget template working before you touch it? Make your own copy of the filled sample in Google Sheets. It's a full business budget example: Cedar Street Supplies, a fictional store and trade supplier, from January to October 2026, in US dollars, with 406 transactions already logged.
How to Read the Sample
Go to Monthly Review, which is already set to October, and read this sample business budget from the top down.
$9,097 under
$6,960 above
$1,710 above
$15,606 behind
$34,593, under the $40,000 buffer
The plan always expected October to lose $14,491, because the store buys stock ahead of the holidays. That part was fine. The real loss was $30,098, and cash fell to $34,593 instead of the planned $47,054. November and December should recover it, and the owner now knows that three lines caused it. Nobody had to wait for year end to find out.
Also look at Repairs and Maintenance. It shows "No Entry" because $300 was budgeted and nothing was logged. Maybe nothing broke. Maybe a bill is sitting unrecorded in a drawer. Either way, now you'll check.
Business Budget Formulas
Every formula is already built into the business budget template Excel file. Here's what each one does, in case you want to adapt it or build your own.
Actuals From Your Transactions
=SUMIFS(Transactions!$D$5:$D$1004, Transactions!$C$5:$C$1004, $B11, Transactions!$F$5:$F$1004, C$9)
In plain English: add every amount where the category matches this row and the month matches this column.
Variance
Income: Actual minus Budget | Costs: Budget minus Actual
This is why a positive variance is always good news, on every line. Sales of $73,603 against $82,700 gives a variance of minus $9,097. Stock of $64,960 against $58,000 gives minus $6,960. Both are bad, and both read the same way. Divide by budget for the percent: minus 11.0% on sales, past both the 10% and $250 limits, so that line turns to Review.
Closing Cash
Closing Cash = Opening Cash + Net Profit + Cash In - Cash Out
For October's latest view: $68,590 opening, minus the $30,098 loss, minus $3,900 cash out, leaves about $34,593.
How to Use the Business Budget Template
Seven steps take this small business budget template from blank to useful.
1- Set Up Your Business
Open Settings and enter your name, currency, first budget month, opening cash and minimum buffer. Rename any category to match your books, and clear any line you don't need. Why? A budget in your own words gets used.
⚡ Tip: Match your category names to your accountant's profit and loss. Comparing the two later becomes a two minute job.
2- Gather Last Year's Numbers
Pull last year's profit and loss and bank statements. Those are your starting point, because they are the only figures in this exercise that aren't opinions.
⚡ Tip: New business with no history? Budget costs from real quotes, then estimate sales low. Being pleasantly surprised costs nothing.
3- Spread Your Sales Across the Year
Enter last year's monthly sales and a growth target in Seasonal Spread, then type the suggested figures into the Annual Plan. Your December stops being an average, and so does your slowest month.
4- Fill In the Annual Plan
Start with income, then cost of goods sold, then fixed costs, which are the easy ones. Finish with variable costs and cash items. Then look at the top of the sheet: is the net margin one you can live with?
⚡ Tip: Round to the nearest $50 or $100. Budgeting to the cent gives you precision you don't actually have.
5- Check Your Lowest Cash Month
Before you call the plan finished, open Cash Check. If a month drops below your buffer, you've found the problem while there's still time to move a purchase or arrange funding.
6- Log Transactions Every Week or Month
Paste your bank and card lines and pick categories. Use positive amounts for both money in and money out, and a negative amount for a refund. Then glance at the Check column for anything in red.
⚡ Tip: Friday, 15 minutes, same time each week. It's far easier than sorting a whole month at once.
7- Review Each Month
This is where it earns its name as a monthly budget template for small business owners. Pick the month in Monthly Review. Start with the lines marked Review, ask why each one happened, and decide what changes. If a miss will repeat, update your forecast. Keep the original budget as it is, so you can still measure against it.
Common Budgeting Mistakes
A small business budget template only works if what goes in is honest. Watch for these.
✕ Splitting the year into 12 equal months
Why it matters: Seasonal businesses get false alarms in slow months and false comfort in busy ones.
Fix: Use last year's monthly pattern through Seasonal Spread.
✕ Budgeting profit and ignoring cash
Why it matters: Loan principal, owner draws and tax payments can drain the bank while profit looks fine.
Fix: Fill in the cash items and check your lowest month.
✕ Planning and never recording actuals
Why it matters: The budget turns into a January document, abandoned by spring.
Fix: Log transactions on a fixed day each week or month.
✕ Chasing every small variance
Why it matters: Everything looks urgent, so nothing gets fixed.
Fix: Set review limits by both percent and amount.
✕ Mixing personal and business spending
Why it matters: Your margin becomes fiction, and tax time becomes painful.
Fix: Keep separate accounts, and log pay to yourself as Owner Draws.
✕ Editing the budget to match reality
Why it matters: Every variance disappears, and you learn nothing.
Fix: Keep the budget fixed, and use a forecast for changing expectations.
Importance of a Business Budget Template
In the Federal Reserve Banks' 2025 Small Business Credit Survey, 94% of US employer firms reported financial challenges in the prior 12 months. Of those firms, 54% responded by using the owner's personal funds. The survey isn't a random sample, but the picture is hard to miss.
So what? Over half of the owners facing trouble reached into their own pockets. A budget won't remove the trouble. It can show it to you earlier, while you still have options.
Survival is the long game. Bureau of Labor Statistics data shows that of US private sector establishments born in March 2013, 79.6% were still operating a year later and 34.7% after ten years. A budget doesn't guarantee you land in that group, but flying blind doesn't help.
Improves Financial Planning and Control
Writing down the year forces decisions you might otherwise avoid. Can you afford that hire in March? Your plan will answer in about a minute.
Eases Financial Tracking
One log and one review screen in a small business budget template replace a pile of statements. When the bank asks how the year is going, you answer in numbers.
Enhances Decision Making
Should you spend more on marketing? In the sample's budget vs actual view, $1,710 of extra ad spend came alongside a $9,097 sales shortfall. That's a conversation you can only have with both figures side by side.
Sustains Risk Management
The template turns "we might have a tight month" into "October, $34,593, below our buffer". A named problem with a date is one you can solve.
Spreadsheet vs Software for Business Budgeting
A small business budget spreadsheet is a great place to plan. Where it starts to strain is the recording. Here's an honest comparison.
| What you need | Small business budget template | Enerpize |
|---|---|---|
| Cost | Free | Free trial, then a paid plan |
| Annual plan by month | Built in, and fully yours to reshape | Keep your plan in the template |
| Recording spending | Paste and categorize | Receipts captured by AI, with approvals |
| Recording income | Paste and categorize | From invoices and income records |
| Reports | Monthly Review and Year Summary | Profit and loss, cash flow and cost center reports |
| Job budgets | Copy the file per project | A budget on each work order |
Plenty of businesses use both, and that works well. Plan the year in the sheet, and let the system do the recording.
How Enerpize Handles Your Actuals
Remember the hardest part of any budget? It's the actuals. That's also where Enerpize earns its place. The screens below use sample data.
Expenses Without the Shoebox
Upload or scan a receipt in the expense management software and AI pulls out the amount, date, vendor and tax. Set categories, recurring expenses and approval steps, and track and report expense budgets by category. Each expense then posts to your accounts automatically.

Income in One List
Record income beside your invoices in the accounting software, with totals for the last 7, 30 and 365 days at the top. Then pull profit and loss and cash flow reports for any date range, ready to hold against your budget.

Every Treasury and Bank Account in View
That Opening Cash figure in your budget? Here's where it comes from. Treasuries and bank accounts sit on one screen with their balances, and bank reconciliation keeps them matched to your statements.

Costs That Know Where They Belong
Budgeting by department? Cost centers let you assign income and expenses to parent and child centers, split a cost by percentage, and report on each one. Build the chart of accounts behind it once, and entries mirror into the general ledger.

A Budget for Every Work Order
Running jobs or projects? Set a budget on each work order and Enerpize shows Total Spent and Remaining Budget. By default, the spent figure comes from expenses linked to that work order. You can switch it to money collected on linked sales invoices. Purchase invoices and journal entries stay visible on the work order, but they don't reduce the budget, so record a cost as an expense when you want it to count.
Business Budget Template for the United States
Your business can show a healthy profit in March and still get an unwelcome bill in April. In the US, estimated tax runs on its own calendar.
The IRS estimated tax schedule for individuals, including sole proprietors and partners, sets four dates: April 15, June 15, September 15 and January 15 of the following year. If a date falls on a weekend or legal holiday, the next business day counts. The IRS says you generally need to pay if you expect to owe at least $1,000 for the year, subject to withholding and credit tests.
What to add:
- Your four estimated payments on the Income Tax Payments line
- Self-employment tax, if you are a sole proprietor
- Owner Draws, so your own pay is planned
⚑ Practical note: The gaps between dates are uneven: two months, three months, then four. Check Cash Check around April and June, when two payments land close together. Corporations follow their own rules, so confirm yours with a tax adviser.
Business Budget Template for the United Kingdom
Sole traders in the UK now have a reason to look at their numbers more than once a year. It's the law.
HMRC says Making Tax Digital for Income Tax became mandatory in April 2026 for sole traders and landlords with qualifying income over £50,000, and the threshold falls to £30,000 from April 2027. It brings quarterly updates, with the first period running from 6 April to 5 July 2026. The Self Assessment deadline stays at 31 January.
What to add:
- April as your first budget month, if you plan by tax year
- Your 31 January tax bill on the Income Tax Payments line
- GBP as your currency label in Settings
⚑ Practical note: Quarterly updates suit a monthly budget habit, but this template doesn't submit anything to HMRC. You still need compatible software for that. From 6 April 2027, HMRC says missed quarterly deadlines earn penalty points.
Business Budget Template for South Africa
Twice a year, SARS wants money from your business before your assessment is done. Is that in your budget?
SARS provisional tax rules say companies automatically fall into the system, along with anyone earning income other than remuneration. You pay at least two amounts in advance. The first is due within six months of the start of the year of assessment, and the second by its last day. A third, optional top up can follow after year end.
What to add:
- March as your first budget month, if your year ends in February
- Both provisional payments on the Income Tax Payments line
- A planned top up, if your profit usually beats your estimate
- ZAR as your currency label in Settings
⚑ Practical note: Your own year end can move these dates, because companies can have approved financial years. Set your first budget month to match yours, then check the payment months in Cash Check.
Business Budget Template for India
In India, a big part of your tax bill leaves in instalments, long before the year is over. Plan for it, or March will plan it for you.
Under section 408 of the Income-tax Act, 2025, most taxpayers pay advance tax in four parts: at least 15% by 15 June, 45% by 15 September, 75% by 15 December and the full amount by 15 March. Those are cumulative figures, so each date tops up what you've already paid. The Income Tax Department's advance tax FAQs add that taxpayers using certain presumptive schemes pay the whole amount by 15 March instead.
What to add:
- April as your first budget month, to match the financial year
- Advance tax on the Income Tax Payments line: 15%, 30%, 30% and 25% of the year's amount
- INR as your currency label in Settings
⚑ Practical note: The Seasonal Spread helps here. If your sales peak around the festive season, your December payment may be easier to fund than your June one. Check that against Cash Check, and confirm your position with your tax adviser.
Who Can Use the Business Budget Template?
Small Business Owners and Startups
You wear every hat, and nobody hands you a monthly finance pack. The small business budget template becomes that pack. Startups can also use the Cash Check to see how many months the money lasts, which is the first thing an investor will ask.
Service Firms
A consulting firm or an accounting practice has little stock and a lot of payroll. Leave Cost of Goods Sold blank and watch salaries as a percent of income.
Medium to Large Enterprises
Department heads can each keep a copy of the company budget template with the same categories, then roll the totals up to finance. Past a few departments, cost centers in a system start to make more sense.
Non-Profit Organizations and Public Institutions
Rename Product Sales to Grants and Donations, and the structure holds. If restricted funds need separate tracking, keep one copy per fund.
Freelancers and Solopreneurs
When income arrives in lumps, Cash Check matters more than profit. Log what you pay yourself as Owner Draws, and track your business expenses separately from your groceries.
Business Budget Glossary
| Term | What it means |
|---|---|
| Actuals | What really came in and went out, as opposed to what you planned. |
| Variance | The gap between budget and actual. Positive is good news in this template. |
| Gross profit | Income minus cost of goods sold. |
| Net profit | Gross profit minus operating costs, including contingency. |
| Cash buffer | The minimum bank balance you want to keep at all times. |
| Fiscal year | The 12 month period your business budgets and reports on. It need not start in January. |
Key Takeaways
- A small business budget template plans income and costs by month, then compares that plan with what actually happened.
- Actuals make a budget useful. Our template builds them from a log of your bank and card lines.
- Don't split the year evenly. In our sample, December's budget is $121,900 against $61,500 for January.
- A positive variance should always mean good news: actual minus budget for income, budget minus actual for costs.
- Flag lines by both percent and amount. A 28% miss worth $179 can wait, but a 38% miss worth $1,710 shouldn't.
- Profit isn't cash. Our sample's October cash fell to $34,593 against a planned $47,054, under its $40,000 buffer.
- Build tax payments into the calendar: four dates in the US and India, and two required payments in South Africa.
- Keep the original budget fixed, and review it every month with a forecast beside it when plans change.
Frequently Asked Questions
What should a small business budget include?
Income by stream, cost of goods sold, fixed costs, variable costs and a contingency. Add cash items such as owner draws, tax payments and loan principal, because they leave the bank without touching profit. Then add a column for actuals, so you can compare plan with reality.
How do I create a budget spreadsheet for my business?
List your income and cost categories down the side and 12 months across the top. Enter last year's figures as a guide, add totals, then add a log of real transactions and a SUMIFS formula to total them by month. Or download our template, which already does all of it.
Is there a free business budget template?
Yes. This small business budget template is free in Excel, Google Sheets, Word and PDF, with a filled sample you can copy. It uses formulas only, with no macros, so you can change any category or layout to fit your business.
How do I budget for a new business with no history?
Start with real quotes for rent, software, insurance and pay, since those are knowable. Estimate sales low, using similar businesses or your own pipeline as a guide. Add a larger contingency, then check how many months your cash lasts on the Cash Check sheet.
What is the difference between a budget and a forecast?
A budget is what you plan to earn and spend, usually set once a year. A forecast is your updated estimate of where you'll actually land, based on results so far. Keep the budget fixed and update the forecast, so you can still measure against your plan.
What are examples of monthly business expenses?
Rent, salaries, insurance, software, phone and internet, utilities, marketing, shipping, office supplies and loan payments. Stock purchases and owner draws matter too. Our template groups them into cost of goods sold, fixed costs, variable costs and cash items.
How often should a small business update its budget?
Log actuals weekly or monthly, and review once a month. Revise your expectations in a forecast whenever something big changes, such as a new hire or a lost customer. Then build a fresh budget once a year, starting from what actually happened.
Should I use Excel or Google Sheets for a business budget?
Both work with this template. The business budget template Excel file suits you if your accountant exchanges .xlsx files. Google Sheets suits two people editing the same budget, and it keeps version history. Once recording takes too long, move the recording into software and keep your plan in the sheet.
About the Author
Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.
Disclaimer
This template and the information on this page are for general guidance only and are not accounting, tax or financial advice. Tax rules and dates differ by country and change over time, so confirm your position with a qualified adviser or your tax authority.
