Skip to main content

Convert bunq payments to csv

Project description

Bunqexport 🌈

After the some discussion in the lexware Finanzmanger forum, it looks like the authors do not feel the need to integrate bunq into their application (https://forum.lexware.de/threads/37851/)

Also in the bunq forums, no one seemed to have a prior solution (https://together.bunq.com/d/24026-lexware-quicken-finanzmanager-import-from-bunq).

So I decided to implement a simple export with python and the bunq rest API.

Features

  • Connect to bunq (https://www.bunq.com) API with a pregenerated API key (see Tinker example: https://github.com/bunq/tinker_python)
  • Export payments from bunq as json and csv into one file per account
  • support special csv format with timestamps in DD.MM.YYYY format in timstamps, as expected from Haufe-Lexware Finanzmanger, when mode is lexware
  • Unit testing using nose
  • Pre-commit checking with pre-commit

Usage

Install bunqexport and generate an export:

$ pip install bunqexport
$ bunqexport --conf bunq-production.conf --mode lexware
[INFO   ] Using conf: bunq-production.conf
[INFO   ] found XX while fetching last 200 Payments for account XXXXXXX
[INFO   ] Wrote bunq_XXXXXXX_Default.csv
[INFO   ] Wrote bunq_XXXXXXX_Default.json
created    type               counterparty_alias.name                   amount.currency amount.value description
23.12.2019  CHECKOUT_MERCHANT                                      bunq  EUR              200.00                                    bunq account top up
23.12.2019         MASTERCARD                    XXXXXXXXXXXXXXXXXXXXXX  EUR              -16.96               XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
23.12.2019            SAVINGS                               XXXXXXXXXXX  EUR               -0.04
24.12.2019            EBA_SCT                                XXXXXXXXXX  EUR              500.00                                                    ---
27.12.2019            EBA_SCT  PayPal (Europe) S.a.r.l. et Cie., S.C.A.  EUR                0.13                           PAYPAL BEVEILIGINGSMAATREGEL
27.12.2019            EBA_SCT  PayPal (Europe) S.a.r.l. et Cie., S.C.A.  EUR                0.03                           PAYPAL BEVEILIGINGSMAATREGEL
...

Contributing

Any contributions are very welcome.

When contributing to this repository, please first discuss the change you wish to make via issue with the owners of this repository before making a change.

Pull Request Process

  1. Ensure any install or build dependencies are removed before the end of the layer when doing a build.
  2. Document your changes (whereever useful), e.g in README.md.
  3. Use pre-commit hooks by installing pip install pre-commit and run pre-commit install.

License

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

bunqexport-0.0.3.tar.gz (33.8 kB view details)

Uploaded Source

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

bunqexport-0.0.3-py3.9.egg (17.2 kB view details)

Uploaded Egg

bunqexport-0.0.3-py3-none-any.whl (34.3 kB view details)

Uploaded Python 3

File details

Details for the file bunqexport-0.0.3.tar.gz.

File metadata

  • Download URL: bunqexport-0.0.3.tar.gz
  • Upload date:
  • Size: 33.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7

File hashes

Hashes for bunqexport-0.0.3.tar.gz
Algorithm Hash digest
SHA256 1dd4cc8a937e109f22d534d7e3b58dc67e661ac0c665c8578c54f7ead46c245d
MD5 a5a1121a64b89a7323665a7345a55ff7
BLAKE2b-256 8c7de144da559d4974b0476ade077808a0c272fbf77e07af4d4bc94d2be45b1c

See more details on using hashes here.

File details

Details for the file bunqexport-0.0.3-py3.9.egg.

File metadata

  • Download URL: bunqexport-0.0.3-py3.9.egg
  • Upload date:
  • Size: 17.2 kB
  • Tags: Egg
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7

File hashes

Hashes for bunqexport-0.0.3-py3.9.egg
Algorithm Hash digest
SHA256 4193645a0547bed96bce9ebd1ffc551d5b0b01bc39c1b92e7e641414c97367f9
MD5 02852b38da6ca22640fd1acc2b9a3d77
BLAKE2b-256 43080fc69cf0d192bbf7cd67f72e84bb468d6fc45621ab472b2c5593f19fdf78

See more details on using hashes here.

File details

Details for the file bunqexport-0.0.3-py3-none-any.whl.

File metadata

  • Download URL: bunqexport-0.0.3-py3-none-any.whl
  • Upload date:
  • Size: 34.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7

File hashes

Hashes for bunqexport-0.0.3-py3-none-any.whl
Algorithm Hash digest
SHA256 a6c25215765bd32767c46bf3cb394a50041266c5782f5ac7b66100e19ce990fe
MD5 5d679cc03aa5f7c839fad64f81588848
BLAKE2b-256 0c621b4432df80ff66c3924cb1d7186681d87fbe5329fe5b9e046de614658888

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page