Tool to convert proprietary bank statement to OFX format, suitable for importing to GnuCash
Project description
Changes
0.9.1 (2023-09-16)
- Make OFX output conform to DTD (#243).
0.9.0 (2023-08-07)
- New
-c
(--config
) option forconvert
command, allows to specify the configuration file to use (#235). - Print the number of transactions in the output (#236).
0.8.0 (2021-09-06)
- Support OFX CURRENCY and ORIGCURRENCY in statement lines. This allows plugins to add information about transaction currency to generated OFX statements.
- Add
--pretty
flag toconvert
command to produce nicely intented OFX files.
0.7.1 (2020-09-14)
- Include PEP-561 marker into source code distribution
0.7.0 (2020-09-13)
- Drop support for Python 3.4, 3.5, add support for Python 3.8
- Fixed naive end balance validation (#106)
- Modernize development environment (use pipenv, mypy, black)
0.6.5 (2020-06-09)
- Added balance checks and improved generation of unique ids (#100, #104)
0.6.4 (2020-03-04)
- Fix regression introduced in 0.6.3 -
edit-config
command stopped working.
0.6.3 (2020-02-13)
- Fix config editing on Windows
0.6.2 (2020-01-20)
- Better
EDITOR
environment variable handling foredit-config
command - Support Python-3.7
- API: type of StatementLine.date_user (date when user initiated transaction) will not be a string by default.
- API: More unique generated transaction ids (when one is not available from the statement file)
0.6.1 (2017-05-07)
- Fix installation problem on python-3.5 (#55)
0.6.0 (2016-12-02)
-
Support for specifying account information for each parsed satatement line and translate it to BANKACCTTO aggregate in OFX.
-
Command line option to display debugging information (--debug).
-
Fix config file location for appdirs >= 1.3.0
0.5.0 (2013-11-03)
-
Plugins are now registered via setuptools' entry-points mechanism. This allows plugins to live in separate eggs and developed independently of ofxstatement itself. Plugins are registered as 'ofxstatement' entry points (#11).
-
Command line interface changed:
ofxstatement
now accepts "action" parameter and few actions were added:ofxstatement convert
: perform conversion to OFXofxstatement list-plugins
: list available conversion pluginsofxstatement edit-config
: launch default editor to edit configuration file
-
ofxstatement convert
can be run without any configuration. Plugin name to use is specified using-t TYPE
parameter in this case (#12). -
StatementLine
supports more attributes, translated to OFX (#13):refnum
- translated to<REFNUM>
in OFX.trntype
- translated to<TRNTYPE>
in OFX.
OFX Statement
.. image:: https://github.com/kedder/ofxstatement/actions/workflows/test.yml/badge.svg?branch=master :target: https://github.com/kedder/ofxstatement/actions/workflows/test.yml .. image:: https://coveralls.io/repos/kedder/ofxstatement/badge.png?branch=master :target: https://coveralls.io/r/kedder/ofxstatement?branch=master .. image:: http://www.mypy-lang.org/static/mypy_badge.svg :target: http://mypy-lang.org/ .. image:: https://img.shields.io/badge/code%20style-black-000000.svg :target: https://github.com/psf/black
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.
Rationale
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.
.. _GnuCash: http://gnucash.org/ .. _OFX: http://en.wikipedia.org/wiki/Open_Financial_Exchange
Mode of Operation
The ofxstatement
tool is intended to be used in the following workflow:
-
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.
-
Run
ofxstatement
on each exported file to convert it to OFX. Shell scripts or a Makefile may help to automate this routine. -
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 eggs, 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 bank_statement.csv statement.ofx
The resulting statement.ofx
is then ready to be imported into a personal
accounting system.
Development / test
ofxstatemnt
uses pipenv
_ to manage the development environment and
dependencies::
$ pip install pipenv $ git clone https://github.com/<your_account>/ofxstatement.git $ cd ofxstatement $ pipenv sync --dev
.. _pipenv: https://github.com/pypa/pipenv
And finally run the test suite::
$ pipenv shell $ pytest
When satisfied, you may create a pull request.
Known Plugins
There are several user-developed plugins available:
================================= ============================================
Plugin Description
================================= ============================================
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-germany
_ Plugin for several german banks (1822direkt and Postbank at the moment)
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-mbank-sk
_ MBank.sk
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-betterment
_ Betterment (https://www.betterment.com/)
ofxstatement-simple
_ Simple (the bank, https://www.simple.com/) JSON financial statement format
ofxstatement-latvian
_ Latvian banks
ofxstatement-iso20022
_ Support for generic ISO-20022 format
ofxstatement-seb
_ SEB (Sweden), it parses Export.xlsx for private accounts
ofxstatement-ee-seb
_ SEB (Estonia), parses proprietary csv file
ofxstatement-paypal
_ PayPal, it parses *.csv
for private accounts
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-dab
_ DAB Bank (Germany)
ofxstatement-consors
_ Consorsbank (Germany)
ofxstatement-is-arionbanki
_ Arion bank in Iceland
ofxstatement-de-triodos
_ German Triodos Bank CSV statements (also works for GLS Bank)
ofxstatement-lansforsakringar
_ Länsförsäkringar (Sweden), it parses Kontoutdrag.xls for private accounts
ofxstatement-revolut
_ Revolut Mastercard
ofxstatement-transferwise
_ Transferwise CSV
ofxstatement-n26
_ N26 Bank
ofxstatement-sp-freiburg
_ Sparkasse Freiburg-Nördlicher Breisgau (Germany)
ofxstatement-al_bank
_ Arbejdernes Landsbank (Denmark)
ofxstatement-fineco
_ FinecoBank (Italy)
ofxstatement-intesasp
_ Intesa San Paolo (xlsx balance file)
ofxstatement-de-ing
_ Ing Diba Bank (Germany)
ofxstatement-us-first-republic
_ First Republic Bank (USA)
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-mt940
_ All financial institutes providing Swift MT940 statements
ofxstatement-it-banks
_ Widiba and Webank italian banks
ofxstatement-chebanca
_ CheBanca! Italian bank (xlsx format)
================================= ============================================
.. _ofxstatement-lithuanian: https://github.com/kedder/ofxstatement-lithuanian .. _ofxstatement-czech: https://gitlab.com/mcepl/ofxstatement-czech .. _ofxstatement-airbankcz: https://github.com/milankni/ofxstatement-airbankcz .. _ofxstatement-raiffeisencz: https://github.com/milankni/ofxstatement-raiffeisencz .. _ofxstatement-unicreditcz: https://github.com/milankni/ofxstatement-unicreditcz .. _ofxstatement-equabankcz: https://github.com/kosciCZ/ofxstatement-equabankcz .. _ofxstatement-mbankcz: https://github.com/SinyaWeo/ofxstatement-mbankcz .. _ofxstatement-otp: https://github.com/abesto/ofxstatement-otp .. _ofxstatement-bubbas: https://github.com/bubbas/ofxstatement-bubbas .. _banking.statements.osuuspankki: https://github.com/koodaamo/banking.statements.osuuspankki .. _banking.statements.nordea: https://github.com/koodaamo/banking.statements.nordea .. _ofxstatement-germany: https://github.com/MirkoDziadzka/ofxstatement-germany .. _ofxstatement-austrian: https://github.com/nblock/ofxstatement-austrian .. _ofxstatement-postfinance: https://pypi-hypernode.com/pypi/ofxstatement-postfinance .. _ofxstatement-mbank-sk: https://github.com/epitheton/ofxstatement-mbank-sk .. _ofxstatement-be-belfius: https://github.com/renardeau/ofxstatement-be-belfius .. _ofxstatement-be-keytrade: https://github.com/Scotchy49/ofxstatement-be-keytrade .. _ofxstatement-be-ing: https://github.com/jbbandos/ofxstatement-be-ing .. _ofxstatement-be-kbc: https://github.com/plenaerts/ofxstatement-be-kbc .. _ofxstatement-be-argenta: https://github.com/woutbr/ofxstatement-be-argenta .. _ofxstatement-be-crelan: https://gitlab.com/MagnificentMoustache/ofxstatement-be.crelan .. _ofxstatement-be-newb: https://github.com/SDaron/ofxstatement-be-newb .. _ofxstatement-betterment: https://github.com/cmayes/ofxstatement-betterment .. _ofxstatement-simple: https://github.com/cmayes/ofxstatement-simple .. _ofxstatement-latvian: https://github.com/gintsmurans/ofxstatement-latvian .. _ofxstatement-iso20022: https://github.com/kedder/ofxstatement-iso20022 .. _ofxstatement-seb: https://github.com/gerasiov/ofxstatement-seb .. _ofxstatement-paypal: https://github.com/gerasiov/ofxstatement-paypal .. _ofxstatement-polish: https://github.com/yay6/ofxstatement-polish .. _ofxstatement-russian: https://github.com/gerasiov/ofxstatement-russian .. _ofxstatement-dab: https://github.com/JohannesKlug/ofxstatement-dab .. _ofxstatement-consors: https://github.com/JohannesKlug/ofxstatement-consors .. _ofxstatement-is-arionbanki: https://github.com/Dagur/ofxstatement-is-arionbanki .. _ofxstatement-be-triodos: https://github.com/renardeau/ofxstatement-be-triodos .. _ofxstatement-de-triodos: https://github.com/pianoslum/ofxstatement-de-triodos .. _ofxstatement-lansforsakringar: https://github.com/lbschenkel/ofxstatement-lansforsakringar .. _ofxstatement-revolut: https://github.com/mlaitinen/ofxstatement-revolut .. _ofxstatement-transferwise: https://github.com/kedder/ofxstatement-transferwise .. _ofxstatement-n26: https://github.com/3v1n0/ofxstatement-n26 .. _ofxstatement-sp-freiburg: https://github.com/omarkohl/ofxstatement-sparkasse-freiburg .. _ofxstatement-al_bank: https://github.com/lbschenkel/ofxstatement-al_bank .. _ofxstatement-fineco: https://github.com/frankIT/ofxstatement-fineco .. _ofxstatement-intesasp: https://github.com/Jacotsu/ofxstatement-intesasp .. _ofxstatement-de-ing: https://github.com/fabolhak/ofxstatement-de-ing .. _ofxstatement-germany: https://github.com/MirkoDziadzka/ofxstatement-germany .. _ofxstatement-us-first-republic: https://github.com/medovina/ofxstatement-us-first-republic .. _ofxstatement-cz-komercni: https://github.com/medovina/ofxstatement-cz-komercni .. _ofxstatement-cd-tmb: https://github.com/BIZ4Africa/ofxstatement-cd-tmb .. _ofxstatement-zm-stanbic: https://github.com/BIZ4Africa/ofxstatement-zm-stanbic .. _ofxstatement-dutch: https://github.com/gpaulissen/ofxstatement-dutch .. _ofxstatement-french: https://github.com/gpaulissen/ofxstatement-french .. _ofxstatement-mt940: https://github.com/gpaulissen/ofxstatement-mt940 .. _ofxstatement-it-banks: https://github.com/ecorini/ofxstatement-it-banks .. _ofxstatement-ee-seb: https://github.com/rsi2m/ofxstatement-ee-seb .. _ofxstatement-chebanca: https://github.com/3v1n0/ofxstatement-chebanca 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::
[swedbank]
plugin = swedbank
[danske:usd]
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
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.
.. _ofxstatement-sample: https://github.com/kedder/ofxstatement-sample
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for ofxstatement-0.9.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e8c57537c9a4a9a5e5edf8dd51bd62bb5054b237ef17a19230b48432d5479416 |
|
MD5 | d67529f4e8c2adb5f267b56c213f6eee |
|
BLAKE2b-256 | 6072ee727885ee1b8716c5daee36557083baaa379a153abd97a74cb95f8971d0 |