Home › Templates › Expense tracker spreadsheet
Expense Tracker Spreadsheet
A free expense tracker spreadsheet for Excel and Google Sheets: log every expense with its category, payment method and need/want tag, set a monthly budget per category, and the Summary tab shows spending by month and category, budget vs actual with variance and % used, your top categories, need vs want share, spending by payment method and average daily spend.
Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no bank connection: you type or paste your expenses yourself.
| Date | Payee | Category | Subcategory | Payment method | Amount | Need/Want used |
|---|---|---|---|---|---|---|
| 15 Oct 2026 | Supermarket | Groceries | Party snacks | Debit card | $38.43 | Want |
| 15 Oct 2026 | Gas station | Transportation | Fuel | Debit card | $45.25 | Need |
| 18 Oct 2026 | Pet store | Pets | Pet food | Debit card | $47.99 | Need |
| 19 Oct 2026 | Diner | Dining out | Restaurant | Credit card | $50.34 | Want |
| 20 Oct 2026 | Food bank | Gifts & donations | Charity | Bank transfer | $20.00 | Want |
| 20 Oct 2026 | Supermarket | Groceries | Weekly shop | Debit card | $121.83 | Need |
| 22 Oct 2026 | Mobile carrier | Utilities | Phone | Autopay | $48.00 | Need |
| 23 Oct 2026 | Cinema | Entertainment | Movies | Credit card | $28.00 | Want |
| 24 Oct 2026 | Farmers market | Groceries | Produce | Cash | $33.07 | Need |
| 26 Oct 2026 | Supermarket | Groceries | Weekly shop | Debit card | $137.33 | Need |
| 27 Oct 2026 | Gift shop | Gifts & donations | Birthday gift | Credit card | $38.51 | Want |
| 28 Oct 2026 | Cafe | Dining out | Coffee | Mobile wallet | $6.75 | Want |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, how the maths works, colour key, limits, disclaimer |
| Transactions | Up to 500 expenses: date, payee, category (dropdown), subcategory, payment method (dropdown), amount, need/want (optional dropdown), notes | Month key, the need/want label used, a check on every row (rows that are not OK are left out and counted in B4), total of counted rows |
| Categories | Up to 20 categories with a monthly budget and a default Need or Want; up to 10 payment methods | Total monthly and annual budget; feeds every dropdown and every Summary table |
| Summary | Optional: year, month and through date (blank = the latest month in your data) | Spent, budget, % used, days counted and average daily spend for the month and year to date; budget vs actual by category with variance and status; need vs want; spending by payment method; top 5 categories; a 12-month × category table with averages; two native charts |
| Example Transactions, Example Categories, Example Summary | Already filled | 295 fictional expenses across ten months, with budgets, so you can see every formula working |
An expense tracker answers "where did the money go". To plan the month before it starts, use the budget spreadsheet; to see which fixed bills are due and paid, use the bill tracker spreadsheet; to save ahead for irregular costs that show up here, use the sinking funds tracker.
How to use it
- Guess first. The CFPB's spending tracker starts with one question: "How much do you think you spent last month?" Write the number down; it makes the first real total more useful.
- Open Categories. Keep, rename or add categories (up to 20), mark each Need or Want, and type a monthly budget. Edit the payment methods in column G.
- Open Transactions. Add one row per expense: date, payee, category, payment method and amount (yellow cells). Use the subcategory for detail such as "Takeout" or "Fuel". Type a refund as a negative amount.
- Leave Need/Want blank to use the category default, or override it for one row, for example party snacks bought at the supermarket.
- Check column K: it says OK when a row is complete.
B4counts rows that need a fix; those rows are left out of every total until you fix them. - Open Summary. It shows the latest month in your data. Type a month (1–12), a year or a through date in
B3:B5to look at another period.
The CFPB tool lists what you need: "All your receipts and bill statements from the month" and "Any online records of your spending". Exporting your bank and card statements to CSV and pasting the date, payee and amount columns into Transactions is the fastest way to fill a month; then pick the categories.
Choosing categories: what the government data uses
The US Bureau of Labor Statistics measures household spending in the Consumer Expenditure Survey. Its 2025 results (released 29 October 2026) say: "Average annual expenditures for all consumer units in 2025 were $81,905, a 4.3-percent increase from 2024". Housing is the biggest group: "On average, consumer units spent $27,790 on housing in 2025, which was 33.9 percent of total average annual expenditures." The release lists the next largest shares as transportation (16.5 percent), food (13.0 percent), and personal insurance and pensions (12.4 percent).
Those are averages across all US households, not a target for yours. They are useful for one thing here: a category list that follows the big groups puts most of your spending into a few rows, where a change makes a real difference. The starter categories map to the BLS groups like this:
| Category | Default | Subcategory ideas | BLS group (reference) |
|---|---|---|---|
| Housing | Need | Rent or mortgage, repairs, HOA fees | Housing |
| Utilities | Need | Electricity, gas, water, internet, phone | Housing (utilities) |
| Groceries | Need | Supermarket, farmers market | Food (food at home) |
| Dining out | Want | Restaurants, takeout, coffee | Food (food away from home) |
| Transportation | Need | Fuel, transit, parking, car repairs | Transportation |
| Insurance | Need | Car, renters, life insurance | Personal insurance / other groups |
| Health | Need | Pharmacy, copays, dental | Healthcare |
| Debt payments | Need | Car loan, student loan, card payments | Not a CE spending group |
| Personal care | Want | Haircuts, toiletries | Personal care products and services |
| Clothing | Want | Clothes, shoes, alterations | Apparel and services |
| Entertainment | Want | Events, hobbies, games, gym | Entertainment |
| Subscriptions | Want | Streaming, apps, cloud storage | Entertainment / miscellaneous |
| Pets | Need | Food, vet, supplies | Entertainment (pets) |
| Education | Need | Books, courses, school fees | Education |
| Gifts & donations | Want | Gifts, charity | Cash contributions |
| Travel | Want | Flights, hotels, trips | Transportation and housing (lodging) |
| Other | Want | Anything else | Miscellaneous |
Groceries and dining out are split because the BLS also splits food into food at home and food away from home, and because they behave differently in a budget. Debt payments are not a BLS spending group, but they leave your account every month, so they get their own row.
Need or want? The CFPB's definition: "Needs are things you can’t live without, like shelter, utilities, food, clothing, and transportation. Needs may also include obligations: things you have to pay, like debt, child support, alimony, and student loans. Wants, however, are things you can choose to live without." The defaults follow that; change them on the Categories tab if your situation differs.
The formulas, explained
Exact formulas from the file (row 8 on Transactions, row 28 for the first category on Summary). On Transactions, A is the date, C the category, E the payment method, F the amount, G the optional need/want and K the row check. On Summary, $B$7 is the through date, $B$8 the year and $B$9 the first day of the month shown.
| Field | Formula |
|---|---|
| Transactions: row check (K8) | =IF(COUNTA(A8:H8)=0,"",IF(NOT(ISNUMBER(A8)),"Add a date",IF(OR(NOT(ISNUMBER(F8)),N(F8)=0),"Add amount",IF(C8="","Pick category",IF(COUNTIF(Categories!$A$5:$A$24,C8)=0,"Category not on list",IF(AND(E8<>"",COUNTIF(Categories!$G$5:$G$14,E8)=0),"Payment method not on list",IF(AND(G8<>"",G8<>"Need",G8<>"Want"),"Pick Need or Want","OK"))))))) |
| Transactions: month key (I8) | =IF(K8<>"OK","",DATE(YEAR(A8),MONTH(A8),1)) |
| Transactions: need/want used (J8) | =IF(K8<>"OK","",IF(G8<>"",G8,IF(INDEX(Categories!$C$5:$C$24,MATCH(C8,Categories!$A$5:$A$24,0))="","Not set",INDEX(Categories!$C$5:$C$24,MATCH(C8,Categories!$A$5:$A$24,0))))) |
| Summary: through date used (B7) | =IF(B5<>"",B5,IF(COUNT(Transactions!$A$8:$A$507)=0,TODAY(),MAX(Transactions!$A$8:$A$507))) |
| Summary: month shown (B9) | =DATE(B8,IF(B4<>"",B4,IF(YEAR(B7)=B8,MONTH(B7),12)),1) |
| Summary: spent in month (B13) | =SUMIFS(Transactions!$F$8:$F$507,Transactions!$K$8:$K$507,"OK",Transactions!$I$8:$I$507,$B$9) |
| Summary: days counted (B18) | =IF(AND(B7>=B9,B7<EOMONTH(B9,0)),DAY(B7),DAY(EOMONTH(B9,0))) |
| Summary: average daily spend (B19) | =B13/B18 |
| Summary: need share (B20) | =IF(N(B13)=0,"",SUMIFS(Transactions!$F$8:$F$507,Transactions!$K$8:$K$507,"OK",Transactions!$I$8:$I$507,$B$9,Transactions!$J$8:$J$507,"Need")/B13) |
| Summary: year-to-date spent (E13) | =SUMIFS(Transactions!$F$8:$F$507,Transactions!$K$8:$K$507,"OK",Transactions!$I$8:$I$507,">="&DATE($B$8,1,1),Transactions!$I$8:$I$507,"<="&$B$9) |
| Summary: category actual (C28) | =IF(A28="","",SUMIFS(Transactions!$F$8:$F$507,Transactions!$K$8:$K$507,"OK",Transactions!$I$8:$I$507,$B$9,Transactions!$C$8:$C$507,A28)) |
| Summary: variance (D28) | =IF(A28="","",B28-C28) |
| Summary: % used (E28) | =IF(OR(A28="",N(B28)=0),"",C28/B28) |
| Summary: status (F28) | =IF(A28="","",IF(N(B28)=0,IF(C28>0,"No budget",""),IF(C28>B28,"Over budget",IF(C28>=0.9*B28,"90%+ used","OK")))) |
| Summary: top category #1 (B74) | =IF(OR(COUNT($J$28:$J$47)<A74,LARGE($J$28:$J$47,A74)<=0),"",INDEX($A$28:$A$47,MATCH(LARGE($J$28:$J$47,A74),$J$28:$J$47,0))) |
| Summary: 12-month grid, January (B84) | =IF($A84="","",SUMIFS(Transactions!$F$8:$F$507,Transactions!$K$8:$K$507,"OK",Transactions!$C$8:$C$507,$A84,Transactions!$I$8:$I$507,B$83)) |
Month key. Each counted row gets the first day of its month in column I. Every Summary total is then a SUMIFS on that key, the category and the row check, so a row with a typo is never half-counted.
Variance and % used. Variance = budget − actual, so a negative number means over budget. % used = actual ÷ budget. Status says Over budget above 100% and 90%+ used from 90% up to 100%. Year to date compares spending from January to the month shown with the monthly budget × the month number (October = 10).
Average daily spend divides the month's spending by the days counted: the whole month for a finished month, or day 1 to the through date when the month is still running. That keeps a half-finished month from looking cheap.
Top 5 avoids SORT and FILTER: each category gets a key of year-to-date spent − row ÷ 1,000,000, LARGE picks the 1st to 5th largest key, and INDEX/MATCH fetches the name. Ties keep the order of the Categories tab.
Worked example from the sample data
The Example tabs hold 295 made-up expenses from 1 Jan to 28 Oct 2026 and 17 categories with a total monthly budget of $3,910.00. The Summary opens on October 2026 because 28 Oct is the latest date.
October: budget vs actual
| Category | Budget | Actual | Variance | % used | Status | YTD actual | YTD variance |
|---|---|---|---|---|---|---|---|
| Housing | $1,450.00 | $1,450.00 | $0.00 | 100.0% | 90%+ used | $14,500.00 | $0.00 |
| Utilities | $230.00 | $184.46 | $45.54 | 80.2% | OK | $2,102.34 | $197.66 |
| Groceries | $620.00 | $556.75 | $63.25 | 89.8% | OK | $5,579.40 | $620.60 |
| Dining out | $220.00 | $119.14 | $100.86 | 54.2% | OK | $1,666.56 | $533.44 |
| Transportation | $260.00 | $380.47 | -$120.47 | 146.3% | Over budget | $1,941.63 | $658.37 |
| Insurance | $110.00 | $90.00 | $20.00 | 81.8% | OK | $1,068.00 | $32.00 |
| Health | $60.00 | $17.62 | $42.38 | 29.4% | OK | $267.89 | $332.11 |
| Debt payments | $315.00 | $315.00 | $0.00 | 100.0% | 90%+ used | $3,150.00 | $0.00 |
| Personal care | $50.00 | $45.11 | $4.89 | 90.2% | 90%+ used | $340.62 | $159.38 |
| Clothing | $80.00 | $0.00 | $80.00 | 0.0% | OK | $380.23 | $419.77 |
| Entertainment | $90.00 | $129.94 | -$39.94 | 144.4% | Over budget | $978.53 | -$78.53 |
| Subscriptions | $30.00 | $15.49 | $14.51 | 51.6% | OK | $154.90 | $145.10 |
| Pets | $70.00 | $47.99 | $22.01 | 68.6% | OK | $655.11 | $44.89 |
| Education | $40.00 | $0.00 | $40.00 | 0.0% | OK | $176.70 | $223.30 |
| Gifts & donations | $75.00 | $58.51 | $16.49 | 78.0% | OK | $372.37 | $377.63 |
| Travel | $150.00 | $0.00 | $150.00 | 0.0% | OK | $869.15 | $630.85 |
| Other | $60.00 | $0.00 | $60.00 | 0.0% | OK | $76.75 | $523.25 |
| Total | $3,910.00 | $3,410.48 | $499.52 | 87.2% | $34,280.18 | $4,819.82 |
October spending is $3,410.48, 87.2% of the budget, with $499.52 left. Two categories are over budget. Transportation is $380.47 against $260.00 (146.3% used) because of a $212.30 car repair on 14 Oct. Entertainment is $129.94 against $90.00. Housing and debt payments show 90%+ used at exactly 100%: fixed costs that match their budget.
Average daily spend and need vs want
The through date is 28 Oct, so October counts 28 days: $3,410.48 ÷ 28 = $121.80 a day. From 1 Jan it is $34,280.18 over 301 days, or $113.89 a day and $3,428.02 a month on average.
Need spending is $3,003.86 (88.1%) and want spending $406.62 (11.9%) in October; year to date the split is 85.3% / 14.7%. The supermarket rows marked Want (party snacks) count as wants even though Groceries defaults to Need.
Top categories and payment methods, January to October
| Rank | Category | Jan-Oct spent | Share |
|---|---|---|---|
| 1 | Housing | $14,500.00 | 42.3% |
| 2 | Groceries | $5,579.40 | 16.3% |
| 3 | Debt payments | $3,150.00 | 9.2% |
| 4 | Utilities | $2,102.34 | 6.1% |
| 5 | Transportation | $1,941.63 | 5.7% |
| Payment method | Oct | Share | Jan-Oct | Share | Rows |
|---|---|---|---|---|---|
| Debit card | $937.76 | 27.5% | $7,717.60 | 22.5% | 97 |
| Credit card | $358.73 | 10.5% | $4,637.96 | 13.5% | 85 |
| Cash | $78.18 | 2.3% | $537.29 | 1.6% | 17 |
| Bank transfer | $1,470.00 | 43.1% | $14,868.00 | 43.4% | 21 |
| Autopay | $499.46 | 14.6% | $5,252.34 | 15.3% | 40 |
| Mobile wallet | $66.35 | 1.9% | $1,266.99 | 3.7% | 35 |
Bank transfers carry the largest share because rent goes that way; card and mobile-wallet rows are smaller but far more frequent.
The 12-month view
| 2026 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct |
|---|---|---|---|---|---|---|---|---|---|---|
| Spent | $3,163 | $3,328 | $3,545 | $3,199 | $3,370 | $3,305 | $4,056 | $3,477 | $3,426 | $3,410 |
| Variance vs $3,910 budget | $747 | $582 | $365 | $711 | $540 | $605 | -$146 | $433 | $484 | $500 |
| Transactions | 26 | 31 | 30 | 26 | 28 | 31 | 29 | 31 | 31 | 32 |
July is the only month over the total budget ($4,055.63), because of a summer trip in the Travel category. The -$45.00 refund on 26 Sep 2026 lowers September's Clothing total instead of being lost.
Common mistakes
- Counting the same money twice. If you log card purchases, do not also log the monthly card payment. The same goes for transfers to savings or between your own accounts.
- Too many categories. Twenty categories with three rows each are hard to act on. Use subcategories for detail and keep the categories broad.
- Typing a new category name in Transactions. It shows Category not on list and is left out. Add the name on the Categories tab first.
- Judging a month before it ends. Compare average daily spend, not the total, until the month is over.
- Dropping refunds. Type them as negative amounts in the original category, so the category total stays right.
- Forgetting cash. Cash spending leaves no statement line. Log it the same day, or keep receipts in an envelope as the CFPB tool suggests.
Limits
- One currency. No bank connection: you type or paste expenses yourself.
- Budgets are the same every month. For a month with a known extra cost, read the variance, or adjust the budget for that month and change it back.
- Subcategories are free text, not a second dropdown.
- Up to 500 transactions per file (start a new copy each year, or insert rows inside the table and check that the ranges grow).
- Recalculation was tested in LibreOffice; the file uses only functions that also exist in Excel 2016+ and Google Sheets.
FAQ
How do I make an expense tracker spreadsheet?
Make one row per expense with the date, payee, category, payment method and amount, keep the category names in a separate list so they can be picked from a dropdown, and total each category by month with SUMIFS. This template already has those columns, the dropdowns, monthly budgets and a Summary tab, so you only type the expenses.
What categories should I use to track expenses?
Start with the big groups and split only where a decision depends on it. The BLS Consumer Expenditure Survey groups household spending into areas such as food, housing, transportation, healthcare, entertainment and personal insurance and pensions; housing alone was 33.9 percent of average annual expenditures in 2025. The template starts with 17 categories, each with a subcategory column for detail, and you can rename or add up to 20.
What is the difference between a need and a want?
The CFPB's spending tracker puts it this way: "Needs are things you can’t live without, like shelter, utilities, food, clothing, and transportation." It adds that needs may include obligations such as debt and student loans, while "Wants, however, are things you can choose to live without." Each category has a default, and you can override it on any row.
How often should I update an expense tracker?
Small and often works best: a few minutes once or twice a week, with receipts and your bank and card statements at hand. The CFPB tool suggests you "Track your spending for a month" first, then "Analyze your spending by category". The Summary works with a partial month: it counts days up to the latest date you entered.
Should I record credit card payments as expenses?
No, if you already log the purchases made on the card. Record each purchase with Credit card as the payment method, and leave out the monthly card payment and transfers between your own accounts, or the same spending is counted twice. Interest and fees are real costs, so log those as their own rows.
Can I use this expense tracker in Google Sheets?
Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The formulas use IF, AND, OR, NOT, N, ISNUMBER, COUNTA, COUNT, COUNTIF, COUNTIFS, SUMIFS, SUMPRODUCT, LEN, SUM, MAX, MIN, LARGE, INDEX, MATCH, ROW, DATE, YEAR, MONTH, DAY, EOMONTH and TODAY, which work in Excel 2016+, Google Sheets and LibreOffice. No macros, no dynamic arrays.
Related tools and templates
- Budget spreadsheetPlan income and spending ahead
- Bill tracker spreadsheetDue dates and a paid checklist
- Sinking funds trackerSave ahead for irregular costs
- Emergency fund trackerMonths of expenses covered
- Debt payoff spreadsheetSnowball or avalanche plan
- All templatesFree spreadsheets
Educational template only, not financial advice. Example data is fictional: the payees, amounts, dates and budgets are made up to show the formulas and are not a recommendation. BLS figures are national averages for 2025 from the Consumer Expenditure Survey release of 29 October 2026; BLS and CFPB material was retrieved on 2 November 2026.