Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Operating budget open in Sheets, in the light themeOperating budget open in Sheets, in the dark theme

What is in it

Budget against actual for each category, with the variance and the totals worked out. The figures are examples to type over.

Operating Budget 2026
CategoryBudgeted ($)Actual ($)Variance ($)
Hosting & Cloud450420=B4-C4
Marketing & Growth12001150=B5-C5
Engineering Contractors35003500=B6-C6
Software Tools200180=B7-C7
Office & Operations300260=B8-C8
Total Operating Expenses=SUM(B4:B8)=SUM(C4:C8)=SUM(D4:D8)

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Variance ($)
=B4-C4
Total Operating Expenses: Budgeted ($)
=SUM(B4:B8)
Total Operating Expenses: Actual ($)
=SUM(C4:C8)
Total Operating Expenses: Variance ($)
=SUM(D4:D8)

Filling it in

  • Use the categories your accounts use, so the actual figures can be copied straight across.
  • Look at the variance on each line, not only the total. Two large differences can cancel out.
  • Agree the budget figures before the period starts and leave them alone, so the comparison means something.

More templates

All 32 templates