![]() ![]() It is easier to copy data: you can copy rows directly or a series of consecutive columns. It is very useful to have the columns also in the same sequence.In Excel you must have the same columns as in Banana Plus (see QRCode Table).With a few small adjustments to the Excel file you can use your data, transfer it to Banana Plus with a copy-paste, and immediately create QR invoices. The extension is designed for associations, organisations or people who have data in Excel and want to print invoices with the QR. Indicate which invoices you want to print.Įnter the text of the letter with the invoice details.Decide what to include in the letter part and in the QR.Run the extension from the menu Extensions → QR-Invoices from Excel.Enter the invoice data manually in the appropriate columns of the QRCode table.If you don't have an Excel file to take the data from:.Copy the rows from Excel and paste them into Banana Plus.In Excel select or filter the rows you need.In Excel adapt and sort the columns to look like those in Banana Plus.If you already have all the invoice data in an Excel file, transfer it to Banana Plus:.In Banana Plus enter the address of your organisation from the menu File → File and accounting properties (Basic data) → Address tab.QR-invoice letters can be created in this way: The extension does not work with any other file type (e.g.This is an extension and cannot be used as an invoice layout.The QR cannot therefore be used to record payments automatically. QR bulletins are of the non-reference type. It is not possible to use a QR-IBAN account. It can only be used with an IBAN account.You manually enter the data into Banana Plus.Associations or people starting from scratch and need to keep user data and create QR invoices:.Insert them into Banana Plus with copy-paste.Associations or people who already have all invoice data in Excel and need to create QR invoices:. ![]() Use the ready to fill-in template for entering invoice data.Have the Advanced Plan of Banana Accounting Plus.Download and install Banana Accounting+ (version 10.1.7 or later).This extension allows you to create Swiss QR invoices for multiple recipients with the possibility of inserting a customised letter text. The Extensions are additional programs that extend the functionalities of Banana Accounting Plus. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |