How to Create a Monthly Budget That Survives Real Life
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Sheetzy guide
By Mani Dazzle, Template maker at Sheetzy · 17 November 2026
One screen that answers the question 'how are we doing?' without any scrolling or maths. A few headline numbers at the top, a couple of charts underneath, everything updating itself from your raw data.
The mistake most first dashboards make is trying to show everything. A good dashboard shows the numbers that change what you do next - this week's sales against last week's, stock running low, invoices unpaid. Everything else belongs on a different tab.
Every working dashboard in Google Sheets has the same skeleton: one tab holds raw data, a second tab holds the dashboard. Never mix them.
Make the data tab a boring, clean table: one header row, one record per row, dates in a real date format, no merged cells, no blank spacer rows. Five minutes of tidiness here saves an hour of formula debugging later.
Select your data, then Insert > Pivot table, and place it on a third working tab. Group by whatever your dashboard is about - by month, by product, by salesperson - and let the pivot do the totals.
If you prefer formulas, =QUERY(data!A:E, "select A, sum(E) group by A", 1) does the same job and is easier to copy across projects. Either way, the summary layer sits between raw data and charts so the dashboard never touches the data tab directly.
Click inside your pivot or QUERY output, Insert > Chart, and pick the simplest type that fits: a line for trends over time, bars for comparing categories, a pie only when parts genuinely add to a whole.
Give every chart a title phrased as the answer, not the topic. 'Sales dipped in week 3' beats 'Sales chart'. Two to four charts is the sweet spot; more than that and nobody looks at any of them.
The top row of the dashboard should be three to five big numbers: total sales this month, open orders, low-stock items. In Google Sheets these are just cells with a formula like =SUM(data!E:E) or =COUNTIF(data!C:C,"unpaid"), styled large.
Add a small comparison under each one - against last month, or against target - with a formula-driven arrow or a coloured number. A number without context is decoration.
A sparkline (=SPARKLINE) inside a scorecard cell turns a flat number into a mini trend line - cheap to add, genuinely useful.
Then Data > Add a slicer gives viewers dropdown filters for the whole dashboard: pick a region or a month and every connected chart and pivot updates. This is the feature that makes a Sheet feel like a real dashboard tool.
Hide gridlines on the dashboard tab (View > Show > Gridlines), remove the charts' grey borders, and line everything up on a simple two-column layout. Consistent fonts, one accent colour, generous white space.
Freeze nothing on the dashboard tab - it should fit one screen. If it scrolls, something needs to move to another page.
Everything above is worth learning once. But if you need a dashboard this week, starting from a wired-up template beats a blank grid: our Stockroom inventory dashboard tracks stock levels and reorder points out of the box, the Ledger sales tracker turns raw sales rows into weekly totals and charts, and the Blueprint project planner does the same for project timelines.
Paste your data into the data tab and the dashboard tab fills itself in. You can still customise every chart the way this guide describes - the steps are identical, you just skip the blank-page hour.
Yes. A dashboard tab that reads from a raw data tab with pivot tables, charts and scorecards covers most small-business reporting. It auto-updates the moment new rows land in the data tab, it is free, and it shares like any other Sheet.
Build every chart and scorecard on formulas or pivot tables that point at the whole data column, not a fixed range. When you add new rows at the bottom of the data tab, the dashboard refreshes on its own. Nothing needs to be re-made.
Not strictly. SUMIFS, COUNTIFS and QUERY can summarise the same numbers, and QUERY is often easier to maintain. Pivot tables are simply the fastest way to group data without writing formulas, so most builders start there.
Three to five headline numbers at the top, then two to four charts that each answer one question. If a chart does not change a decision, remove it. A dashboard nobody reads is usually a dashboard with twelve charts.
Yes - our Stockroom inventory dashboard and Ledger sales tracker already have the data tab, formulas and charts wired together, so you paste in your numbers instead of building from scratch. Links are at the end of this guide.
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Half to needs, a third to wants, a fifth to savings. The 50/30/20 rule is the lowest-effort budget that still works - here is how to run it with real numbers.