Thurgauer Kantonalbank TKB - Import bank account statement .csv (Banana+ Advanced)

The .csv format is different for each bank and is updated and changed regularly. On this page you will find the most recent extension for importing the Thurgauer Kantonalbank .csv format. This import extension allows you to import Thurgauer Kantonalbank transactions into Banana Accounting Plus. 

The extension can be installed from the Extensions menu > Manage Extensions.

Requirements for use

• Banana Accounting Plus with the Advanced Plan.
• Thurgauer Kantonalbank also provides files with standard format ISO20022, which you can import with the Professional plan. To import files in this format you need to install the relevant import extension Swiss for ISO20022 Camt 052, 053, 054. If you do not find this format already available by default, you can request it from Thurgauer Kantonalbank.

For some banks, the specific .csv format may offer better results. In any case, the Advanced plan guarantees a wider choice and maximum results and also offers several other advanced functions that speed up and simplify accounting work considerably.

Export procedure from Thurgauer Kantonalbank (TKB)

Export your bank transactions in CSV format by accessing your online account.

• Open the Accounts section and select the account for which you want to export movements.
• Export your account movements by choosing *.csv format.
• Save the file to your computer.
• We recommend saving the file somewhere you can easily find it later and not opening it before importing.

Import procedure

• From the Actions menu > Import into Accounting > select 'Import: Transactions' from the pull-down menu.
• Select the extension to use, in this case "Thurgauer Kantonalbank - Import account statement (*.csv)".
• Use the Browse button to select the file from which you want to import the movements.
• Press the OK button.

Error messages

• Unrecognized .csv file format: The format of the .csv file you are trying to import does not match any of the formats associated with this extension:
  • Check that you have selected the correct file.
  • If the file you chose is correct, our extension may need to be updated.
• This extension requires Banana Accounting+ Advanced plan: You are attempting to use the extension with a license other than the one requested. Please switch to the Advanced plan to use the features of this extension.

Send feedback

The format of the *.csv file may be updated and the extension no longer works properly. Send us feedback including a sample file (.csv) with the new format and we will update the import extension.