Question

PayPal Foreign Transaction are not correct

Forum|Forum|7 years ago
November 8, 2018
1 reply
10 views

One of my clients, their PayPal transactions are coming into QB at the currency they were paid in rather than USD. An example is that if they pay someone in 15000 PHP it comes into QB as 15000 PHP and not 300 USD (rough figures)

Any know how to fix this?

QuickBooks Online

V

VivienJ

Hi there, Dean Anderson.

I’m here to help with your PayPal transactions.

Are you using the US version of QuickBooks, or the International version, such as QBO Philippines? Did you connect your PayPal account as a Bank account in the program? Also, are these transactions imported into the program, or you’re manually entering them while referencing the PayPal statement?

If you’re using the International version and you’ve connected PayPal as a Bank Account, you'll first enable the Multicurrency feature of the program so all foreign transactions will calculate correctly. Then, set up the vendor your client needs to pay with a USD currency.

You can then create a USD PayPal account in your Chart of accounts. This way, you’ll be able to transfer those transactions from the Php PayPal account to the foreign account.

To set up your vendor in foreign currency:

Go to Expenses in the left panel, then Suppliers.
Click New Supplier.
Enter the necessary vendor details.
Choose USD in the I pay this supplier with dropdown.
Click Save.

To set up the foreign PayPal bank account:

Go to Accounting in the left panel, then Chart of Accounts.
Click New.
Enter some relevant information.
Select USD under Currency, then click Save and Close.

Once the PayPal in Php transactions come over, transfer the transactions you need in the PayPal USD account.

Here’s how:

Click the Create button (Plus icon), pick Transfer.
In the Transfer Funds From drop-down, select the PayPal in Php.
Choose PayPal in USD in the Transfer Funds To drop-down.
Ensure the currency is in USD.
Enter the Transfer Amount.
Click Save and Close.

For more details about how the Multicurrency feature works in QuickBooks Online, check out this article:

That’s it! Your foreign transactions should be posted accurately in the program.

Let me know if you’re referring to something different, or if you have questions with the process. I’ll be around.

S

sbo1Author

Hi,

The client is using the US version of QB and I believe that they connected to PayPal via QB. The account on QB is also USD denominated PayPal account.

This is only a recent thing as up until mid-September and the start of October the transaction were all coming into QB in USD so it a very new issue.

Thanks

Dean

J

JamesDuanT

QuickBooks Team

I have this similar problem. It is showing USD $150 in my PayPal account but it is showing up as CAD $150 in my QuickBooks account. I have been looking for ways to match/record this transaction but I haven't managed to do so since it shows as CAD $150 under my PayPal account in my Quickbooks when it's supposed to be USD $150...

We appreciate you for joining in on the thread, RuRuRu.

Just like CharleneMae_F explained on her response, the imported transactions will follow the home currency of the company. If your company's home currency is CAD while your PayPal accounts is in USD, I'd recommend correcting the transactions within the PayPal.

You can log in to your PayPal account and convert the amounts from USD to CAD. After that, you can already import the data to QuickBooks Online. This will or should correct your future transactions which was also mentioned by VivienJ on this response.

Meanwhile, we can follow the steps in this response to correct the transactions that were already imported in QuickBooks Online.

Though there is still room for questions to clarify your situation, the steps provided by VivienJ and CharleneMae_F to correct the data were pretty much the same.

Please get back to us if you have additional queries about the process. We'd be glad to hear more details about it.

Sign up

Login with SSO

Let's get you signed in

Login with SSO