QBO Landed Costs

Can anyone help out with accounting for landed costs when importing.

I use multicurrency so current workflow....

1. Overseas supplier invoice recorded and paid in USD / EURO etc

2. Shipping paid in GBP to UK based shipping company

3. Import duty / clearance paid in GBP to UK based company for customs

4. Supplier USD prices pasted into a spreadsheet with GBP shipping / customs charges. Spreadsheet distributes the costs and calculates the ACTUAL landed cost of items

The problem I have is how to then allocate this to the item costs in QBO. If it was all in GBP it would be easy (reduce shipping / customs clearance account and increase item stock value)
The method used is from this video https://www.youtube.com/watch?v=zChuAlHNd6Y

I am stuck how to reduce the shipping / duty account as the supplier invoice is in USD so I am not able to follow the guide exactly as it is in the video. Any help by a genuine human and not a forum bot would be appreciated!