Softwiro
Free Excel template

Small Business Budget Template for Excel (Monthly)

A free Excel budget for a small business, a studio or a freelancer. You plan each income line and each expense line for every month of the year and mark every cost as fixed or variable. Then you log sales and costs as they happen. The sheet compares each line with its budget for the month and for the year so far, flags lines that are over budget or close to it, shows net profit for every month and works out the revenue you need to break even. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 106 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
This monthBudgetActualVariance (+ is good)
Income18,610.0018,499.42-110.58
Expenses10,540.0011,153.15-613.15
Net profit8,070.007,346.27-723.73
Expense budget used105.8%
Year to dateBudgetActualVariance (+ is good)
Income177,910.00181,959.284,049.28
Expenses105,860.00107,043.66-1,183.66
Net profit72,050.0074,915.622,865.62
Expense budget used101.1%

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: This month and the year so far: budget, actual and variance for income, expenses and net profit, how much of the expense budget is used, a list of the lines over budget, break-even figures, expenses by payment method and four charts.
  • Budget: Your plan: up to 30 income and expense lines, each marked Fixed or Variable, with an amount for every month from January to December and a year total.
  • Log: The entries you type: date, vendor or customer, budget line from a dropdown, amount, payment method and a note. The sheet looks up whether each row is income or an expense and whether the cost is fixed or variable, and a Check column flags a missing amount, date or line. Room for 1,000 rows.
  • Categories: Every budget line against its budget for the month and for the year so far: actual, variance, percent of budget used and a status (On track, Near limit, Over budget; On plan or Behind plan for income).
  • Monthly: All twelve months side by side: income, expenses and net profit as budget, actual and variance, the share of the expense budget used, profit margin, a running profit total, a status per month and year-to-date totals.
  • Break-even: Contribution margin, fixed costs, break-even revenue, margin of safety, the number of orders or jobs to break even and the revenue needed for your target profit, for the month and for the year to date, budget and actual.
  • Settings: Business name, currency symbol, the month to review, the near-limit alert level, your average sale value, your monthly profit target and your list of payment methods.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Many small business budget templates are a grid you fill in by hand at the end of the month. Here you log each sale and cost once, and the comparison with the budget, the alerts, the monthly profit and the break-even point update by themselves. Fixed and variable costs are part of the budget from the start, so the break-even view needs no extra typing. The sample is a small design studio with a log from January to November 2026, so you can see every sheet working before you replace it with your own figures.

How do I make a small business budget in Excel?

Start with income, then costs. List the kinds of revenue you expect (client projects, retainers, product sales) and the costs you pay (rent, wages, insurance, software, materials, advertising, shipping). Give each its own row and type an amount for every month, because most businesses have slower and busier months. Mark each cost as fixed if it stays about the same whatever you sell, or variable if it moves with your sales.

Check the plan before the year starts. In the sample, the planned income for November is 18,610.00 and planned expenses are 10,540.00, which leaves a planned profit of 8,070.00. If planned expenses are higher than planned income, the plan loses money and needs work before you begin. Many businesses start from last year's figures from their accounts; whichever way you start, edit the budget when you learn something new.

How do I compare budget vs actual for each month?

Log every sale and cost against the budget line it belongs to, and the sheet adds up each month for you. Variance is the gap between plan and reality: the Monthly sheet shows it for income, expenses and net profit, and the Categories sheet shows it for each line. A positive variance is always in your favour: income above plan or costs below plan.

In the sample, November income came to 18,499.42 against 18,610.00 planned, and expenses were 11,153.15 against 10,540.00, so 105.8% of the expense budget was used and net profit was 7,346.27 instead of 8,070.00. The Categories sheet shows why: advertising was 1,028.10 against a budget of 745.00 and travel and meetings was 382.50 against 255.00. Year to date the business is ahead, with net profit of 74,915.62 against 72,050.00 planned.

What is a break-even point and how do I find it?

Break-even is the revenue at which you cover all your costs and make neither profit nor loss. Divide your fixed costs by your contribution margin percentage, which is revenue minus variable costs, as a share of revenue. That is why the budget asks whether each cost is fixed or variable. For a rough check you can also try the break-even calculator.

In the sample, November fixed costs were 4,773.60 and the contribution margin was 65.5%, so break-even revenue was 7,286.29. Revenue of 18,499.42 is 60.6% above that, which is the margin of safety. At an average sale of 450.00 that is 17 orders or jobs to break even, and to earn the 6,000.00 monthly profit target the business needs 16,444.51 of revenue.

How do I know when I am about to go over budget?

Set the near-limit level on Settings (90% in the sample). A line turns yellow when it has used that share of its budget and red once it passes 100%, and the Dashboard lists the lines that are over budget. In November the sample has 8 lines over budget and 6 near the limit. Looking at this mid-month, not at the end, is what gives you time to act. For a look at cash timing, see the cash flow forecast.

How to use it

  1. On Settings type your business name, your currency symbol, any date in the month you want to review, the alert level (90% of a budget in the sample) and your payment methods.
  2. On Budget list your income lines and expense lines, one per row. Mark every expense as Fixed (rent, salaries, insurance) or Variable (materials, ads, shipping), then type the amount you plan for each month.
  3. On Log add every sale and every cost as it happens: date, who it was with, the budget line from the dropdown, the amount and how it was paid. Always type amounts as positive numbers.
  4. Categories compares each line with its budget for the month and for the year so far and tells you which lines are over budget or near the limit.
  5. Monthly shows budget vs actual for all twelve months: income, expenses, net profit, how much of the expense budget is used and a running total of profit.
  6. Break-even turns your fixed and variable costs into the revenue you need to cover costs, and the Dashboard pulls it all together with charts.

Before you start:

  • Capacity: 30 budget lines, 1,000 log rows and 8 payment methods.
  • The date on Settings decides the month on Categories, Break-even and Dashboard, and the year on Monthly. Change it to review another month.
  • Type every amount as a positive number. Whether it counts as income or an expense comes from the Type of the budget line it is filed under.
  • Give every budget line a different name, because log rows find their line by name. A row whose line is not on Budget shows "Unknown category" in the Check column.
  • Break-even treats every expense not marked Variable as a fixed cost, so mark each expense line on Budget as Fixed or Variable.
  • Use one currency in one workbook. The currency symbol on Settings is only a label. Year-to-date means January up to the month you are reviewing.

Excel file (.xlsx) · 106 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this small business budget template really free?

Yes. Download it, use it for your business and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

How many budget lines and log entries can it hold?

30 budget lines, 1,000 log rows and 8 payment methods. When the log is full, save a copy and start a new file for the next year.

What is the difference between fixed and variable costs?

A fixed cost stays about the same whatever you sell, such as rent, insurance or a salary. A variable cost rises and falls with sales, such as materials, shipping, card fees or commissions. Some costs are a mix; pick the one that fits best. The break-even sheet treats every expense not marked Variable as fixed.

Why does a log row say Unknown category?

Its budget line is not on the Budget sheet, usually because of a spelling difference or a renamed line. Pick the line from the dropdown. Until then the amount does not count under any line.

Can I use it for a freelancer or a one-person business?

Yes. Use one income line per kind of work and the costs you actually have. Delete the sample lines you do not need and keep the rest of the structure.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Accounting

More free templates

All templates · Free tools