Guide · My Expenses

How to track expenses in a spreadsheet

Quick answer

To track expenses in a spreadsheet, use one row per purchase with five columns (Date, Description, Category, Amount, Payment method), then add a summary table that totals each category with SUMIF. Add a pie or bar chart of the summary, and start a new tab each month so months can be compared side by side.

Updated 2 min readGambit Studio

The 5 columns

A: DateB: DescriptionC: CategoryD: AmountE: Paid with
11/01RentHousing1400Bank transfer
11/02SupermarketGroceries86Debit
11/02CoffeeEating out5Cash

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

  1. Create the five columns and freeze the header row.
  2. Make Category a pop-up or drop-down list, so names stay identical.
  3. Add the summary table with SUMIF.
  4. Insert a pie or bar chart from the summary.
  5. 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.

Sources

  1. App Store: Numbers (Apple), description read on November 11, 2026

Frequently asked questions

What people ask most about this, answered with the source.

How do I make an expense tracker in a spreadsheet?
Use columns for Date, Description, Category, Amount and Payment method, total each category with SUMIF and add a chart.
What formula totals expenses by category?
SUMIF: =SUMIF(C:C, "Groceries", D:D) adds every amount in column D whose category in column C is Groceries.
Is a spreadsheet or an app better for tracking expenses?
Spreadsheets are flexible for analysis; apps are faster for logging at the moment you pay. Many people log in an app and analyze monthly.
My ExpensesWhere's My Money? Easy Control
Get