Dans cet article

    PayPal Templates | Multi-currency accounting

    Double-Entry Accounting with foreign currencies

    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 WebApp

    Documentation 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:

    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.


    Aperçu du modèle

    Company XX

    Accounting 2022

    Basic Currency: EUR


    Table: Accounts
    Group Description Sum In Gr1
        BALANCE SHEET    
      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
      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
      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
      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)    
      .D1 Division 1 CD  
      .D2 Division 2 CD  
      .D3 Division 3 CD  
    CD   Total Division   1
      ,P1 Project 1 CP  
      ,P2 Project 2 CP  
      ,P3 Project 4 CP  
    CP   Total Division car expenses    
    Dites-nous comment nous pouvons mieux vous aider
    Si les informations contenues dans cette page ne correspondent pas à ce que vous recherchez, ne sont pas suffisamment claires ou ne sont pas à jour, faites-nous savoir.

    Partager cet article: Twitter | Facebook | LinkedIn | Email