供应商子菜单
供应商的分类账和控制未结清发票
直接在会计文件中可以:
设置和使用供应商功能
- 设置营业额会计账户 (权责发生制) 。
- 设置现金会计账户 (现金原则) 。
- 配置供应商的设置 (与客户的解释相同) 。
- 设置发生业务表并登记供应商的发票。
- 已开,过期或已收的供应商发票报告。
注释
- 在多币种账户中,报告是基于供应商的货币账户余额,因此不考虑任何汇率差额。
在收到的发票表中,也列出了汇率差额发生业务,而在其它打印输出中,只使用供应商货币的金额。 - 报告的摘要列显示每张发票的第一行发生业务。
- 对于应收账款会计,可以设置一个带有成本中心的供应商分类账。
示例文件
营业额管理 (权责发生制原则)
简介
在Banana财务会计中,可以对供应商的营业额和收款情况进行管理。详细的解释可在收入会计或现金会计页面找到。
这里我们将解释如何设置供应商的组和账户,以便可以为每个供应商建立一个单独的发票清单。
如果您的发票不多,而且不想按供应商保留详细信息,也可以使用一个账户来记录所有供应商的发票。在这种情况下,发票清单将按所有供应商分组,而不是按单个供应商分组。
设置供应商组和账户
供应商账户和 / 或组可以作为正常账户直接输入账户表中的负债部分。
也可以用供应商分类账创建一个单独的部分。这样,只有供应商组的总额会出现在负债中,而所有的供应商账户都会出现在分类账中。
要在一个单独的部分创建分类账,您必须在账户表的最后添加:
- 类 * (标题) (参见类)
- 类 02 为供应商 (参见类)
- 您需要的供应商账户 (参见添加一个新账户) 。 每个供应商在账户表中都是一行,并有自己的账号。账户的编号是自由的 (参见账户) ,然而我们建议只使用数字,特别是用于支付管理。
- 在一个组中,所有的供应商账户都被汇总。
- 该组又在负债中存在的一组中被合计。

- 供应商总数被添加到总组列的汇总组200A中。
- 必须在负债组列中设置用于总组 (200A) 的相同编号或代码,以便在资产负债表中报告供应商总数。
- 总组编号是自由的 (参见总组) 。

登记收到的发票

登记付款
- 输入登记日期。
- 转到发票字段,按F2 键或双击单元格。
将出现未结清发票的清单。 - 选择已付款的供应商发票并按回车键。
程序将完成摘要,应付账款和金额字段的输入。如果没有输入对应的账户,程序就会报告发生业务中的差异。

输入信用证
为了从最初的发票中扣除金额,您必须使用相同的发票编号。如果调整文件 (例如,信用证) 有一个不同的编号,则必须保留这个编号,把这个编号写在另一列,例如,原始文件。

收款管理 (现金原则)
在成本中心设置供应商登记
对于发票上带有增值税的瑞士用户,此设置可以让您以最佳方式管理增值税。
它可以管理客户和供应商登记为成本中心 (也请参见成本和利润中心页面) 。详细的解释在收入会计或现金会计页面。
- 建议使用成本中心3 (账户前有分号 ";") 。
- 因此,成本中心的余额将不会出现在资产负债表中。

发生业务
这些信息可以在带有增值税的客户和供应商,采用现金原则页面中找到。
各种供应商发生业务
所列的各种功能与供应商的功能有相同的模式。因此,请参阅相关的客户页面以了解更多细节。
查看发生业务表中的发票列
查看客户-显示发票列。
自动完成
查看客户-自动完成。
命令提取发票行并打开发票链接
查看客户-命令提取发票行。
输入地址 (可选)
查看客户-启用地址列。

配置供应商设置
- 选择命令报表 → 供应商 → 设置。
- 重要的是要在 "组或账户" 中指出供应商不同账户所在的账户表组。
- 关于不同选项的解释,请参见客户/供应商设置。
供应商发票清单
查看已收到的发票
命令: 报表 → 供应商 → 已收到的发票。
此表显示属于供应商分类账或单个供应商的所有发票。

显示未结发票
命令: 报表 → 供应商 → 按供应商开发票。
此表只显示有未结余额的发票。
对于多币种会计,如果某个供应商存在未记录的汇率差,将显示 "调整汇率差 "一行,使未结清发票列表中的余额与账户明细中的余额相平衡。

查看按支付日期开发票
命令: 报表 → 供应商 → 按支付日期开发票。
此表只显示有未结余额的发票,按到期日分组。

Payment files 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.
Migration to structured addresses
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).
Opening a new year
The payment file (XML file) can only be created in the accounting file that contains the necessary payment data for its generation. When opening the new year, only customer and supplier invoices are carried forward, without their related payment data; therefore, it is not possible to create a payment file for invoices recorded in the accounting file of the previous year.
However, through the menu Report > Suppliers > List of payment files, you can also view the payment files from previous years, based on the Suppliers settings, by enabling the Include transactions from previous years option in the Report > Suppliers > Settings command.
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 payment files display all payments included in payment files present in the Transaction table (Payment file).

Payment List

