Bank statement Camt ISO 20022 Switzerland (Banana+)

Requirements

To use this extension, Banana Accounting Plus is required.

Characteristics

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

• The QR reference number is entered in the description of the transaction;
• You can extract the invoice number from the QR/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 QR/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).

Invoice pairing

This extension works in conjunction with Swiss QRCode invoice printing, see:

• Invoice Layout Extension [CH10].
• QR-Code customisation
• Payment records

Installing extension

From the Menu Extensions > Manage extensions > Online > Import > select the extension Bank statement Camt ISO 20022 Switzerland (Banana+) > Install button.

Parameter settings

The extension parameters are required to electronically record invoice collection movements.
With these settings, it is possible to define how the invoice number and customer data are to be extracted, so that they are automatically inserted in the relevant columns of the Transactions table.

To access the extension parameters

• Open the accounting file where you want to import the movements.
• Access the extension parameters:
  • From the Extensions menu > Manage Extensions > select the Bank statement Camt ISO 20022 Svizzera (Banana+) > Settings button.
  • Or from the Actions menu > Import to accounting > Manage extensions > select extension Bank account statement Camt ISO 20022 Switzerland (Banana+) > Settings button

Add contra account transaction

If this option is enabled, the extension will enter a contra account 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 contra account entry is made.

QR invoice data

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.

It is possible to extract the invoice number from the reference number created by the Banana Accounting Plus program by checking the appropriate checkbox without modifying the parameters related to the 'Start position' and the 'Number of characters' to use.

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'.

It is possible to extract the customer account from the reference number created by the Banana Accounting Plus program by checking the appropriate checkbox without modifying the parameters related to the 'Start position' and the 'Number of characters' to use.

It is also possible to extract the customer account billed with other invoicing systems by indicating the position of the first character and the number of characters in the reference number corresponding to the customer account, or by indicating a JavaScript function that extracts the invoice number, for example: "(function(text) {return text.substr(10,5);})". NB: The string must contain opening and closing 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: (Standard Account Statement with IBAN)
  • QR-Invoice using the IBAN account.
  • Electronic statement with all transaction details (debits and credits). Is it possible to utilize it for invoicing with the normal IBAN account and with the SCOR type reference number, in order to automatically record both debits and credits through the use of automatic completion rules for transactions.
  • If payments are received into the special QR-IBAN account, the total amount of daily receipts received into the special QR-IBAN account (without details) will also be available daily.
• camt054 Special Account Statement QR-IBAN)
  • QR-Invoice using special QR-IBAN.
  • This is the account statement with only incoming payments to the special QR-IBAN account (Only credits invoiced with the QRR reference number will be included).
• camt052: Account Report:
  • Only used in special situations, to monitor transactions for a specific day. 
     

Related document:

• Closing Invoices