Skip to content

Tool to convert proprietary bank statement to OFX format, suitable for importing to GnuCash or other personal finance applications.


Notifications You must be signed in to change notification settings


Repository files navigation

OFX Statement

Ofxstatement is a tool to convert proprietary bank statements to OFX format, suitable for importing into personal accounting systems like GnuCash. This package provides a command line tool to run: ofxstatement. Run ofxstatement -h for more help. ofxstatement works under Python 3 and is not compatible with Python 2.


Most internet banking systems are capable of exporting account transactions to some sort of computer readable format, but few support standard data formats, like OFX. On the other hand, personal accounting systems such as GnuCash support standard formats only, and will probably never support proprietary statement formats of online banking systems.

To bridge the gap between them, this ofxstatement tool was created.

Mode of Operation

The ofxstatement tool is intended to be used in the following workflow:

  1. At the end of each month, use your online banking service to export statements from all of your bank accounts in a format known to ofxstatement.
  2. Run ofxstatement on each exported file to convert it to OFX. Shell scripts or a Makefile may help to automate this routine.
  3. Import the generated OFX file into your personal accounting system.

Installation and Usage

Before using ofxstatement, you have to install a plugin for your bank (or write your own!). Plugins are installed as regular python packages, with easy_install or pip, for example:

$ pip3 install ofxstatement-lithuanian

Note that ofxstatement itself will be installed automatically this way. After the installation, the ofxstatement utility will be available.

Users of Ubuntu and Debian operating systems can install ofxstatement from official package repositories:

$ apt install ofxstatement ofxstatement-plugins

You can check that ofxstatement is working by running:

$ ofxstatement list-plugins

You should get a list of your installed plugins.

After installation, the usage is simple:

$ ofxstatement convert -t <plugin> bank_statement.csv statement.ofx

The resulting statement.ofx is then ready to be imported into a personal accounting system.

Known Plugins

There are several user-developed plugins available:

Plugin Description
ofxstatement-mt940 Swift MT940 statements
ofxstatement-iso20022 Generic ISO-20022 format
ofxstatement-paypal PayPal, *.csv for private accounts
ofxstatement-transferwise Transferwise CSV (international)
ofxstatement-lithuanian Plugins for several banks, operating in Lithuania: Swedbank, Danske and common Lithuanian exchange format - LITAS-ESIS.
ofxstatement-czech Plugin for Poštovní spořitelna (maxibps) and banks using GPC format (e.g., FIO banka, module gpc).
ofxstatement-airbankcz Plugin for Air Bank a.s. (Czech Republic)
ofxstatement-raiffeisencz Plugin for Raiffeisenbank a.s. (Czech Republic)
ofxstatement-unicreditcz Plugin for UniCredit Bank Czech Republic and Slovakia
ofxstatement-equabankcz Plugin for Equa Bank a.s. (Czech Republic)
ofxstatement-cz-komercni Komerční banka (Czech Republic)
ofxstatement-mbankcz mBank S.A. (Czech Republic)
ofxstatement-otp Plugin for OTP Bank, operating in Hungary
ofxstatement-bubbas Set of plugins, developed by @bubbas: dkb_cc and lbbamazon.
banking.statements.osuuspankki Finnish Osuuspankki bank
banking.statements.nordea Nordea bank (at least Finnish branch of it)
ofxstatement-seb SEB (Sweden), it parses Export.xlsx for private accounts
ofxstatement-lansforsakringar Länsförsäkringar (Sweden), it parses Kontoutdrag.xls for private accounts
ofxstatement-be-belfius Belfius (Belgium)
ofxstatement-be-keytrade KeytradeBank (Belgium)
ofxstatement-be-ing ING (Belgium)
ofxstatement-be-kbc KBC (Belgium)
ofxstatement-be-argenta Argenta (Belgium)
ofxstatement-be-crelan Crelan (Belgium)
ofxstatement-be-triodos Belgian Triodos Bank CSV statements
ofxstatement-be-newb Belgian cooperative bank newB
ofxstatement-germany Plugin for several german banks (1822direkt and Postbank at the moment)
ofxstatement-dab DAB Bank (Germany)
ofxstatement-consors Consorsbank (Germany)
ofxstatement-de-triodos German Triodos Bank CSV statements (also works for GLS Bank)
ofxstatement-sp-freiburg Sparkasse Freiburg-Nördlicher Breisgau (Germany)
ofxstatement-de-ing Ing Diba Bank (Germany)
ofxstatement-mastercard-de Mastercard PDF statements (Germany)
ofxstatement-sparkasse-de Sparkasse PDF statements (Germany)
ofxstatement-austrian Plugins for several banks, operating in Austria: Easybank, ING-Diba, Livebank, Raiffeisenbank.
ofxstatement-postfinance Swiss PostFinance (E-Finance Java text based bank/credit statements).
ofxstatement-fineco FinecoBank (Italy)
ofxstatement-intesasp Intesa San Paolo xlsx balance file (Italy)
ofxstatement-chebanca CheBanca! xlsx format (Italy)
ofxstatement-n26 N26 Bank (Italy)
ofxstatement-it-banks Widiba and Webank (Italy)
ofxstatement-bancoposta BancoPosta - Poste Italiane (Italy)
ofxstatement-hype Hype - Banca Sella (Italy)
ofxstatement-betterment Betterment (USA)
ofxstatement-us-first-republic First Republic Bank (USA)
ofxstatement-simple Simple (USA, defunct) JSON financial statement format
ofxstatement-mbank-sk (Slovakia)
ofxstatement-latvian Latvian banks
ofxstatement-ee-seb SEB (Estonia), parses proprietary csv file
ofxstatement-ee-swedbank Swedbank (Estonia), parses proprietary csv file
ofxstatement-polish Support for some Polish banks and financial institutions
ofxstatement-russian Support for several Russian banks: Avangard, AlfaBank, Tinkoff, SberBank (both debit and csv), VTB.
ofxstatement-is-arionbanki Arion bank (Iceland)
ofxstatement-revolut Revolut Mastercard
ofxstatement-al_bank Arbejdernes Landsbank (Denmark)
ofxstatement-cd-tmb Trust Merchant Bank (DRC)
ofxstatement-zm-stanbic Stanbic Bank (Zambia)
ofxstatement-dutch Dutch financial institutes like ICSCards and ING
ofxstatement-french French financial institutes like BanquePopulaire
ofxstatement-schwab-json Charles Schwab investment history JSON export
ofxstatement-bbva BBVA (Spain)
ofxstatement-qif Converts Quicken Interchange Format (QIF) formatted bank transaction files
ofxstatement-santander Converts Santander transaction files

Advanced Configuration

While ofxstatement can be used without any configuration, some plugins may accept additional configuration parameters. These parameters can be specified in a configuration file. The configuration file can be edited using the edit-config command that opens your favorite editor (defined by environment variable EDITOR or else the default for your platform) with the configuration file:

$ ofxstatement edit-config

The configuration file format is in the standard .ini format. The configuration is divided into sections that correspond to the --type command line parameter. Each section must provide a plugin option that points to one of the registered conversion plugins. Other parameters are plugin specific.

A sample configuration file:

plugin = swedbank

plugin = litas-esis
charset = cp1257
currency = USD
account = LT123456789012345678

Such a configuration will let ofxstatement know about two statement file formats handled by the plugins swedbank and litas-esis. The litas-esis plugin will load statements using the cp1257 charset and set a custom currency and account number. This way, GnuCash will automatically associate the generated .ofx file with a particular GnuCash account.

To convert the proprietary CSV file danske.csv into the OFX file danske.ofx, run:

$ ofxstatement -t danske:usd danske.csv danske.ofx

Note that configuration parameters are plugin specific. See the plugin documentation for more info.

To use a custom configuration file, pass the -c / --config option:

$ ofxstatement convert -t pluginname -c /path/to/myconfig.ini input.csv output.ofx

Development / Testing

ofxstatemnt uses pipenv to manage the development environment and dependencies:

$ pip install pipenv
$ git clone<your_account>/ofxstatement.git
$ cd ofxstatement
$ pipenv sync --dev

And finally run the test suite:

$ pipenv shell
$ pytest

When satisfied, you may create a pull request.

Writing your own Plugin

If the plugin for your bank has not been developed yet (see Known plugins section above) you can easily write your own, provided you have some knowledge about the Python programming language. There is an ofxstatement-sample plugin project available that provides sample boilerplate and describes the plugin development process in detail.