---
title: "Monthly operating budget template for small businesses"
description: "Free monthly operating budget template in Excel and CSV: revenue, cost of sales, gross profit and expenses over 12 months, with annual totals and account codes."
canonical: https://ledgeriano.com/templates/budget-template
language: en
publisher: "Ledgeriano"
updated: 2026-11-06
---

# Monthly operating budget template for small businesses

> Free monthly operating budget template in Excel and CSV: revenue, cost of sales, gross profit and expenses over 12 months, with annual totals and account codes.

An operating budget template plans revenue and expenses month by month for a fiscal year, line by line against your chart of accounts. This free Excel and CSV file has two revenue lines, cost of sales, nine expense lines, gross profit and operating profit for each month of 2027, with annual totals.

Download: [Excel (.xlsx)](https://ledgeriano.com/templates/files/budget-template.xlsx), [CSV (UTF-8)](https://ledgeriano.com/templates/files/budget-template.csv)

## How the template is laid out

Each row is one budget line with the account code it maps to, twelve monthly amounts and an annual total. Subtotal rows (total revenue, gross profit, total operating expenses and operating profit) have no account code, so you can filter them out when loading the lines elsewhere.

The sample is a small trading company with 2027 product sales of 595,000 and a 55% cost of sales ratio. Sales are seasonal, with a strong fourth quarter; salaries rise in July; marketing follows the sales peaks; audit and legal fees land in March and December.

## How to build each line

Budget the drivers, not just the totals. A few rules keep the plan realistic:

- Start from the sales budget: units times price per month, using last year's seasonality. The [master budget](https://ledgeriano.com/glossary/master-budget) starts here for a reason.
- Tie cost of sales to sales with your gross margin, so a change in sales moves it automatically.
- Budget fixed costs (rent, insurance, subscriptions, depreciation) at their contract amounts and timing.
- Put irregular costs in the month they fall due, such as annual audit fees, rather than spreading them evenly.
- Check the result with the [break-even calculator](https://ledgeriano.com/tools/break-even-calculator): if planned sales sit close to break-even, the plan has little room for error.

## Budget vs actual

A budget earns its keep when you compare it with actual results each month. Positive variances on revenue and negative variances on expenses are favourable; investigate the large ones and note whether they are timing differences or real changes. When volume differs a lot from plan, a [flexible budget](https://ledgeriano.com/glossary/flexible-budget) separates the effect of selling more or less from spending differences.

## Budgets in Ledgeriano

In [Ledgeriano](https://ledgeriano.com/features) a budget belongs to a fiscal year and holds an amount per month for each account, cost center and project. You can spread an annual amount evenly or seasonally, copy last year's actuals with a growth percentage, keep scenarios as drafts, approve one default budget per year and see budget vs actual with favourable and unfavourable variances by statement section, account, cost center, project and month. The [management accounting guide](https://ledgeriano.com/guides/management-accounting) walks through the full master budget.

## Preview

| Account code | Budget line | Jan 2027 | Feb 2027 | Mar 2027 | Apr 2027 | May 2027 | Jun 2027 | Jul 2027 | Aug 2027 | Sep 2027 | Oct 2027 | Nov 2027 | Dec 2027 | Total 2027 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 4101 | Sales of goods | 42000 | 40000 | 46000 | 48000 | 50000 | 47000 | 44000 | 43000 | 52000 | 55000 | 60000 | 68000 | 595000 |
| 4102 | Revenue from services | 8000 | 8000 | 8500 | 8500 | 9000 | 9000 | 9000 | 9000 | 9500 | 9500 | 10000 | 10000 | 108000 |
|  | Total revenue | 50000 | 48000 | 54500 | 56500 | 59000 | 56000 | 53000 | 52000 | 61500 | 64500 | 70000 | 78000 | 703000 |
| 5101 | Cost of goods sold | 23100 | 22000 | 25300 | 26400 | 27500 | 25850 | 24200 | 23650 | 28600 | 30250 | 33000 | 37400 | 327250 |
|  | Gross profit | 26900 | 26000 | 29200 | 30100 | 31500 | 30150 | 28800 | 28350 | 32900 | 34250 | 37000 | 40600 | 375750 |
| 6201 | Salaries and wages | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 19000 | 19000 | 19000 | 19000 | 19000 | 19000 | 222000 |
| 6205 | Rent expense | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 72000 |
| 6206 | Utilities | 1400 | 1400 | 1200 | 1000 | 900 | 1100 | 1300 | 1300 | 1000 | 1000 | 1200 | 1400 | 14200 |
| 6102 | Advertising and marketing | 2500 | 2500 | 3000 | 3000 | 3000 | 2000 | 2000 | 2000 | 3500 | 3500 | 4500 | 5000 | 36500 |
| 6214 | Software subscriptions and IT services | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 10800 |
| 6207 | Insurance expense | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 8400 |
| 6208 | Professional fees (audit, legal, consulting) | 500 | 500 | 2500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 3000 | 10500 |
| 6210 | Telephone and communication | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4800 |
| 6301 | Depreciation of property, plant and equipment | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 18000 |
|  | Total operating expenses | 31900 | 31900 | 34200 | 32000 | 31900 | 31100 | 32300 | 32300 | 33500 | 33500 | 34700 | 37900 | 397200 |
|  | Operating profit | -5000 | -5900 | -5000 | -1900 | -400 | -950 | -3500 | -3950 | -600 | 750 | 2300 | 2700 | -21450 |

## How to fill in the operating budget template

1. **Set the year and accounts**: Change the month headers to your fiscal year and the account codes to your chart of accounts.
2. **Budget sales**: Enter monthly sales from expected volume and prices, following last year's seasonality.
3. **Derive cost of sales**: Apply your expected cost of sales ratio to each month's sales.
4. **Add operating expenses**: Enter fixed costs at contract amounts and irregular costs in the month they fall due.
5. **Review the totals**: Check monthly operating profit, the annual total and the cash timing before approving the budget.

## Frequently asked questions

### What is the difference between an operating budget and a cash budget?

An operating budget plans revenue and expenses on the accrual basis, which gives budgeted profit. A cash budget plans receipts and payments by month, including loan repayments and asset purchases, which shows whether you will run short of cash.

### Should a budget be monthly or annual?

Build it monthly. An annual figure hides seasonality, and monthly amounts let you compare budget with actual results while there is still time to react.

### How do I budget for a new business with no history?

Start from capacity and market evidence: how many customers you can reach and serve each month, at what price, and what it costs to deliver. Then budget fixed costs from quotes and contracts, and test the plan against break-even.

### Can I add departments or projects?

Yes. Add a cost center or project column and repeat the lines per department. In accounting software the same budget can be kept per account, cost center and project.