Skip to content
How to track spending: a long receipt unrolls into colored lanes of everyday expenses, with a magnifying glass over the groceries

PERSONAL FINANCE · BUDGETING

How to Track Your Spending: 5 Methods and a Simple Spreadsheet

Tracking spending means writing down where every dollar goes, sorting it into a few categories and checking the totals once a week. You can do it with your bank app, cash envelopes, an app or a spreadsheet. Here's how each method works, the categories to use, what the average US household spends, and a calculator to compare your month.

5 ways to trackSpreadsheet setupAverage spending 2025Spending check calculator

THE SHORT ANSWER

Record, sort, review: the three steps

Pick one place where all spending gets recorded. Give every purchase one of 8–12 categories. Once a week, spend ten minutes adding up the totals and comparing them with what you planned. After one full month you'll know your real numbers, which is what any budget needs first.

$6,825⁠average spending per US household per month in 2025 (BLS Consumer Expenditure Survey)
33.9%of that went to housing, the biggest category
$345⁠a month on food away from home, about 39% of the food budget

METHODS

5 ways to track your spending

MethodHow it worksGood forWatch out for
Bank or card appUses the categories your bank assigns automaticallyA quick first look with zero setupWrong categories, and cash or other cards are missing
SpreadsheetYou enter or paste transactions and sort them into your own categoriesFull control, every account in one place, no subscriptionNeeds a weekly 10-minute habit
Budgeting appLinks accounts and imports transactionsPeople who won't enter anything by handMonthly fees, broken bank connections, privacy
Cash envelopesWithdraw cash for each category; when an envelope is empty, you stopGroceries, eating out and other easy-to-overspend categoriesDoesn't work for bills and online shopping
Notebook and receiptsWrite each purchase down the day you make itBuilding awareness in the first 30 daysHard to total and compare months

Many people combine two: a spreadsheet as the single record, filled from bank exports once a week, plus cash envelopes for one or two problem categories. If you want a short reset first, a no-spend challenge pairs well with your first tracking month.

SPREADSHEET SETUP

How to track spending in Excel or Google Sheets

  1. 1

    Make one transactions table

    Columns: Date, Description, Category, Amount, Account, and Need or Want. One row per purchase. In Excel, select the range and press Ctrl+T to make it a table so formulas grow with it.

  2. 2

    Add a category dropdown

    List your categories on a second sheet, then use Data › Data validation on the Category column. Same spelling every time is what makes the totals work.

  3. 3

    Paste in bank exports weekly

    Most banks let you download transactions as CSV. Paste the new rows, delete transfers between your own accounts, and pick a category for each.

  4. 4

    Total each category by month

    Use SUMIFS on a summary sheet (formula below) or a pivot table with Category as rows and Amount as values.

  5. 5

    Compare with your plan

    Next to each total, add what you planned to spend and a difference column. Highlight anything over plan with conditional formatting.

=SUMIFS(Amount, Category, "Groceries", Date, ">="&DATE(2027,1,1), Date, "<"&DATE(2027,2,1))Total groceries for January 2027. Works the same in Excel and Google Sheets; replace the names with your column ranges, such as D:D for Amount.
DateDescriptionCategoryAmountAccountNeed / Want
Jan 2KrogerGroceries$84.20⁠DebitNeed
Jan 3Streaming serviceSubscriptions$17.99⁠Credit cardWant
Jan 3Gas stationTransportation$46.10⁠Credit cardNeed
Jan 4Lunch with coworkersEating out$22.50⁠CashWant

Example rows, not real data. The Need or Want column lets you see later how much of the month was flexible. That split is the base of the 50/30/20 budget.

CATEGORIES

Spending categories that work

Too few categories hide the problem; too many make tracking a chore. Start with these and split one only when you need to see it in more detail.

CategoryWhat goes in it
HousingRent or mortgage, property tax, home insurance, repairs
UtilitiesElectricity, gas, water, internet, phone
TransportationCar payment, fuel, insurance, maintenance, transit, rideshare
GroceriesFood and household supplies from stores
Eating outRestaurants, takeout, delivery, coffee
HealthInsurance premiums you pay, doctor visits, prescriptions
SubscriptionsStreaming, apps, memberships, software
Shopping and personal careClothes, haircuts, gifts, household items
Debt paymentsCredit card, student loan and personal loan payments
SavingsEmergency fund, sinking funds, investing

Irregular bills (car registration, annual subscriptions, holidays) are what usually breaks a month. Track them as their own category and see how to keep track of bills.

BENCHMARK

What the average US household spends per month

The Bureau of Labor Statistics surveys what households actually spend. In 2025, average spending per consumer unit (roughly a household) was $81,905 a year. Monthly, by category:

Category (BLS 2025)Per monthShare of spending
Housing (incl. utilities, furnishings)$2,316⁠33.9%
Transportation$1,124⁠16.5%
Food at home$541⁠7.9%
Food away from home$345⁠5.1%
Personal insurance and pensions$848⁠12.4%
Healthcare$539⁠7.9%
Entertainment$340⁠5.0%
Apparel and services$168⁠2.5%
Cash contributions$186⁠2.7%
Everything else$418⁠6.1%
Total$6,825⁠100%

Average spending rose 4.3% from 2024, while consumer prices (CPI-U) rose 2.6%. "Personal insurance and pensions" is mostly Social Security and retirement contributions that come out of a paycheck before you see it, so the calculator below leaves it out and compares your take-home spending with the remaining $5,978 a month.

SPENDING CHECK CALCULATOR

Compare your month with the average

SPENDING CHECK

Where your take-home pay goes

Enter last month's totals from your bank statements or tracker. You'll see what's left, and which category takes a bigger share of your spending than in the average household.

Left over this month——
Total spending——
Biggest gap vs average——

    Average shares are from the BLS Consumer Expenditure Survey 2025, excluding personal insurance and pensions. A higher share isn't wrong by itself: rent in a big city or a long commute changes the mix. Results stay in your browser.

    With the example numbers, spending is $4,650 and $850 is left. Eating out takes 9.7% of spending against 5.8% for the average household, the biggest gap. That's the category to watch first.

    MAKE IT STICK

    How to keep tracking after January

    1. 1

      Same day, same time each week

      Sunday evening, 10 minutes: paste transactions, pick categories, look at totals. Weekly beats daily for most people.

    2. 2

      Track first, judge later

      Record one honest month before cutting anything. The first month is about knowing your numbers.

    3. 3

      Change one category at a time

      Pick the biggest gap from the calculator and set a target for next month. Leave the rest alone.

    4. 4

      Give the leftover a job

      Move what's left to savings the day you get paid: an emergency fund first, then goals.

    5. 5

      Check the year, not just the month

      A yearly view shows irregular costs like insurance and holidays that a single month hides.

    READY-MADE TEMPLATES

    Skip the setup and start tracking today

    A ready tracker already has the categories, monthly totals and charts, so the weekly habit is just entering numbers. Ours work in Excel and Google Sheets; check each product page for current features.

    Income and Expense Tracker Template for Google Sheets & Excel
    EXCEL + GOOGLE SHEETS

    Income and Expense Tracker Template for Google Sheets & Excel

    The listing describes up to 50 custom categories for income, bills, expenses, savings, debt and investments, a monthly budget vs actual overview, an annual summary, custom date ranges and multi-currency conversion.

    • Up to 50 custom categories
    • Monthly budget vs actual
    • Annual financial summary
    View the income and expense tracker

    Want a simpler start? See the monthly budget spreadsheet. Product features and compatibility are listed on each product page and may change.

    FAQ

    Spending tracking questions

    What is the easiest way to track spending?

    Start with your bank app's categories for a quick look, then move to one spreadsheet or app that covers every account. Paste transactions once a week and assign a category to each one.

    How do I track my spending in Google Sheets?

    Make a table with Date, Description, Category, Amount and Account columns, add a category dropdown with data validation, paste bank CSV exports weekly, and total each category by month with SUMIFS or a pivot table.

    How many spending categories should I use?

    8 to 12 is enough for most households: housing, utilities, transportation, groceries, eating out, health, subscriptions, shopping, debt payments and savings. Split a category only when you need more detail.

    How much does the average household spend per month?

    $6,825 a month in 2025, or $81,905 a year, according to the BLS Consumer Expenditure Survey. Housing was 33.9% of it, transportation 16.5% and food 13.0%.

    How long should I track spending before making a budget?

    One full month gives you real numbers to plan with. Three months is better, because it catches irregular bills that don't show up every month.

    Sources and method

    Method: monthly figures are the BLS annual averages divided by 12 and rounded. "Everything else" groups alcohol, tobacco, personal care, reading, education and miscellaneous. Calculator shares exclude personal insurance and pensions ($71,730 a year of other spending). Checked November 18, 2026.

    Back to top