Spreadsheet loader - how do i load secondary ledger values
I have been tasks with finding a solution to a multi currency GL Journal loader issue. The accounting team gets a payment in SGD transactional currency for a BU with GBP as the base currency. However the bank account this journal needs to be reconciled to has USD as the base currency. This is also the currency for our secondary ledger. Is there a way to use spreadsheet loader and load all 3 transaction amounts and currency?
example:
Transaction 10 SGD
Base 5 GBP
Secondary ledger transaction 5 GBP
Secondary ledger base 6 USD