Follow

How do I download camt.053/camt.054/MT940 file in my E-Banking?

Overview of Banks

In this article, we will explain to you where you can find your statements of account in your e-banking and how you can download them. Only examples of banks that do maintain an interface are listed.

 


Which bank uses which file format?

To make it possible for you to manually upload statements of accounts or credit/debit notes into bexio, you must download the electronic statement of account or ESR credit notes from your e-banking. Depending on the bank, you either need:

  • A camt.053 or an MT940 file for the statement of account
  • A camt.054 or a v11 file for ESR credit notes

We have optimized the import for the following file formats for the following banks:

Bank Statements of account ESR
Credit Suisse MT940 v11
Postfinance camt.053 Version 4
with/or without details, without receipts
camt.054 (ESR)
Raiffeisen MT940 v11
St. Galler Kantonalbank (SGKB) camt.053 Version 2 & 4
(MT940 not supported)
camt.054 (ESR)
Thurgauer Kantonalbank (TKB) camt.053 Version 2 & 4
(MT940 not supported)
camt.054 (ESR)
UBS MT940
(manual import possible only if no link to e-banking exists)
v11
Zürcher Kantonalbank (ZKB) MT940 v11

 

As far as all other banks are concerned, we cannot guarantee this; however, you are encouraged to attempt manual imports.

If you should encounter problems downloading the file, please contact your bank's support directly.

Note

The following articles will explain to you what types of files MT940 and camt.053 are; they also provide additional information on ISO 20022:

 


Credit Suisse

Make sure that you have ordered a subscription for electronic statements of account, otherwise data for download will not be available to you.

Online Banking DirectNet Classic

  1. Log into your Credit Suisse E-Banking "DirectNet Classic" with your credentials
  2. Under tab "Account & Assets" > "File download" > "TELE INFACCOUNT" > "Postings SWIFT"
  3. Click the respective account (in blue lettering)
  4. Under "View" choose whether you want to have new or transferred files displayed
  5. Now you can select the respective file and download it by clicking on the file name

The file is saved as a .STA-file and can now be uploaded to bexio.

 Online banking for businesses

  1. Log into your Credit Suisse e-banking in "Online Banking for Businesses"
  2. Go to the menu
  3. Choose "Payments" > "File-based payments" > "Download" > "INFACCOUNT"
  4. Click the respective account for which you want to download a statement of account
  5. Make sure that tab "MT940" has been selected
  6. Under "View choices," choose whether you want to see new files or transferred files
  7. You can click on the file name to download the desired file

The file is saved as a .STA-file and can now be uploaded to bexio.

600_ebanking_cs_download_en.png

To find out how you can reconcile your bank statements with bexio, go to the help center article:
Bank transactions with bexio.

 


Postfinance

Make sure you have ordered Get your statement of account in the proper format from PostFinance Support, otherwise no files will be available for download.

Download (camt.053) statement of account

  1. Log into your PostFinance e-banking
  2. Click on tab "Documents"
  3. Search for tile "Statements of account" and click the magnifier
  4. Now you will see the view with documents in status "Not obtained"
  5. Choose the desired statement of account
  6. Click the "Download" button 

If you want to download "all" or "already obtained" documents, proceed as follows:

  1. Click "Search options"
  2. Choose "All" or "Obtained" under status
  3. Next, click the "Search" button
  4. Choose the desired statements of account
  5. Click the "Download" button"

600_ebanking_pofi_download_camt053_en.png

ESR credit notes (camt.054) download 

  1. Click on tab "Documents"
  2. Search for tile "ESR credit notes" and click the magnifier
  3. Now you will see the view with ESR credit notes in status "Not obtained"
  4. Choose the desired ESR credit notes
  5. Click the "Download" button 

If you want to download "all" or "already obtained" documents, proceed as follows:

  1. Click "Search options"
  2. Choose "All" or "Obtained" under status
  3. Next, click the "Search" button
  4. Choose the desired ESR credit notes
  5. Click the "Download" button"

601_ebanking_pofi_download_camt054_en.png

Important!

The documents will be exported in a ZIP file. Please extract the ZIP file after it has been exported and upload the files to bexio individually using the "Import bank transactions" feature. 

 

To find out how you can reconcile your bank statements with bexio, go to the help center article:
Bank transactions with bexio.

 


Thurgauer Kantonalbank (TKB)

Statement of account (camt.053) download

  1. Log into your TKB e-banking
  2. In the menu navigation, go to "Service & Settings" > "Download data"
  3. Under "New data transfer" go to the extreme right and click button "Get data"
  4. Choose the type of data - "camt.-messages"
  5. In the tab, choose "camt.053"
  6. Choose the account
  7. Choose the date range
    • All new data (recommended)
    • All new files in a time frame
    • Already obtained data in a time frame (recommended if transactions are missing in bexio)
  8. Click on button "Next"
  9. A dialog window opens and lists the export related details. Click on the "Export" button to save the files.

600_ebanking_tkb_download_de.png

ESR credit notes for payments (camt.054) download

    li>Log into your TKB e-banking
  1. In the menu navigation, go to "Service & Settings" > "Download data"
  2. Under "New data transfer" go to the extreme right and click button "Get data"
  3. Choose the type of data - "camt.-messages"
  4. In the tab, choose "camt.053"
  5. Choose the account
  6. Choose the date range
    • All new data (recommended)
    • All new files in a time frame
    • Already obtained data in a time frame (recommended if transactions are missing in bexio)
  7. Click on button "Next"
  8. A dialog window opens and lists the export related details. Click on the "Export" button to save the files.

600_ebanking_tkb_download_camt054_de.png

To find out how you can reconcile your bank statements with bexio, go to the help center article: Bank transactions with bexio.

 


Raiffeisen

Make sure you have set up the data transfer in your Raiffeisen e-banking, otherwise you may not have access to any data for download.

  1. Log into your Raiffeisen e-banking
  2. Go to "Data transfer" under tab "Payments" > ".
  3. On the right-hand side click "Statements of account" under "Download" > and on the link "Account data for bookkeeping software"
  4. Choose the "SWIFT" format
  5. Under account data, choose whether you want
    • All items posted that have not been obtained until the day before (recommended)
    • Account data that has been previously obtained
    • Data for a pre-defined statement of account period (recommended if transactions are missing in bexio)
  6. Under accounting details choose "With details"
  7. Click the "Download" button to save the MT940 file

600_ebanking_download_de.png

To find out how you can reconcile your bank statements with bexio, go to the help center article: Bank transactions with bexio.

 


UBS

UBS data can be exported via a direct bexio connection. We will explain how you can set up this connection in the following help article: How do I link my USB e-banking with bexio? 

 


Zürcher Kantonalbank (ZKB)

Make sure that you have ordered the subscription for electronic account deliveries from the ZKB e-banking support, since you might otherwise not have any files available for download.

  1. Log into your ZKB e-banking an
  2. Go to to "Data transfer" in the tab "Account & Payments" &gt.
  3. Under "Obtained files" click on "Get file" on the right-hand side
  4. Choosing reporting format "Statement of account SWIFT MT940"
  5. Choose the desired account
  6. Under Data Volume, choose whether you want
    • All accounting transactions not obtained yet (recommended)
    • Accounting transactions that have not been obtained yet with a date filter
    • All accounting transactions once again using a date filter (recommended if transactions are missing in bexio)
  7. Click on the "Get" button to save the MT940 file

View "Send & get":

600_ebanking_zkb_download_statement_list_de.png

View "Get file":

601_ebanking_zkb_download_statement_mt940_de.png

To find out how you can reconcile your bank statements with bexio, go to the help center article: Bank transactions with bexio.

 


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request