Processing via bank files

Category: Process payments

Plugin.ch lets you import and automatically process payment files received from your bank. Two formats are supported: files V11 (legacy format, deprecated since the end of 2021) and files XML in ISO 20022 camt054 format (modern format). This tutorial guides you through the structure of these files and how to import them into the system.

A Structure of the reference number

The reference number used for bank payments is a key element that allows Plugin.ch to reliably identify which invoice is being paid. This number contains 27 characters structured as follows:

Full reference number:
[Subscriber Number (9)] + [Reserved (2)] + [Member Number (8)] + [Invoice Number (7)] + [Control Character (1)]
Component Length Description
Subscriber number 9 characters Unique identifier of the club/organization
Reserved 2 characters Reserved space, generally made up of zeros
Member number 8 characters Identifier of the member who received the invoice
Invoice number 7 characters Unique invoice number in Plugin.ch
Control character 1 character Checksum for validating the number

💡 Tip
The reference number allows Plugin.ch to automatically match received payments to the correct invoice. This eliminates manual errors and considerably speeds up the reconciliation process.

B V11 format (legacy format)

The V11 format was widely used for exchanging banking data. Each payment line contained exactly 100 characters, and an 87-character control line accompanied each file.

⚠️ Note
V11 files are no longer accepted since the end of 2021. If you still have files in this format, please ask your bank for an export in XML format (ISO 20022 camt054).

C XML ISO 20022 camt054 format

Recommended tools for viewing XML files

To examine the detailed content of XML files, we recommend using specialized editors that make it easier to navigate the XML hierarchy:

Notepad++ for XML

Notepad++ with XML syntax highlighting

XML Notepad

XML Notepad with tree view

General document structure

A camt054 XML file starts with a declaration and a “Document” root element that encapsulates all the banking data:

XML header

Header group (GrpHdr)

The GrpHdr section contains the message metadata, notably the file's unique identifier (MsgId) and the creation date/time (CreDtTm):

Header group

Notification group (Ntfctn)

The Ntfctn section groups account information and bank transactions. It contains the account and transaction details:

Notification group 1
Notification group 2

Entry details (Entry)

Each entry contains the account IBAN, the total amount, and the transaction type (generally CRDT for credit):

Entry details

Number of transactions

Plugin.ch checks the indicated number of transactions to make sure all transactions were imported correctly:

Number of transactions

Details of each transaction

Each transaction includes the amount, the debtor's information (who is paying), and the debtor's bank:

Transaction details 1
Transaction details 2

D Process a payment file

Step 1: Access payment management

From the menu, go to INVOICE then MANAGE INVOICES. Then click the tab or button “Payment”.

Access to payments

Step 2: Select the file

Click the “Choose a file” to browse your computer and select the XML file received from your bank.

Choose a file button
Selection dialog

Step 3: Confirm the selection

Once the file is chosen, it is displayed in the interface. Check that it is the correct file.

File chosen

Step 4: Validate the payments

Click the “Validate payments” to start the import. Plugin.ch will process all payments in the file and automatically match them to the corresponding invoices.

Step 5: Review the PDF report

A detailed PDF report is generated. It lists all processed payments, amounts, dates, and the status of each transaction. Keep this report as proof.

PDF report 1
PDF report 2

Step 6: Archive the file

Once successfully processed, move the XML file to a “Processed files” folder in your personal folders. This avoids accidental duplicate processing and keeps your files organized.

E Review a processed file

Access to file history

In the “Review a payment file” area, you can view the complete history of bank files already processed by Plugin.ch.

Review area

Select a file from the list

A drop-down menu or list displays all previously imported payment files. Select the file you want to review.

File list

View the file details

Click the “Review a payment file” to display the detailed report with all payments included in this file.

File details

F Managing duplicate processed files

Duplicate payment detection

If you accidentally import the same bank file twice, Plugin.ch automatically detects this. The payments from the second processing are displayed in BLUE in the report.

Duplicate payments (blue)

Protection against duplicate validation

Payments displayed in blue are not processed by Plugin.ch. Only payments in black (from the first processing) are taken into account. No duplicate credit is recorded on invoices.

⚠️ Note: Duplicate payments via e-banking
If a member has unintentionally made two payments for the same invoice via their e-banking, the second payment will be displayed in blue in Plugin.ch and will not be taken into account. However, the amount will still have been debited from the member's account. Check your bank account to identify these situations and contact the member for a refund if necessary.

Bank account check

💡 Tip
After each bank file import, review the generated PDF report. Payments in blue indicate an anomaly. Note these references to carry out the necessary checks with your bank.

Plugin.ch Tutorial — Process payments

Was this article helpful?

In the same folder

Didn't find your answer?

Sign in to your account to ask your question: it is sent directly to our support team, who will reply by email.

Sign in to ask a question