A good one-page spending dashboard in Excel has four parts: a row of KPI cards, a monthly trend chart, a category bar chart and a short top-merchants list. Build it on its own sheet on a fixed column grid with gridlines off, and keep every formula on a separate calculation sheet so the dashboard stays clean.
What belongs on the page and what does not
The test for each item is whether it answers a question you ask every month. Four questions cover most households: how much did I spend, is that more or less than usual, where did it go, and who got the money.
- KPI cards: spent this month, income, net saved, and savings rate.
- Trend: one line or column chart of the last twelve months.
- Category bars: the top eight categories this month, sorted largest first.
- Top merchants: five rows with merchant and amount.
- Leave out: raw transactions, pie charts of twelve slices, and anything you would never act on.
A grid that survives different screens
Set every dashboard column to the same width, say 12 columns of about 9 characters, and treat each block as a whole number of columns. Align charts to cell edges using Alt while dragging so they snap to the grid. Avoid merging cells for cards. Select the card's cells, open Format Cells, choose Alignment, and set Horizontal to Center Across Selection. That keeps the grid intact.
| Zone | Rows | Columns | Content |
|---|---|---|---|
| Header | 1-2 | A-L | Title and month selector |
| KPI cards | 4-7 | A-L, three columns each | Spent, income, net, savings rate |
| Trend chart | 9-22 | A-F | Twelve-month columns or line |
| Category bars | 9-22 | G-L | Top eight categories |
| Top merchants | 24-30 | A-L | Five-row list with amounts |
Keep the whole thing within about 1,200 pixels wide and 30 rows tall. Then it fits a laptop screen at 100 per cent zoom and prints cleanly. Turn off gridlines under View, and use one accent colour plus a neutral grey so the page does not look busy.
Why keep calculations on a separate sheet?
Charts and cards should read from cells that already hold the answer. Put a sheet called Calc behind the dashboard with one block per visual. Anyone, including you in six months, can then see where a number comes from, and the dashboard can be deleted and rebuilt without losing the logic.
- Data sheet: your transactions as a Table named Data.
- Calc sheet: month start in a cell, then each card's formula next to a label.
- Dashboard sheet: cards simply point at Calc cells, for example =Calc!B2.
- Charts point at the Calc ranges, not at the Data sheet.
Say Calc!B2 holds the month start date. A spend card can then use =SUMIFS(Data[Amount], Data[Date], ">="&Calc!B2, Data[Date], "<"&EDATE(Calc!B2,1)). Savings rate on the card is =IF(Calc!B3=0,"",(Calc!B3-Calc!B4)/Calc!B3), with income in B3 and spend in B4.
How many charts is too many?
Three visuals plus the cards is usually the limit before the page stops being a summary. If you want more, add a second dashboard sheet for a different question, such as yearly comparison, rather than squeezing it in. A page you glance at in ten seconds is worth more than a page that takes ten minutes to read.
Format large numbers consistently across cards. With the Windows region set to English (India), Excel usually groups digits the lakh way, as in 12,34,567, while other regions show 1,234,567. Pick one, and give each card a large number with a small grey label above it.
A short build order
Make the Calc sheet first, then the cards, then the charts, and only then think about colour. If the numbers on the cards disagree with the totals in your pivot or statement, fix that before polishing anything. SpendixAI also gives you a dashboard and 25 ready-made reports if you would rather not maintain formulas, but a sheet you built yourself teaches you what each number means.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


