Bank statement Camt ISO 20022 Switzerland (compatible with Banana 9)

Characteristics

This import extension differs from the generic ISO20022  import by the following specifics:

• The ISR reference number is entered in the description of the transaction;
• You can extract the invoice number from the ISR reference number (see parameters);
  The invoice number you extracted will be saved in the Invoice (DocInvoice) column;
• You can extract the customer account from the ISR reference number (see parameters);
  The customer account you extracted will be saved as an account/category or cost center depending on the parameters;
• You can disable the entry of the contra-account in the transaction (see parameters).

Parameters

To access the extensions parameters, open an accounting file (Note: the parameters are saved in the accounting file), then open the Manage Extensions dialog from the Extensions Menu or from the Import to Accounting dialog, and then click the Settings button.

The example images you enter here refer to the Settings dialog box, as it appears in Accounting Banana 9.0.4 or later. With previous versions of Banana Accounting the parameters are displayed to the user one at a time in sequence in separate dialogues.

Add counterpart transaction

If this option is enabled, the extension will enter a counterpart entry with the total amount of the details for movements with details. The [CA] symbol appears in the clearing account and the corresponding account number must be entered manually. If this option is deactivated, no counterpart entry is made.

Extract invoice number from ISR reference

If this option is enabled, you can define how to extract the invoice number from the ISR reference number. The invoice number you extracted will be saved in the Invoice (DocInvoice) column.

You can extract the invoice number by indicating the position of the first character and the number of characters that match the invoice number in the ISR reference number, or by indicating a JavaScript function that extracts the invoice number from the ISR number, for example: "(function(text) {return text.substr(10,5);})". NB: The string must contain the initial and final round brackets.

Extract customer account from ISR reference number

If this option is enabled, you can define how to extract the customer account from the ISR reference number. The extracted customer account will be saved in the account/category field or in the cost center field according to the parameters. If balance accounts are used as customer accounts leave the parameter 'Cost center for customer accounts' blank, otherwise enter the cost center used, e.g.: 'Cc1', 'Cc2' or 'Cc3'.

You can extract the customer account by indicating the position of the first character and the number of characters in the ISR reference number that correspond to the customer account, or by indicating a JavaScript function that extracts the invoice number from the ISR number, for example: "(function(text) {return text.substr(10,5);})". NB: The string must contain the initial and final round brackets.

Swiss specifications

Specifications for the use of ISO 20022 have been issued for the Swiss banking system.
Formats have been standardized as follows: 

• camt053: Account Statement, with detailed transactions.
  This is the file that your bank should provide, specifying that it does also include payments received.
  A summary file (without any details) might be asked for, in which case camt054 form will also have to be requested, detailing the receipts.
• camt054:
  Transactions detailed by type (such as bills payments received for bills issued).
  If detailed cash receipts are required, the bank will provide the dates in a camt054 file (as a substitute for V11).
  This results in two files:
  • camt053 file (Account Statement) with the several payments and the daily total of cashed bills, which details are contained in the camt054 file.
  • camt054 file, detailing all transactions for cashed bills with their reference number.
• camt052: Account Reporting.
  Is only used in special situations, to monitor transactions for a specific day. 

Related document:

• Closing Invoices