En este artículo

Revenue-based Accounting Tutorial for Ltd and LLC | SME

Switzerland
Double-Entry Accounting with vat/sales tax
Education

The ideal template for a Ltd or LLC with VAT management based on revenue. The chart of accounts is structured according to SME standards, and the VAT Codes table includes the rates valid from 01.01.2024. You can manage customers and suppliers, create invoices with QR codes, send reminders, and prepare the VAT report. Professional and immediate reports: Balance Sheet, Profit and Loss Statement, Account Cards, Journal, VAT Summaries, and many other reports, including by period. Cost Centers and Segments to monitor expenses and profitability by sector or project. Digital attachments can be added to transactions. Open the template from our WebApp or directly from the program and save the file to 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 WebApp

Documentación de la plantilla

Efficient and customizable accounting management for SMEs
Our accounting template is pre-configured according to the standard framework of the Swiss Code of Obligations, specifically designed to meet the needs of small and medium-sized enterprises (SMEs) with an annual turnover equal to or greater than CHF 500,000.

Flexibility and customization
If you need to customize the chart of accounts, you can easily add new accounts. See our dedicated page on the Complete SME Chart of Accounts, which includes all the accounts and groups specified by the Swiss SME account system (Sterchi, Mattle, Helbing), ensuring perfect integration.

Simplicity and automation
Data entry is fast and intuitive, with an interface similar to Excel. You can import data directly from your bank statements or credit cards, and thanks to the use of Rules, the process becomes fully automated, drastically reducing manual work.

All-round accounting management
Record transactions quickly and automatically, keep balances always updated, and generate professional real-time reports. With our system, you can:

Some features require a subscription to the Banana Accounting Plus Advanced plan, such as generating the sample or XML file for the VAT report, using the new Rules functions, Filter, and temporary Sort Rows. See all the features of the Advanced plan.

Create your file

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.

Also see Organize accounting files locally, on network and cloud.

Accounts Table

When opening the template, the chart of accounts includes all the accounts to manage your business. You only need to enter:

  • In the Accounts table, Account column, your Customer and Supplier accounts complete with address, country code, and language.
addresses for revenue accounting

opening balances sa sagl

After each transaction, the columns in the Accounts table are updated immediately, giving you a clear and instant view of your financial situation.

The Income Statement has a progressive structure, allowing the profit to be viewed in the following stages:

  • Gross operating profit after deducting material and resale goods costs
  • Gross operating profit after deducting personnel costs
  • Operating result before depreciation, adjustments, financial results, and taxes (EBITDA)
  • Operating result before financial results and taxes (EBIT)
  • Operating result before taxes (EBT)
  • Non-operating result
  • Profit or loss before taxes
  • Annual profit or loss

sa sagl income statement

Record transactions

In the Transactions table, enter all daily movements. To speed up entry, we recommend using various automation features:

Transactions with VAT

To record VAT transactions, simply enter the VAT code corresponding to the operation (purchase, sale, international transactions, etc.). Calculations are made automatically, with no need to manually post to the VAT account.

In our templates, all VAT codes are pre-set in compliance with the new 2024 VAT rates.

revenue-based transaction entries

At the end of the period, you can automatically obtain:

Import transactions from bank statements with Rules (Advanced plan only)

The new Rules feature is the most advanced automation innovation, highly appreciated by our users. This technology simplifies the management of financial transactions imported from bank, postal, and credit card statements using keywords. Each recurring transaction is automatically linked to a keyword, allowing precise assignment of the counterpart, VAT code, costs, and related segments.

Thanks to this system, during subsequent imports, the software quickly recognizes transactions based on the keywords and automatically completes the entry in the Transactions table. This drastically reduces manual entry, significantly speeds up workflow, and minimizes the chance of errors.

import rules

Create your invoices

Integrated invoicing in the accounting file allows invoice data to be recorded in the Transactions table. For each new invoice, insert a new transaction row.

The following settings are essential for creating invoices:

  • Enter customer addresses (columns in the Address view)
  • Set the customer group
  • In the Transactions table, it is essential to enter the invoice number,

You can enter simple invoices on a single row or more complex invoices on multiple rows. Additionally, by enabling the Items columns (from the Tools menu), you can specify quantities, unit, and unit price.

invoices with revenue method

To print the invoice go to Report > Customers > Print Invoice

 

invoice pdf

Beautified Balance Sheet with Groups

To view the Balance Sheet, click on the menu Report  > Beautified Balance Sheet with Groups. You can customize the report with the columns you want to see, such as including the budget column or having Reports also by period.

sa sagl balance sheet

Cash Flow: the lifeblood of your business

Cash flow is central to a company’s ability to operate, maintain solvency with suppliers, and generate income. Anticipating cash availability is essential to avoid mistakes, minimize risks, and optimize strategic decisions, helping you reach your goals successfully.

For optimal business management, it is crucial to have forward-looking insights, forecasting cash flow trends, sales, purchases, and future investments. Knowing whether your business will generate income is important, but forecasting cash availability is even more decisive. Without sufficient liquidity, you may be forced to cut expenses or seek financing.

With Banana Accounting, you can easily create both a cash flow forecast and a financial budget—strategic tools that will help you build a successful future for your business.

Discover the advanced forecasting features in our Documentation:

Template preview

Company XXX

Accounting 2024

Basic Currency: CHF

Double-entry with VAT/Sales tax

Table: Accounts
Group Description Sum In Gr1
    BALANCE SHEET    
         
    ASSETS    
         
  1000 Cash on hand 100  
  1010 Post office current account 100  
  1020 Bank account 100  
  1045 Credit cards / Debit cards 100  
100   Cash and cash equivalents 10 1
         
  1060 Bonds and stocks 106  
106   Short-term assets listed on the stock exchange 10  
         
  1090 Internal transfers 109  
  1091 Transfer account for salaries 109  
  1099 Clarification account 109  
109   Transfer accounts 10  
         
  1100 Receivables from deliveries and services (debtors) 110  
  1109 Provision for doubtful debts 110  
110A   Clients from register 110  
110   Receivables from deliveries and services 10  
         
  1140 Advances and loans 114  
  1176 Withholding tax 114  
  1179 Tax at source 114  
  1180 AHV, IV, EO, ALV current account 114  
  1190 Various short-term receivables 114  
  1191 Deposits 114  
114   Other short-term receivables 10  
         
  1200 Resale merchandise 120  
  1210 Raw materials 120  
  1230 Auxiliary material 120  
  1231 Consumables 120  
  1260 Finished products 120  
  1270 Semi-finished products 120  
  1280 Non-invoiced services 120  
120   Inventories and non-invoiced services 10 1
         
  1300 Prepaid expenses 130  
  1301 Accrued income 130  
130   Accrued income and prepaid expenses 10 1
         
10   Current assets 1 1
         
  1400 Bonds and stocks 140  
  1440 Loans 140  
  1460 Loans/Mortgages to shareholder 140  
140   Financial assets 14  
         
  1480 Participations 148  
148   Participations 14  
         
  1500 Machinery and equipment 150  
  1510 Furniture and installations 150  
  1520 Office machines, information and communication technology 150  
  1530 Vehicles 150  
  1540 Tools and equipment 150  
150   Movable tangible assets 14  
         
  1600 Commercial properties 160  
160   Fixed tangible assets 14  
         
  1700 Patents, know-how, licences, rights and development 170  
  1710 Brands 170  
  1712 Models 170  
  1770 Goodwill 170  
170   Intangible assets 14  
         
  1850 Unpaid share capital, nominal capital, participation certificate capital and foundation capital 180  
180   Unpaid share capital or foundation capital 14  
         
14   Fixed assets 1  
         
1   Total assets 00  
         
         
    LIABILITIES    
         
  2000 Accounts payable (creditors) 200  
  2030 Advance payments from third parties 200  
200A   Suppliers from register 200  
200   Accounts payable 20 1
         
  2100 Short-term debt due to banks 210  
  2120 Financial leasing commitments 210  
  2140 Other onerous debts 210  
210   Short-term interest-bearing debts 20  
         
  2200 VAT due 220  
  2201 VAT settlement account 220  
  2206 Withholding tax 220  
  2208 Direct taxes 220  
  2209 Tax at source 220  
  2210 Other short-term debts 220  
  2260 Debts due to shareholder 220  
  2269 Dividends 220  
  2270 AHV, IV, EO, ALV current account 220  
220   Other short-term debts 20  
         
  2300 Accrued expenses 230  
  2301 Revenues received in advance 230  
  2330 Short-term provisions 230  
230   Accruals and deferred income, short-term provisions 20  
         
20   Short-term third party capital 2A  
         
  2400 Due to banks 240  
  2420 Financial leasing commitments 240  
  2430 Debenture loans 240  
  2450 Loans 240  
  2451 Mortgages 240  
240   Long-term interest-bearing debts 24  
         
  2500 Other long-term debts (not interest-bearing) 250  
250   Other long-term debts 24  
         
  2630 Provisions 260  
260   Long-term provisions and similar statutory positions 24  
         
24   Long-term third party capital 2A  
         
2A   Third party capital 2  
         
  2800 Share capital, nominal capital, participation rights or foundation capital 280  
280   Nominal capital or capital of the foundation 28  
  2900 Premium at foundation or in the event of a capital increase    
  2903 Legal reserves 290  
  2950 Legal retained earnings 290  
  2955 Revaluation reserve 290  
  2960 Optional retained earnings 290  
290   Reserves 28  
  2965 Own shares, nominal shares, share certificates and participation certificates (negative) 296  
296   Own shares, nominal shares, share certificates and participation certificates (negative) 28  
  2970 Profit or loss carried forward 297  
2979   Profit or loss for the year 297  
297   Profit or loss from Balance Sheet 28  
         
28   Equity 2  
         
2   Total liabilities 00 1
         
         
    PROFIT & LOSS STATEMENT    
         
  3000 Revenues from own products 30  
  3200 Revenues from resale merchandise 30  
  3400 Revenues from provided services 30  
  3600 Other revenues and services 30  
  3710 Own consumption 30  
  3800 Decrease in revenues 30  
  3805 Losses on receivables, changes in value adjustments 30  
  3810 Credit/debit card fees 30  
30   Net amount from deliveries and services 3  
  3900 Changes in finished products inventories 39  
  3901 Changes in semi-finished products inventories 39  
  3940 Changes in non-invoiced services value 39  
39   Changes in inventories and non-invoiced services 3  
3   Revenues from supplies and services E1  
         
  4000 Material costs for production 4  
  4200 Merchandise costs for resale 4  
  4400 Expenses for services 4  
  4500 Energy consumption for production 4  
  4800 Discounts 4  
4   Costs for material, goods, services and energy E1  
         
E1   Gross operating result after deducting costs for materials and resale merchandise E2  
         
  5000 Salaries 5  
  5700 AHV, IV, EO, ALV contributions 5  
  5710 Family allowance 5  
  5720 Contribution to pension funds 5  
  5730 Contribution to accident insurance 5  
  5740 Daily sickness benefits insurance 5  
  5790 Tax at source 5  
  5800 Other personnel expenses 5  
  5810 Personnel training 5  
  5820 Travel expenses 5  
  5830 Management flat-rate expenses 5  
  5900 Benefits from third parties 5  
5   Personnel expenses E2  
         
E2   Gross operating result after deducting personnel expenses E3  
         
  6000 Rental 60  
  6040 Cleaning 60  
60   Facility expenses 6  
  6100 Maintenance, repairs and replacement of movable tangible assets 61  
  6105 Leasing of movable tangible assets 61  
61   Maintenance, repairs, replacements (MRR): leasing of movable tangible assets 6  
  6200 Repairs 62  
  6210 Petrol 62  
  6220 Liability insurance 62  
  6260 Vehicle leasing and rental 62  
  6270 Private share of vehicle expenses 62  
  6280 Freights 62  
62   Vehicle and transport expenses 6  
  6300 Property insurance, charges, fees, permits 63  
63   Property insurance, charges, fees, permits 6  
  6400 Electricity 64  
  6410 Heating 64  
  6430 Water 64  
  6460 Garbage 64  
64   Energy and disposal costs 6  
  6500 Office equipment 65  
  6503 Specialist publications, newspapers, periodicals 65  
  6510 Telephone 65  
  6512 Internet 65  
  6513 Postal charges 65  
  6570 IT charges including leasing 65  
  6580 Licenses and updates expenses 65  
  6583 Consumables 65  
65   Administrative and IT expenses 6  
  6600 Advertisements 66  
  6642 Gifts to customers 66  
66   Advertising expenses 6  
  6700 Other operating expenses 67  
67   Other operating expenses 6  
6   Various operating expenses E3  
         
E3   Operating result before depreciation and value adjustments, financial results and taxes (EBITDA) E4  
         
  6800 Depreciation and value adjustments to fixed assets 68  
68   Depreciation and value adjustments to fixed assets E4  
         
E4   Operating result before financial results and taxes (EBIT) E5  
         
  6900 Financial costs 69  
  6940 Bank costs 69  
  6950 Financial revenues 69  
69   Financial costs and revenues E5  
         
E5   Operating result before taxes (EBT) E6  
         
  7000 Ancillary activities revenues 7  
  7010 Ancillary activities costs 7  
  7500 Operational real estate revenues 7  
  7510 Operational real estate costs 7  
7   Ancillary operating result E6  
         
  8000 Non-operating costs 8  
  8100 Non-operating revenues 8  
  8500 Extraordinary, non-recurring or unrelated to the period costs 8  
  8510 Extraordinary, non-recurring or unrelated to the period revenues 8  
8   Non-operating, extraordinary, non-recurring or unrelated to the period result E6  
         
E6   Profit or loss before taxes E7  
         
  8900 Direct taxes 89  
89   Direct taxes E7  
         
E7   Annual profit or loss 2979  
         
00   Difference should be = 0 (blank cell)    
         
         
    Clients register    
  110001 Customer A CLI  
  110002 Customer B CLI  
  110003 Customer C CLI  
  110004 Customer D CLI  
  110005 Customer E CLI  
CLI   Total clients 110A  
         
         
    Suppliers register    
  200001 Supplier A SUP  
  200002 Supplier B SUP  
  200003 Supplier C SUP  
  200004 Supplier D SUP  
  200005 Supplier E SUP  
SUP   Total suppliers 200A  
         
         
    COST CENTERS    
         
  .PAC Packaging A INV  
  .RM Raw materials A INV  
  .AM Auxiliairy materials A INV  
INV   Total inventories    
         
  ,MAN1 Maintenance 1 MAN  
  ,MAN2 Maintenance 2 MAN  
  ,MAN3 Maintenance 3 MAN  
MAN   Total maintenance costs    
         
  ;ADV1 Advertising type 1 ADV  
  ;ADV2 Advertising type 2 ADV  
ADV   Total advertising costs    
         
         
Table: VAT codes
VAT Code Description %VAT
  Explanations  
  V = Sales (200)  
  VS = Discount sales and services (235)  
  B = Acquisition tax (38x)  
  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-2024.20230614  
  Last update: 14.06.2023  
     
  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
V81 Sales and services 8.1% 8.10
V77-B Sales and services 7.7% (chosen) 7.70
V81-B Sales and services 8.1% (chosen) 8.10
V25-N Sales and services 2.5% 2.50
V26 Sales and services 2.6% 2.60
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
VS81 Discount Sales and services 8.1% 8.10
VS25-N Discount Sales and services 2.5% 2.50
VS26 Discount Sales and services 2.6% 2.60
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 2024  
F2 2. Flat tax rate 2024  
FS1 Discount Sales and services 1. Flat tax rate 2024  
FS2 Discount Sales and services 2. Flat tax rate 2024  
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 (322-333)  
     
B77 Acquisition tax 7.7% (With VAT/Sales tax) 7.70
B77-1 Acquisition tax 7.7% (Without VAT/Sales tax) 7.70
B77-2 Acquisition tax 7.7% (VAT/Sales tax amount) 7.70
B81 Acquisition tax 8.1% (With VAT/Sales tax) 8.10
B81-1 Acquisition tax 8.1% (Without VAT/Sales tax) 8.10
B81-2 Acquisition tax 8.1% (VAT/Sales tax amount) 8.10
  Total Tax on purchases (382-383)  
  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
M77-1 Purchase of material and services 7.7% (Without VAT/Sales tax) 7.70
M77-2 Purchase of material and services 7.7% (VAT/Sales tax amount) 7.70
M81 Purchase of material and services 8.1% (With VAT/Sales tax) 8.10
M81-1 Purchase of material and services 8.1% (Without VAT/Sales tax) 8.10
M81-2 Purchase of material and services 8.1% (VAT/Sales tax amount) 8.10
M25 Purchase of material and services 2.5% 2.50
M26 Purchase of material and services 2.6% 2.60
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-1 Investment and operating expenses 7.7% (Without VAT/Sales tax) 7.70
I77-2 Investment and operating expenses 7.7% (VAT/Sales tax amount) 7.70
I81 Investment and operating expenses 8.1% 8.10
I81-1 Investment and operating expenses 8.1% (Without VAT/Sales tax) 8.10
I81-2 Investment and operating expenses 8.1% (VAT/Sales tax amount) 8.10
I25 Investment and operating expenses 2.5% 2.50
I26 Investment and operating expenses 2.6% 2.60
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
K81-A Subsequent adjustment of prior tax 8.1 % (410) 8.10
K77-B Corrections of prior tax 7.7% (415) 7.70
K81-B Corrections of prior tax 8.1% (415) 8.10
K77-C Reductions of the deduction of prior tax 7.7% (420) 7.70
K81-C Reductions of the deduction of prior tax 8.1% (420) 8.10
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  
     

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email