<!-- I thought about adding some graphics for a better appearance, but it is too large and dominates the page:  -->

bank2ynab

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

• What? (Features)
  • Wish List
• Why?
• How?
• Installation Instructions
  • Requirements
• User Guide
• YNAB API Import
• Contributors
• Known Bugs
• List of Supported Banks

<a name="what"></a>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.

<a name="wishlist"></a>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)

<a name="why"></a>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.

<a name="how"></a>How? Contribute!

• If you're "just a user":
  • tell us your import format and we can create a converter - for you and for everyone else!
  • use the converter provided here and give us feedback - or participate!
• If you've already built a YNAB converter:
  • take advantage of this project to get more import formats.
  • give back to this project by sharing your existing import formats.
• Add a brainstorming item as a new issue.
• Join the chat over at https://gitter.im/bank2ynab/Lobby
• See also: the wiki, perhaps most importantly this page about import formats.

<a name=install></a>Installation Instructions

• Install from PyPI: pip install bank2ynab
• Or install from source (recommended for contributors):
  • git clone https://github.com/bank2ynab/bank2ynab.git
  • cd bank2ynab
  • uv sync
• Then follow the User Guide below.

<a name="requirements"></a>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!

Troubleshooting:

• If you see RequestsDependencyWarning about urllib3/chardet/charset_normalizer, resync the environment with uv sync --reinstall.

<a name="userguide"></a>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. Run bank2ynab once to generate default config files.
   • user_configuration.conf is read from BANK2YNAB_CONFIG_DIR if that environment variable is set.
   • Otherwise it is read from your OS user config directory for bank2ynab.
   • On Windows, that is typically %LOCALAPPDATA%\bank2ynab\bank2ynab\user_configuration.conf.
   • Example: C:\Users\YourName\AppData\Local\bank2ynab\bank2ynab\user_configuration.conf
3. Check the [DEFAULT] configuration in that user_configuration.conf file. You only need to do this once.
   • Source Path = c:\users\example-username\Downloads sets where downloaded CSV files are read from.
   • Delete Source File = True can be set to False if you want to keep originals.
4. Check that bank2ynab.conf contains a [SECTION] for your bank format.
5. Run the converter:
   • If installed from PyPI: bank2ynab
   • If running from source: uv run bank2ynab
6. If API upload is not configured, import the output CSV manually in YNAB.

<a name="api"></a>YNAB API Import

Use this section if you want bank2ynab to upload transactions directly to YNAB.

1. Create a Personal Access Token in YNAB (My Account -> Developer Settings -> Personal Access Tokens).
2. Open user_configuration.conf and set YNAB API Access Token = <your_token>.
3. Run bank2ynab again.
4. On first API run for each bank section, choose:
   • Budget
   • Account
5. The selected mapping is stored as YNAB Account ID = <budget_id>||<account_id> in your user config.

Notes:

• Config location:
  • BANK2YNAB_CONFIG_DIR if set.
  • Otherwise your OS default user config directory for bank2ynab.
• Windows example:
  • %LOCALAPPDATA%\bank2ynab\bank2ynab\user_configuration.conf
• Root-level config files in the project directory are no longer used.
• If Save YNAB Account = True, account mapping is reused automatically.
• If token is blank, API upload is skipped and output remains CSV-based.
• Keep your token private.

<a name="contributors"></a>Contributors

<a name="knownbugs"></a>Known Bugs

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

<a name="formats"></a>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):

<!--AUTO BANK UPDATE START-->

1. AT easybank credit card
2. AT Raiffeisen Bank 2018
3. AT Raiffeisen Bank RCM
4. AT Raiffeisen Bank 2019 checking
5. AT Raiffeisen Bank 2021 checking
6. AT Raiffeisen VISA
7. AU ANZ
8. AU ING
9. AU National Australia Bank
10. BE BNP Paribas Fortis old
11. BE BNP Paribas Fortis Export
12. BE KBC checking
13. BE KBC credit
14. BE Keytrade Bank
15. BR Banco Bradesco Checking
16. BR Banco do Brasil, checking
17. BR Inter, checking
18. CA TD Canada Trust, checking+Visa
19. CH UBS Checking account
20. CH UBS Checking account - Alternative 1
21. CH UBS Credit card
22. CH Neon Monthly Account Statement
23. CH Neon Yearly Account Statement
24. CH SwissCard
25. CH ZKB Erweiterte Suche
26. CH ZKB Finanzassistent-Chronik
27. CO Bancolombia
28. Crypto.com
29. CZ AirBank checking and savings
30. CZ Ceska Sporitelna
31. CZ Raiffeisen bank
32. DE Amazon VISA LBB
33. DE Commerzbank checking
34. DE Consorsbank checking
35. DE Deutsche Bank
36. DE Deutsche Bank Credit Card
37. DE Deutsche Kreditbank checking
38. DE Deutsche Kreditbank checking new
39. DE Deutsche Kreditbank credit card
40. DE Fiducia (Volksbank, Sparda-Bank, BBBank, PSD Bank, Raiffeisen, ...)
41. DE ING-DiBa
42. DE Kreissparkasse
43. DE N26
44. DE Ostseesparkasse Rostock checking
45. DE Ostseesparkasse Rostock credit card
46. DE Sparkasse Rhein-Neckar-Nord
47. DE Sparkasse Südholstein
48. DK Bankernes EDB Central
49. DK Danske Bank
50. DK Jyske Bank VISA
51. DK Nordea
52. DK Portalbank
53. Hibiscus banking software
54. HU Erste Bank checking
55. HU K&H
56. HU OTP
57. IE AIB Ireland
58. IE Bank of Ireland
59. IE First South Credit Union
60. IE N26
61. IE Ulster Bank, savings
62. IT RomagnaBanca Inbank
63. LV Swedbank
64. Mint
65. MV Bank of Maldives, checking
66. NETELLER
67. NL American Express (AMEX)
68. NL Bunq checking
69. NL bunqDesktop software
70. NL bunqDesktop software 2
71. NL ING
72. NL ING Checking 2020
73. NL KNAB
74. NL Rabobank
75. NL Rabobank-2018
76. NL RegioBank
77. NL Rabobank Credit Card
78. NO DNB
79. NO Sparebank 1 VISA
80. Personal Capital
81. PL Alior Bank
82. PL mBank
83. PL PKO BP
84. PL Bank Pekao
85. Revolut
86. SE Handelsbanken
87. SE Länsförsäkringar checking
88. SE Morrow Bank
89. SE