Expense Tracking From Bank Statements: A Simple System

TL;DR: Your bank and card statements already record every expense; you just need them in a spreadsheet. Convert each month's statements, combine them into one table, tag transfers, categorize with a small rules table, and review a one-page summary once a month. Most of the value comes from the monthly review, not from the perfect category list.

Expense tracking apps come and go. Bank statements don't. Every month, your bank and card issuers produce a complete, official record of where your money went. If you can get those records into a spreadsheet quickly, you have an expense tracker that never misses a transaction, never loses its bank connection and never changes its pricing.

We've used variations of this system for households, freelancers and small businesses. It's deliberately simple. The aim is a process you'll still be doing in month twelve.

Why statements beat manual tracking

Manual tracking (typing purchases into an app or notebook as they happen) works for a few weeks and then decays. You forget the coffee, the parking, the subscription renewal that happens automatically. Statements catch everything that touched an account.

Bank-connected apps solve the forgetting, but connections break, history is often limited, and categorization rules live inside someone else's product. Statements are portable: the same PDFs will work with any tool, now or in five years.

The trade-off is timing. Statements arrive monthly, so you're tracking in arrears. For most people, a monthly review is the right cadence anyway.

The system in five steps

1. Collect: download every statement for every account each month.
2. Convert: turn them into rows.
3. Combine: one table for all accounts.
4. Categorize: a rules table does most of the work.
5. Review: a one-page summary, once a month.

Step 1: collect

List every account that spends money: checking, savings, each credit card, store cards, PayPal or other payment apps, and for businesses, payment processors and any account that pays bills. Then, at the start of each month, download last month's statement for each.

Name the files consistently, for example 2026-03 checking.pdf, 2026-03 visa.pdf, and keep them in a folder per year. It sounds trivial. It's what makes month eleven as easy as month one.

Step 2: convert

Upload the PDFs to a converter such as SheetStatement and download each as Excel or CSV. The converter checks that each statement's transactions add up to its closing balance, so you know nothing's missing. If you'd rather use the bank's own activity download for recent months, that works too, but use the statement period dates and drop pending items.

Step 3: combine

Create a workbook with a sheet called Data, formatted as an Excel Table named Txn, with these columns:

Column	Notes
Date	Real dates
Account	Checking, Visa, Amex, etc.
Description	Original text from the statement
Amount	Money out negative, money in positive, for every account
Category	Formula from the rules table
Override	Manual category when needed
Final	Override if present, else Category
Month	=TEXT([@Date],"yyyy-mm")

Each month, paste the new rows at the bottom. If you prefer automation, put the monthly CSVs in one folder and combine them with Power Query; see our Power Query guide.

Sign conventions

Make every account follow "money out negative." Bank accounts usually already do. Credit card exports often show purchases as positive; flip them when pasting (=-x), or add a step in Power Query. Consistent signs mean one formula works for every account.

Step 4: categorize

Choose categories

Pick a short list. For a household, something like:

• Housing (rent or mortgage, maintenance)
• Utilities (power, water, internet, phone)
• Groceries
• Dining out
• Transport (fuel, transit, parking, car payments)
• Insurance
• Health
• Kids
• Subscriptions
• Shopping
• Travel
• Gifts and donations
• Fees and interest
• Income
• Transfer
• Other

For a business, use the categories your accountant uses, or the expense lines on your tax return. Our post on categorizing business expenses from bank statements suggests a starting set.

Build a rules table

On a Rules sheet, a table with Keyword and Category. Then in Txn[Category]:

=LET(hit,ISNUMBER(SEARCH(Rules[Keyword],[@Description])),
 IFERROR(INDEX(Rules[Category],MATCH(TRUE,hit,0)),"Other"))

Order matters: put specific keywords above general ones. Our guide to Excel formulas for categorizing transactions explains this and several more advanced patterns.

Tag transfers first

Credit card payments from checking, transfers to savings, and moving money between your own accounts are not expenses. Add rules for them (for example, "PAYMENT THANK YOU," "TRANSFER TO," "ONLINE PMT") with the category Transfer. Exclude Transfer from every report. This one step prevents most of the "why is my spending so high?" confusion.

Step 5: review monthly

The review is where tracking turns into decisions. On a Summary sheet:

1. A pivot table: Final in rows, Month in columns, Sum of Amount in values, filtered to exclude Transfer and Income.
2. A row for total spending and a row for income.
3. A simple chart: spending by category for the last six months.

Then, once a month, spend fifteen minutes with it:

• What changed? Compare this month with the average of the last three. Big jumps deserve a look.
• What's recurring? Filter Subscriptions and scan the list. Cancel anything you're not using.
• What's "Other"? If Other is large, add rules.
• Anything unexpected? Unfamiliar merchants, duplicate charges, fees you didn't expect.

We think the subscription scan alone justifies the whole system for most households. Recurring charges are easy to forget and easy to cancel once you see them.

Adding a budget, if you want one

Tracking tells you what happened. A budget says what you intended. Once you have three or four months of tracked data, adding a budget is easy, and the history makes it realistic instead of aspirational.

1. On a Budget sheet, list your categories with a monthly target for each. Start from your actual three-month average, then adjust the few categories you genuinely want to change.
2. Next to each, pull this month's actual from the Data table: =-SUMIFS(Txn[Amount],Txn[Final],A2,Txn[Month],$F$1) where F1 holds the month you're reviewing, like 2026-03. The minus sign turns spending into a positive number for comparison.
3. Add a Difference column and conditional formatting: green under budget, amber within 10% over, red beyond that.

Keep the targets few and honest. A budget with forty lines and wishful numbers gets ignored by March. A budget with eight lines you actually care about gets looked at.

Tracking for a household of two (or more)

When partners share expenses, the statement-based system has a real advantage: it doesn't depend on anyone remembering to log things. A few additions help:

• Account owner column: whose account or card each transaction came from.
• Shared/Personal column: if you split shared costs, mark which expenses are shared. A pivot on that column with owner in the rows shows who paid how much of the shared total.
• A settle-up line: shared total ÷ 2 minus what each person paid shows who owes whom for the month.

This turns the awkward "I think I paid more for groceries" conversation into a number you can both look at. It also means each person can keep their own accounts while the household sees the full picture.

The yearly review

Once a year, usually in January, step back from the monthly view:

• Totals by category for the year. Which categories are larger than you would have guessed? Those are usually the most interesting.
• Recurring charges list. Filter for payees that appear in at least ten of twelve months. This is your real list of subscriptions and fixed costs, and it's often longer than people expect.
• Annual charges. Insurance premiums, domain renewals, memberships and other once-a-year payments are easy to forget. List them with their month so next year's version doesn't come as a surprise.
• Rules cleanup. Delete rules for payees that disappeared, merge categories you never really used, and decide whether the list still fits your life.

Then archive the year's workbook and statements, and start a fresh Data table for the new year, keeping the Rules sheet. A year of history is also exactly what you'll want if you apply for a mortgage, a lease or a loan, because you'll already understand your regular income and outgoings.

Business expense tracking

For a small business or freelancer, add a few columns:

• Business/Personal: if one account is used for both (try not to, but it happens).
• Receipt: Y/N, with the receipt's file name or location.
• Client: for billable expenses you'll re-invoice.
• Notes: the business purpose for meals, travel and anything that could look personal.

At the end of the year, the pivot table by category becomes the basis for your conversation with your accountant. To be clear, the spreadsheet categories are your labels; whether and how an expense is deductible depends on your situation and local rules, which is a question for a tax professional. Our guide to bank statements for tax preparation explains what preparers typically want.

If the business already uses accounting software, import the statements there instead of (or as well as) tracking in Excel. See bank statement to QuickBooks and bank statement to Xero.

A worked example

A freelance designer wants to know where her money goes. She has a checking account, a credit card and a PayPal account.

Month 1: she downloads March statements for all three, converts them, and pastes 187 rows into the Data table. She writes 25 rules covering her regular payees. 31 rows land in Other. She sorts them by amount, adds rules for the recurring ones, and overrides the rest. Total time: about an hour, most of it on rules.

Month 2: April adds 172 rows. Her rules catch all but 12. The review takes fifteen minutes. She notices two design software subscriptions that overlap and cancels one.

Month 3: 165 rows, 6 uncategorized. She sees her Dining out category has crept up and decides it's fine, it's client lunches. She adds a Client column so she can re-bill some.

By month six, the monthly routine takes about twenty minutes from download to review. At tax time, she hands her preparer the summary pivot and the PDFs.

Cash and other gaps

Statements only capture what moves through accounts. Cash spending shows up as an ATM withdrawal and nothing else. If you use cash a lot, decide how to handle it: either treat ATM withdrawals as their own category ("Cash") and accept that you won't know what it was spent on, or keep a simple cash log for the bigger cash purchases and enter them by hand. Most people are fine with the first option. The same goes for gift cards and prepaid balances: the load appears on the statement, the individual purchases don't.

Tips that keep the system alive

Do it at the same time every month. The first weekend works for many people.

Don't aim for perfect categories. Consistent and roughly right beats perfect and abandoned.

Keep the original description. You'll want it when a charge needs explaining.

Verify each statement. If a month doesn't balance, fix it before categorizing. Our balance checker helps.

Review rules quarterly. Delete rules for payees you no longer use, and check that broad rules aren't catching the wrong things.

Back up the workbook. It becomes valuable over time.

Spreadsheet or app?

	Statements + spreadsheet	Bank-connected app
Completeness	Every transaction	Depends on connection
History	As far back as your statements	Often limited at connection
Control over categories	Full	Partial
Effort	Monthly routine	Lower, until connections break
Portability	Total	Varies
Real-time	No (monthly)	Yes

Many people use both: an app for day-to-day awareness, statements and a spreadsheet for the monthly or yearly view they trust.

Privacy

Your spending history is personal. Keep the workbook somewhere private, not in a shared folder with open links. When converting, use a service that encrypts uploads and deletes them after processing; our security page explains our approach.

Our take

The best expense tracker is the one built on data you already have. Bank statements are complete and official; a spreadsheet makes them useful. Spend an hour setting up the categories and rules, then twenty minutes a month keeping it going. The insight comes from the monthly review, so protect that time.

Troubleshooting your tracker

The totals don't match what you feel you spent. Usually transfers or card payments are being counted as spending. If you track both a checking account and a credit card, the payment to the card is a transfer; the purchases on the card are the spending. Counting both doubles those expenses.

One category swallows everything. If "Shopping" or "Amazon" is a third of your spending, split it. Marketplace purchases cover groceries, household goods and gifts. Keep receipts or order histories for the big ones and recategorize them, or add a subcategory column.

Annual bills distort the month. Insurance, subscriptions and registrations paid once a year make one month look terrible. Add a column for "Monthly equivalent" (the annual amount divided by 12) and use it for budgeting, while keeping the actual payment date for the real cash picture.

Rules mis-tag a merchant. A keyword like "SHELL" matches both fuel and a restaurant with "Shell" in its name. Make keywords more specific, and put specific rules above general ones in your lookup table.

Cash disappears. ATM withdrawals hide what the cash was spent on. Either track cash spending separately in a small note on your phone, or treat cash as its own category and set a monthly limit for it.

A second worked example: a couple's shared expenses

Two partners split household costs 60/40. Each has a personal account and they share a joint account. Every month, they convert all three statements, tag shared expenses with a "Shared" column, and use a PivotTable to see who paid what. A simple formula works out the settle-up: =SharedTotal*0.6 - PartnerAPaid. If it's positive, partner A owes the difference. Ten minutes a month replaced a recurring argument.

A mini monthly checklist

1. Statements for every account downloaded and converted.
2. Totals verified against each statement.
3. Transfers and card payments tagged.
4. Uncategorized rows reviewed.
5. Annual bills spread across months for budgeting.
6. Month compared with the same month last year.

FAQ

Can I track expenses using only bank statements?

Yes. Bank and card statements record every transaction that touches your accounts. Converting them to a spreadsheet and categorizing them gives you a complete expense record.

How do I avoid counting credit card payments as expenses?

Tag card payments and transfers between your own accounts with a Transfer category and exclude it from spending reports. The individual card purchases are the real expenses.

How should I categorize expenses?

Use a short, consistent list. For households, around fifteen categories is plenty. For businesses, follow your accountant's categories or your tax return's expense lines.

How often should I review expenses?

Monthly works well for most people. A fifteen-minute review of changes, subscriptions and uncategorized items is enough to keep spending in view.

Is a spreadsheet better than an expense app?

They suit different needs. Apps are real-time but depend on bank connections. Statements and a spreadsheet are complete, portable and fully under your control. Many people use both.

Can I use Google Sheets instead of Excel?

Yes. The same structure works. Use regular ranges instead of Excel tables, and ARRAYFORMULA where needed for the category lookup.