Sorry to hear you’re struggling with the PayPal feed. Just from the list of the scenarios you’ve mentioned (and this is just a subset) you can see that there are many many different transaction types in PayPal and translating this into a useful set of accounting records can be difficult, especially if you’re dealing with multi-currencies, cancellations, credit holds and all kinds of other edge cases.
Firstly I would establish whether you really need to use the feed at all? The simplest way to handle PayPal for accounting purposes is to just lodge, weekly or monthly bulk sales invoices. I.e. go into PayPal pull a report on all sales and all charges and lodge as two entries on your PayPal merchant account and post the former to a client called PayPal Sales and the charges to a supplier invoice.
Simplified way of Handling Payments from Merchant Accounts
Specifically regarding multi-currency it’s not likely we can fully support this unless PayPal change their feed format. One critical aspect for multi-currency is the exchange rates. PayPal post say a USD entry on one day without the GBP equivalent, then they go an modify that entry on the feed 3-5 days later. To make this work we’d have to constantly poll back a week to check for changes which is simply not practical.
Any foreign currency entries will therefore need to be manually uploaded to a separate USD/EUR (or whichever other currency you’re using) denominated merchant account. At this stage, without bulk logging there is no simple alternative.