How to Upload Bank Statements
Uploading a bank statement means exporting a file from your bank's website and importing it into ZenExpenses. No bank login is shared and no account connection is needed. The whole process takes about two minutes.
Step 1: Pull up your bank statement
Log in to your bank's website or app and find the export option. Banks label it differently, but it is almost always in one of these places:
- Account page → "Download", "Export", or a download icon near the transaction list
- "Statements & Documents" for monthly PDF statements
- Transaction history → date range picker → export
Choose CSV if offered; PDF statements work too. Pick the date range you want, usually the last full month.
Step 2: Upload the file
In ZenExpenses, click Upload and select the downloaded file. Account statement processing runs automatically: the columns (date, description, amount) are detected, duplicates from overlapping date ranges are skipped, and each transaction becomes a row you can categorize.
This also answers "how do I transfer bank transactions to a spreadsheet" without the spreadsheet: instead of copying lines by hand or maintaining importer scripts, the file upload does the import, and you can export clean categorized data later if you still want one.
Step 3: Review the imported transactions
- Check the totals: the imported sum should match the statement.
- Scan the dates: make sure the range is what you exported.
- Categorize: transactions matching your category rules are sorted already; assign the rest by hand.
FAQ
Which file formats can I upload?
CSV exports and PDF statements from any bank. Credit card statements work the same way as checking accounts.
How often should I upload?
Once a month is enough for most people. Upload each account's statement after the month closes, then review categories in one sitting.
Can I auto import bank transactions instead?
ZenExpenses deliberately uses file upload instead of a live bank connection: you never share bank credentials, and it works with any bank in any country. The trade-off is one short manual step per month.
What if a column is not recognized?
Statement layouts vary. If an upload looks wrong, check that the file actually contains transactions (some banks export summaries), or contact support with the bank name.
Upload your first statement
Grab last month's statement from your bank and see it categorized in minutes.
Try ZenExpenses ↗