Frequently asked qestions and answers

Who provides Import statements PayPal service?

The service is provided by Ing. Samuel Zubo, ID no.: 75396602, Not regitered to VAT.

What are the main advantages of the service?

The main advantages of the service are:

  • 98% time saving
  • 98% cost saving
  • error protection of the accounting data

What is the cheapest way to use Import statements PayPal service? What kind of discouts / bonuses are offered?

Here are some recommendations:

  • Do bigger purchase (increase of the balance) and get up to 23% discount.
  • Pay by bank transfer (for using PayPal we charge the 5% fee).
  • Recommend us to your friend. He/she will get 50 transactions for free and we will increase your balance with 10% of his first order. And he will get 50 transaction additionaly.
  • Write us, how sattisfied You are with our service. If we will post your feedback on our pages, as thanks we will increase your balance.:)

Do you afford a VAT invoice?

Yes, after receiving the payment for order we will immediately send you email with the link for downloading the tax document - invoice in PDF format. We are not-registered for VAT since 11.1.2023.

How to get original PayPal statement?

  • Please log in on the site www.paypal.com.
  • In the menu choose: "Activity".
  • PayPal shows last transactions:
  • Choose "Download".
  • The form will be displayed.
  • Choose the interval (first and last day of the month) and the format of the statement: "Comma Delimited - All Activity".
  • By clicking on "Download History" You will save the statement in your computer. in the .csv format

  • WARNING!
    • The updates into MS Excel, or Google spreadsheet can change the date format in some cells. In that case the transformation will not work.
    • Do not remove lines from original file. Removing of some transactions from original file can have unexpected impact on the whole transformation
    • If You need to edit the original statement, please use simple text editor e.g. Notepad, PS Editor, Sublime Text.

My accounting software supports more formats for bank statements import. Which format should I use?

If your accounting software supports various formats for statements import, we basically recommend to use XML. However with following exceptions.
Accounting softwares are not perfect. Each one has some problem with certain statement format. Certain formats do not allow to insert into the accounting all data we would like to.
For XML it is possible to insert more information from original PayPal statements. Thus there will be more information in your accounting and your accountant will have a better overview of which payment is concerned and from whom the payment comes. Unfortunately ABO format do not allow inserting of some important parameters.
Therefore our recommendation for accounting software are following:

  • Accounting software Pohoda - use the statements in ABO format
  • Accounting software Money S3 - use the statements in Sepa XML format.
  • For other accounting softwares use SEPA XML if possible.

How much time can I save with PayPal / Raiffeisenbank / Ceska Sporitelna Bank statement import?

According to our experiences on standard hardware it is possible to save up to 98% of time with sofwares Money S3 or Pohoda. With faster programs or hardware the saving can be even higher.

What to do for correct payment matching?

The "must" is correct using of the variable symbol. Variable symbol should have 10 digits in Czech republic and Slovak republic. If You use PayPal, Your eshop should send varibale symbol to payment gateway in the parameter <input type="hidden" name="invoice" value="'{variabilní symbol}'">. Yes it is confusing, as some companies use the variable symbol as customer ID, order ID, or invoice ID. In the statement from PayPal You will find these values in the column named: "Invoice Number". This value is necessary for pairing payments with invoices in the accounting.

The rules for right payments can be adjusted in your accounting software. Usual requirements are:

  • match in variable symbol
  • match in the volume and the currency of the transaction. Thus we recommend to create invoice in the same currency as the payment to the PayPal was realized (e.g. CZK, EUR).
  • Set the column with variable symbol of the original statement: My account -> The variable symbol column (PayPal statement). Default value is "Invoice Number".

Why is the accounting of transactions from PayPal statements so complicated?

PayPal allows the different kinds of statements. The basic one is PDF format which contains niether variable symbol nor client data. In this case the easy payments matching is impossible and searching demands much time. The matching is even more complicated if the invoice is issued in a currency different from the currency in which the PayPal account is kept, because the amount in the invoice differs from the amount in the statement.

How to import the statements into Pohoda accounting software? What are the advantages and disadvantages of using different statement formats?

ABO - we recommend to use in the accounting software Pohoda

How Pohoda complements the parameters of an accounting document:

  • Matching is based on the variable symbol given that the amount on the invoice corresponds to the amount on the statement.
  • Note we enter first 20 characters of partner's email. In regard to the PayPal charge the value is "poplatky".
  • Date of the transaction is the same as the date of PayPal account activity.
  • Company - data are get from the matched invoice (in the moment of matching).
  • The setting alone of ABO is much easier than it is in Money S3: Bank accounts -> Homebanking -> New -> ABO -> .

    • SEPA XML

  • Matching is based on the variable symbol given that the amount on the invoice corresponds to the amount on the statement.
  • Imports only the amount and variable symbol.
  • Date of the transaction is set incorrectly - the date of statement is used and so it is the same for all transactions in the statement.
  • Contact information of the other side are not entered.

    • How to best import the statements into Money S3 accounting software? What are the advantages and disadvantages of using different statement formats?

    SEPA XML - we recommend to use in the accounting program Money S3

  • Matching is based on the variable symbol given that the amount on the invoice corresponds to the amount on the statement.
  • Imports only the amount and variable symbol.
  • Date of the transaction is set correctly - the transaction date from the statement is used.
  • Date of the account document drawing is set to the date of statement import.
  • Does not fill the contact information of the other side.
  • Does not fill the comment to the frame Comment.

    • ABO

    How Money S3 complements the parameters of an accounting document:

  • Matching is based on the variable symbol given that the amount on the invoice corresponds to the amount on the statement.
  • Note we enter first 20 characters of partner's email. In regard to the PayPal charge the value is "poplatky".
  • Date of the transaction is the same as the date of PayPal account activity.
  • Company - data are get from the matched invoice (in the moment of matching).
  • The setting alone of ABO is more complicated than it is in Pohoda: Accounting -> Bank -> Homebanking -> Account the statement -> ... (prtntscrns) -> ABO format setting -> Account statements -> Account number format: "internal format", Bank code: 7777.