Skip to content

Easily convert and import your bank's statements into YNAB. This project consolidates other conversion efforts into one universal tool.

License

Notifications You must be signed in to change notification settings

sadikaya/bank2ynab

 
 

Repository files navigation

bank2ynab

This project consolidates other conversion efforts into one universal tool that easily converts and imports your bank's statements into YNAB.

Development: GitHub issues by-label GitHub open issues GitHub last commit PRs welcome! Join the chat at https://gitter.im/bank2ynab/Lobby Code style: black

Testing: Travis status Coverage Status Maintainability

What? (Features)

Convert your downloaded bank statements into YNAB's input format. Here's what this script does, step by step:

  1. Look for and parse the bank2ynab.conf. This file contains all the rules and import formats.
  2. Look for and parse every CSV file in the configured download directory.
  3. If the CSV file matches any of the configured formats:
    1. Create a new CSV file in YNAB's CSV format with the correct columns and a blank Category column.
    2. Optionally delete the original CSV file.

Wish List

  • add many more input formats from all the other YNAB-CSV-conversion projects.
  • maybe coming later: automatically download your bank statements? (uses external services; only available in some countries)
  • maybe coming later: automatically import the converted data into your YNAB app? (optional, default off)

Why?

There are currently more than 80 GitHub projects related to YNAB converter scripts. Clearly there's a need, but until now these solutions have been fragmented. The present project "bank2ynab" aims to focus the efforts on a common source that encapsulates a large number of bank formats. This will also provide a common basis for a solution using a variety of programming languages.

How? Contribute!

Installation Instructions

Requirements

  • Windows or Mac or Linux
  • Python v3.9+ installed (download it from python.org)
  • Support for other scripting languages may follow. Contributions are welcome!

User Guide

Using bank2ynab is easy:

  1. Download some bank statements from your banking website.
    • Make sure to choose CSV format. Save with the default suggested filename so that the converter can find it.
    • It's okay if the statements contain data that you already have in YNAB. YNAB will detect and skip these.
  2. Check the [DEFAULT] configuration in user_configuration.conf. You only need to do this once. Specifically:
    • Source Path = c:\users\example-username\Downloads Specify where you save your downloaded CSV files.
    • Delete Source File = True set to False if you want to keep the original CSV you downloaded.
  3. Check that the configuration in bank2ynab.conf contains a [SECTION] for your banking format. You only need to do this once per bank you use. If you can't find your bank in the config, tell us your bank's format and we can add it to the project.
  4. Install the required dependencies by navigating to the bank2ynab directory in your command line and entering the following - pip install -r requirements.txt or pip3 install -r requirements.txt.
  5. Run the bank2ynab.py conversion script to generate the YNAB-ready CSV output file. How to do this depends on your operating system:
    • Windows: Open a command prompt, navigate to the script directory, and run the command python bank2ynab.
      • Pro tip: Create a program shortcut! Right-click on the bank2ynab.bat file, choose Send to and then choose Desktop (create shortcut). Now you can just double-click that shortcut!
    • Linux/Mac: Open a terminal, navigate to the script directory, and run the command python3 ./bank2ynab.     - Important: Be sure to use python3 specifically, and not python or python2 which is probably the system default.
  6. Depending on your configuration, the conversion script will now import your files into YNAB automatically, or you can add the files manually:
    • Automatic import (when you have provided your YNAB API access token:
      • The conversion script will now ask you which budget it should use to import your converted CSV file to (if you have multiple). It will also ask you which account inside the budget to use (if you have multiple); you'll only have to answer this question once.
    • Manually drag-and-drop the converted CSV file onto the YNAB web app:
      • YNAB will detect this and offer you import options. If you had already switched YNAB to the corresponding account view, YNAB will understand that you want to import this file to this account.

Known Bugs

For details, please see our issue list labeled "Bug".

List of Supported Banks

Here is a list of the banks and their formats that we already support. Note that we have many more formats in the pipeline so the list continues to grow, and we are happy to receive requests. In alphabetical order (country and bank):

  1. AT easybank credit card
  2. AT Raiffeisen Bank 2018
  3. AT Raiffeisen Bank RCM
  4. AT Raiffeisen Bank 2019 checking
  5. AT Raiffeisen VISA
  6. AU ANZ
  7. AU ING
  8. AU National Australia Bank
  9. BE KBC checking
  10. BE KBC credit
  11. BE Keytrade Bank
  12. BR Banco do Brasil, checking
  13. BR Inter, checking
  14. CA TD Canada Trust, checking+Visa
  15. CH UBS Checking account
  16. CH UBS Credit card
  17. CH ZKB Erweiterte Suche
  18. CH ZKB Finanzassistent-Chronik
  19. CO Bancolombia
  20. Crypto.com Card
  21. CZ AirBank checking and savings
  22. CZ Ceska Sporitelna
  23. CZ Raiffeisen bank
  24. DE Amazon VISA LBB
  25. DE Commerzbank checking
  26. DE Consorsbank checking
  27. DE Deutsche Bank
  28. DE Deutsche Bank Credit Card
  29. DE Deutsche Kreditbank checking
  30. DE Deutsche Kreditbank credit card
  31. DE Fiducia (Volksbank, Sparda-Bank, BBBank, PSD Bank, Raiffeisen, ...)
  32. DE ING-DiBa
  33. DE Kreissparkasse
  34. DE N26
  35. DE Ostseesparkasse Rostock checking
  36. DE Ostseesparkasse Rostock credit card
  37. DE Sparkasse Rhein-Neckar-Nord
  38. DE Landesbank Berlin Amazon Kreditkarten-Banking
  39. DE Sparkasse Südholstein
  40. DK Bankernes EDB Central
  41. DK Danske Bank
  42. DK Jyske Bank VISA
  43. DK Nordea
  44. DK Portalbank
  45. Hibiscus banking software
  46. HU Erste Bank checking
  47. HU K&H
  48. HU OTP
  49. IE AIB Ireland
  50. IE Bank of Ireland
  51. IE First South Credit Union
  52. IE N26
  53. IE Ulster Bank, savings
  54. IT RomagnaBanca Inbank
  55. LV Swedbank
  56. Mint
  57. MV Bank of Maldives, checking
  58. NETELLER
  59. NL Bunq checking
  60. NL bunqDesktop software
  61. NL bunqDesktop software 2
  62. NL ING
  63. NL ING Checking 2020
  64. NL KNAB
  65. NL Rabobank
  66. NL Rabobank-2018
  67. NL Rabobank Credit Card
  68. NO DNB
  69. NO Sparebank 1 VISA
  70. Personal Capital
  71. PL mBank
  72. Revolut
  73. SE Handelsbanken
  74. SE Länsförsäkringar checking
  75. SE Nordea - internetbanken.privat.nordea.se
  76. SE Nordea - netbank.nordea.se
  77. SE SEB Skandinaviska Enskilda Banken
  78. SE Sparbanken Tanum
  79. SE Swedbank
  80. SE Swedbank 2019
  81. SE Swedbank 2020
  82. SG OCBC Bank
  83. SG OCBC Bank Credit Card
  84. SG POSB savings
  85. SK Tatra Banka
  86. SK VUB
  87. UK Co-operative Bank
  88. UK Monzo checking
  89. UK Barclaycard credit card
  90. UK Barclaycard Business Credit Card
  91. UK first direct checking
  92. UK John Lewis Partnership Card
  93. US Bank of America
  94. US Bank of America Credit Card
  95. US BB&T
  96. US Chase Credit Card 2017
  97. US Chase Credit Card 2019
  98. US Schwab Checking
  99. US Schwab Savings
  100. US TB Bank
  101. US USAA

XKCD on standards: Fortunately, the charging one has been solved now that we've all standardized on mini-USB. Or is it micro-USB? Shit.


Disclaimer: Please use at your own risk. This tool is neither officially supported by YNAB (the company) nor by YNAB (the software) in any way. Use of this tool could introduce problems into your budget that YNAB, through its official support channels, will not be able to troubleshoot or fix. See also the full MIT licence.

About

Easily convert and import your bank's statements into YNAB. This project consolidates other conversion efforts into one universal tool.

Resources

License

Code of conduct

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Python 98.8%
  • Shell 1.2%