A useful small-business budget spreadsheet lists monthly revenue, direct costs, operating expenses, and the difference between budget and actual results. In Excel for Microsoft 365, set up columns for category, budget, actual, and variance, then use simple subtraction and SUM formulas to total the month; the sample below shows a completed version and how to adapt it.
Sample monthly budget at a glance
This illustrative example is for one month. The figures are examples, not recommended targets: costs, sales patterns, and accounting treatment vary by business. The variance column is actual minus budget, so a positive number is not automatically good or bad. For revenue and profit, a positive variance usually means more than planned; for expenses, it usually means spending exceeded the plan.
| Category | Budget | Actual | Variance |
|---|---|---|---|
| Sales revenue | $18,000 | $19,000 | $1,000 |
| Cost of goods sold | $5,400 | $5,700 | $300 |
| Gross profit | $12,600 | $13,300 | $700 |
| Payroll | $5,000 | $5,100 | $100 |
| Rent | $1,800 | $1,800 | $0 |
| Marketing | $700 | $850 | $150 |
| Utilities | $400 | $420 | $20 |
| Software | $250 | $250 | $0 |
| Insurance | $300 | $300 | $0 |
| Shipping and delivery | $250 | $310 | $60 |
| Other operating costs | $300 | $280 | -$20 |
| Operating expenses | $9,000 | $9,310 | $310 |
| Operating profit before interest and tax | $3,600 | $3,990 | $390 |
Gross profit is revenue less cost of goods sold. Operating profit in this simplified example is gross profit less the listed operating expenses; it is not necessarily the same as net income or cash available. The sample omits items such as interest, income tax, owner draws, debt principal payments, and capital purchases, which may matter in a real plan.
Set up the workbook
Use one worksheet for the monthly budget, and keep the layout consistent from month to month. Put the category names in column A, budget amounts in column B, actual amounts in column C, and the variance in column D. The example table maps to these rows: row 1 contains headers; row 2 is sales; row 3 is cost of goods sold; row 4 is gross profit; rows 5 through 12 are the eight operating-expense categories; row 13 totals operating expenses; and row 14 calculates operating profit before interest and tax.
Start a new workbook with a clear name, such as Monthly Budget, and include the month and year near the top of the sheet. Add categories that fit how the business actually earns and spends money. A retailer may need inventory and card-processing fees; a consultant may need subcontractors, travel, and professional software. Avoid making the list so detailed that updating it becomes burdensome, but separate expenses that you will want to monitor independently.
- Keep income, direct costs, and operating expenses in distinct rows.
- Use the same categories in the budget and in the records used to enter actual results.
- Enter amounts as numbers, not text containing currency symbols, so Excel can calculate them.
- Format the amount columns consistently as currency, and make the variance heading explicit.
On Windows, select the amount cells and use Home > Number group > Accounting Number Format or Currency to display money consistently. Excel for Mac has the same core formulas and number formats, though ribbon arrangement and some menu labels can vary. Avoid merging cells inside the data area; merged ranges can make sorting, filtering, and copying formulas harder.
Enter formulas and check the totals
Formulas keep totals current when you revise a budget or enter new actuals. With budget values in B2:B3 and actual values in C2:C3, enter this in B4 to calculate budget gross profit; it returns $12,600 for the sample:
=B2-B3
With actual revenue in C2 and actual cost of goods sold in C3, enter this in C4; it returns $13,300:
=C2-C3
With gross profit in B4 and C4, enter this in D4 to show actual minus budget; the result is $700:
=C4-B4
With the eight operating-expense budget amounts in B5:B12, enter this in B13; it returns $9,000:
=SUM(B5:B12)
With actual operating expenses in C5:C12, enter this in C13; it returns $9,310:
=SUM(C5:C12)
With budget expenses in B5:B12 and actual expenses in C5:C12, enter this in D13 to show the $310 expense overrun:
=C13-B13
With budget gross profit in B4 and budget operating expenses in B13, enter this in B14; the result is $3,600:
=B4-B13
With actual gross profit in C4 and actual operating expenses in C13, enter this in C14; the result is $3,990:
=C4-C13
With budget operating profit in B14 and actual operating profit in C14, enter this in D14; it returns a $390 favorable profit variance:
=C14-B14
For the remaining detail rows, use actual minus budget in column D. Copying a formula down adjusts its row references automatically, but check that totals and subtotals point to the intended ranges. A quick arithmetic check is that $13,300 gross profit minus $9,310 operating expenses equals $3,990 operating profit.
Build a realistic revenue and expense plan
A budget is a forecast, not a promise. Base revenue estimates on evidence such as signed work, recurring contracts, recent sales, booked appointments, or a seasonal pattern. If sales vary, estimate each month separately rather than multiplying one strong month by twelve. A new business can make assumptions explicit—for example, expected transactions multiplied by an average sale—and update them when actual results provide better information.
Separate costs that change with sales from costs that are mostly fixed in the short term. Materials, inventory, payment fees, or delivery may rise as sales rise. Rent or a software subscription may stay similar for a period, although contracts can change. This distinction helps explain why revenue growth does not necessarily produce the same percentage increase in profit: additional sales can bring additional direct costs, labor, or fulfillment needs.
Look at prior records and known commitments when estimating expenses. Include less frequent costs in the month they are expected or set aside a monthly planning amount for them, while making the method clear. Annual insurance, equipment maintenance, renewal fees, and seasonal advertising can otherwise disappear from a monthly forecast simply because they are not paid every month. Do not count a future expense twice—once as a monthly reserve and again as the full payment—when reviewing totals.
Budget versus cash flow: why both matter
A profit-oriented budget and a cash-flow forecast answer different questions. A budget estimates income and expenses over a period; cash flow tracks when money is expected to enter or leave the bank account. A sale made on credit may be recorded as revenue before the customer pays. Likewise, loan principal reduces cash but is not an operating expense in the same way as interest, and buying equipment can affect cash differently from how its cost is recognized in accounting records.
For a small business with delayed customer payments, seasonal income, or large supplier bills, add a separate cash-flow worksheet. List opening cash, expected receipts by date or week, and expected payments, then calculate the ending cash balance for each period. Compare that forecast with bank balances and payment schedules, and revise it when collection dates or bills change. The monthly sample above cannot, by itself, show whether cash will be available on a particular day.
Do not treat the example’s operating profit as take-home pay or as a tax estimate. The worksheet is a planning aid, not accounting, tax, investment, legal, or financial advice. Check the treatment of real transactions and applicable obligations with a qualified accountant, tax professional, or other appropriate professional.
Review results and improve the forecast
Update actual amounts on a regular schedule, such as monthly, using the same cut-off dates each time. Reconcile the figures to reliable bookkeeping records rather than relying on memory or a bank balance alone. Then investigate meaningful variances. In the sample, sales are $1,000 above budget, but cost of goods sold is also $300 higher and operating expenses are $310 higher. Marketing accounts for $150 of the operating-expense difference. Those numbers invite questions about sales volume, product costs, campaign timing, or one-off purchases; they do not prove the reason on their own.
- Check whether a difference is recurring, seasonal, or a one-time event.
- Separate timing differences, such as a bill arriving late, from changes in the underlying cost.
- Update future months when new information changes the outlook, while preserving the original budget if you need to compare plan with outcome.
- Record a short note for unusual items so a future review has context.
A common misconception is that a favorable variance always means the business is doing better. Spending less than budget could reflect an efficient purchase, but it could also mean a necessary repair or marketing activity was postponed. Similarly, revenue above plan may come with costs that reduce the benefit. Interpret each difference alongside the operational reason and its effect on cash and service, not as an isolated score.
Common spreadsheet problems to avoid
Small workbooks often become unreliable through inconsistent categories, overwritten formulas, or mixing personal and business transactions. Keep business records organized according to the business’s bookkeeping process, and use clearly labeled categories. Protecting formula cells can reduce accidental edits, but protection is not a substitute for keeping a backup. Save dated copies or use a controlled cloud version history, and verify that the copy can be opened before depending on it.
Another frequent problem is reading every positive variance as favorable. In the sample, the $300 positive variance on cost of goods sold means costs came in above plan, while the $700 positive gross-profit variance means gross profit exceeded plan. Keep the actual-minus-budget convention consistent, and label the column so the direction is clear. If you want an explicitly favorable/unfavorable status, add a separate interpretation column rather than changing the sign convention halfway through the workbook.
Also avoid using a spreadsheet as the only record of transactions when the business needs a proper bookkeeping system, audit trail, or shared controls. A spreadsheet can summarize and help plan, but it may not capture invoices, payment status, reconciliations, or access controls adequately. Limit access to sensitive financial data and share only the workbook or ranges appropriate for each person.
Frequently Asked Questions
What should a small-business budget spreadsheet include?
At minimum, include the period, income categories, direct costs, operating expenses, budget amounts, actual amounts, and a clearly defined variance. Add cash-flow timing, debt payments, taxes, or capital purchases when relevant to the decisions the workbook needs to support.
Can I use this sample for a startup with no past sales?
Yes, as a structure, but not as a forecast to copy. Build estimates from documented assumptions such as expected customers, average transaction value, planned opening date, supplier quotes, and fixed commitments. Mark uncertain estimates and revise them as actual sales and costs arrive.
How often should I update a business budget?
Many owners review actuals monthly because that period is manageable and aligns with common reporting cycles. Businesses with tight cash, rapid changes, or weekly payroll may also need a more frequent cash-flow check. Set a repeatable schedule that fits the business rather than treating one frequency as universal.
Is a budget spreadsheet the same as a cash-flow spreadsheet?
No. A budget groups expected income and expenses by period, while a cash-flow forecast focuses on when receipts and payments occur. A profitable month can still have a cash shortfall if customers pay late or bills fall due before collections arrive.
Should I include taxes and owner pay?
Include relevant planned amounts as separate, clearly named lines if they help the forecast, but their accounting and tax treatment depends on the business and jurisdiction. Do not assume that the example’s operating profit is taxable income or money available for an owner’s personal use; check specifics with a qualified professional.
Related
- Pay Off Debt Snowball Spreadsheet: Build One in Excel
- How to Record a PowerPoint Presentation as a Video
- How to Record a PowerPoint Presentation in Zoom
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Full Line in Word: Borders and ShapesTo insert a full-width horizontal line in Word, put the cursor in the paragraph where the divider should…
- Excel Undo Shortcut: How to Reverse Changes SafelyIn Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action. On a Mac,…
- Edit a Data Validation List in Excel: Steps and FixesTo edit a data validation list in Microsoft Excel for Microsoft 365 on Windows, select a cell that…
- How to Make a Monthly Budget in Google Sheets Step by StepTo make a monthly budget in Google Sheets, create separate income and expense tables, enter planned and actual…
- Essential Excel Skills for Data AnalysisFor data analysis in Excel, the essentials are clean, consistently structured data; formulas such as SUM, AVERAGE, and…
- Excel Number Format With Leading Zeros: How It WorksTo display leading zeros in Excel without changing a number’s value, select the cells, press Ctrl+1, choose Number…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.