We used Pivot Expense Split during our trip to Europe, and it worked really well for handling multi-currency expenses across different accounts and account with multiple currencies like HSBC One.
For each transaction, I simply select the account, local currency, and amount. If the transaction is settled in a different account currency, I choose the “Settle on currency” option.
The transaction is then recorded in the Journal sheet using Google’s exchange rate and automatically split into the Split sheet. Once the bank posts the transaction, I update the Journal and can run the Resplit function if needed.
For entries in the “Split among” field that are settled in another currency, any specified amounts are automatically converted.
For example, an amount of 18.9 in the split (EUR) will be converted to 30.19 CAD for Peter and the rest of CAD to Mary during splitting.
