In this article
Sole proprietorship | SME | Simplified plan | Double-Entry Multi-Currency Accounting
Ideal model for a sole proprietorship with accounts in multiple currencies in addition to the base currency. This file is designed for businesses that use currencies other than their base currency. It includes dedicated columns and an Exchange Rates table where you can set the exchange rate freely. Each time you record a transaction, the program automatically calculates the equivalent value in the base currency. Exchange rate differences are also calculated automatically. You can set up a second currency to present reports and balance sheets abroad, with balances available in both the base currency and the secondary currency. Open the model from our WebApp or directly from the program, and save the file on your computer.
Open in Banana WebApp
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 WebAppTemplate documentation
The multi-currency model based on double-entry accounting, this model allows you to manage accounts in foreign currencies as well as the base currency.
Create your File
- Open the template using the Banana Accounting Plus WebApp.
Use the command File > File Properties to set the period, your company name, and the base currency (you can manage your budget and accounting in any currency).
Use the command File > Save As to save the file. It's helpful to include the company name and year in the file name, e.g., "Rossi-SA-20xx.ac2". - In the Exchange Rates Table, set the foreign currencies always in reference to the base currency and their exchange rates. Opening exchange rates are only set the first time you use Banana Accounting. When transitioning to a new year, these rates will be automatically carried over based on the closing rates entered as of 31.12.
ATTENTION: If you close the browser without saving, the data you entered will be lost. Always save the file on your computer.
To reopen the saved file, click File > Open.
In our Documentation, you will find detailed explanations and topics related to multi-currency accounting, including:
Template preview
Company XX
Accounting 2025
Basic Currency: CHF
Double-entry with foreign currencies
Group | Account | Description | Currency | Sum In | Gr1 |
---|---|---|---|---|---|
BALANCE SHEET | |||||
ASSETS | |||||
1000 | Cash on hand | CHF | 10 | ||
1010 | Post office current account | CHF | 10 | ||
1020 | Bank account | CHF | 10 | ||
1024 | Bank account EUR | EUR | 10 | ||
1025 | Bank account USD | USD | 10 | ||
1045 | Credit cards / Debit cards | CHF | 10 | ||
1090 | Internal transfers | CHF | 10 | ||
1091 | Transfer account for salaries | CHF | 10 | ||
1099 | Amounts to be clarified | CHF | 10 | ||
1100 | Due from clients or debtors | CHF | 10 | ||
1176 | Withholding tax | CHF | 10 | ||
1191 | Deposits | CHF | 10 | ||
1300 | Accrued income and prepaid expenses | CHF | 10 | ||
10 | Current assets | 1 | |||
1500 | Machinery | CHF | 14 | ||
1510 | Office equipment | CHF | 14 | ||
1512 | Store fixtures | CHF | 14 | ||
1520 | Office machines, information and communication technology | CHF | 14 | ||
1530 | Vehicles | CHF | 14 | ||
1540 | Tools and equipment | CHF | 14 | ||
14 | Fixed assets | 1 | |||
1 | TOTAL ASSETS | 00 | 1 | ||
LIABILITIES | |||||
2000 | Accounts payable | CHF | 20 | ||
2100 | Short-term interest-bearing debts | CHF | 20 | ||
2300 | Accruals and deferred income | CHF | 20 | ||
20 | Short-term third party capital | 2 | |||
2400 | Due to banks | CHF | 24 | ||
2500 | Other long-term debts | CHF | 24 | ||
2600 | Provisions | CHF | 24 | ||
24 | Long-term third party capital | 2 | |||
2800 | Share capital | CHF | 28 | ||
2850 | Private account | CHF | 28 | ||
2970 | Profit or loss carried forward | CHF | 28 | ||
2891 | Annual profit or loss | CHF | 28 | 1 | |
28 | Equity | 2 | |||
2 | TOTAL LIALIBILITIES | 00 | 1 | ||
PROFIT & LOSS STATEMENT | |||||
REVENUES | |||||
3000 | Gross revenues from manufactured products | CHF | 3 | ||
3200 | Gross revenues from resale of goods | CHF | 3 | ||
3400 | Gross revenues from provided services | CHF | 3 | ||
3600 | Other revenues | CHF | 3 | ||
3710 | Own consumption | CHF | 3 | ||
3800 | Discounts | CHF | 3 | ||
3810 | Credit/debit card fees | CHF | 3 | ||
3 | TOTAL REVENUES | 02 | 1 | ||
EXPENSES | |||||
4000 | Purchases | CHF | 4 | ||
4 | Purchases | 4-6 | |||
5600 | Salaries (administration) | CHF | 5 | ||
5701 | AHV, IV, EO holder | CHF | 5 | ||
5710 | Family allowances | CHF | 5 | ||
5720 | Contribution to pension funds | CHF | 5 | ||
5730 | Contribution to accident insurance | CHF | 5 | ||
5740 | Contribution to voluntary daily benefits insurance | CHF | 5 | ||
5790 | Source tax | CHF | 5 | ||
5820 | Travel expenses | CHF | 5 | ||
5830 | Management flat-rate expenses | CHF | 5 | ||
5880 | Other personal expenses | CHF | 5 | ||
5900 | Temporary staff | CHF | 5 | ||
5 | Personnel expenses | 4-6 | 1 | ||
Financial charges and revenue | |||||
6000 | Rental | CHF | 6 | ||
6030 | Incidental rent costs | CHF | 6 | ||
6100 | Maintenance, repairs and replacement of tangible assets | CHF | 6 | ||
6200 | Repairs | CHF | 6 | ||
6210 | Fuel | CHF | 6 | ||
6220 | Car insurance | CHF | 6 | ||
6260 | Car leasing and rental | CHF | 6 | ||
6280 | Transport expenses | CHF | 6 | ||
6300 | Insurance for damage of items | CHF | 6 | ||
6400 | Energy and disposal costs | CHF | 6 | ||
6500 | Office equipment | CHF | 6 | ||
6503 | Technical magazines, newspapers, periodicals | CHF | 6 | ||
6510 | Phone / internet | CHF | 6 | ||
6513 | Postages | CHF | 6 | ||
6520 | Contributions | CHF | 6 | ||
6521 | Donations, grants | CHF | 6 | ||
6530 | Book-keeping fees | CHF | 6 | ||
6570 | IT costs including leasing | CHF | 6 | ||
6574 | Small investments | CHF | 6 | ||
6580 | Licenses and updates | CHF | 6 | ||
6583 | Consumables | CHF | 6 | ||
6600 | Advertising expenses | CHF | 6 | ||
6641 | Customer support | CHF | 6 | ||
6800 | Depreciation and value adjustments of fixed assets | CHF | 6 | ||
6900 | Costs for bank interests | CHF | 6 | ||
6940 | Bank charges | CHF | 6 | ||
6949 | Exchange rate loss | CHF | 6 | ||
6950 | Financial revenues | CHF | 6 | ||
6999 | Exchange rate profit | CHF | 6 | ||
8900 | Direct taxes | CHF | 6 | ||
6 | Other operating expenses | 4-6 | 1 | ||
4-6 | TOTAL EXPENSES | 02 | |||
02 | Annual profit (-) or loss (+) | 2891 | 1 | ||
00 | Difference should be = 0 (blank cell) | ||||
COST CENTERS | |||||
.PAC | Packaging A | CHF | INV | ||
.RAW | Raw materials A | CHF | INV | ||
.AUX | Auxiliary material A | CHF | INV | ||
INV | Total inventories | ||||
,MAN1 | Maintenance 1 | CHF | MAN | ||
,MAN2 | Maintenance 2 | CHF | MAN | ||
,MAN3 | Maintenance 3 | CHF | MAN | ||
MAN | Total maintenance | ||||
;PB1 | Publicity 1 | CHF | PU | ||
;PB2 | Publicity 2 | CHF | PU | ||
PU | Total publicity | ||||
Ref.Currency | Currency | Text |
---|---|---|
CHF | EUR | Euro |
CHF | USD | US Dollar |