This is the process for dealing with Paypal for Wordjuice Ltd accounts analysis |
Download 'Completed Payments' from Paypal |
Take CSV file and upload to Google Sheets (ie the document you're in now) |
Take Original file and take out unnecessary columns |
Sort into Currency Order in new tab |
In next tab, create USD (do this before GBP) |
Sort next tab, USD in $ order value |
Do some process for GBP |
Add other currencies at the end, eg EUR or JPN |