Share this content

PayPal Currency Conversion


I have a client seling a high volume of items that are paid for via Paypal. Most of these transactions are very straightforward in that they are GBP.

The client has started to sell overseas Aus $, US $ and Euro's.

The client provides me with a spreadsheet of PayPal Txs (about 2500 lines per month) and the foreign currency sales are listed but not included in the running balance on the account. A 'currency conversion' line appears for the foreign currencies each month which is included in the running balance. Am I correct in assuming that this is the aggregate of all transactions in a particular curency in the month including both receipts and payments?

Is there a spreadsheet/software available to filter non balance impacting transactions and make the whole thing easier to post into SAGE (the client uses PayPal both for sales and to make purchases)?

Many thanks in advance.


Please login or register to join the discussion.

12th Aug 2012 07:08


I would just sort by column to isolate transactions you need to treat differently.

Thanks (0)
By paul.k2
13th Aug 2012 12:25

I have the scars

I am currently working on a project for an Accounting Practice that is servicing a web based trader.

We have developed a solution based on the spreadsheet downloads that interfaces with software used by the accountant. The accountants have started testing this week.

All sales and most purchases are via PayPal. The trader operates in multiple currencies, but the only currency conversions that seem to happen are when:

1. He pays for something through PayPal

2. He transfers funds from PayPal to his normal bank account.

Each transaction that generates a currency moment seems to have a discrete posting for this, i.e. it is not an aggregation of all movements.
Some traders seem to have a separate PayPal account per currency.

PayPal are not very helpful and it is difficult to find out what might or should be in the download.

For example, should Sales Tax be in there.

I believe there is a version of the download that only shows balance effecting items and I am fairly certain this excludes currency transactions.

Your client can give you read only access to the system.

If I were you I would ask them to do this for you. You could then see the options available to you and decide which is best.

There are at least 3 versions of the download and a range of options that you can select. Your trader is probably just giving you the default.

Paul Kelly


Thanks (1)