Expense tracker

Log spend in four seconds — a Category dropdown that keeps SUMIF honest, a running total, and a summary block.

Use this templateSheets template

Expense trackerLog spend in four seconds — a Category dropdown that keeps SUMIF honest, a running total, and a summary block.

Expenses

	A	B	C	D	E	F	G
1	Date	Description	Category	Amount	Running total
2	2026-06-01	Cold brew	Food	$4.50	$4.50
3	2026-06-02	Monthly transit pass	Transport	$96.00	$100.50
4	2026-06-03	Standing desk mat	Office	$64.00	$164.50
5	2026-06-05	Team lunch	Food	$38.00	$202.50
6	2026-06-08	Cloud storage	Software	$12.00	$214.50
7
8	Total	$214.50
9	Average	$42.90
10	Food only	$42.50
11	Largest spend	$96.00
12
13	Category summary	Amount
14	Food	$42.50
15	Transport	$96.00
16	Office	$64.00
17	Software	$12.00

Running spend

Running spend data
Category	Running total
2026-06-01	4.5
2026-06-02	100.5
2026-06-03	164.5
2026-06-05	202.5
2026-06-08	214.5

Expense by category

Expense by category data
Category	Amount
Food	42.5
Transport	96
Office	64
Software	12