A Google Sheets expense dashboard needs two tabs: Data, which holds one row per transaction, and Dashboard, which reads from Data using a month selector. Change the month in one cell and every total, chart and top-merchants list changes with it. The tools are SUMIFS, UNIQUE, QUERY and a chart, all available in the free version.
What goes on the Data tab?
Row 1 holds headers and everything below is a transaction. Use these columns: A Date, B Merchant, C Category, D Amount, E Account. Dates must be real dates (they right-align after you type 05-11-2026), not text; amounts must be plain numbers without a typed ₹ sign. Format the column as Currency or Number instead.
Keep the category list short, perhaps ten names, and apply a dropdown to C2:C2000 through Data > Data validation, so Food never becomes food and Groceries. SUMIFS ignores capital letters, but extra spaces and different spellings will break the totals.
How does the month selector work?
On the Dashboard tab, put the label Month in A1. In B1 enter the first day of the month you want to see, for example 01-11-2026. Add a dropdown to B1 from a list of month-start dates if you like. Every formula below reads B1, so this one cell is the control for the whole page.
In A4 write =UNIQUE(Data!C2:C2000) to list each category once. In B4 write:
=SUMIFS(Data!$D$2:$D$2000, Data!$C$2:$C$2000, A4, Data!$A$2:$A$2000, ">="&$B$1, Data!$A$2:$A$2000, "<"&EDATE($B$1,1))
Fill it down beside the category list. SUMIFS takes the sum range first, then pairs of range and condition. The two date conditions mean "on or after the first of the month" and "before the first of the next month". Under the list, =SUM(B4:B20) gives the month total.
How do I add the chart?
- Select the category names in A4:A20 and the totals in B4:B20.
- Choose Insert > Chart. Pick a Pie chart for a quick share view or a Column chart if you have more than six categories.
- In the chart editor, check that the Data range is those cells and that column A is used as labels.
- Move the chart above the table. Because it reads formula cells, it redraws when B1 changes.
A pie works only when a handful of categories carry most of the spend; a bar chart sorted high to low is easier to read once the list grows. UNIQUE returns a blank entry if the range has empty cells, which shows up as an empty slice, so limit the range to the rows you need or filter out zero totals.
How do I list the top five merchants?
QUERY does the grouping in one formula. In D4 write:
=QUERY(Data!A2:D2000, "select B, sum(D) where A >= date '"&TEXT($B$1,"yyyy-mm-dd")&"' and A < date '"&TEXT(EDATE($B$1,1),"yyyy-mm-dd")&"' group by B order by sum(D) desc limit 5 label sum(D) ''", 0)
It filters Data to the chosen month, groups by merchant, sorts the largest first and keeps five rows. The final 0 tells QUERY that the range has no header row, because you started at row 2. If one shop appears under two spellings, clean them on the Data tab first, since QUERY groups exact text only.
When does a sheet stop being enough?
A sheet is a good start while you type fifty rows a month. When you are pasting hundreds of rows from statements and re-categorising the same merchants each month, SpendixAI can take an uploaded statement, apply your category rules and show a dashboard and insights without the typing. The Data and Dashboard idea you built here remains a handy way to check a figure.
Next steps
- Add a budget column next to the category totals and show Over or Under with =IF(B4>C4,"Over","OK").
- Add an Account filter to compare cards with UPI spending.
- Protect the formula cells (Data > Protect sheets and ranges) so a stray edit does not break them.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


