PayPal Transfer from Foreign Currency Causing Major Issues on Multicurrency Account
My business earns a lot of money in USD, but since I'm from the UK, I obviously use GBP. Whenever I transfer money from PayPal to my Bank account, it first converts to GBP and then sends it.
My setup looks like:
- Integrated PayPal account using QuickBooks Integration with PayPal - This is a GBP Account
- PayPal USD account to the Bank Accounts so I can track all the USD expenses and payments in the same PayPal account (since integration isn't multicurrency).
- Business Bank Account where I transfer the PayPal money into
What's happening is that if I set transactions as a transfer from Bank Account and say it comes from the PayPal GBP account, it works fine. It's GBP to GBP. However, whenever I try to set a transfer from my PayPal USD account to the PayPal GBP account, it converts the USD to GBP exactly, so $100 = £100, which is obviously wrong. But here is the major problem: I can't correct the values in my account history in the Chart of Accounts because if I correct them there, they will repost the incorrect values again after I've corrected them, meaning I have duplicated transfers (with the one added again being wrong again)! I really can't fathom why it would repost the same transaction after it's been corrected. Each transfer should be assigned a unique ID in the database and then linked to the two accounts using the correct table for USD or GBP, which is set in the account, so that if it's corrected in the account history, it's adjusted in both accounts where the transfer took place. So I'm guessing this is an SQL issue, with the databases wired incorrectly somehow?
The logical way I wanted to do this was to go through the Integration Transactions, but it doesn't let me select the deposit account as my PayPal USD because it's a foreign currency. That would have solved all the issues, and then I could simply exclude the transaction from the PayPal USD account and edit the transaction values in the account history to ensure the USD values match.
The system is making it really hard to automate, which should be a simple procedure. We literally get all USD and GBP values from PayPal as exact figures. If you want to integrate with PayPal, why is it failing so badly at using its API?
The only solution I can see is to automate the transfers, go into the account history on the PayPal GBP account, correct all the values, go into the PayPal USD account, undo all of the PayPal transfers, and then exclude them. It's absurd.
If there is a workaround to automate this, I would greatly appreciate it if someone could provide a working system.