In this article

PayPal Templates | Multi-currency accounting

Universell
Doppelte Buchhaltung mit Fremdwährungen
Unternehmen

Multi-currency accounting files predefined for importing PayPal transactions.

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 WebApp

Template documentation

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 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.

 

Template preview

Company XX

Accounting 2022

Basic Currency: EUR

Double-entry

Table: Accounts
Group 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    

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email