Track your spending from bank statements

Why start from statements

Budgeting apps want your bank login and usually import only recent history. Statements already cover the past: last year's spending, an account you've since closed, a card from a bank no app supports, or a joint account you don't want to link.

Working from files also keeps you in control. You choose which statements to upload, nothing connects to your bank, and you end up with a spreadsheet you own rather than data inside an app.

See your spending by category in five steps

1. Download statements for every account you spend from — checking, savings and credit cards — for three to twelve months. PDFs are fine; CSV works too if your bank offers it.
2. Upload them all at once. Every transaction gets a clean payee name (Netflix rather than NETFLIX.COM 866-579-7172 CA) and a category.
3. Check the balance result. Opening balance + money in − money out must equal the closing balance, so you know no transaction was skipped.
4. Fix any category that's wrong. Save the fix as a rule and the same payee is categorized the same way in every future statement.
5. Export to Excel or CSV and open the Summary sheet: totals by category and by month.

Don't count the same money twice

Most spending summaries go wrong in the same places. Put these in a Transfers category and leave them out of your spending totals:

• Credit card payments from your checking account — the card purchases themselves are the spending
• Moving money to savings or between your own accounts
• Topping up PayPal, Venmo or another wallet, if you also upload that wallet's statement
• Refunds, which belong in the category of the original purchase, not in income

Build a budget in Excel or Google Sheets

The Excel file has real dates and numbers, so formulas work immediately. A simple budget is the average of your last three to six months per category: with categories in column D and amounts in column E, =SUMIFS(E:E, D:D, "Groceries")/6 gives an average month of groceries for a six-month export.

For Google Sheets, export CSV and pick the date format you use (for example MM/DD/YYYY) so dates import as dates. See bank statements to CSV and bank statements to Excel for what each file contains.

What to look for

• Subscriptions. Sort by payee: clean names make repeat charges easy to spot, including ones you forgot about
• Fees. Overdraft, ATM and foreign transaction fees often hide in long statements
• Drift. Compare the same category month by month — dining out and shopping tend to creep
• Once-a-year costs. Insurance, renewals and gifts don't show up in a single month but belong in the budget
• Card spending. Card statements usually hold most of the day-to-day spending; see credit card statements to Excel

Privacy and cost

Uploaded files are processed in memory and never stored. The transactions stay in your account until you delete them or auto-delete removes them, and they're never used to train AI. See security.

Your first statement is free (up to 10 pages, one month); after that you pay, but every upload shows a preview first — transaction count, balance check result and the first three rows. A one-time pack of 100 pages costs $12 and never expires — enough for a year of one account whose statements run up to eight pages a month. See pricing.

Questions