This import extension allows you to import Deutsche Bank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.
Refer to the documentation in German: Sparkasse Schwelm-Sprockhövel - Bewegungen importieren .csv (Banana+ Advanced).
This extension lets you import in Banana Accounting your PayPal transactions. Only for Banana+ version.
PayPal transactions are usually composed of small amounts and have many particularities (refund, fees, etc.).
It can be expensive and time consuming to handle all this work within the main company accounting.
We have prepared different template that you can immediately use:
This import extension allows you to import your Lightspeed transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.
The .csv format is different for each bank and is updated and changed regularly. On this page you will find the most recent extension for importing the Valiant Bank .csv format. This import extension allows you to import Valiant Bank transactions into Banana Accounting Plus. The extension can be installed from the Extensions menu > Manage Extensions.
This model is designed to manage the cash-based accounting for a SA or Sagl without VAT obligations. The customer ledger is configured with CC3. Numerous features automate the entry of records, calculations, and VAT reporting, verify and flag errors, and provide outputs such as Balance Sheets and Income Statements, Account Sheets, Journals, financial forecasts and budgets, as well as invoices with Swiss QR codes. Optimize and accelerate your work with professional results. Open the model from our WebApp or directly from the program and save the file on your computer.
Run Banana Accounting Plus on your browser without any installation. Customize the template, enter the transactions and save the file on your computer.
Open template in WebAppIdeal model for managing cash-based accounting for a SA or Sagl, without VAT liability and with an annual turnover equal to or exceeding CHF 500,000. The chart of accounts is structured according to the SME schema and includes the customer/supplier ledger, suitable for those who use cash-based accounting.
Company XXX
Accounting 2025
Basic Currency: CHF
Double-entry
| Group | Account | Description | Sum In | Gr1 |
|---|---|---|---|---|
| BALANCE SHEET | ||||
| ASSETS | ||||
| 1000 | Cash on hand | 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 in Stock Exchange | 10 | ||
| 1090 | Internal transfers | 109 | ||
| 1091 | Transfer account for salaries | 109 | ||
| 1099 | Amounts to be clarified | 109 | ||
| 109 | Transfer accounts | 10 | ||
| 1100 | Due from Clients or Debtors | 110 | ||
| 1109 | Provision for Doubtful Debts | 110 | ||
| 110 | Accounts receivable | 10 | ||
| 1140 | Advances and loans | 114 | ||
| 1176 | Withholding tax | 114 | ||
| 1179 | Source tax | 114 | ||
| 1180 | Receivables from social insurances and social security institutions | 114 | ||
| 1190 | Various short-term receivables | 114 | ||
| 1199 | Securities | 114 | ||
| 114 | Other short-term receivables | 10 | ||
| 1200 | Goods for resale | 120 | ||
| 1210 | Raw materials | 120 | ||
| 1230 | Auxiliary material | 120 | ||
| 1231 | Consumables | 120 | ||
| 1260 | Finished products | 120 | ||
| 1270 | In-process products | 120 | ||
| 1280 | Non-invoiced services | 120 | ||
| 120 | Inventories | 10 | 1 | |
| 1300 | Prepaid expenses | 130 | ||
| 1301 | Accrued income | 130 | ||
| 130 | Prepaid Expenses | 10 | 1 | |
| 10 | Current assets | 1 | 1 | |
| 1400 | Bonds and stocks | 140 | ||
| 1440 | Loans | 140 | ||
| 1460 | Loan to shareholder | 140 | ||
| 140 | Financial assets | 14 | ||
| 1480 | Investments | 148 | ||
| 148 | Investments | 14 | ||
| 1500 | Machinery | 150 | ||
| 1510 | Office furniture and equipment | 150 | ||
| 1520 | Office machinery, information and communication technology | 150 | ||
| 1530 | Motor vehicles | 150 | ||
| 1540 | Tools and equipment | 150 | ||
| 150 | Movable tangible assets | 14 | ||
| 1600 | Commercial buildings | 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 fixed assets | 14 | ||
| 1850 | Unpaid share capital, nominal capital, participation certificate capital or foundation capital | 180 | ||
| 180 | Unpaid share capital or foundation capital | 14 | ||
| 14 | Fixed assets | 1 | ||
| 1 | Total assets | 00 | ||
| LIABILITIES | ||||
| 2000 | Suppliers or creditors | 200 | ||
| 2030 | Deposits received | 200 | ||
| 200 | Suppliers or creditors | 20 | 1 | |
| 2100 | Due to banks short/term | 210 | ||
| 2120 | Financial leasing commitments | 210 | ||
| 2140 | Other onerous debts | 210 | ||
| 210 | Short-term interest-bearing debts | 20 | ||
| 2206 | Withholding tax | 220 | ||
| 2208 | Direct taxes | 220 | ||
| 2210 | Other short-term debts | 220 | ||
| 2260 | Due to share-holders | 220 | ||
| 2261 | Dividends | 220 | ||
| 2270 | Social insurances and social security institutions | 220 | ||
| 2279 | Source tax | 220 | ||
| 220 | Other short-term debts | 20 | ||
| 2300 | Accrued expenses | 230 | ||
| 2301 | Next year's revenues collected | 230 | ||
| 2330 | Short-term provisions | 230 | ||
| 230 | Accruals and deferred income | 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 | Mortgage | 240 | ||
| 240 | Long-term onerous debts | 24 | ||
| 2500 | Other long-term debts (non-onerous) | 250 | ||
| 250 | Other long-term debts | 24 | ||
| 2600 | Provisions | 260 | ||
| 260 | Provisions and similar statutory posts | 24 | ||
| 24 | Long-term third party capital | 2A | ||
| 2A | Third party capital | 2 | ||
| 2800 | Share capital, nominal capital, participation certificate capital or foundation capital | 280 | ||
| 280 | Share capital or capital of the foundation | 28 | ||
| 2900 | Premium at foundation or in the event of a capital increase | 290 | ||
| 2903 | Reserves from capital contributions | 290 | ||
| 2950 | Legal retained earnings | 290 | ||
| 2955 | Revaluation reserve | 290 | ||
| 2960 | Optional reserves from profit | 290 | ||
| 290 | Reserves | 28 | ||
| 2965 | Treasury stock, shares, rights of investment (negative) | 296 | ||
| 296 | Treasury stock, shares, rights of investment (negative) | 28 | ||
| 2970 | Profit / Loss carried forward | 297 | ||
| 2979 | Profit / Loss for the year | 297 | ||
| 297 | Profit / Loss from Balance Sheet | 28 | ||
| 28 | Equity | 2 | ||
| 2 | Total liabilities | 00 | 1 | |
| PROFIT & LOSS STATEMENT | ||||
| 3000 | Earnings from own products | 30 | ||
| 3200 | Earnings from resale | 30 | ||
| 3400 | Earnings from services rendered | 30 | ||
| 3600 | Other revenues and services | 30 | ||
| 3710 | Own consumption | 30 | ||
| 3800 | Decrease in revenues | 30 | ||
| 3805 | Losses on accounts receivable, credit variation | 30 | ||
| 3810 | Credit/debit card fees | 30 | ||
| 30 | Net revenues from supplies 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 | Change in inventories and non-invoiced services | 3 | ||
| 3 | Revenues from supplies and services | E1 | ||
| 4000 | Raw materials | 4 | ||
| 4200 | Expenses for goods for resale | 4 | ||
| 4400 | Third party expenses | 4 | ||
| 4500 | Energy consumption for production | 4 | ||
| 4800 | Reduction of costs | 4 | ||
| 4 | Costs for material, goods, services and energy | E1 | ||
| E1 | Gross operating result after deducting costs for materials and goods | E2 | ||
| 5000 | Salaries | 5 | ||
| 5700 | Contribution to old age insurance and unemployment | 5 | ||
| 5710 | Family equalization fund | 5 | ||
| 5720 | Contribution to pension funds | 5 | ||
| 5730 | Contribution to accident insurance | 5 | ||
| 5740 | Daily sickness benefits insurance | 5 | ||
| 5790 | Source tax | 5 | ||
| 5800 | Other personnel expenses | 5 | ||
| 5810 | Training of personnel | 5 | ||
| 5820 | Travel and entertainment expenses effective | 5 | ||
| 5830 | Travel and entertainment expense allowance | 5 | ||
| 5900 | Temporary staff | 5 | ||
| 5 | Personnel expenses | E2 | ||
| E2 | Gross operating result after deducting personnel expenses | E3 | ||
| 6000 | Rental | 60 | ||
| 6040 | Cleaning of facilities | 60 | ||
| 60 | Rental | 6 | ||
| 6100 | Maintenance, repairs and replacement of movable tangible assets | 61 | ||
| 6105 | Leasing costs of movable tangible assets | 61 | ||
| 61 | Maintenance, repairs and replacement of movable tangible assets | 6 | ||
| 6200 | Repairs | 62 | ||
| 6210 | Fuel | 62 | ||
| 6220 | Car insurance | 62 | ||
| 6260 | Car leasing and rental | 62 | ||
| 6270 | Private share of vehicle expenses | 62 | ||
| 6280 | Transportation expenses | 62 | ||
| 62 | Vehicle and transportation expenses | 6 | ||
| 6300 | Insurance for damage of items | 63 | ||
| 63 | Insurance for damage of items | 6 | ||
| 6402 | Electricity | 64 | ||
| 6410 | Heating expenses | 64 | ||
| 6430 | Water | 64 | ||
| 6460 | Garbage | 64 | ||
| 64 | Energy and disposal costs | 6 | ||
| 6500 | Office supplies | 65 | ||
| 6503 | Technical magazines, newspapers, periodicals | 65 | ||
| 6510 | Telephone / internet | 65 | ||
| 6511 | Hosting at third-party | 65 | ||
| 6513 | Postal charges | 65 | ||
| 6570 | IT charges including leasing | 65 | ||
| 6580 | Licenses and updates | 65 | ||
| 6583 | Consumables | 65 | ||
| 65 | Administrative and IT costs | 6 | ||
| 6600 | Advertising | 66 | ||
| 6642 | Gifts to customers | 66 | ||
| 66 | Advertising | 6 | ||
| 6700 | Various costs for the financial year | 67 | ||
| 67 | Various costs for the financial year | 6 | ||
| 6 | Other operating expenses, depreciation, value adjustments and financial results | E3 | ||
| E3 | Operating result before depreciation and value adjustments, financial results and taxes (EBITDA) | E4 | ||
| 6800 | Depreciation and value adjustments of fixed assets | 68 | ||
| 68 | Depreciation and value adjustments of fixed assets | E4 | ||
| E4 | Operating result before financial results and taxes (EBIT) | E5 | ||
| 6900 | Costs for bank interest | 69 | ||
| 6940 | Bank costs | 69 | ||
| 6950 | Financial revenue | 69 | ||
| 69 | Financial costs and revenue | E5 | ||
| E5 | Operating result before taxes (EBT) | E6 | ||
| 7000 | Non-operating revenue | 7 | ||
| 7010 | Non-operating costs | 7 | ||
| 7500 | Corporate real estate revenues | 7 | ||
| 7510 | Corporate real estate costs | 7 | ||
| 7 | Result from non-operating activities | E6 | ||
| 8000 | Extraneous costs | 8 | ||
| 8100 | Extraneous revenue | 8 | ||
| 8500 | Extraordinary, unique costs or costs relating to other accounting periods | 8 | ||
| 8510 | Extraordinary, unique revenue or revenue relating to other accounting periods | 8 | ||
| 8 | Results of extraneous, extraordinary or unique character, or for other accounting periods | E6 | ||
| E6 | Profit or loss before taxes | E7 | ||
| 8900 | Direct taxes | 89 | ||
| 89 | Direct taxes | E7 | ||
| E7 | Annual profit or loss | 2979 | 1 | |
| 00 | Difference should be = 0 (blank cell) | |||
| Clients ledger | ||||
| ;110001 | Bianchi Ltd. | CLI | ||
| ;110002 | Rossi Francesco | CLI | ||
| ;110003 | John Smith | CLI | ||
| ;110004 | Rossier Anne | CLI | ||
| ;110005 | Müller Ltd. | CLI | ||
| CLI | Total clients | |||
| Suppliers ledger | ||||
| ;200001 | Alberti Sergio | SUP | ||
| ;200002 | Fumagalli Lorenzo | SUP | ||
| ;200003 | Color Ltd. | SUP | ||
| ;200004 | Martini LLC. | SUP | ||
| SUP | Total suppliers | |||
| 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 | |||
| ;PB1 | Publicity 1 | PU | ||
| ;PB2 | Publicity 2 | PU | ||
| PU | Total publicity | |||
| Group | Item | Description | Sum In |
|---|---|---|---|
| AD-1 | Chairs category A | 10 | |
| AD-2 | Chairs category B | 10 | |
| 10 | Total chairs category A and B | ||
| AB-1 | Tables category A | 12 | |
| AB-2 | Tables category B | 12 | |
| 12 | Total tables category A and B | ||
These reports will report the VAT in CHF in case the the base accounting currency is in EUR, USD or another currency different from CHF.
To use this extension it is necessary to have the Advanced plan of Banana Accounting Plus.
The extension is released as a beta version. This means that some details may change without notice.
This import extension allows you to import Basler Kantonalbank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.
Refer to the documentation in German: Basler Kantonalbank - Bewegungen importieren .csv (Banana+ Advanced)
The INPAS International standard template for associations provides a comprehensive framework for organizing financial transactions and reporting for associations adhering to international standards.
Run Banana Accounting Plus on your browser without any installation. Customize the template, enter the transactions and save the file on your computer.
Open template in WebApp[This page is currently being updated]
The INPAS International template for associations provides a comprehensive framework for organizing financial transactions and reporting for associations adhering to international standards.
To use this extension you must download and install Banana Accounting Plus.
To install the extension: