Dans cet article
PayPal Templates | Multi-currency accounting
Multi-currency accounting files predefined for importing PayPal transactions.
Ouvrir dans Banana WebApp
Ouvrez Banana Comptabilité Plus sur votre navigateur sans aucune installation. Personnalisez le modèle, saisissez les transactions et enregistrez le fichier sur votre ordinateur.
Ouvrir le modèle dans Banana WebAppDocumentation Modèle
PayPal import transactions
Banana has an import filter that allows you to directly import the PayPal transaction data into your accounting files.
The attached files are predefined with the accounts so that you can immediately start using it.
There are two template example files that you can download and open in Banana:
- Multi currency accounting with EUR as a Basic Currency
- Multi currency accounting with USD as a Basic Currency
Files suitable for
These example files are especially suitable in case you have PayPal transactions in different currencies and especially if you have set up your PayPal account to use and keep different currencies (see also PayPal template for Double-entry accounting) .
The imported transactions will automatically be imported to the currency account, so that you can see all transactions separately and have a balance in the currency.
Even if you use another accounting software, you will find that is very efficient to keep a separate accounting in Banana and keep your PayPal accounting in it. Instead of recording all transctions in your accounting solution, you can keep a separated accounting in Banana and once a month or when needed, only record the summary movement for the period in your accounting solution .
Further adapting the file
The file can easily be adapted to suit your needs.
Adding new accounts and new currencies
-
In the Accounts table, add new accounts for other currencies or for different Income or Expense types.
-
Add new currencies in the Exchange rates Table
Changing to another basic currency
This file can easily be converted into one with another Basic Currency
- Change the Basic currency in the Accounting properties.
- Adapt the Exchange Rates table with the appropriate currencies and exchange rates.
- In the Accounts table, change the currency for the accounts that need to be in Basic currency.
Add VAT/Sales Tax, change language or convert into another type
Use the Convert to new file command to add more options or change the accounting file settings.
Aperçu du modèle
Company XX
Accounting 2022
Basic Currency: EUR
Double-entry
Group | Account | Description | Sum In | Gr1 |
---|---|---|---|---|
BALANCE SHEET | ||||
ASSETS | ||||
Paypal EUR | Paypal Account EUR | Total Assets | ||
Paypal USD | Paypal Account USD | Total Assets | ||
Paypal CHF | Paypal Account CHF | Total Assets | ||
Paypal GBP | Paypal Account GBP | Total Assets | ||
Paypal YEN | Paypal Account YEN | Total Assets | ||
Paypal CAD | Paypal Account CAD | Total Assets | ||
Paypal Account | Paypal Account ... | Total Assets | ||
Bank Account | Bank Account (internal transfer) | Total Assets | ||
Total Assets | TOTAL ASSETS | 00 | 1 | |
LIABILITIES | ||||
Profit or loss brought forward | Profit or loss brought forward | Total Liabilities | ||
230 | Profit or loss of the current year | Total Liabilities | 1 | |
Total Liabilities | TOTAL LIABILITIES | 00 | 1 | |
1 | ||||
PROFIT/LOSS STATEMENT | ||||
EXPENSES | ||||
Paypal Out | Paypal Out | Total Expenses | ||
Paypal Fee | Paypal Fee | Total Expenses | ||
Other | Other | Total Expenses | ||
Exchange rate loss | Exchange rate loss | Total Expenses | ||
Total Expenses | TOTAL EXPENSES | Profit(-) Loss(+) from Profit & Loss Statement | 1 | |
REVENUE | ||||
Paypal In | Paypal In | Total Revenue | ||
Exchange rate profit | Exchange rate profit | Total Revenue | ||
Total Revenue | TOTAL REVENUE | Profit(-) Loss(+) from Profit & Loss Statement | 1 | |
Profit(-) Loss(+) from Profit & Loss Statement | Profit(-) Loss(+) from Profit & Loss Statement | 230 | 1 | |
00 | Difference should be = 0 (blank cell) | |||
COST AND PROFIT CENTERS | ||||
Division | ||||
.D1 | Division 1 | CD | ||
.D2 | Division 2 | CD | ||
.D3 | Division 3 | CD | ||
CD | Total Division | 1 | ||
Projects | ||||
,P1 | Project 1 | CP | ||
,P2 | Project 2 | CP | ||
,P3 | Project 4 | CP | ||
CP | Total Division car expenses |