Multi-currency accounting files predefined for importing PayPal transactions.
See also How to use a template
Basic Currency: EUR
|1000||Paypal Account EUR||1|
|1001||Paypal Account USD||1|
|1002||Paypal Account CHF||1|
|1003||Paypal Account GBP||1|
|1004||Paypal Account YPY||1|
|1005||Paypal Account CAD||1|
|1006||Paypal Account ...||1|
|1500||Bank Account (internal transfer)||1|
|2300||Profit or loss brought forward||2|
|230||Profit or loss of the current year||2|
|3100||Exchange rate loss||3|
|4100||Exchange rate profit||4|
|02||Profit(-) Loss(+) from Profit & Loss Statement||230|
|00||Difference should be = 0 (blank cell)|
|COST AND PROFIT CENTERS|
|CP||Total Division car expenses|
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 normal 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.