Hello Victor,

You have already said that you are using a spreadsheet to manually allocate the costs among the lines on your receipt. If you insist on using the manual proration, then add two columns to the spreadsheet to calculate the amount to prorate in the currency of the item vendor and have the spreadsheet tell you the amounts to enter.