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.

Download Excel template (.xlsx) 155 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 2 Nov 2026

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.

Preview: the Example Transactions and Example Summary tabs (fictional data, 1 Jan to 28 Oct 2026). The Summary shows the latest month, October 2026, by default.
$3,410.48spent in Oct 2026, 87.2% of the $3,910 budget
$121.80average daily spend (32 expenses over 28 days)
88.1% · 11.9%need · want share in October
2 of 17categories over budget (Transportation and Entertainment)
DatePayeeCategorySubcategoryPayment methodAmountNeed/Want used
15 Oct 2026SupermarketGroceriesParty snacksDebit card$38.43Want
15 Oct 2026Gas stationTransportationFuelDebit card$45.25Need
18 Oct 2026Pet storePetsPet foodDebit card$47.99Need
19 Oct 2026DinerDining outRestaurantCredit card$50.34Want
20 Oct 2026Food bankGifts & donationsCharityBank transfer$20.00Want
20 Oct 2026SupermarketGroceriesWeekly shopDebit card$121.83Need
22 Oct 2026Mobile carrierUtilitiesPhoneAutopay$48.00Need
23 Oct 2026CinemaEntertainmentMoviesCredit card$28.00Want
24 Oct 2026Farmers marketGroceriesProduceCash$33.07Need
26 Oct 2026SupermarketGroceriesWeekly shopDebit card$137.33Need
27 Oct 2026Gift shopGifts & donationsBirthday giftCredit card$38.51Want
28 Oct 2026CafeDining outCoffeeMobile wallet$6.75Want
Example Summary, October 2026: budget (light bar) and actual spending (dark bar) by category. Housing budget $1,450.00, actual $1,450.00; Utilities budget $230.00, actual $184.46; Groceries budget $620.00, actual $556.75; Dining out budget $220.00, actual $119.14; Transportation budget $260.00, actual $380.47; Insurance budget $110.00, actual $90.00; Health budget $60.00, actual $17.62; Debt payments budget $315.00, actual $315.00; Personal care budget $50.00, actual $45.11; Clothing budget $80.00, actual $0.00; Entertainment budget $90.00, actual $129.94; Subscriptions budget $30.00, actual $15.49; Pets budget $70.00, actual $47.99; Education budget $40.00, actual $0.00; Gifts & donations budget $75.00, actual $58.51; Travel budget $150.00, actual $0.00; Other budget $60.00, actual $0.00.BudgetActualActual, over budgetHousing$1,450 / $1,450Utilities$184 / $230Groceries$557 / $620Dining out$119 / $220Transportation$380 / $260Insurance$90 / $110Health$18 / $60Debt payments$315 / $315Personal care$45 / $50Clothing$0 / $80Entertainment$130 / $90Subscriptions$15 / $30Pets$48 / $70Education$0 / $40Gifts & donations$59 / $75Travel$0 / $150Other$0 / $60

Chart: budget vs actual for October 2026, built from the same file. The workbook draws the same comparison as a native Excel chart, plus a month-by-month spending chart.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, how the maths works, colour key, limits, disclaimer
TransactionsUp to 500 expenses: date, payee, category (dropdown), subcategory, payment method (dropdown), amount, need/want (optional dropdown), notesMonth 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
CategoriesUp to 20 categories with a monthly budget and a default Need or Want; up to 10 payment methodsTotal monthly and annual budget; feeds every dropdown and every Summary table
SummaryOptional: 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 SummaryAlready filled295 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

  1. 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.
  2. 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.
  3. 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.
  4. Leave Need/Want blank to use the category default, or override it for one row, for example party snacks bought at the supermarket.
  5. Check column K: it says OK when a row is complete. B4 counts rows that need a fix; those rows are left out of every total until you fix them.
  6. Open Summary. It shows the latest month in your data. Type a month (1–12), a year or a through date in B3:B5 to 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:

CategoryDefaultSubcategory ideasBLS group (reference)
HousingNeedRent or mortgage, repairs, HOA feesHousing
UtilitiesNeedElectricity, gas, water, internet, phoneHousing (utilities)
GroceriesNeedSupermarket, farmers marketFood (food at home)
Dining outWantRestaurants, takeout, coffeeFood (food away from home)
TransportationNeedFuel, transit, parking, car repairsTransportation
InsuranceNeedCar, renters, life insurancePersonal insurance / other groups
HealthNeedPharmacy, copays, dentalHealthcare
Debt paymentsNeedCar loan, student loan, card paymentsNot a CE spending group
Personal careWantHaircuts, toiletriesPersonal care products and services
ClothingWantClothes, shoes, alterationsApparel and services
EntertainmentWantEvents, hobbies, games, gymEntertainment
SubscriptionsWantStreaming, apps, cloud storageEntertainment / miscellaneous
PetsNeedFood, vet, suppliesEntertainment (pets)
EducationNeedBooks, courses, school feesEducation
Gifts & donationsWantGifts, charityCash contributions
TravelWantFlights, hotels, tripsTransportation and housing (lodging)
OtherWantAnything elseMiscellaneous

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.

FieldFormula
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

CategoryBudgetActualVariance% usedStatusYTD actualYTD variance
Housing$1,450.00$1,450.00$0.00100.0%90%+ used$14,500.00$0.00
Utilities$230.00$184.46$45.5480.2%OK$2,102.34$197.66
Groceries$620.00$556.75$63.2589.8%OK$5,579.40$620.60
Dining out$220.00$119.14$100.8654.2%OK$1,666.56$533.44
Transportation$260.00$380.47-$120.47146.3%Over budget$1,941.63$658.37
Insurance$110.00$90.00$20.0081.8%OK$1,068.00$32.00
Health$60.00$17.62$42.3829.4%OK$267.89$332.11
Debt payments$315.00$315.00$0.00100.0%90%+ used$3,150.00$0.00
Personal care$50.00$45.11$4.8990.2%90%+ used$340.62$159.38
Clothing$80.00$0.00$80.000.0%OK$380.23$419.77
Entertainment$90.00$129.94-$39.94144.4%Over budget$978.53-$78.53
Subscriptions$30.00$15.49$14.5151.6%OK$154.90$145.10
Pets$70.00$47.99$22.0168.6%OK$655.11$44.89
Education$40.00$0.00$40.000.0%OK$176.70$223.30
Gifts & donations$75.00$58.51$16.4978.0%OK$372.37$377.63
Travel$150.00$0.00$150.000.0%OK$869.15$630.85
Other$60.00$0.00$60.000.0%OK$76.75$523.25
Total$3,910.00$3,410.48$499.5287.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

RankCategoryJan-Oct spentShare
1Housing$14,500.0042.3%
2Groceries$5,579.4016.3%
3Debt payments$3,150.009.2%
4Utilities$2,102.346.1%
5Transportation$1,941.635.7%
Payment methodOctShareJan-OctShareRows
Debit card$937.7627.5%$7,717.6022.5%97
Credit card$358.7310.5%$4,637.9613.5%85
Cash$78.182.3%$537.291.6%17
Bank transfer$1,470.0043.1%$14,868.0043.4%21
Autopay$499.4614.6%$5,252.3415.3%40
Mobile wallet$66.351.9%$1,266.993.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

2026JanFebMarAprMayJunJulAugSepOct
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
Transactions26313026283129313132

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

Limits

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

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.