En este artículo
Tutorial invoice with customer ledger | Revenue-based accounting | VAT
Banana Accounting Plus offers an innovative and professional method for creating invoices and automatically recording them in the accounting. The proposed tutorial template shows you how to record different types of invoices, from the simplest one to those with multiple items, and to test all the printing functions. If you want to create your own file based on this template, replace the example customer accounts in the Accounts table with your own data, enter the invoice items in the Transactions table, and the invoice is ready to be printed with or without a QR code for Switzerland. Open the template from our WebApp or from the program and save the file on your computer.
Abrir en Banana WebApp
Abra Banana Contabilidad Plus en su navegador sin necesidad de instalación. Personaliza la plantilla, introduce las transacciones y guarda el archivo en tu ordenador.
Abrir tutorial en WebAppDocumentación de la plantilla
Tutorial with a very simple and short chart of accounts, where we provide some recording examples to create invoices with VAT. The file also includes the Items table, where you can enter the data of the items or services to be invoiced. The data entered in the Items table is automatically retrieved in the Transactions table.
Create the file and test the Invoice functions
If you want to try out the invoice printing functions with VAT and QR code, you can start with this template.
- Open the template with the Banana Accounting Plus WebApp
- With the File > File and accounting properties command, set the period, your company name, and base currency.
- With the File > Save As command, save the file, for example as "Rossi-SA-20xx.ac2".
- In the Accounts table, enter the data of one of your customers. In the Addresses view, you can complete all address details (company name, address, phone and email contacts, country code and customer language).
- In the Transactions table, you will find various billing scenarios already recorded. You can delete the rows and enter the data of your invoice. By entering the Debit and Credit accounts, the invoice will be automatically posted.
- Select the Reports > Customers > Print invoices menu, click OK to preview the documents.
- To try out the different available invoice layouts, see the Invoice layouts page.
- To customize the invoices, see the Advanced input - Type column page.
You can find all the information about creating and printing invoices with QR code at the following webpage:
WARNING: If you close the browser without saving, you will lose the entered data. Always save the file to your computer.
To reopen the saved file, click on File > Open.
Some functions require a subscription to the Advanced plan of Banana Accounting Plus, such as using the new features for printing the VAT return sample from 2024, Rules, Filter and Temporary row sorting. See all the features of the Advanced plan.
Other Resources
Template preview
Invoices 2022
Basic Currency: CHF
Double-entry with VAT/Sales tax
| Group | Account | Description | Sum In |
|---|---|---|---|
| BALANCE SHEET | |||
| Assets | |||
| 1020 | Bank account | 1 | |
| 10 | Customers' register | 1 | |
| 1 | Total assets | 00 | |
| Liabilities | |||
| 2200 | VAT Due | 2 | |
| 2201 | VAT according to VAT report | 2 | |
| 297 | Profit for the period | 2 | |
| 2 | Total Liabilities | 00 | |
| PROFIT & LOSS STATEMENT | |||
| Revenue & Expenses | |||
| 3000 | Sales Revenue Product A | 4 | |
| 3001 | Sales Revenue Product B | 4 | |
| 3002 | Other sales revenue | 4 | |
| 3400 | Revenue from services | 4 | |
| 3800 | Discounts | 4 | |
| 4 | Total Revenue & Expenses | 02 | |
| 02 | Profit/Loss for Profit & Loss Statement | 297 | |
| 00 | Difference should be = 0 (blank cell) | ||
| Customers' Register | |||
| 1100 | Customer A | DEB | |
| 1101 | Customer B | DEB | |
| 1102 | Customer C | DEB | |
| 1103 | Customer D | DEB | |
| 1104 | Customer E | DEB | |
| DEB | Total | 10 |
| VAT Code | Description | %VAT |
|---|---|---|
| Explanations | ||
| V = Sales (200) | ||
| VS = Discount sales and services (235) | ||
| B = Acquisition tax (380) | ||
| M = Expenses for material and services (400) | ||
| I = Investments and other operating expenses (405) | ||
| K = Corrections (410, 415, 420) | ||
| Z = Not considered (910) | ||
| VAT codes information (do not modify) | ||
| id=vatcodes-che-2018.20211210 | ||
| Last update: 10.12.2021 | ||
| VAT Due | ||
| V0 | Exempt services (220) | |
| V0-E | Export services abroad (221) | |
| V0-T | Transfers in the reporting procedure (225) | |
| V0-N | Non-taxable services (230) | |
| Decrease of income from services, see discounts | ||
| V0-D | Various (280) | |
| V77 | Sales and services 7.7% | 7.70 |
| V80 | Sales and services 8.0% | 8.00 |
| V77-B | Sales and services 7.7% (chosen) | 7.70 |
| V80-B | Sales and services 8.0% (chosen) | 8.00 |
| V25-N | Sales and services 2.5% 2018 | 2.50 |
| V25 | Sales and services 2.5% 2017 | 2.50 |
| V37 | Sales and services 3.7% | 3.70 |
| V38 | Sales and services 3.8% | 3.80 |
| VS77 | Discount Sales and services 7.7% | 7.70 |
| VS80 | Discount Sales and services 8.0% | 8.00 |
| VS25-N | Discount Sales and services 2.5% 2018 | 2.50 |
| VS25 | Discount Sales and services 2.5% 2017 | 2.50 |
| VS37 | Discount Sales and services 3.7% | 3.70 |
| VS38 | Discount Sales and services 3.8% | 3.80 |
| Taxable turnover (299) | ||
| F1 | 1. Flat tax rate 2017 | |
| F2 | 2. Flat tax rate 2017 | |
| FS1 | Discount Sales and services 1. Flat tax rate 2017 | |
| FS2 | Discount Sales and services 2. Flat tax rate 2017 | |
| F3 | 1. Flat tax rate 2018 | |
| F4 | 2. Flat tax rate 2018 | |
| FS3 | Discount Sales and services 1. Flat tax rate 2018 | |
| FS4 | Discount Sales and services 2. Flat tax rate 2018 | |
| Total Flat tax rate (321-331) | ||
| B77 | Acquisition tax 7.7% (With VAT/Sales tax) | 7.70 |
| B80 | Acquisition tax 8% (With VAT/Sales tax) | 8.00 |
| B77-1 | Acquisition tax 7.7% (Without VAT/Sales tax) | 7.70 |
| B80-1 | Acquisition tax 8% (Without VAT/Sales tax) | 8.00 |
| B77-2 | Acquisition tax 7.7% (VAT/Sales tax amount) | 7.70 |
| B80-2 | Acquisition tax 8% (VAT/Sales tax amount) | 8.00 |
| Total Tax on purchases (380-381) | ||
| Total VAT Due (399) | ||
| Recoverable VAT | ||
| M0 | Exempt material- and service expenses | |
| I0 | Exempt investment and operating expenses | |
| M77 | Purchase of material and services 7.7% (With VAT/Sales tax) | 7.70 |
| M80 | Purchase of material and services 8.0% (With VAT/Sales tax) | 8.00 |
| M77-1 | Purchase of material and services 7.7% (Without VAT/Sales tax) | 7.70 |
| M80-1 | Purchase of material and services 8.0% (Without VAT/Sales tax) | 8.00 |
| M77-2 | Purchase of material and services 7.7% (VAT/Sales tax amount) | 7.70 |
| M80-2 | Purchase of material and services 8.0% (VAT/Sales tax amount) | 8.00 |
| M25 | Purchase of material and services 2.5% | 2.50 |
| M37 | Purchase of material and services 3.7% | 3.70 |
| M38 | Purchase of material and services 3.8% | 3.80 |
| Investment and operating expenses | ||
| I77 | Investment and operating expenses 7.7% | 7.70 |
| I77-2 | Investment and operating expenses 7.7% (VAT/Sales tax amount) | 7.70 |
| I80 | Investment and operating expenses 8.0% | 8.00 |
| I25 | Investment and operating expenses 2.5% | 2.50 |
| I37 | Investment and operating expenses 3.7% | 3.70 |
| I38 | Investment and operating expenses 3.8% | 3.80 |
| Corrections and adjustments | ||
| K77-A | Subsequent adjustment of prior tax 7.7% (410) | 7.70 |
| K80-A | Subsequent adjustment of prior tax 8 % (410) | 8.00 |
| K77-B | Corrections of prior tax 7.7% (415) | 7.70 |
| K80-B | Corrections of prior tax 8% (415) | 8.00 |
| K77-C | Reductions of the deduction of prior tax 7.7% (420) | 7.70 |
| K80-C | Reductions of the deduction of prior tax 8% (420) | 8.00 |
| F1050 | Tax computation according to form Nr. 1050 | |
| F1055 | Tax computation according to form Nr. 1055 | |
| Total Recoverable VAT (479) | ||
| Total VAT payable (500) or VAT credit (510) | ||
| Other financial flows | ||
| Z0-A | Subsidies, tourist taxes collected by the tourism offices, contributions to the institutions responsible for the elimination of waste and for the supply of water (let. a - c) | |
| Z0 | Gifts, dividends, compensation for damages etc. | |
| Not considered | ||
| Final total for control |