Payment orders for invoices from suppliers
The new Payments function allows you to create payment orders (pain.001) either from a list of transactions or by scanning the QR codes on received invoices.
The pain.001 files are XML messages that contains details of the payments to be made and that can be uploaded to the portal of the major financial institutions. Banana currently supports the Swiss payment standards (SPS).
More info Payment orders PAIN.001.
Prerequisites and important notes
Currently the payment functionality
- Is available in the Dev-Channel version, so please install the latest version of Banana Accounting+ Dev Channel.
- This extension works only with the Advanced Plan, you can request a 1 month promo code from our support service.
- The extension is currently in Beta Test, please check everything and report any problem.
How to create the payment file (pain.001)
- Open your accounting file (double entry accounting or income-expense accounting ) or download our example file Payments_2024_en.ac2
- In the Accounts table, verify the presence of the Address view.
You can add it using the menu command Tools > Add/Remove functionalities... > Add Address columns in Accounts table.
If your Address columns are different (e.g. missing IBAN, see the documentation Address view.
- The first time, install the Payment functionalities with the command Tools > Add/Remove functionalities... > Add payment functionalities
- Set up the debit bank account, which will be used when creating the payment order. In the Accounts table, select the debit account and complete the following data (Address view):
- Name, surname or company name (bank account holder)
- IBAN (IBAN account of the bank or postal account to be debited)
- Bank clearing (BIC code of the financial institution to be debited)
- Check and update the address and payment information of your suppliers in the Accounts table (Address view).
If you don't have a list of suppliers, please define it according to our explanation in the Suppliers section.
If you make payments by scanning QR-Codes you don't need to setup the addresses because all information for the payment is included in the QR-Code
- In the Transactions table enter the invoices of your suppliers or scan your QR-Codes
- Enter and complete the payment details by clicking directly on the Payment Data column. Ensure that all transactions to be paid are completed with the payment information.
If the supplier list (Account ID) is empty, it is necessary to configure the Payments extension by setting up the Suppliers group.
See the Payment orders extension (Payment Data dialog) for guidance.
- Select the command Reports > Suppliers > Create payment file
- Please fill in with the name of the account holder to be debited, their corresponding IBAN, and BIC code. If you have previously entered this information in the Accounts table, it will be automatically suggested.
If you want to display each payment separately on the bank statement, you must enable the "Individual booking" option when creating the payment order; otherwise, only the total amount will be shown on the bank statement.
Press the "Next" button.
- A summary of the payment file is displayed and you can specify where to save it. Click on Finish, you will be asked to save the payment file, which you can upload to your bank. Note: In Banana it's not possible to connect to your bank and transmit the file, you need to upload the file from your computer into the bank app or website.
- After saving the payment file, a row containing the payment/file object will be inserted into the Transactions table.
You can view the content of the XML file again by double-clicking on the Payment Data cell or by clicking on the edit icon located at the top right of the cell.
This is a receipt, and it is no longer possible to modify the payment file or send it again.
Warning! The payment/file objects are used to determine whether a payment has been transmitted to the bank.
Therefore, it is recommended not to delete the rows containing these objects; otherwise, payments that have already been transmitted will continue to appear among the pending ones.
When creating a payment order in Banana, the related payment entries are not generated immediately, as the file must first be transmitted to the bank and the payment is only executed after bank confirmation.
Once the payments have been made, it is recommended to import into Banana the ISO 20022 file provided by the bank, which contains the details of the completed payments.
After importing the invoice payments, you can complete them by pressing F2 in the Invoice column, so that they are marked as paid in the Supplier Invoices table (menu Reports > Suppliers).
Create payment file
The command Reports→ Suppliers→ Create payment file creates an XML message collecting information from payment data objects.
See How to create the payment file (pain.001)
Scanning QR-Codes
The Reports→ Suppliers→ Scan QR-code command displays the Scan code dialog,which allows you to enter one or more QR codes and create the accounting entries and related payment files from these data.
We tested the functionality with the Datalogic QuickScan reader (more on scanner configuration).
It is also possible to scan the QR-Codes with a mobile app, copy the data to the clipboard and paste them into the Banana Scan code dialog. You can search for an app that scans QR codes and saves them to the clipboard in the Apple or Android store. Our company does not provide or publish any software of this type.
If you have multiple QR codes to scan, use the Next Scan button after each scan.
If you are picking up a list of QR codes from the clipboard, they must be separated by semicolons, without adding spaces or line breaks (...EDP;SPC...).
To automatically retrieve the supplier's account number, you must correctly specify the supplier's name in the Organization column of the Accounts table, Address view. The text in the Organization column must exactly match the name indicated in the QR code.
Configure and Use QR Code Scanner
- Configure and connect the scanner.
- In Banana, select the command Reports > Suppliers > Scan QRCode (Ctrl+8) and place the cursor in the input field.
- Press the button on the scanner.
- The scan dialog will be automatically filled in.
- Complete the process.
Configure and Use Mobile App
- Install the mobile app, scan QR codes with the app, and save the data to the clipboard.
- Transfer the saved text to your computer with Banana (e.g., via email or AirDrop).
- In Banana, select the command Reports > Suppliers > Scan QRCode (Ctrl+8) and place the cursor in the input field.
- Paste the copied text into the scan dialog.
- Complete the process.
List of payments
The command Reports→ Suppliers→ List of payments display all payments included in payment files. Payment data are not included.