Download app: ch.banana.switzerland.import.camt.js
Import and convert account statement movements into accounting movements. Supports files in ISO 20022 camt052, camt053 or camt054 for the Swiss specifications.
Import and convert account statement movements into accounting movements. Supports files in ISO 20022 format and camt052, camt053, camt054 for Swiss specifications.
This filter differs from the generic ISO20022 filter 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 disable the entry of the contra-account in the transaction (see parameters).
To access the filter parameters, open an accounting file (Note: the parameters are saved in the accounting file), then open the Manage Apps dialog from the Apps 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 filter enters 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.
Specifications for the use of ISO 20022 have been issued for the Swiss banking system.
Formats have been standardised 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.
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.