openstan — Free UK Bank Statement Analyser¶
Parse, analyse, and export your UK bank statement PDFs in seconds.
Free, open source, and 100% offline — your data never leaves your machine.
"I built openstan because I was manually typing HSBC statements into spreadsheets for my self-assessment tax return. There had to be a better way."
— Jason Farrar, creator
Import an entire year of statements, build reports, and export to Excel in under a minute. No subscription. No account. No internet connection required. No Python or database knowledge needed.
Why openstan?¶
| openstan | EasyBankConvert | DocuClipper | Dext / AutoEntry | |
|---|---|---|---|---|
| Price | Free | $49–$159/month | $20–$360+/month | £25–£50+/month |
| Privacy | 100% offline | Cloud upload | Cloud upload | Cloud upload |
| UK banks | HSBC, TSB, NatWest + extensible | Implied (AI-based) | Explicitly yes | Yes |
| Output | Excel, CSV, JSON | Excel, CSV, JSON | Excel, CSV, QBO, Xero | Xero, QuickBooks, CSV |
| Open source | Yes (LGPL-3.0) | No | No | No |
| Extensible | Yes — TOML files | No | No | No |
| Offline | Yes | No | No | No |
What openstan does¶
- Import bank statement PDFs from any supported bank — one file at a time or whole folders at once.
- Review import results: successful statements are committed to your project database; statements that need attention are highlighted with full debug output and the original PDF side by side.
- Summarise your project: transaction counts, account breakdowns, and automatic detection of statement coverage gaps (missing months flagged clearly).
- Export to Excel, CSV, or JSON — either as a flat transactions table or a full star-schema dataset (accounts, calendar, statements, transactions, balances, gaps).
- Build reports with a no-code report builder: filter, group, and aggregate your transactions, save named configurations, and export results.
- Advanced export — spec-driven custom exports via TOML files with per-account and date-range filtering.
Privacy¶
openstan makes one outbound network call: a silent version check on startup. No statement data, no telemetry, no analytics, no account registration. See the full Privacy Policy.
Your bank statements are sensitive. They stay on your machine.
Supported banks¶
openstan parses statements using the bank_statement_parser library. The following banks and account types are currently supported:
| Bank | Supported account types |
|---|---|
| HSBC UK | Bank Account (Current), HSBC Advance, Flexible Saver, Online Bonus Saver, Rewards Credit Card |
| TSB UK | Spend & Save (Current Account) |
| NatWest UK | Current Account |
New banks can be added by anyone via a TOML configuration file — no coding required. Don't see your bank? Request it here.
How to get started¶
- Install openstan for your operating system — no Python required.
- Follow the Quick Start guide to create your first project and import your first statements.
- Browse the Screens reference for a guide to every panel and option.
Supported platforms¶
| Platform | Installer |
|---|---|
| Windows 10 / 11 | .msi |
| macOS 12+ (Intel & Apple Silicon) | .dmg |
| Ubuntu / Debian | .deb |
| Fedora / RHEL | .rpm |
Licence¶
openstan is released under the LGPL-3.0-or-later licence.
Copyright © 2025 Jason Farrar.

