In this article

    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.

    In Banana WebApp openen

    Open Banana Accounting Plus op uw browser zonder enige installatie. Pas het sjabloon aan, voer de transacties in en sla het bestand op uw computer op.

    Open tutorial in WebApp

    Model documentatie

    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:

    Modelvoorbeeld

    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