We need lo load Journals from CAD currency to USD books monthly once.I initially wanted to use conversion for loading journals,so that we will have amounts in entered and functional currency.I thought to use month end exchange rate to load journals one time.But our accounting team want to load average exchange rate of month for P&L accounts and month end exchange rate for balance sheet accounts.If i use 2 different exchange rate for journal,as it will become unbalanced journal(receivable account one exchange rate and balance sheet account one exchange rate).


What is the best way to achieve this?



Translational functionality has options to enter different exchange rate's for balance sheet and P&L accounts.



One option is to load journals in USD instead of CAD currency.Then i can use translation to convert balances to CAD.Translation has set up to enter different exchange rate's.


Another option is do conversion based on journal load date from CAD to USD and use translation to use different exchange rate's for accounts.