The 5 columns
| A: Date | B: Description | C: Category | D: Amount | E: Paid with |
|---|---|---|---|---|
| 11/01 | Rent | Housing | 1400 | Bank transfer |
| 11/02 | Supermarket | Groceries | 86 | Debit |
| 11/02 | Coffee | Eating out | 5 | Cash |
Category totals with SUMIF
In a summary table, list your categories in one column and next to each one use:
=SUMIF(C:C, "Groceries", D:D)
Replace "Groceries" with a cell reference to the category name, then copy down. The same formula works in Numbers, Excel and Google Sheets. Total of the month: =SUM(D:D).
Steps
- Create the five columns and freeze the header row.
- Make Category a pop-up or drop-down list, so names stay identical.
- Add the summary table with SUMIF.
- Insert a pie or bar chart from the summary.
- Duplicate the sheet each month.
On iPhone
Apple's free Numbers app has a home budget template, pivot tables and charts, and you can create a form on iPhone to enter data quickly on the go (App Store). The weak spot of every spreadsheet is entering purchases on the go; My Expenses, by Gambit Studio, is built for this: you log amount, description, category and date in seconds, and its charts show each category's share of the month and how it compares with last month.