PayPal Multi-currency accounting Templates

Multi-currency accounting files predefined for importing PayPal transactions.

Company XX

Accounting 2016

Basic Currency: EUR

Double-entry

Accounts
Group Account Description Gr
       
    BALANCE SHEET  
       
    ASSETS  
  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
1   TOTAL ASSETS 00
       
       
    LIABILITIES  
  2300 Profit or loss brought forward 2
230   Profit or loss of the current year 2
2   TOTAL LIABILITIES 00
       
       
       
    PROFIT/LOSS STATEMENT  
       
    EXPENSES  
  3000 Paypal Out 3
  3001 Paypal Fee 3
  3002 Other ... 3
  3100 Exchange rate loss 3
3   TOTAL EXPENSES 02
       
    REVENUE  
  4000 Paypal In 4
  4100 Exchange rate profit 4
4   TOTAL REVENUE 02
       
02   Profit(-) Loss(+) from Profit & Loss Statement 230
       
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  
       
    Projects  
  ,P1 Project 1 CP
  ,P2 Project 2 CP
  ,P3 Project 4 CP
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:

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

Changing to another basic currency

This file can easily be converted into one with another 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.

 

Share this article: Twitter | Facebook | Email