The Banana Accounting procedure for VAT management requires entering the VAT code on the same line where the revenue is recorded. 

Revenue is recognized only when the invoice is actually paid, recording transactions at the time of collection. 

It is necessary to set up the customer sub-ledger in the accounts table via the CC3 Profit Center.

Therefore, in cash-based VAT management, the VAT code is entered only when the invoice is collected.

Invoice data is entered in the Transactions table. For each new invoice, enter a new transaction line.

• Indicate the date of the transaction.
• The invoice number
  • For invoicing with Swiss QR with IBAN account, use only numbers or letters, without spaces, separators, or other characters. The maximum allowed length is 7 characters.
  • For invoicing with Swiss QR with QR-IBAN, use only numbers without spaces, separators, or other characters. The maximum allowed length is 7 digits.
  • If Swiss QR is not used, the invoice number can be freely chosen.
  • Each invoice must have a unique invoice number, even across multiple accounting years. This is important because using the same invoice number over multiple years is still considered a single document. If you wish to repeat the same invoice number, you must add the year to the invoice number or another identifier to distinguish it from previous years' invoices (e.g., 1234524, 1234525).
  • The description text (products, services, consulting...) that will appear on the customer's invoice.
  • The Debit account must remain empty.
  • The Credit account must remain empty.
  • Enter the amount.
  • In cases subject to VAT, enter the VAT sales code in square brackets (e.g., "[V81]").
    The VAT code entered in square brackets allows the VAT amount to be displayed on the invoice, without being recorded until the payment is registered.

Invoice with multiple lines

When there are multiple items to be invoiced (different products or services, or both), they must be recorded on multiple lines (one item per line):

• Enter a new transaction line for each item you want to print on the invoice.
• On each additional line, repeat the date and invoice number, identical to the previous lines.

Basic columns

Date
The invoice will show the date indicated in this column. All lines belonging to the document must have the same date.

Invoice
For invoice management, an invoice number must be entered in the Invoice column.

Description
A description of the products or services being invoiced. These texts appear on the invoice.

Debit
Use the column only to record the invoice payment, entering the liquidity account (bank, post,...).

Credit
Use the column only to record the invoice payment, entering the revenue account.

Amount
An amount. If VAT is managed, enter the gross amount (including VAT).

VAT Code
The VAT code corresponding to the revenue account (sales or services):

• For invoice issuance, the VAT code must be entered in square brackets (e.g., "[V81]").
• For recording the invoice payment, the VAT revenue code must be entered without square brackets.

CC3
A customer account present in the Accounts table, in the CC3 Profit Center group.

Optional columns

Type
In the Type column, detail rows can be defined, such as totalization rows or a specific payment term for an invoice.
This column is not visible by default, but it must be displayed via the menu Data > command Columns setup and checking the DocType column.

Quantity
The quantity of goods or services to be invoiced.
To add the quantity column, use the menu Tools > Add/remove functionalities > Add Item column in the Transactions table.

Unit
A type of unit (e.g., 'pz', 'h', 'm', 'kg').

Unit Price
The unit price related to the goods or services.
The program automatically calculates the total amount based on the quantities entered in the Quantity column.

 

The standard procedure of Banana Accounting in VAT management requires entering the VAT code always on the line where the revenue is recorded.

Issued invoices are immediately recorded and accounted for. Revenues are recognized at the time of invoice issuance.

It is necessary to set up the customer ledger in the Accounts table. At the end of the year, customer accounts must appear in the balance sheet.

Therefore, in VAT management on turnover, the VAT code is entered when creating the invoice.

Invoice data is entered in the Transactions table. For each new invoice, enter a new transaction row.

• Enter the date of the transaction
• The invoice number
  • For invoicing with Swiss QR with IBAN account, use only numbers or letters, without spaces, separators, or other characters. The maximum allowed length is 7 characters.
  • For invoicing with Swiss QR with QR-IBAN, use only numbers without spaces, separators, or other characters. The maximum allowed length is 7 digits.
  • If Swiss QR is not used, the invoice number can be freely chosen.
  • Each invoice must have a unique invoice number, even across multiple accounting years. It is important because using the same invoice number across years is considered as a single document. If you wish to repeat the same invoice number, add the year to the invoice number or another identifier to distinguish it from previous years' invoices (e.g., 1234524, 1234525).
• The description text (products, services, consulting...) that will appear on the customer’s invoice
• In the Debit account, enter the customer account number
• In the Credit account, enter the contraccount (Sales account, Consulting, or others)
• Enter the amount
• If subject to VAT, enter the VAT Code with the applicable VAT percentage. See Invoice printing and VAT management.

Multi-row Invoice

When there are multiple items to be invoiced (various products or services or both), they must be recorded on multiple lines (one item per line):

• Enter a new transaction row for each item to be printed on the invoice.
• On each additional line, repeat the date and invoice number, the same as the previous lines.

Basic Columns

Date
The invoice will display the date indicated in this column. All rows belonging to the document must have the same date.

Invoice
For invoice management, an invoice number must be entered in the Invoice column.

Description
A description of the products or services to be invoiced. These texts appear on the invoice.

Debit
A customer account that belongs to the ledger in the Accounts table.

Credit
A revenue account in the Accounts table.

Amount
An amount. If VAT is managed, enter the gross amount (including VAT).

VAT Code
The VAT code corresponding to the revenue account (sales or services).

Optional Columns

Type
In the Type column, you can define detail rows, such as subtotal rows or a specific payment term for an invoice.
This column is not visible by default but must be enabled through the menu Data > command Arrange columns and checking the column DocType.

Quantity
The quantity of goods or services to be invoiced.
To add the quantity column, use the menu Tools > Add new features > Add Items columns in the Transactions table.

Unit
A type of unit (e.g., 'pcs', 'h', 'm', 'kg').

Unit Price
The unit price for the goods or service.
The program automatically calculates the total amount based on the quantities entered in the Quantity column.

 

If you are subject to VAT under the balance rate or flat-rate regime with the cash-based system, you must record the invoice issuance to the customer and its accounting registration separately, for the following reasons:

1. Invoice to be sent to the customer:
   It must show a normal commercial VAT rate (e.g., 8.1%), as required by tax regulations.
2. Accounting of the invoice:
   It must instead be recorded in accounting with the effective balance rate (e.g., 6.2%), using the corresponding VAT code (e.g., F1).

This approach is essential to ensure that the VAT paid corresponds to the applicable reduced regime, while still maintaining a formally correct invoice for the customer.

Issuing the invoice to the customer

To issue the invoice to the customer, proceed as follows:

In the Accounts Table:

• Create a customer sub-account with the profit center CC3 (example: ;10001 for customer XX)
• In the  Address view, enter all customer data.

In the Transactions table:

• Enter the date and description in the corresponding columns
• In the Amount column, enter the amount
• The Debit and Credit columns must remain empty.
• In the VAT Code column, type the code V81 in square brackets  [V81]. 
  VAT codes in square brackets do not generate any VAT entry.
• In the CC3 column, indicate the profit center number without semicolon (e.g., 10001). 

Since there are no accounts in the Debit and Credit columns, the invoice creation entry will not be recorded in accounting.

Recording the invoice with VAT balance rate

When recording an invoice subject to VAT with a balance rate in accounting, it is sufficient to proceed as with a normal entry, indicating the accounts in the Debit and Credit columns and entering the VAT code corresponding to the balance rate (e.g., F1).

Two recording systems can be used to register the invoice with the balance rate:

• Recording with split
  In the VAT codes table, VAT percentages have been assigned to balance rate VAT codes. In the transactions table, by entering the balance rate VAT code (e.g., F1), the program automatically enters the corresponding VAT percentage (e.g., 6.2) and the VAT amount.
• Recording without split, by entering the balance rate VAT code (e.g., F1), percentage and amount are not entered. At the end of the period, the specific extension for calculating balance VAT is used. 
  Based on the rate defined in the extension dialog, the program:
  • Identifies all entries with balance rate VAT code.
  • Automatically calculates the VAT due for the reporting period.
  • Totals the amounts on a periodic basis (e.g., monthly, quarterly, yearly).

 

The Banana Accounting procedure for VAT management requires entering the VAT code always on the line where the income is recorded. When accounting is managed based on turnover, the income is recorded when the invoice is issued. 

When subject to VAT using the balance rates or flat-rate method, customer invoices must be issued using the normal rates (e.g., 8.1%). However, the accounting of invoices under the balance rates or flat-rate method involves reduced rates (e.g., 6.2%).

• If the amounts are gross, you can record them based on turnover or on cash received, by entering the VAT code in square brackets.
• If the amounts are net, it is not possible to create and post the invoices at the same time. In this case, it is necessary to manage:
  • The creation of invoices in an accounting file, using the integrated invoicing or with the Offers and Invoices Application
  • The posting of invoices in the accounting file.
    In this case, the creation of the invoices must be handled in an accounting file or with the Offers and Invoices Application, and the posting in a separate accounting file.

Issuing an Invoice with Balance Rate and Gross Amounts

To issue an invoice to customers with the normal rate (e.g., 8.1%), it is necessary to create in the Accounts table:

• A customer sub-account using the CC3 profit centers (example: ;10001), completing all customer information in the columns of the Address view.
• Enter the date and description in the corresponding columns.
• The Debit and Credit columns must remain empty.
• In the Amount column, enter the amount.
• In the VAT Code column, type the code V81 in square brackets [V81].
  VAT codes in square brackets do not result in any VAT posting.
• In the CC3 column, indicate the profit center account without a semicolon (e.g., 10001).
  As there are no accounts in the Debit and Credit columns, the invoice creation entry will not be posted.

Posting an Invoice with Balance Rate and Gross Amounts

When recording the invoice in the accounting, to post it using the VAT balance rate, you must enter the transaction as usual, also entering the accounts in the Debit and Credit columns and the VAT code of the balance rate:

• If the VAT breakdown method is used, enter the VAT code for the balance rate (e.g., F1). In this case, the VAT Codes table includes the VAT rates for the balance. In example F1 corresponds to 6.2%.
• If the non-VAT breakdown  method is used, enter the VAT code without rate (e.g., F1). In the VAT code table, the balance rate codes do not have rates.

To post the invoice using the balance rate, it is necessary to create in the Accounts table:

• A customer sub-account using balance sheet accounts.
• Enter the date and description in the corresponding columns.
• In the Debit column, enter the customer account (e.g., 10001).
• In the Credit column, enter the income account.
• In the Amount column, enter the amount.
• In the VAT Code column, type the VAT code for the balance rate (e.g., F1)

 

 

 

 

To enter a discount or reduction in an invoice, add a new row and enter:

• Invoice date
• Invoice number
• Description of the discount or reduction
• Accounts in the Debit and Credit columns. It is important to invert the accounts compared to the sales transaction.
  When the customers / suppliers register is set up with cost centers and there are registrations with discounts and reductions, in order for the amount to be reversed, the sign of the cost centers must be inverted.
• In case of VAT, indicate the VAT code with the minus sign, so that the VAT is deducted, or, if present use the VAT code for discount and reductions.

 

Beim Drucken von Rechnungen, die in die Buchhaltung integriert sind, entspricht der Gesamtbetrag der Mehrwertsteuer (MWST) der Summe der einzelnen MWST-Buchungen, die die gleiche Rechnung ausmachen. Da die einzelnen MWST-Buchungen auf die nächsten Hundertstel gerundet werden, kann es bei der Berechnung der MWST auf den Gesamtrechnungsbetrag zu einer Differenz kommen.

Betrachten Sie zum besseren Verständnis das folgende Beispiel:

• Zeile 1: 7,7% von CHF 187.50 = CHF 14.4375 -> Aufgerundet: CHF 14.44
• Zeile 2: 7,7% von CHF 875.00 = CHF 67.375 -> Aufgerundet: CHF 67.38
• Total: 7,7% von CHF 1062.50 = CHF 81.8125 -> Abgerundet: CHF 81.81

Auf der Rechnung wird ein Mehrwertsteuerbetrag von CHF 81.82 anstelle von CHF 81.81 ausgewiesen. Tatsächlich entspricht der Betrag von CHF 81.82 der Summe der für jeden Artikel einzeln berechneten Mehrwertsteuer (CHF 14.44 + CHF 67.38).

Diese Vorgehensweise wird angewendet, um Differenzen zwischen den in der Buchhaltung verbuchten und den auf der Rechnung ausgewiesenen Mehrwertsteuerbeträgen zu vermeiden. Auf diese Weise stimmt der Gesamtbetrag der Mehrwertsteuer in der Buchhaltung mit dem in der Rechnung ausgewiesenen Betrag überein.

Weitere Informationen sind auf der Webseite Rechnungen ausdrucken und MWST verwalten verfügbar.
 

The default layouts include the following languages: Italian, German, English, French, Dutch.

Invoice texts are printed in the customer's language, provided that this is set in the Language column (Accounts table, Address view).
The language is an ISO code, generally of 2 lowercase letters (it=italian, de=german, en=english, fr=french, nl=dutch).

When no language has been indicated for the customer account, the language of the accounting is used, defined in the File menu→ File and accounting properties (basic data) → Other.

The due date of an invoice can be set up in different ways: 

• Generalized due date - identical due date for all invoices
  Select menu Reports→ Customers → Settings → General → Invoices are due, indicate the period (in days) after which the invoice is considered due. As an example, if the date of your document is the 10th of May and you enter a value of 10 days, the due date will be the 20th of May. 
• Due dates per customer - specific for each customer
  In the Accounts table, a DateExpiration column is available (if not on display set up via Data → Columns setup ...). The period (in days) after which the invoice is considered to be due can be set up in this column.
• Specific dates per invoice
  In the Transactions table, Due dates view, the Date Exp. column is visble; you can indicate the expiration date directly in this column.

• Alternative text for the expiration date
  It is possible to define a text of your choice as a payment term for each invoice. This will replace the text of the expiration date. Revert to Advanced input -Type column for detailed information.

With Banana Accounting Plus, you can also print invoices in foreign currency.

Required settings:

• Open one of our multi-currency accounting templates.
• Set up in the Accounts table, in the customer ledger, the customer with the foreign currency. Invoices are printed in the currency of the customer's account.
• If you want to send invoices in different currencies to the same customer, you must create accounts in different currencies for the same customer (Accounts table).
• Use the UNI11 layout for printing invoices to be sent abroad.

Invoices in foreign currency with VAT in base currency

It is not normally possible to enter a foreign currency invoice with VAT in base currency. This can be overcome with the following procedures:

Invoices in foreign currencies with VAT using Cash principle

• Open one of our multi-currency accounting templates with VAT with cost centres CC3.
• Set up in the Accounts table, customers in foreign currencies as CC3 cost centres (;).
  If you wish to send invoices in different currencies to the same customer, you must create accounts in different currencies for the same customer (Accounts table).
• In the Transactions table, you must enter the invoice data on several rows:
  •     In the first row:
    • In the Amount column enter the amount net of VAT (without entering any debit or credit account).
    • In the column CC3 enter the customer's cost centre account in foreign currency.
  • In the second line:
    • In the Amount column enter the VAT amount in foreign currency (without entering any debit or credit account), manually calculating the VAT amount in foreign currency.
    •  In column CC3 enter the customer's cost centre account in foreign currency.
• For printing invoices with Swiss QR code use layout CH10.

To register the receipt:

• In the Debit column enter the liquidity account.
• In the Debit column enter the revenue account.
• In the VAT Code column enter the VAT code of the sale.
• In the column CC3 enter the customer's cost centre account in foreign currency with a negative sign.

Example: Invoice entry in foreign currency (EUR) with VAT on receipts in base currency (CHF):

Invoices in foreign currencies with VAT on turnover

• Open one of our multi-currency accounting templates with VAT and a customer ledger.
• In the Accounts table, set the customers in foreign currencies both as a ledger (Accounts) and as CC3 cost centres (;).
• In the Transactions table, you must enter the invoice data on several rows:
  •  In the first line enter the invoice issue normally:
    • The date, the description, in the Debit account the customer account in foreign currency and in the Debit account the revenue, the amount before VAT and the VAT code of the sale.
    • The invoice number does not have to be entered.
  • In the second line:
    • In the Amount column enter the invoice amount net of VAT (without entering any debit or credit account).
    • In column CC3 enter the customer's cost centre account in foreign currency.
    • Where the columns Quantity, Unit and Unit Price are used, the unit price must be net of VAT.
  • In the third line:
    • In the Amount column enter the VAT amount in foreign currency (without entering any debit or credit account), manually calculating the VAT amount in foreign currency.
    • In column CC3 enter the customer's cost centre account in foreign currency.

Rows with cost centres are simply used to search invoices in foreign currency with VAT.

To register the receipt:

• In the Debit column enter the liquidity account.
• In the Debit column enter the customer's foreign currency account.
• In the column CC3 enter the customer's cost centre account in foreign currency with a negative sign.

Example: Invoice entry in foreign currency (EUR) with VAT on turnover in base currency (CHF):

 

  The Type column in the Transactions table can be used to define the commands that are relevant to the display for printing data specific to your Invoice.
Check the DocType column via menu Data → Columns setup ..., to display the column and use it.

Entering data

Once the column is displayed, you may proceed by entering your data. You will need to:

• Add an empty row after the Date of the Invoice.
• Enter the date of the Invoice in the Date column.
• Enter the required command in the Type column (refer to table below)
• Enter the Invoice number in the Invoice column.
• Enter the data relevant to appear on the Invoice in the Description column.

 

Invoice to the customer

Typing 10: the Type column will list all possible options available to customize the data of your invoice.

Invoice data	Column Type	Description column
Client address If you want the address to look differently from the one defined in the Accounts table (Address view), you can change it using using the appropriate options. On each row a different element of the address is indicated (name, surname, address...).	10:adr:fna 10:adr:lna 10:adr:bna 10:adr:str1 10:adr:str2 10:adr:str3 10:adr:cod 10:adr:cit 10:adr:sta 10:adr:cou	Enter name Enter surname Enter name of company/organization Enter line 1 of address Enter line 2 of address Enter line 3 of address Enter postal code Enter the location Enter the state /province Enter the country
Shipping address	10:sadr:pna 10:sadr:fna 10:sadr:lna 10:sadr:str1 10:sadr:cod 10:sadr:cit	Enter prefix Enter name Enter surname Enter line 1 of address Enter postal code Enter the country
Greetings After the invoice details, you may add a line of text for your final greetings (also see Examples invoices).	10:gre	Enter your greetings
Final notes One or several rows of notes can be inserted after the details of the invoice and before the greetings (also see Examples invoices).	10:not	Enter your notes
Order date	10:ordd	Enter the order date
Order number	10:ordn	Enter the order number
Parameters (advanced) When wanting to print personalized data on the invoice, you can use the appropriate command. This option is aimed at users with JavaScript programming knowledge, and allows you to change the invoice layout, so as to use the parameters indicated via this command. For further information please revert to Printing custom data.	10:par	Enter your customized parameters
Payment term Should you want to indicate an alternative text as a payment term, enter the desired text. This will be displayed on the invoice.	10:ter	Enter the alternative text for the payment term
Text begin	10:beg	Enter the text printed before the invoice title
Title If you do not wish to use the default invoice title, you can choose a different title.	10:tit	Enter your text to appear as the invoice title
Items subtotals It is possible to enter intermediate totals for your invoice in the table with the details of the invoice (also see Examples invoices).	10:tot 10:tot:0 10:tot:1 10:tot:2	Enter level 0 subtotal (tot and tot: 0 is always level 0) Enter level 1 subtotal Enter level 2 subtotal
Header line text In the invoice details table you can add headers to group items (also see Examples invoices).	10:hdr	Enter the text you want to add to the invoice details. Leave empty to add an empty line.

 Intermediate Totals

In order to insert intermediate totals, you will need to add additional rows in the Transactions table:

• Enter 10 in the Type column: select :tot from the drop down menu, 10:tot will display. Enter again : and enter :1
• Enter the appropriate description in the Description column (ex. Total goods)
• Enter the Invoice number (in the absence of number, the total will not be printed).

Example of Invoice with intermediate totals.

 Alternative text for payment terms

It is possible to define your own wording as a payment term for each invoice and this will replace the existing text for the expiry date. 

• Enter an additional line with the same invoice number in the Transactions table.
• You will need to enter 10: in the Type column and select :ter from the drop-down menu, therefore the wording 10:ter will appear
• In the Description column, enter your text (ex 30 days net, 60 days etc ..).

When the invoice is printed, the value assigned as a payment term will be displayed.

Additional customisations

Other customisation options, such as the definition of bank details or final greetings, are available in the Print invoices dialog.

Mandatory requirements to use the layout preferences:

• Banana Accounting Plus (Release 10.1.7 or later).
• The Advanced plan

How to print a delivery note

In the Transactions table select the row where the delivery note to be printed is located and proceed as follows:

• Menu Report > Customers > Print invoices
• Select Layout CH10 or UNI11
• Under Print as, select:
  • Delivery note with amounts
    In this case, amounts in details and total amount are included in the delivery note.
  • Delivery note without amounts
    Only the details of the dispatched goods are displayed in the delivery note, without any amounts.
• Conferm with OK.

Delivery address

When printing the delivery note with an address other than the billing address, the delivery address must be entered in the Transactions table, using the Type column.

In this case, the delivery note will print the address entered in the Transactions table and not that of the respective customer, which is instead found in the Accounts table, Address view.

Printing customization

All settings that characterise Layout CH10 and UNI11 are also retained when printing the delivery note.

To change the settings, go to Print Layout Settings.

Under Texts > Delivery Note you can define the initial and final texts in the delivery note.

Print example:

 

Requirements in order to use layout preferences to select the label "Estimate" are

• Banana Accounting+ (version 10.1.7 or later).
• Advanced plan

 

How to print an estimate

In theTransactions table, select the row that corresponds to the estimate and proceed as follows:

• Menu Reports > Customers > Print invoices
• Select Layout CH10 or UNI11
• Select the option Print as, and choose Estimate
• Confirm with OK.

The offer is always printed without the Swiss QR bulletin.

Printing customization 

All the settings that characterize the CH10 and UNI11 Layout are also retained in the printing of the estimate.

To modify the settings, go to the Print Layout Settings.

In the Texts > Estimate section, you can define the initial and final texts of the quote.

In Banana Accounting Plus you can print reminders in two different ways:

• Print reminders from the Print reminders dialog
  • The reminder is based on the customer's open balance.
  • Function available in Banana Accounting Plus - any plan (excluding Free plan limitations).
  • Uses the Payment reminder (Banana+) Layout. The print is without QR payment slip.
  • Limited customizations.
• Print reminders from the Print Invoices dialogue
  • The reminder is created from the unpaid invoice.
    Do not use this mode if the customer account has a partial open balance that does not correspond to a specific invoice.
  • Requires the Banana Accounting + ( version 10.1.7 or more recent) and the Advanced plan.
  • Uses the CH10 Invoice layout (with QR code printing) and UNI11
  • Customizations provided by the layouts