This invoice layout allows you to change the print settings via the Settings dialogue. The settings are similar to the UNI11 layout with the added option of printing the Swiss QR Code.

See also:

• General Information on Customising Invoice
• Estimates and invoices
  • Print Estimates and Invoices.
  • How to customise your invoice
• Invoices in accounting
  • Print Invoices.
  • How to print invoices integrated into accounting.

Invoice Settings Dialogue

To access the invoice parameter settings dialogue, you have two possibilities:

• From the Print Invoice dialogue, Layout section, Settings button.
  • Print Invoices dialogue for invoicing integrated into accounting.
  • Print Invoices dialogue for the Estimates and Invoices application.
• From the Print Preview, by clicking on the cogwheel symbol (settings).

The dialogue is composed of several levels and sub-levels that allows you to operate on a specific part of the invoice:

• Print
   The elements that make up the invoice print, with the possibility of customising them.
• Texts
  The texts, in the different languages, which are used for printing.
• QR-Code
• The settings for printing the Swiss QR-Code.
• Styles
  Change font and colours.
• Programming (own JavaScript file)
  It is an even higher level of customization, but it requires programming knowledge.
  You can change or replace the different printing elements by programming your own JavaScript file.

The Restore Defaults button in the dialogue resets all settings to the default values. Confirming with OK confirms and saves the parameters entered.
You can undo and restore changes made to parameters with the command Menu → Edit → Undo operation.

 Print Property

This level defines which elements of the invoice to include and which to exclude from the invoice printing.

It is divided into several sub-levels that allow you to manage a different element of the invoice.

Header

Dialogue element that allows you to define the header on the top of the invoice page.

• Page header.
  Check the box to include the sender's address in the invoice header.
  The address is automatically taken from the basic data of the file, defined in File → File and accounting properties → Address.
  The VAT number is mandatory and must be entered in the appropriate field.
• Line 1 text ... Line 5 text.
  If you do not wish to use the basic address data, you can enter the texts you wish to use manually.
  These texts will be displayed in the header and replace any texts defined in the file properties.
  In this case the VAT number is not automatically printed. Remember to add the VAT number in one line as it is mandatory.
• Logo.
  Check to include the logo in the header.
  The logo is defined with the command File → Logo setup where you can also set the size, choose how to align it (left, centre, right), and also choose how to align the address with respect to the logo.
• Logo name.
  Enter the name of the logo customisation defined in the menu File → Logo setup, respecting upper and lower case.

Customer address

Element of the dialogue that allows you to set some parameters for the billing address.

The customer addresses are taken from the specific columns of the table, see Accounts → Address view for integrated invoicing, and from the Contacts table for the Estimates and Invoices application.

• Sender address text.
  Above the customer's address you can enter a line for the sender's address.
  Leave empty to use the address defined in File → File and accounting properties → Address or enter text manually.
  Enter <none> to not enter the sender line.
• Address composition.
  Decide how to compose the address. Enter the XML address column names in the order you prefer: for the integrated invoicing Accounts table (Address view), for the application Offers and Invoices Contact table. Each column name must be included between the signs '<' and '>'.
  You can display the XML name of each column with the command Columns setup, Settings tab.
  
  You may only use the following columns (other columns cannot be used):
  Prefix column (XML name = NamePrefix).
  Organisation Column (XML name = OrganisationName).
  First Name column (XML name = FirstName).
  Column Surname (Name XML = FamilyName).
  Street Column (XML name = Street).
  AddressExtra Column (XML name = AddressExtra).
  PostBox Column (XML name = POBox).
  PostalCode Column (XML name = PostalCode).
  Location Column (XML name = Locality).
  Region Column (XML name = Region).
  Country Column (XML name = Country).
  CountryCode column (XML name = CountryCode).
  EmailWork column (XML name = EmailWork).
  
  Some examples:
  • Include organisation name, address, postcode and location:
    <OrganisationName>
    <Street>
    <PostalCode> <Locality>
  • Include prefix, first name, last name, address, postcode and locality:
    <NamePrefix>
    <FirstName> <FamilyName>
    <Street>
    <PostalCode> <Locality>
  • Include extra address, post office box and country code:
    <OrganisationName>
    <NamePrefix>
    <FirstName> <FamilyName>
    <Street> <AddressExtra>
    <POBox>
    <CountryCode> - <PostalCode> <Locality>
• Align left.
  Check to print the address on the left, otherwise it will be printed on the right.
• Move horizontally.
  Enter a value in cm to move the customer's address to the right (positive value) or to the left (negative value).
• Move vertically.
  Enter a value in cm to move the customer's address down (positive value) or up (negative value).
• Shipping address.
  Only available for invoicing integrated in accounting.
  The shipping address is also printed.
  The shipping address is entered by means of the code :sadr in the TypeDoc column of the Transactions table to define the shipping address.

Information

Element of the dialogue that allows you to define which invoice information to include and which to exclude from the print (top left):

Integrated Invoicing:

• Invoice number / Credit note.
  Specified in the DocInvoice column of the Transactions table.
• Invoice date.
  Specified in the Date column of the Transactions table.
• Order number
  Specified in the DocType column of the Transactions table with code: ordn
• Order date
  Specified in the DocType column of the Transactions table with code:ordd
• Customer number
  Specified in the invoice transaction of the Transactions table.
• Customer VAT number.
  Specified in the VAT number column of the Accounts table, Other view.
• Customer fiscal number
  Specified in the Fiscal number column of the Accounts table, Other view.
• Invoice due date
  The due date of an invoice can be set up in different ways. For more information, see the Due dates and payment terms page.
• Page number
  The current page number.

Estimates and invoices application

• Invoice number / Estimate
  Specified in the Id column of the Invoices/Estimates table
• Invoice date.
  Specified in the Date column of the Invoices/Estimates table
• Order number
  Specified in the Order Nr of the create/edit invoice dialogue.
• Order date
  Specified in the order date of the create/edit invoice dialogue.
• Customer number
  Specified in the Contact Id column of the Invoice/Estimates table.
• Customer VAT number.
  Specified in the VAT number column of the Contacts table.
• Customer fiscal number
  Specified in the Fiscal number column of the Contacts table.
• Invoice due date
  Indicated in the Due Date column of the Invoices/Estimates table.
  The due date of an invoice can be set up in different ways. For more information, see Set the payment term.
• Page number
  The current page number.
• Customised fields
  Only with the Advanced Plan.
  Invoice section of the Invoice Dialogue are added.

Invoice Details

By invoice details we mean the table showing the items, quantities, prices and totals.

Predefined column compositions

Allows you to select the columns to be displayed in the invoice details directly from a list.
The list includes some predefined column compositions to choose from. Some of them require the Banana Accounting Plus Advanced Plan.

Select a pre-defined column composition from the list and confirm.
The values of the properties Column Names, Column Width, Title Alignment, Text Alignment of the Invoice Details section, and the property Invoice Details Column Names of the Text section, are set automatically by the programme.

Available from version 10.0.10.21348 or newer of Banana Accounting Plus.

Column Arrangement Logic

The columns to be displayed can be defined manually in this way:

• In the column names you indicate the XML names of the columns to be printed.
• In the subsequent fields, the print characteristics of the individual columns are indicated.
  • Column width.
  • Title alignment.
  • Text alignment.
• In the section Texts you indicate the column header texts.
  • For each language, the text for the header must be indicated.

If you select a default Columns setting, all elements are changed automatically.

Valid for all elements

• Elements are separated by ';' and must be the number of the defined columns.
• If one of these elements is left blank, the default values are taken over.

Column Names

Manually indicate which columns to display in the invoice details.
Enter the XML names of the columns in the Transactions table. You can display the XML name of each column with the command Columns setup, Settings tab. Separate column names with a ';' (semicolon).

The default columns are:

• For invoices integrated in accounting:
  • Number (item Id)
    This applies both to the Id column of the Item table in the Estimates and Invoices application, and to the Item column of the Transactions table in the Integrated Invoicing.
  • Description
  • Quantity
  • ReferenceUnit
  • UnitPrice
  • Amount
  • VatRate
• Plus for the invoice offer application:
  • Date
  • Discount

With the Advanced Plan of Banana Accounting Plus, you can add other table columns in addition to the predefined columns.

• Transactions table.
  • Only for invoices integrated in accounting.
  • The syntax to use is T.ColumnName.
    "T." indicates that this is a column of the Transactions table, "ColumnName" is the XML name of the column (e.g. "T.Notes", "T.DateWork", etc.)
• Items table.
  • The syntax to be used is I.ColumnName.
    "I." indicates that it is a column of the Items table, "ColumnName" is the XML name of the column (e.g. "I.Links", etc.).

Column Width

Enter the width of each column with a percentage value. Each value defines how much space a column occupies in relation to the total width of the page. The sum must be 100%.
Separate column widths with a ";" (semicolon).

Title Alignment

Enter the title alignment for each column. You can align the text to the left, centre and to the right. Separate each alignment with a ";" (semicolon).

Text Alignment

Enter the text alignment of each column. You can align the text left, centre and right. Separate each alignment with a ";" (semicolon).

Gross amounts (including VAT)

You can decide whether to use gross amounts including VAT or net amounts excluding VAT.

Printing additional descriptions

Only available for invoicing integrated in accounting.
You can decide whether you want to enter additional descriptions on several rows.

• In the Transactions table with the Columns setup command add one or more additional description columns.
  For each additional description row you need to add an appropriate column.
  Create columns of type Text with the name "Description" followed by a number (e.g., Description1, Description2, Description3, etc.).
  The "XML name" of each column must begin with the word "Description" (in English) followed by a number.
  In the "Name" field you can enter whatever you want.
  
  
   
• In these columns enter additional text for invoice descriptions.
  The text in each column will be displayed on a new line in the invoice description.

Some examples

• Include the columns Description, Quantity, Unit, Unit Price and Amount:
  • Description;Quantity;ReferenceUnit;UnitPrice;Amount
    50%;10%;10%;15%;15%
    center;center;center;center;center
    left;center;center;right;right
• Include only the Description and Amount columns:
  • Description;Amount
    70%;30%
    center;right
    left;right
• Include the columns Description, Notes and Amount. Notes is not a default column, the name must be preceded by 'T.'. Requires the Banana Accounting Plus Advanced Plan.
  • Description;T.Notes;Amount
    35%;35%;30%
    left;left;right
    left;left;right
• Include the columns Description, DateWork, Quantity, Unit Price and Amount (DateWork is a manually created column, the name must be preceded by "T."). Requires the Advanced Plan of Banana Accounting Plus.
  • Description;T.DateWork;Quantity;ReferenceUnit;UnitPrice;Amount
    35%;15%;10%;10%;15%;15%
    left;center;center;center;right;right
    left;center;center;center;right;right
• For Estimates and Invoices application: include the columns Number, Date, Description, Quantity, Unit, Price, Discount and Amount.
  • Item;Date;Description;Quantity;ReferenceUnit;UnitPrice;Discount;Amount
    10%;10%;50%;10%;10%,10%;15%;15%
    left;left;left;right;right;right;right;right
    left;left;left;right;right;right;right;right

Footer

Dialogue element that allows a footer to be inserted.

The footer can only be included if the QR code is excluded from printing. When the QR code is included, the footer is automatically excluded from printing.

• Print footer.
  Indicates whether to include the footer, which consists of three columns (see the chapter "Text properties" below).
• Print separating border.
  Indicates whether to include the border on the top of the footer.

Texts Property

This level defines all invoice texts, which are grouped and divided by language.

Languages

You can change the texts to be used for each language and also add translations for other languages.

The language to be used is chosen according to the language specified for the customer:

• For integrated invoicing, it is defined in the Accounts table, Address view, Language column.
• For the application Estimates and Invoices, it is defined in the Contacts table, Language Code column .

If no language is indicated for the customer, the default accounting language is used.

The default languages for which a complete translation exists are: German, English, French and Italian.

The first language to appear in the dialogue is always the current language of the file, defined in File > File and accounting properties > Other. The rest are listed in alphabetical order.

Define languages

• Default values: de;en;fr;it
• Enter the list of languages using the two-character codes.
  • de = German
  • en = English
  • fr = French
  • it = Italian
• Separate the language codes with a ";" (semicolon).

Add languages

• In the language field, at the end, add the new language code for the language you want to use.
  For example if you want to use Spanish language add ";es" at the end of the existing language codes (e.g. "de;en;fr;it;es").
  Always use the ";" (semicolon) to separate the language codes.
• Click on Ok.
• The Settings dialogue closes to apply the changes.
• Reopen the Settings dialogue.
• In the Texts section, there is now a new section with the name of the language code you have entered (e.g. "es"). 
  This new section contains all the texts described in the paragraph Text section for each language.
  At first, all texts are in English.
• In the right side, replace all existing english texts with the correct translations for the new language you added.
  Do not replace texts between “<” and “>” because they are used by the program (e.g. "Factura <DocInvoice>").
• Click on Ok and print the invoice.

Remove languages

• In the language field delete the code of the language you want to remove.
• Click on Ok.
• Confirm with Yes to remove the language and its texts from the list.
• Reopen the Settings dialogue. Now the language section has been removed.

Text section for each language

Each language has its own section starting with the language code.
You can change the text to be used for each individual language.
If you delete the content, when you confirm with Ok, the default text will be automatically used.

• Invoice number.
  Text in the information preceding the invoice number.
• Invoice date.
  Text in the information preceding the invoice date.
• Invoice order.
  Text in the information preceding the order number.
• Order date.
  Text in the information preceding the order date.
• Customer number.
  Text in the information preceding the customer number.
• Customer VAT number
  Text in the information preceding the customer's VAT number.
• Customer tax number.
  Text in the information preceding the customer's tax number.
• Invoice due date.
  Text in the information preceding the invoice due date.
• Page number.
  Text in the information preceding the page number.
• Shipping address.
  Text appearing above the shipping address.
• Invoice title.
  Optional text inserted before the details table.
  Enter <none> to display no text.
• Credit note title.
  Optional text inserted before the table of details.
  Enter <none> to display no text.
• Begin text.
  Optional text, on one or more lines, inserted immediately after the invoice title.
• Invoice detail column names.
  Must be separated by a ';' (semicolon).
  When changing the columns to be displayed in the invoice (section Print, Invoice details, Column names), you must always also adapt the texts for the column headings.
• Invoice total.
  Text that appears in the invoice total line.
• End text
  Optional text, on one or more lines, inserted at the end of the invoice.
  This text takes priority over text added from the dialogue Print invoices → Options → End text.
• Left/centre/right footer text.
  The <Page> code is replaced with the page number.
  Enter <none> to display no text.

Specific texts for printing Proforma invoices, Estimates, Delivery notes, Order confirmations and Reminders (requires Advanced Plan):

• Proforma invoice
  • Title.
    Optional text inserted before the details table. Enter <none> to display no text.
  • Begin text.
    Optional text, on one or more lines, inserted immediately after the proforma invoice title.
  • Final Text.
    Optional text, on one or more lines, inserted at the end of the proforma invoice.
• Estimate
  • Number.
    Text in the information preceding the estimate number.
  • Date.
    Text in the information preceding the estimate date.
  • Validity.
    Text in the information preceding the estimate validity date.
  • Title.
    Optional text inserted before the details table.
  • Begin text.
    Optional text, on one or more lines, inserted immediately after the estimate title.
  • Final text.
    Optional text, on one or more lines, inserted at the end of the estimate.
• Delivery note
  • Delivery note number.
    Text in the information preceding the delivery note number.
  • Delivery note date.
    Text in the information preceding the date of the delivery note.
  • Title.
    Optional text inserted before the details table. Enter <none> to display no text.
  • Begin text.
    Optional text, on one or more lines, inserted immediately after the delivery note title.
  • End Text.
    Optional text, on one or more lines, inserted at the end of the delivery note.
• Order confirmation
  • Order Confirmation Number.
    Text in the information preceding the order confirmation number.
  • Order Confirmation Date.
    Text in the information preceding the date of the order confirmation.
  • Title.
    Optional text inserted before the details table. Enter <none> to display no text.
  • Begin text.
    Optional text, on one or more lines, inserted immediately after the title.
  • Final text.
    Optional text, on one or more lines, inserted at the end of the order confirmation.
• Reminder
  • Invoice date (only for integrated invoicing in the accounting file).
    Text in the information preceding the invoice date.
    Used if there is the transaction with the reminder date created via the Reports > Customers > Print reminders command.
  • Date  (only for integrated invoicing in the accounting file).
    Text in the information preceding the reminder date.
    Used if there is the transaction with the reminder date created via the Reports > Customers > Print reminders command.
  • Due date  (only for integrated invoicing in the accounting file).
    Text in the information preceding the reminder due date.
    Used if there is the transaction with the reminder date created via the Reports > Customers > Print reminders command.
  • Title.
    Optional text inserted before the details table. Enter <none> to display no text.
  • Begin Text
    Optional text, on one or more lines, inserted immediately after the reminder title.
  • Final Text.
    Optional text, on one or more lines, inserted at the end of the reminder.

Bold writing

With a specific annotation you can apply the bold style to certain texts. To do so, include the desired texts between double asterisks ** .

Applicable to:

• Start text.
• End text.
• Descriptions of items appearing in invoice details.

Examples:

**text** = text
**text1 text2**, text3 = text1 text2, text3

Customise title, begin text and final text

The data for the title, begin text and final text are taken over and inserted automatically with every new invoice.

If you also want to include customer information (first name, last name, etc.) or the invoice number in these texts, you can do so:

• With the Professional Plan the data must be entered manually each time you create an invoice.
• With the Advanced Plan you can automate data entry on all invoices.

For automated data entry (only with the Advanced Plan) you must use the predefined columns from which the data is taken:

• Customer Address Columns
  • In integrated invoicing, from the Accounts table, Address view.
  • In the Estimates and Invoices application, from the Contacts table.
• Invoice number column
  • In integrated invoicing, from the Accounts table, Invoice column.
  • In the Estimates and Invoices application, from the Invoices table, column Invoice Id.

In the texts you must insert the following columns, specifying the XML name of the columns between the signs '<' and '>'.

• Address
  • <NamePrefix>, <OrganisationName>, <FirstName>, <FamilyName>, <Street>, <AddressExtra>, <POBox>, <PostalCode>, <Locality>, <Region>, <Country>, <CountryCode>, <EmailWork>.
• Invoice number
  • <DocInvoice>.
    In this case DocInvoice is used both for integrated invoicing and for the Estimates application and invoices.

To display the XML name of each column, use the command Columns setup, Settings section.

When the invoice is created, these texts are replaced with the actual values.

• The text "Invoice <DocInvoice>" is converted to "Invoice 10".
• The text "Invoice <DocInvoice>, <FirstName> <FamilyName>" is converted to "Invoice 10, James Johnson".

Styles Properties

This level defines the parameters that affect the visual appearance of the invoice, like font type, size and colors.

Font type and size

The font and font size are applied to all invoice texts, with the exception of the header, which has a fixed size that can only be changed with custom CSS Stylesheet.

The size of the title and the total line are resized according to the chosen font size.

For more information regarding the font that can be used and exporting to PDF, please see the Create PDF page.

Colours

Enter the colours you wish to apply to the invoice printout.

• Text Colour.
  The colour applied to all text on the invoice: header, information, address, start text, invoice details, end text, footer.
  The colour of the QR bulletin cannot be changed.
• Header details background colour.
  The main colour of the invoice. It is applied to: title, invoice details header, horizontal lines, total line and double underline.
• Details header text colour.
  The colour of the text in the column headings of the invoice details table.
• Background colour for alternating rows.
  The background colour applied to the rows of the various invoice items.
• Title and total colour.
  The colour of the title and total line (text and underline).

To enter a colour you have two possibilities::

• Select a color from those available.
• Enter the hexadecimal code of the colour (HEX). This is a code starting with # followed by six characters (e.g. #0000, #009FE3, #FF00EA).
  Colour codes are easily found on the Internet. For example, you can consult the table at https://www.w3schools.com/cssref/css_colors.asp.

If no colour is entered (leaving the field empty), the default colour is set. Applies to every colour field. This is useful if you want to reset to the original colours.

Integrated Invoicing Texts

n integrated invoicing, certain texts can also be defined in the Transactions table when entering invoice data.

• Invoice title / credit note.
  • Enter in the column TypeDoc the command 10:tit (12:tit for credit note).
  • Enter the desired text in the Description column.
  • It takes priority over any text defined in the settings of the invoice layout. 
• Begin text.
  • Enter in the column TypeDoc the command 10:beg.
  • Enter the desired text in the Description column.
  • Only one line of text can be entered.
  • It takes priority over any text defined in the settings of the invoice layout.
• Notes.
  • In the column TypeDoc enter the command 10:not.
  • Enter the desired text in the Description column.
  • Several lines of notes can be entered. Each note must be defined on a new line in the table Entries.
• Greetings.
  • Enter the command 10:gre in the column TypeDoc.
  • Enter the desired text in the Description column.
  • Only one line of greetings can be entered.

Priority Title and Begin Text:

Priority Final Text:

Error messages

• @error Text names and columns do not match.
  The number of columns of the invoice details table (Print → Invoice Details → Column names) do not match with the texts to print (Texts → language code → Column names invoice details). Check the invoice settings.

This page explains how to set up printing of the Swiss QR-Code on invoices and also refers to technical information on customisation possibilities, use of address formats and more.
For technical specifications please refer to the QR-Code References and Standards.

QR Section

In the Invoice settings there is a special section for data entry for the QR section printing.

• To print the QR on the invoice you must check the "Print QR Code" box.

There is then a very important choice to be made. The QR-Code system has two main modes depending on the type of account you want to use. In the Reference Type you have to indicate the system you want to use .

• Print QR-bills with the IBAN account.
  You can immediately start printing invoices with the QR. The bank statement will show the account number of the customer and the invoice. In this way you will have immediate and automated control of payments.

• Print QR-bills with the QR-IBAN account.
  If you want an ISR-compatible system or if you want your invoice payment data to be received in a different data file than the account statement.

   Your bank must give you a QR-IBAN account number and the individual payment data will not appear on the normal account statement, but on a separate one.

Then follow the available settings regardless of the chosen QR Reference Type.

Addresses

• Address payable to
  The program sets the address of the recipient of the payment using the address data in the File properties (from the File menu). In this case the address it is a combined (K) address type.
• You can indicate another address, by completing the fields in the Payable to section. In this case the address it is a structured (S) address type.
• For further information please refer to the paragraph Technical information.
• Customer address type.
  Select the type of address to use, structured (S) or combined (K).
  For further information please refer to the paragraph Technical information.

The addresses in the "Payable to" and "Payable by" sections of the QR must always contain either the name of the organization or the first name and last name.
The name of the organization has priority over the name / last name: if it is present then the name of the organization will be entered, otherwise the name / last name will be entered.
Entering both is not possible as the rows are limited and each row must contain precise information.
The address structure is as follows:

• organization name or first / last name
• street and house number
• postal code and city

The addresses in the "Payable to" and "Payable by" sections of the QR follow the rules of the Swiss QR standard.
It is not possible to add rows or change the composition of the addresses on the QR.

Include / exclude from printing

Include additional information (XML column name )
You can enter additional invoice information to be displayed on the QR Bulletin in the 'Additional Information' section.

In the Invoice settings dialogue → QR section → Include additional information, enter the XML name of the column used from where the additional information is taken.
See how to display XML column names.
See how to add new columns.

• Integrated invoicing
  In the Transactions table, add a new column where the additional information is to be entered, or use an existing column such as the Notes column.
  
  
   
• Estimates and Invoices application
  In the Invoices table add a new column where you can enter additional information, e.g. Info.
  Do not use the Notes column as this is used to display the final text of the invoice.
  
  
   
• Include billing information (optional).
  Add automatically generated structured billing information.
  If present, they are added after the additional information (see previous point).
• Exclude invoice address.
  Exclude the customer's billing address and leave an empty box to enter the address by hand.
• Exclude invoice amount.
  Exclude the invoice amount and leave an empty box to enter the amount by hand.
  To be used when the customer can choose the amount to be paid.
  

QR section print format

• QR on separate page.
  Print the payment and receipt sections of the QR-bill on a separate page.
  This way there is more space for the invoice.
• Separation border print.
  Print a dashed separation border to separate the invoice from the payment and receipt sections.
• Print scissors symbol.
  Print the scissors symbol on the separating border.
• QR X position and QR Y position (optional).
  Change the horizontal and vertical position of the QR Code section - usually there is no need to change the default values.

Other information

• The addresses that appear on the payment and receipt sections must contain:
  • Name and surname or company name (the company name has priority in case both are defined).
  • Address.
  • Postcode and town.
  • Country code (is not on the print but is included in the QR code).
• The country code is a two-character code according to the specifications of the ISO 3166-1 standard (eg CH, LI, AT, DE, IT, FR).
  • The country code of the invoice sender can be set via File → File and accounting properties → Address section, Country field.
  • The customer's country code is set in the Country Code column of the Accounts table, Address view.

Technical information

In the QR Code the addresses of the issuer of the invoice and the customer can be of two types: combined or structured.
The type defines how the address data is represented within the QR code image.

Normally the combined type address (K) is used. However, in some cases it's possible to use the structured address type (S) because the bank may require it.

Regardless of the type chosen, the printing of the address on the receipt and payment section of the QR, will be the same.

• Combined address (K).
  • This is used by default.
  • The elements of the address are combined and inserted in maximum 4 fields of the QR code.
  • The combined address is composed as follows:
    • Field 1: Company name or customer name and surname (maximum 70 characters).
    • Field 2: street and house number, P.O. box (maximum 70 characters).
    • Field 3: postal code and city (maximum 70 characters).
    • Field 4: country code (two-character code according to the specifications of the ISO 3166-1 standard).
  • When printing on the invoice, the address structure is as follows:
    • organization name or first / last name
    • street and house number
    • postal code and city
• Structured address (S).
  • The address elements are divided and inserted in maximum 6 fields of the QR code.
  • The structured address is composed as follows:
    • Field 1: company name or customer name and surname (maximum 70 characters).
    • Field 2: street and P.O. box (maximum 70 characters).
    • Field 3: house number (maximum 16 characters).
    • Field 4: postal code (maximum 16 characters).
    • Field 5: city (maximum 35 characters).
    • Field 6: country code (two-character code according to the specifications of the ISO 3166-1 standard).
  • When printing on the invoice, the address structure is as follows:
    • organization name or first / last name
    • street and house number
    • postal code and city

Here is the summary schema taken from the standard format documentation on page 35.  On page 29, the details of the address sections.

Issuer address (beneficiary)

The address can be of two types:

• Combined address (K).
  • The address is taken from File → File and accounting properties → Address.
  • Use the Address1 field to enter the street and house number.
  • In the Invoice settings, the section QR Code → Payable to must be unchecked.
• Structured address (S).
  • The address is taken from the Invoice settings, section QR Code → Payable to.
  • In the Invoice settings check the Payable to box and enter the address data in the fields below.
    
    

Customer address

The address can be of two types:

• Combined address (K).
  • The address is taken from the Accounts table → Address view.
  • Use the Street column to enter street and house number.
    
    
     
  • In the Invoice settings, section QR Code → Customer address type, select K.
• Structured address (S).
  • The address is taken from the Accounts table → Address view.
  • Use the Street column to enter the street only.
  • Use the Address Extra column to enter the house number (use the command Data → Columns setup to display the column if it is hidden).
    
    
     
  • In the Invoice settings, section QR Code → Customer Address Type, select S.

Printing and sending in paper format

The QR-invoice can be printed and sent in paper format. To do so, it is necessary to use a special perforated sheet of white paper.

Testing QR-Code

The invoice PDFs with QR codes can be tested with the official validation page as described below:

• Create and save the QR invoice PDF.
• Visit the official validation page https://www.swiss-qr-invoice.org/validator
• Drag the PDF file to the blue area.

If the code is correct, the page will display the content of the QR code. On the other hand, if there are any problems, they will be displayed in red.

If no red messages are shown, the QR is considered correct (see example below).

The following advanced customization features require the Advanced Banana Accounting Plus plan.

Advanced layout customisation (with programming)

The CH10 layout can be customised with specific programming.

• Programming in Javascript
  • You can further customise the printout by creating functions that replace the default ones, for printing the header, addresses, details, text and footer.
• Creation of CSS styles
  • You can tailor your printing even more with the creation of custom styles so that you can change the appearance of the invoice (text formatting, positioning of elements, etc.).

Creating your own print layouts

• Customisation by creating your own customised layout.
  • Requires programming in Javascript.
  • You can use the existing layout and modify it as desired.

The Banana invoice is constructed with a Javascript program. The Extension also allows you to add Javascript programming so that you can completely customize the content and format of the invoice (this functionality requires the Advanced plan).

See more about Banana Accounting API Extensions Reference.

Add your custom Javascript file

Three steps are required to define and use your Javascript file:

1. Add the document table to the Banana Accounting file.
   If it is not already present you need to add the Documents table in the Banana document with the menu command Tools > Add new features > Add document table.
2. Add a new Javascript type document to the document table.
   1. In the ID column enter the file name including the extension .js (e.g. "myFile.js").
      If the id is missing the ".js" at the end, it won't work.
   2. In the Description column enter a comment (optional).
   3. In the Attachments column, double click on the cell or select the edit symbol, then select Javascript Code and confirm with OK.
   4. An editor will open in which you can write the code.
   5. Delete everything in it.
   6. Insert the Javascript code. You can modify the content at any time.
      
      
      Documents table - Javascript Code attachment
       
3. Tell the invoice layout to use the customized Javascript attachment file.
   1. Select Settings of the Print invoices dialogue.
   2. In the Javascript/CSS > JS file name, enter the name of the newly created Javascript attachment file with the extension ".js" at the end (e.g. "myFile.js").
   3. Click Ok to confirm.
      
      
      Settings Dialogue - Javascript File Property

Javascript Hook Replacement Functions

The invoice layout is created with a set of predefined Javascript functions.

The hook functions are Javascript replacements functions to be used instead of the the predefined.

The hook functions should be defined in the ".js" file of the Documents table.

• The name of the hook function is the name of the predefined function used in the layout, preceded by the text "hook_".
  For example, if you want to change the header printing you have to define the hook_print_header() that will replace the predefined print_header() function.
  • The parameters must be the same as those used in the main function.
  • If you create your own hook function, it is necessary to know how it works the function you want to replaces.
• When generating the invoice, the layout extension checks for the existence of a hook replacement function and, if available, utilizes it to substitute the predefined function.
• Hook functions let you selectively change some part of how the invoice is build, without directly modifying the original script of the invoice Layout.

Graphic explanation of the Hook functions

With the hook functions, you can customize the following sections of the invoice.

(1) hook_print_header()

Function that prints the header part of the invoice (logo and texts).

(2) hook_print_info_first_page() and hook_print_info_other_pages()

Functions that print the information parts of the invoice.

(3) hook_print_customer_address()

Function that prints the customer address part of the invoice.

(4) hook_print_shipping_address()

Function that prints the shipping address part of the invoice (in case it exists).

(5) hook_print_text_begin()

Function that prints the title and begin text parts of the invoice.

(6) hook_print_details_net_amounts() and hook_print_details_gross_amounts()

Functions that print the invoice details using net/gross amounts.
Use the hook_formatItemsValue() function to change the format and style of the items.

(7) hook_print_final_texts()

Function that prints the final texts, notes and greetings parts of the invoice, right after the invoice details.

(8) hook_print_footer()

Function that prints the footer at the bottom of the page (usable only when not printing the QR slip).

List of Hook functions

This file contains all the available hook functions with their parameters and an empty function body, that should be replaced with your implementation. 

• See examples of invoice customization.
   

// Function used to set all the variable values used by the invoice layout script
function hook_set_variables(variables, userParam) {...}
// Function used to print the header at the top of the page (logo and text address)
function hook_print_header(repDocObj, userParam, repStyleObj, invoiceObj, texts) {...}
// Function used to print the invoice information on the first page
function hook_print_info_first_page(repDocObj, invoiceObj, texts, userParam) {...}
// Function used to print the invoice information from page 2 onward
function hook_print_info_other_pages(repDocObj, invoiceObj, texts, userParam) {...}
// Function used to print the customer address
function hook_print_customer_address(repDocObj, invoiceObj, userParam) {...}
// Function used to print the shipping address
function hook_print_shipping_address(repDocObj, invoiceObj, texts, userParam) {...}
// Function used to print the text before the invoice details (title and begin text)
function hook_print_text_begin(repDocObj, invoiceObj, texts, userParam) {...}
// Function used to print the invoice details using net amounts (VAT excluded)
function hook_print_details_net_amounts(banDoc, repDocObj, invoiceObj, texts, userParam, detailsTable, variables) {...}
// Function used to print the invoice details using gross amounts (VAT included)
function hook_print_details_gross_amounts(banDoc, repDocObj, invoiceObj, texts, userParam, detailsTable, variables) {...}
// Function used to print the text after the invoice details (notes, greetings, etc.)
function hook_print_final_texts(repDocObj, invoiceObj, userParam) {...}
// Function used to print the footer at the bottom of the page. Usable only when not printing the QR slip part.
function hook_print_footer(repDocObj, texts, userParam) {...}
// Function used to format the value and set the className of the item
function hook_formatItemsValue(value, variables, columnName, className, item) {...}
// Function used to modify the QR settings
function hook_modify_settings_qr(invoiceObj, qrcodeData) {...}

Examples of a hook functions 

Within your hook function you can call the original hook function. This way you can limit the changes to the code.
For example this hook function call the original one, only in a specific case.

/** 
 * This function prints the final text only for INVOICES and not for CREDIT NOTES.
 * Invoices = DocType 10
 * Credit notes = DocType 12
 */
function hook_print_final_texts(sectionClassFinalTexts, invoiceObj, userParam) {
   // We can check the DocType and print the text only when is not 12
   if (invoiceObj.document_info.doc_type !== "12") {
      print_final_texts(sectionClassFinalTexts, invoiceObj, userParam);
   }
}

Predefined variables

The predefined variables are the default used by the invoice layout script.

The variables for decimals start with "decimals_". (decimals_quantity, decimals_unit_price, decimals_amounts).

The variable that start with "$" are template variable that you can use in the CSS styles ($font_family, $font_size, $text_color, ...).
Example of an extract of the predefined CSS invoice layout.

body {
  font-family: $font_family;
  font-size: $font_size;
  color: $text_color;
}

List of all predefined variables and their default values that you can override with the hook_set_variables() function:

/* Variable that sets the decimals of the Quantity column */
variables.decimals_quantity = "";
/* Variable that sets the decimals of the Unit Price column */
variables.decimals_unit_price = 2;
/* Variable that sets the decimals of the Amount column */
variables.decimals_amounts = 2;
/* Variables that set the colors */
variables.$text_color = userParam.text_color;
variables.$background_color_details_header = userParam.background_color_details_header;
variables.$text_color_details_header = userParam.text_color_details_header;
variables.$background_color_alternate_lines = userParam.background_color_alternate_lines;
variables.$color_title_total = userParam.color_title_total;
/* Variables that set the font */
variables.$font_family = userParam.font_family;
variables.$font_size = userParam.font_size+"pt";
/* Variables that set the font size and margins of the Invoice Begin Text */
variables.$font_size_title = userParam.font_size*1.4 +"pt";
/* Variables that set font size, margins, padding and borders of the Invoice Details */
variables.$font_size_header = userParam.font_size*1.2 +"pt";
variables.$font_size_total = userParam.font_size*1.2 +"pt";
/* Variables that set the position of the invoice address
 * Default margins when the address on right: 12.3cm margin left, 4.5cm margin top
 * Default margins when the address on left: 2.2cm margin left, 5.5cm margin top
 * Sum userParam dX and dY adjustments to default values */
variables.$right_address_margin_left = parseFloat(12.3) + parseFloat(userParam.address_position_dX)+"cm";
variables.$right_address_margin_top = parseFloat(4.5) + parseFloat(userParam.address_position_dY)+"cm";
variables.$left_address_margin_left = parseFloat(2.2) + parseFloat(userParam.address_position_dX)+"cm";
variables.$left_address_margin_top = parseFloat(5.5) + parseFloat(userParam.address_position_dY)+"cm"; 

Example of 'hook_set_variables' function

You can overwrite the predefined variable with the hook_set_variables() function. 
Only use the variable that you want to replace. 

// Example of hook function usage that sets
// the decimals of the Amounts columns to 4
// the font type to Times New Roman
function hook_set_variables(variables, userParam) {
   variables.decimals_amounts = 4;
   variables.$font_family = "Times New Roman";
}

Banana invoices are formatted through a CSS Stylesheet. The extension allows you to use a customized stylesheet so you can fully modify the appearance of the invoice (this functionality requires the Advanced plan).

Following you will find information and examples that let anyone understand the basic of the CSS so that you are able to do a lot of customization to your invoice, even if you are not a CSS professional.

• See also the page CSS Examples. 

Banana CSS Stylesheet file

The CSS file property let you specify an CSS stylesheet file to be used for formatting the invoice. You have to enter the name of a CSS document, contained in the Documents table.

The properties you define in the custom CSS file will extend or overwrite the styles of the default stylesheet.

Cascading Style Sheet (CSS) is a specification language that allows to customize the appearance of web pages, and a subset of the whole CSS specification is also used in Banana to prepare reports. 
Here are some basics about CSS Stylesheet formatting.

• The document, in our case the invoice, is composed by a series of Elements that contains all the data of the invoice.
• Each element can have one or more class properties that specify which style should be used for that element.
• Each element can contain other elements.
• In the CSS stylesheet you specify the formatting properties of each class of style.
• The elements hynnerit the styles of the parent element.
• The main element for the invoice is the Document.

Add your custom CSS stylesheet

Three steps are required to define and use your CSS file:

1. Add the document table to the Banana Accounting file.
   If it is not already present you need to add the Documents table in the Banana document with the menu command Tools > Add new features > Add document table.
2. Add a new CSS type document to the document table.
   1. In the ID column enter the file name including the extension .css (e.g. "myStyle.css").
      If the id is missing the ".css" at the end, it won't work.
   2. In the Description column enter a comment (optional).
   3. In the Attachments column, double click on the cell or select the edit symbol, then select CSS stylesheet and confirm with Ok.
   4. An editor will open in which you can write the code.
   5. Enter or edit the script and confirm with Ok.
   6. Save the Banana Accounting file.
      
      
      Documents table - CSS stylesheet attachment
       
3. Specify the CSS file created in the invoice layout extension.
   1. Select Settings of the Print invoices dialogue.
   2. In the Javascript/CSS > CSS file name, enter the name of the newly created CSS attachment file with the extension ".css" at the end (e.g. "myFile.css").
   3. Click Ok to confirm.
      
      
      Settings Dialogue - CSS File Property

Syntax of a CSS stylesheet

The syntax of the CSS is quite simple as you see in this style definition that set the size of the Invoice title text element to 14 points and without bold.

/* this two lines are comment 
   title_text is for the invoice number */
.title_text {
  font-family: Arial;
  font-size: 14;
  font-weight: normal;
  color: #6495ED;
}

Syntax rules:

• Element are case sensitive.
• You specify the style name ".title_text" starting with a dot (".") and followed by the  curly open bracket "{".
  • Property name, followed by the colon ":"
  • Values followed by the semicolon ";"
  • You can have has many allowed properties you need.
• End with the curly close bracket "}".
• You can have has many allowed style classes.
• The defined values overwrite the predefined one.

Comments:

• Add comments to the css by including the text within a /*    comment */,
  It help you remember the purpose of the code.
  See the comments in the predefined CSS for explanations of the elements.

Most used properties

Font

• font-family
  Specify the font name.
• font-size
  Specify the font size in points.
• font-weight
  Specify the font weight: normal, bold or value between 1-1000.

Text alignment

• text-align
  Specify the horizontal alignment of the text.
  It is used for example to align on the right of the cell all the amounts of the invoice (i.e. "text-align: right").

Colors

For the main colors you can use the name in English (black, yellow, white, blue, red, ...) or the hexadecimal values (HEX) preceded by the # sign (e.g. #000000, #009FE3, #FF00EA).
For codes see the table at https://www.w3schools.com/cssref/css_colors.asp.

• color
  Define the color of a text.
• background-color
  Define the background color of an element.
  It is used for example to set the background color of the header row of the invoice details.

Positioning

All elements in the invoice are positioned relative to the prior element. You can change the positioning.

• margin
  • margin-top
    To set the margin on the top of the element.
  • margin-right
    To set the margin on the right side of the element.
  • margin-bottom
    To set the margin on the bottom of the element.
  • margin-left
    To set the margin on the left side of the element.
    It is used for example in case it is required to move an element a bit to the right. More margin on the left means move the element to the right.
• padding
  • padding-top
    Sets the height of the area on the top of an element.
  • padding-right
    Sets the width of the area on the right of an element.
  • padding-bottom
    Sets the height of the area on the bottom of an element.
  • padding-left
    Sets the width of the area on the left of an element.

/* For example it is used for the details table, to avoid that
all the texts are printed too close to the table border. */
.doc_table td {
  padding-top: 5px;
  padding-bottom: 1px;
  padding-left: 4px;
  padding-right: 4px;
}

Absolute positioning

Some elements are positioned relative to the begin of the document. The position of these elements does not depend on any other element in the document.

• postion
  •  For the logo, header text and address elements it is used the absolute positioning ("position: absolute").

Borders

To apply borders to tables and table rows.

• border-style
  Sets the line style for all four sides of an element's border.
  • border-top-style
  • border-right-style
  • border-bottom-style
  • border-left-style
• border-color
  Sets the color for all four sides of an element's border.
  • border-top-color
  • border-right-color
  • border-bottom-color
  • border-left-color
• border-width
  Sets the width for all four sides of an element's border.
  • border-top-width
  • border-right-width
  • border-bottom-width
  • border-left-width

/* For example use it to apply a double underline
 to the total line of the invoice. */
  .total_cell {
  border-bottom-style: double;
  border-bottom-color: #337ab7;
  border-bottom-width: 1px;
}

Display / Hide element

Set the attribute display to none to hide an element.  In this case the Invoice number is hidden.

.title_text {
   display: none;
}

Predefined CSS stylesheet

The Javascript layout create a document with elements that include a specific class, that is then positioned and formatted based on the CSS style definition.
If you want to add other styles class you have to modify the Javascript code by using the hook functions.

Here you can see the complete CSS stylesheet used for invoices documents.

• Some styles are initialized with the predefined values set by the users (value that begin with the $. 
  For example The $font_family is replaced with the font name family specified by the user or initialized with the Javascript variable initialization function.
• Test starting with /* and ending with */ are comments

/* Page definition.
   Sets margins of the document.
   Each elements of the invoice is positioned relative to these margins. */
@page {
  margin-top: 0cm;
  margin-bottom: 0cm;
  margin-left: 0cm;
  margin-right: 0cm;
}
/* Properties for all the content of the document.
   This values will be used for all elements, unless there is not a specific definition.
   Sets font family, font size and text color. */
body {
  font-family: $font_family;
  font-size: $font_size;
  color: $text_color;
}
/* Vertically align the content of a cell in a table. */
td {
  vertical-align: top;
}
/* Text that is right aligned. 
   This class is used in combination of others */
.right {
  text-align: right;
}
/* Text that is center aligned. 
   This class is used in combination of others */
.center {
  text-align: center;
}
/* Font that is bold. */
.bold {
  font-weight: bold;
}
/* The width of the area on the right of an element.
   This value is the space between an element and its border. */
.padding-right {
  padding-right: 20px;
}
/* The width of the area on the left of an element.
   This value is the space between an element and its border. */
.padding-left {
  padding-left: 20px;
}
/* The top border of an element.
   Sets the line style, the line color and the line width of the border. 
   Used for example as horizontal line between the items and the total net */
.border-top {
  border-top-style: solid;
  border-top-color: $color_title_total;
  border-top-width: thin;
}
/* Text of the header when printed on the right of the document.
   Sets margins and position relative to the document.
   When no logo is used, text alignment is set to right. */
.header_text {
  margin-top: 1.2cm;
  margin-left: 1.2cm;
  margin-right: 1.2cm;
  text-align: right;
  position: absolute;
}
/* Text of the row 1 of the header (if defined through Invoice settings).
   Sets bold and size 16 of the font. */
.header_row_1 {
  font-weight: bold;
  font-size:16pt;
}
/* Text of the row 2, row 3, row 4 and row 5 of the header (if defined through Invoice settings).
   Sets bold and size 10 of the font. */
.header_row_2_to_5 {
  font-weight: bold;
  font-size: 10pt;
}
/* Logo positioning.
   Sets margins and position relative to the document. */
.logo {
  margin-top: 1.2cm;
  margin-left: 1.34cm;
  margin-right: 1.2cm;
  position: absolute;
}
/* Text of the information table when printed on the left of the document.
   Sets font size and margins relative to the document and the prior element. */
.info_table_left {
  font-size: $font_size;
  margin-top: 4.5cm;
  margin-left: 1.2cm;
  margin-right: 1.2cm;
}
/* Text of the information table when printed on the right of the document.
   Sets font size and margins relative to the document and the prior element. */
.info_table_right {
  font-size: $font_size;
  margin-top: 5.5cm;
  margin-left: 12.3cm;
  margin-right: 1.2cm;
}
/* Text of the information table when printed on page 2 and above.
   Sets font size and margins relative to the document and the prior element. */
.info_table_row0 {
  font-size: $font_size;
  margin-top: 4.5cm;
  margin-left: 1.2cm;
  margin-right: 1.2cm;
}
/* Cells of the information table rows when printed on the left.
   Sets the space between the text in the cell and the cell border (top and bottom). */
table.info_table_left td {
  padding-top: 0px;
  padding-bottom: 0px;
}
/* Cells of the information table rows when printed on the right.
   Sets the space between the text in the cell and the cell border (top and bottom). */
table.info_table_right td {
  padding-top: 0px;
  padding-bottom: 0px;
}
/* Cells of the information table rows when printed on page 2 and above.
   Sets the space between the text in the cell and the cell border (top and bottom). */
table.info_table_row0 td {
  padding-top: 0px;
  padding-bottom: 0px;
}
/* Display the information table for pages 2 and above.
   For pages 2 and above it is used a different information table (.info_table_row0).
   This table is not displayed on first view of the document (page 1).
   On first page it is used the other one (.info_table_left or .info_table_right). */
@page:first-view table.info_table_row0 {
  display: none;
}
/* Can be used to set the column width of the first column of info table 
   width: 100px */
.info_table_first_column {
}
/* Can be used to set the column width of the second column of info table 
   width: 100px */
.info_table_second_column {
}
/* Address positioning when printed on the right.
   Sets margins and position relative to the document.
   Sets also the font size. */
.address_table_right {
  font-size: $font_size;
  top: 4.5cm;
  left: 12.3cm;
  width: 7.5cm;
  position: absolute;
}
/* Address positioning when printed on the left.
   Sets margins and position relative to the document.
   Sets also the font size. */
.address_table_left {
  top: 5.5cm;
  left: 2.2cm;
  width: 7.5cm;
  position: absolute;
}
/* Address positioning when printed on the right,
   and moved horizontally/vertically through Invoice settings.
   Sets margins and position relative to the document.
   Sets also the font size. */
.custom_address_table_right {
  font-size: $font_size;
  top: $right_address_margin_top;
  left: $right_address_margin_left;
  width: 7.5cm;
  position: absolute;
}
/* Address positioning when printed on the left,
   and moved horizontally/vertically through Invoice settings.
   Sets margins and position relative to the document.
   Sets also the font size. */
.custom_address_table_left {
  top: $left_address_margin_top;
  left: $left_address_margin_left;
  width: 7.5cm;
  position: absolute;
}
/* Small address line of the sender, above the customer's address.
   Sets font size, text alignment.
   Sets also a bottom border used as underline. */
.small_address {
  font-size: 7pt;
  text-align: center;
  border-bottom-style: solid;
  border-bottom-color: $text_color;
  border-bottom-width: 1px;
  margin-bottom: 0.3cm;
}
/* Shipping address positioning.
   Sets font size and margins relative to the information table. */
.shipping_address {
  font-size: $font_size;
  margin-top: 0.4cm;
  margin-left: 1.2cm;
  margin-right: 1.2cm;
}
/* Shipping address title.
   Sets font weight and color of the text. */
.title_shipping_address {
  font-weight: bold;
  color: $color_title_total;
}
/* Invoice title.
   Sets font size, font weight and color of the text. */
.title_text {
  font-size: $font_size_title;
  font-weight: bold;
  color: $color_title_total;
}
/* Begin text positioning.
   Sets margins relative to the prior element.
   It is used all the available width of the document to insert the text. */
.section_class_begin {
  margin-top: 1.0cm;
  margin-left: 1.2cm;
  margin-right: 1.2cm;
  width: 100%;
}
/* Table for the begin text.
   Use all the available width of the document. */
.begin_text_table {
  width: 100%;
}
/* Begin text style.
   Sets the font size of the text. */
.begin_text {
  font-size: $font_size;
}
/* Invoice details positioning, first page.
   Sets the top margin relative to the prior element (begin text/title) */
.section_class_details:first-view {
  margin-top: 0.5cm;
}
/* Invoice details positioning, page 2 and above.
   Sets the margins relative to the prior element (information) */
.section_class_details {
  font-size: $font_size;
  margin-top: 0.5cm;
  margin-bottom: 0.5cm;
  margin-left: 1.3cm;
  margin-right: 1.2cm;
}
/* Invoice details table width.
   Use all the available width of the document. */
.doc_table {
  width: 100%;
}
/* Header row of the invoice details.
   Sets font size, font weight, text color and background color. */
.doc_table_header {
  font-size: $font_size_header;
  font-weight: bold;
  color: $text_color_details_header;
  background-color: $background_color_details_header;
  border-bottom: thin solid $color_title_total;
}
/* Cells of the invoice details table.
   Sets the space between the text in the cell and the cell border (top, bottom, left and right). */
.doc_table td {
  padding-top: 5px;
  padding-bottom: 1px;
  padding-left: 0px;
  padding-right: 0px;
}
/* Cells of header row of the invoice details table.
   Sets the space between the text in the cell and the cell border (top, bottom, left and right). */
.doc_table_header td {
  padding-top: 4px;
  padding-bottom: 2px;
  padding-left: 0px;
  padding-right: 0px;
}
/* Item row of the invoice details.
   Sets font weight. */
.item_cell {
  
}
/* Total row of the invoice details.
   Sets font size, font weight and text color. 
   Sets also a bottom border used as double underline for the entire row. */
.total_cell {
  font-size: $font_size_total;
  font-weight: bold;
  color: $color_title_total;
  border-bottom-style: double;
  border-bottom-color: $color_title_total;
  border-bottom-width: 1px;
}
/* Subtotal row of the invoice details.
   Sets the font weight and a bottom border used as underline for the entire row. */
.subtotal_cell {
  font-weight: bold;
  border-bottom-style: solid;
  border-bottom-color: $color_title_total;
  border-bottom-width: thin;
}
/* Header cell of the invoice details.
   Sets the font weight as bold. */
.header_cell {
  font-weight: bold;
}
/* VAT text style of the invoice details.
   Sets the font size of the text.
   Used when printing the invoice details using gross amounts, through Invoice settings. */
.vat_info {
  font-size: $font_size;
}
/* Even rows style of the invoice details.
   Sets the background color for even rows. */
.even_rows_background_color {
  background-color: $background_color_alternate_lines;
}
/* Final texts positioning.
   Sets margins relative to the prior element (invoice details).
   Applied to notes, greetings and final texts. */
.section_class_final_texts {
  margin-top: 0cm;
  margin-bottom: 0.5cm;
  margin-left: 1.26cm;
  margin-right: 1.0cm;
}
/* Footer top border positioning. 
   Sets margins relative to the prior element (final texts).
   Sets also a top border line over the text. */
.footer_line {
  margin-left: 1.2cm;
  margin-right: 1.0cm;
  border-top-style: solid;
  border-top-color: $color_title_total;
  border-top-width: thin;
}
/* Footer positioning and style.
   Sets margins relative to the prior element (footer line). 
   Sets also font size and use all the available width of the document. */
.footer_table {
  font-size: 8pt;
  margin-bottom: 2.0cm;
  margin-left: 1.2cm;
  margin-right: 1.0cm;
  width: 100%;
}

Error Messages

@error Missing QR-IBAN

• The QR-IBAN code must be entered in the invoice settings, under the related QR-IBAN entry.
• Check that QR-IBAN code is not entered from File → File and accounting properties → Address section.

@error Incorrect QR-IBAN

Check that the QR-IBAN code entered in the invoice settings is correct.

@error Missing IBAN

• The IBAN for an account in CHF can be specified in two ways:
  • From File → File and accounting properties → Address section.
  • From invoice settings, under the related IBAN entry.
• The IBAN for an account in EUR must be entered in the invoice settings, under the IBAN EUR entry.

@error Incorrect IBAN

• Check that the IBAN code entered from File → File and accounting properties → Address section or in the invoice settings is correct.
• Check that the QR-IBAN has not been entered from File → File and accounting properties → Address section. The QR-IBAN code must be entered in the invoice settings.

@error Address: missing name/business

Set the sender's first and last name or company name from File → File and accounting properties → Address section, and the customer's first and last name or company name in the Accounts table → Address view.

@error Address: missing ZIP code

Set the sender's zip code from File → File and accounting properties → Address section, and the customer's zip code in the Accounts table → Address view.

@error Address: missing locality

Set the sender's locality from File → File and accounting properties → Address section, and the customer's locality code in the Accounts table → Address view.

@error Address: missing country code

Set the sender's country code from File → File and accounting properties → Address section, and the customer's country code in the Accounts table → Address view.

@error Address: Incorrect country code

The country code must be two characters in accordance with ISO 3166-1 (e.g. CH, LI, AT, DE, IT, FR).

@error isrId too long, max 8 chars. Your isrId %1

The membership number entered is too long. The maximum length allowed is of 8 digits. For more information QR reference.

@error isrId invalid, only digits are permitted. Your isrId %1

The membership number entered is not valid. It can only consist of numbers. For more information QR reference.

@error customerNo too long, max 7 digits. Your customerNo %1

The customer number is too long. The maximum length allowed is of 7 digits. For more information QR reference.

@error customerNo invalid, only digits are permitted. Your customerNo %1

The customer number is not valid. It can only consist of numbers. It must not contain ASCII (A-Z) letters, spaces, separators or other characters. For more information QR reference.

@error invoiceNo too long, max 7 digits. Your invoiceNo %1

The invoice number is too long. The maximum length allowed is of 7 digits. For more information QR reference.

@error invoiceNo invalid, only digits are permitted. Your invoiceNo %1

The invoice number is not valid. It can only consist of numbers. It must not contain ASCII (A-Z) letters, spaces, separators or other characters. For more information QR reference.

@error Name too long, max 70 characters

The name is too long. The maximum length allowed is of 70 characters. For more information Technical information.

@error Address too long, max 70 character

The address is too long. The maximum length allowed is of 70 characters. For more information Technical information.

@error House number too long, max 16 characters

The house number is too long. The maximum length allowed is of 16 characters. For more information Technical information.

@error Postal code too long, max 16 characters

The postal code is too long. The maximum length allowed is of 16 characters. For more information Technical information.

@error Locality too long, max 35 characters

The locality is too long. The maximum length allowed is of 35 characters. For more information Technical information.

@error Postal code+Locality too long, max 70 characters

The postal code + locality is too long. The maximum length allowed is of 70 characters. For more information Technical information.

This page shows some examples of possible printouts of QR invoices.

• Download the file with examples.

Invoice with default settings

• Use the default settings of the templates for invoices dialog:
• Enter an IBAN account in the basic data File and accounting properties > Address or in the invoice settings.

Example print:

Invoice with logo

Via  File > Logo setup:

• Define the logo, size and alignment.
• Set the alignment of the invoice header text.
  Define the header text in File and accounting properties > Address or using the templates for invoices dialog:

Example invoice with logo aligned on the left and text on the right:

Example invoice with logo aligned on the right and text on the left:

Invoice with Letterhead-Style Logo (A4 Format)

This example explains how to set a full-page logo (like a letterhead). An image with a logo at the top and a footer at the bottom is used. The goal is to print the invoice with:

• On pages with invoice details, both the logo and the footer are displayed.
• On the last page with the QR slip, only the logo is displayed without the footer.

This is useful, for example, if you want to print a QR invoice that also includes the footer, because normally the footer can only be added if the QR slip is excluded from printing.

Here's how to do it:

• Create an A4-sized image of the letterhead with the logo at the top and the footer at the bottom.
  Example:
  
  
   
• Insert the created image as the logo from the menu File > Logo setup.
  • Set the size: width 21cm and height 29.7cm (if the image dimensions are already correct, you can skip this).
  • Set alignment to left.
  • The position and alignment of the text are irrelevant since no text will be printed in the header.
• Use custom CSS to adjust the logo margins.
  In the Documents table, add a new row with the CSS as an attachment.
  • In the ID column, enter an ID (e.g., logo.css). It must end with ".css".
  • In the Attachments column, double-click the cell and select CSS Stylesheet.
  • In the editor that opens, paste the following code:

  • .logo {
      margin-top: 0cm;
      margin-left: 0cm;
      margin-right: 0cm;
    }

• Set some parameters in the invoice settings dialog:
  • In the Print > Header section, uncheck Page header.
  • In the same section, check Logo.
  • In the field Composition for logo and header alignment, enter the name of the customization you defined in File > Logo Setup > Customization > Name (default is "Logo").
  • In the QR Code section, check QR on separate page.
  • In the Javascript / CSS section, enter the CSS file ID defined in the Documents table (e.g., logo.css) in the CSS file name field.

Example of a QR invoice, with logo and footer on the first page, and logo with QR slip on the second page:

  

Invoice without logo and company header on the left

Go the the File > Logo setup window:

• Do not add any logo image
• As Text position enter the following settings:
  • Relative position to logo: To the left
  • Horizontal align: Left
• Go to the Customization section and in the Name field enter a name for the customization (e.g., "Logo").

Now go to the invoice setup dialog window, in the Print > Header part:

• Check the Page header checkbox
• Check the Logo checkbox (although no logo image will be shown)
• In the field Composition for logo and header alignment enter the name of the customization that you previously defined in the Logo Setup > Customization > Name dialog (e.g., "Logo").

Printout example:

Invoice with customer address on the left

Via the templates for invoices dialog, in the client Address section:

• Define the composition of the address by specifying the XML names of the address columns of the Accounts table.
• Check the Align left box to print the address on the left and the part of the information on the right.
  
  

Printout example:

Invoice with headings and intermediate totals

In some cases it may be useful to add headers and intermediate totals in the invoice details.

In the Transactions table, define the header and intermediate totals rows using the Column type column:

• Header lines: enter the command 10: hdr and the text in the Description column.
• Intermediate totals rows: enter the command 10: tot and the text in the Description column.
  
  

Multi-page invoice example:
  

Invoice with shipping address, description and amount columns

Via the templates for invoices dialog:

• Check the Shipping address box in the Customer address section.
• In the Invoice Details section, define:
  • The names of the columns to use, specifying the XML names of the Transactions table columns.
  • The width of each column.
  • The alignments of titles and texts of the columns.
• In the Texts section, define the header text of each column.
  Add the translation for each language you intend to use.
   
• 

Invoice printout example with other settings:

Use columns from the Transactions table

Prerequisites:

• Advanced Plan of Banana Accounting Plus.

In some cases it may prove useful to include a dedicated column (not predefined in the program)for invoice details, such as a column in which to indicate the date of execution of a job.

Column creation:

• With the Columns setup command, add a column in the Transactions table.
  Each proper column of type Data must begin with the word Date (eg DateWork, DateExecution, DateXXX).
• Enter your postings to create the invoice and in this column indicate the date of execution of the job.
• For the invoice printout, the program uses the date format defined in the operating system settings.

Via the templates for invoices dialog:

• In the Invoice Details section define:
  • The names of the columns to use, specifying the XML names of the Transactions table columns.
    Insert the column created in this way: T.DateWork (the own columns must be preceded by "T.")
  • The width of each column.
  • The alignments of titles and texts of the columns.
  • View the Gross amounts box to use gross amounts with VAT included.
• In the Texts section, define the header text of each column.
  Add the translation for each language you intend to use.
  

Invoice printout example:

Invoice with initial, final text, notes and greetings

Define the initial texts in the Transactions table, notes and greetings using the Type column:

• Initial text: enter the command 10: beg and the text in the Description column.
• Note: enter the 10: not command and the text in the Description column
• Greetings: enter the command 10: gre and the text in the Description column.
• The text inserted between the double asterisks (**) will be displayed in bold.
  
  

Via the templates for invoices dialog:

• In the Texts section, define the final text to be included immediately after the invoice details.
  The text inserted between the double asterisks (**) will be displayed in bold.
  
  

Invoice printout example:

Invoice with no amount

It is used when you want to leave the possibility of choosing the amount to be paid to the person making the payment (for example for a donation).
In the QR part the amount is excluded, leaving an empty box to enter the amount by hand.

In the Transactions table enter the donation record without the amount.

Through the invoice settings dialog, in the QR Code section check the Exclude invoice amount box.

Example of invoice printing:

Invoice with multi-row descriptions (integrated invoicing)

This example for Integrated invoicing shows how to create invoices using multi-row descriptions.

The steps to follow are:

• Use the Arrange Columns command to add one or more additional description columns in the Transactions table.
  Create columns of type Text with the name "Description" followed by a number (e.g., "Description1", "Description2", "Description3", etc.).
  The XML name of each column must begin with the word "Description" followed by a number.
  
  
   
• In the newly created columns, enter additional text for the invoice description.
  The text for each column will be displayed on a new line in the invoice description.
  
  
   
• In the Invoice parameters dialog box, in the Print > Invoice details section, display the Print additional descriptions box.
  
  

At this point, if there are additional description columns in the Transactions table and if they contain texts, these texts will be added on the invoice printout.

Example invoice printout:

Invoice with multi- row descriptions (Estimates-Invoices)

This example for the Estimates and Invoices application shows how to create invoices with multi-row descriptions.

• In the invoice edit dialog, under the Invoice Details section, in the Description column:
  • Enter the description text
  • You can use line breaks and add as many lines as you want.
  • You can also leave blank lines.
  • You can insert one or more texts between double asterisks to apply bold styling (e.g. Bold text).
  • You can enter the amount either on the same line as the multi-line description, or on a new line (see image).
    
    

When printing the invoice, descriptions are displayed on several rows as in the dialogue.

Example invoice printout:

Invoice with Article Discount column

This example for invoicing with the Estimates and Invoices application shows how to add the Article Discount column in the invoice details.

Requirements:

• Banana Accounting Plus Advanced Plan.
• Beta Release version of the Estimates and Invoices application.

The steps to follow are as follows:Create invoices using the Discount column. Enter a percentage or a value.


 

• Via the invoice settings dialogue:
  • Via the invoice settings dialogue:In the section Print > Invoice details add the Discount column, set the column widths and the alignment of headings and texts.
    • Description;Quantity;ReferenceUnit;UnitPrice;Discount;Amount
      35%;10%;10%;15%;15%;15%
      left;center;center;right;right;right
      left;center;center;right;right;right
  • In the section Texts > Invoice detail column header, for each language set the texts for the table headers, also adding the text for the Discount column.
    • Description;Quantity;ReferenceUnit;UnitPrice;Discount;Amount
       

Example invoice printout: 

Invoice with product images

This example shows how to add and print product images in the invoice details.

Requirements

• Advanced plan of Banana Accounting Plus.
• Invoice customization with JavaScript.

Steps

1. Add products images.
   • Save images of each product.
     Use the same directory where the .ac2 file is located or a subfolder.
     The supported formats are PNG and JPG.
     Use small images to reduce the weight of the generated PDF file.
2. Edit the Items table.
   • Add the Links column.
     In the Items table, make the Links column visible with the Columns setup command.
   • Link images to items.
     In the Links column of Items table, add the link of the image for each product.
     Click on the icon at the top right of the cell and select the corresponding image.
3. Add the Documents table.
   • If not present, add the Documents table.
     From the menu Tools > Add/Remove functionalities > Add Documents table.
4. Add the JavaScript code as attachment in the Documents table.
   • In the ID column, enter the name of the attachment including the .js extension (e.g., "myFile.js").
   • In the Attachments column, click on the icon at the top right and select Javascript code.
     An editor opens where you can enter javascript code. Delete all.
   • Copy and paste
     • the javascript code of the 'hook_print_details_net_amounts' function (that prints the invoice with net amounts).
     • the javascript code of the 'hook_print_details_gross_amounts' function (that prints the invoice with gross amounts).
   • Click OK.
5. Sets the parameters of the invoice layout.
   • In the Invoice Settings:
     • In the Invoice Details section, add the columns "I.Links" (column for images) and "Number" (column for item number).
       
       I.Links;Number;Description;Quantity;ReferenceUnit;UnitPrice;Amount
       10%;10%;30%;10%;10%;15%;15%
       left;left;left;right;center;right;right
       left;left;left;right;center;right;right
        
     • In the Texts section, add the texts for the column headings (e.g., “Image;Item;Description;Quantity;Unit;Unit Price;Amount”).
     • In the Javascript / CSS > JS File Name section, enter the id of the attachment that contains the javascript code (e.g., "myFile.js").

Images of the products will also be included in the invoice printout.

Example: