Dans cet article

    PayPal Templates | Multi-currency accounting

    Universal
    Double-Entry Accounting with foreign currencies
    Business

    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

    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    

    Aidez-nous à améliorer la documentation

    Nous serions heureux de recevoir des commentaires sur l'amélioration de cette page.

    Dites-nous quel thème doit être mieux expliqué ou comment clarifier un sujet.

    Partager cet article: Twitter | Facebook | LinkedIn | Email