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.
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.
METHODS
5 ways to track your spending
| Method | How it works | Good for | Watch out for |
|---|---|---|---|
| Bank or card app | Uses the categories your bank assigns automatically | A quick first look with zero setup | Wrong categories, and cash or other cards are missing |
| Spreadsheet | You enter or paste transactions and sort them into your own categories | Full control, every account in one place, no subscription | Needs a weekly 10-minute habit |
| Budgeting app | Links accounts and imports transactions | People who won't enter anything by hand | Monthly fees, broken bank connections, privacy |
| Cash envelopes | Withdraw cash for each category; when an envelope is empty, you stop | Groceries, eating out and other easy-to-overspend categories | Doesn't work for bills and online shopping |
| Notebook and receipts | Write each purchase down the day you make it | Building awareness in the first 30 days | Hard 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
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
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
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
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
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.| Date | Description | Category | Amount | Account | Need / Want |
|---|---|---|---|---|---|
| Jan 2 | Kroger | Groceries | $84.20 | Debit | Need |
| Jan 3 | Streaming service | Subscriptions | $17.99 | Credit card | Want |
| Jan 3 | Gas station | Transportation | $46.10 | Credit card | Need |
| Jan 4 | Lunch with coworkers | Eating out | $22.50 | Cash | Want |
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.
| Category | What goes in it |
|---|---|
| Housing | Rent or mortgage, property tax, home insurance, repairs |
| Utilities | Electricity, gas, water, internet, phone |
| Transportation | Car payment, fuel, insurance, maintenance, transit, rideshare |
| Groceries | Food and household supplies from stores |
| Eating out | Restaurants, takeout, delivery, coffee |
| Health | Insurance premiums you pay, doctor visits, prescriptions |
| Subscriptions | Streaming, apps, memberships, software |
| Shopping and personal care | Clothes, haircuts, gifts, household items |
| Debt payments | Credit card, student loan and personal loan payments |
| Savings | Emergency 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 month | Share 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.
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
Same day, same time each week
Sunday evening, 10 minutes: paste transactions, pick categories, look at totals. Weekly beats daily for most people.
- 2
Track first, judge later
Record one honest month before cutting anything. The first month is about knowing your numbers.
- 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
Give the leftover a job
Move what's left to savings the day you get paid: an emergency fund first, then goals.
- 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
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
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.