A CSV file is the simplest way to get your own transaction history out of your bank: plain rows of text, one line per transaction, readable by any spreadsheet or budgeting tool. The catch is that every bank hides the option in a slightly different place and names it slightly differently. The steps below work for most banks, whether you use a website or an app, and the checks at the end save you from the problems that only show up after the file is already in your budget.
Why CSV is usually the best format to ask for
CSV is data first and pretty second. Each line is a transaction, with columns for the date, the amount and the description, so a budgeting tool or a spreadsheet can read it without guessing. A PDF statement looks nicer, but it was made to be printed, and pulling clean rows out of it is much harder.
If your bank offers more than one choice, CSV is a safe first pick. Some banks also offer standardized formats such as OFX, which work well too. If CSV is not offered at all, look for a spreadsheet option (XLS or XLSX), which holds the same kind of table.
Exporting a CSV in six steps
Menu names differ from bank to bank, but the path is almost always the same:
- Log in on a computer if you can. Many banks offer fuller export options on the website than in the mobile app, and a file saved on a computer is easier to find and check.
- Open the account you want. Go to the transaction list for one account or card, not the overview page. Each account, savings account and credit card usually has to be exported separately.
- Look for the export or download option. It is often a small button or link near the transaction list, labeled something like export, download, statement or transactions file. If you cannot find it, look under a menu called documents, statements or reports.
- Set the date range before you export. Choose whole months, from the first day to the last, and go back as far as the bank allows, since many banks limit how much history one file can hold. For a long history, export in several chunks.
- Choose CSV as the format. If you see choices such as CSV, PDF, XLS or OFX, pick CSV. If there is an option to include all columns or all details, turn it on, because extra columns can always be ignored later but missing ones cannot be recovered.
- Save the file somewhere you will find it and keep the original. Give it a name that includes the account and the dates, for example the bank, the account and the month, and do not overwrite it if you later tidy a copy.
Six checks before you use the file
Open the file once and look at it before importing. These are the problems that cause most failed or wrong imports:
- Does it cover the dates you expected? Check the first and last rows. A file that stops mid month or starts a few days late will quietly leave gaps in your totals.
- Are dates readable and consistent? A date such as 03/04 can mean the third of April or the fourth of March depending on the bank. Compare a few rows with your online banking to be sure which one you have.
- Are the amounts correct? Some files show spending as negative numbers and income as positive, others use two separate columns for money out and money in. Some use a comma as the decimal mark. Check one or two transactions you remember.
- Is the separator what you expect? Despite the name, many CSV files use semicolons instead of commas, especially where the comma is the decimal mark. A tool that expects commas may then show everything crammed into one column.
- Do special characters look right? If names show strange symbols, the file uses a different text encoding. That is normally fixable when you import, so note it rather than editing the file by hand.
- Is it still the original? Opening a CSV in a spreadsheet and saving it again can change dates, drop leading zeros and rewrite number formats. If you only want to look, close it without saving, or work on a copy.
Where Home Budget Analytics fits
Once you have the file, Home Budget Analytics reads it from an upload. Statements from banks it already recognizes are mapped automatically, and for a new layout you point out the date, amount and description columns once and the app remembers that mapping for every later statement from the same bank. Transactions are then deduplicated, so an overlapping export does not count anything twice, and categorized with rules you approve.
It helps to be clear about the limits. The app works from statements you upload rather than a live bank connection, so you refresh it by exporting and uploading again. It does not move money, it does not track investments or net worth, and there is no native mobile app.
Common questions
I cannot find an export option in my bank. What now?
Try the website instead of the app, look under statements, documents or reports, and check whether the option appears only after you open a single account. If your bank offers only PDF, that can still work, but a CSV or spreadsheet export is more reliable when it exists, so it is worth a quick look at the bank's help pages.
How much history should I export?
As much as the bank allows, ideally at least a full year, because yearly patterns such as insurance, travel and holiday spending only show up over a long period. If the bank limits each file, export it in chunks of whole months.
Do I need a separate file for every account?
Usually yes. Current accounts, savings accounts and credit cards are normally exported one at a time, so repeat the steps for each one you want in your budget.
Is it safe to keep these files on my computer?
A statement contains personal financial detail, so treat it like any private document: store it in a place only you can reach, avoid sending it by email, and delete copies you no longer need.
Turn your export into a budget
Upload the file you just downloaded, see your spending by category and set your first budgets from it - free to try, no card required.
Start your free trial