A good Google Sheets budget template does one thing a bank app can't: it lets you decide where your money should go before you spend it, then shows you how you're tracking. This guide walks through building a simple, powerful budget-vs-actual template for 2026 — and where to grab a free one to start.
Go deeper: to log what you actually spend, pair this with our Google Sheets expense tracker guide; to build a budget from real receipt data, see how to build a budget from your receipts; and for a business version, the small business expense spreadsheet template.
Budget template vs. expense tracker: this is a planning tool — you set targets and watch the gap. If you mainly want to record and scan receipts you've already paid, start with the expense tracker guide above instead.
1. Set up the structure
Create three sections: Income at the top, Categories down the left (rent, groceries, transport, savings, fun), and three columns next to them — Budgeted, Actual, and Difference.
2. Add the budget-vs-actual formula
In the Difference column use =Budgeted-Actual. A positive number means you're under budget; negative means over. Sum each column at the bottom so you can see your total planned vs. spent and what's left.
3. Make overspending obvious with conditional formatting
Highlight the Difference column with conditional formatting: green when positive, red when negative. Now a glance tells you which categories are in trouble — no math required.
4. Set realistic monthly category budgets
A simple starting point is the 50/30/20 framing — roughly half to needs, a third to wants, the rest to savings and debt — then adjust to your real numbers. Revisit the budgeted amounts each month as your income changes.
5. Add a chart (optional)
Insert a pie chart of your budgeted categories and a bar chart of budget vs. actual. Seeing the split makes it far easier to spot where to cut.
Keep "Actual" accurate by scanning receipts
A budget only works if the Actual column is real. ReceiptSync lets you scan any receipt — card or cash — and syncs the date, amount, and merchant to Google Sheets automatically, so your actuals stay current without manual entry. Download the free expense tracker template as a starting point, or explore our free budgeting and tax tools.