Your bank already has a record of where your money went. A CSV gives you a portable copy of that transaction history that you can work with in a spreadsheet or another tool.
Want the short version?
- Download enough transaction history to reveal patterns.
- Open the CSV in a spreadsheet or import it into a purpose-built tool.
- Identify the date, description and amount fields.
- Organize transactions into useful groups.
- Total, compare and inspect the transactions behind the numbers.
What is a bank CSV?
A CSV is a simple file containing information arranged in rows and columns. Each row usually represents a transaction, with fields such as date, description or merchant, and amount.
How do you download one?
Every bank handles this a little differently. Look for an option labeled Download, Export, Download transactions, or Export activity. It's usually near the account's transaction history.
If you can't find it, search the web or ask an AI assistant how to download transactions as CSV from your specific bank, then follow instructions on the bank's legitimate site or app.
Choose enough history to tell you something
A few transactions won't reveal much. Several months can begin to show recurring expenses and normal patterns; more history can help distinguish a typical month from an unusual one.
Option 1: analyze it manually
Open the file in Excel, Google Sheets, or another spreadsheet. Identify the transaction fields, add useful categories, then sort, filter, total and compare the data.
Categorization is an important step, but deciding the “right” category for every possible transaction is its own problem. For this exercise, the goal is simply to group spending well enough that the resulting totals mean something.
Option 2: use a tool that imports transaction files
A CSV-based finance tool can handle some of the repetitive import, mapping, organization and calculation while leaving you in control of when new transaction history is added.
What should you look for?
Start with category totals, recurring charges, changes over time, the frequency behind large totals, and what's left after money comes in and goes out. Then inspect the actual transactions behind anything that deserves attention.
The annoying part is repeating the work
The first analysis can take time. The bigger question is what happens next time. Do you categorize the same merchants again? A spreadsheet can automate some of this with your own formulas and rules; a purpose-built tool can remember decisions for you.
Where KAPOK fits
KAPOK was built for the CSV approach. It helps map different bank exports, previews rows before import, checks for previously imported transactions, provides built-in categories, and turns categorization decisions into reusable rules.
Want to try this with your own transaction history?
KAPOK is almost ready. Get one email when it launches.
One email when KAPOK launches. No newsletter.