Double-entry template files predefined for importing PayPal transactions.
Basic information about Double-Entry Accounting
PayPal import transaction
Banana has an import filter that allows you to directly import the PayPal transactions data in your accounting file.
The attached files are predefined with the accounts so that you can start immediately using it.
There are two template example files you can download and open in Banana:
Files suitable for
These template files are especially suitable in case you have only one PayPal preferred currency.
The imported transactions will automatically be imported to the currency account, so that you can separately see all transactions.
If in PayPal you keep balances in different currencies, it will be more suitable to use a PayPal accounting in Multicurrency.
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 transactions 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.
Changing to another Basic currency
This file can easily be converted into one with another Basic currency.
- Change the Basic currency in the File properties.
Add VAT/Sales Tax, change language or convert into another type
Use Convert to new file to add more options or change the accounting file settings.
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|