Import Journal Transactions for Trial Balance but There's 1 Cash Account use Other Currency

Hi ​@dinda56 

In your scenario, where you are importing Trial Balance data and one Cash Account uses a foreign currency (USD) while the base currency is IDR, the recommended and safest approach is to separate Journal Transactions by currency.

Key Principle. You should:
+ Create one Journal Transaction for IDR accounts
+ Create another Journal Transaction for USD accounts
+ Use Opening Balance accounts (clearing accounts) for each currency to keep journals balanced.
This ensures the system correctly handles currency and exchange rate calculations.

Best Regards,

NNT

Hi ​@nhatnghetinh Thank you for your answer. So, it’s better to separate between the currency right.
Lets say I Import the trial balance uses Journal Transactions for IDR Accounts.
and after all the data of IDR accounts up to Acumatica, I start to import the trial balance uses Journal Transactions for USD accounts, is that correct? 

Hi ​@dinda56 

Yes, To be safe after you import the Journal Transactions do not Release. Please check if the Credit & Debit balances in the Transaction Journals match the trial balance => Only then should you release the data.

Note that you may need to use opening balance accounts (clearing accounts) for each currency to keep journals balanced.

Best Regards,

NNT

​@nhatnghetinh Okay thank you for the explanation, I will try it, thank you.

Hello.

In addition to NNT’s suggestions, another option that I have used successfully:

1. Set up an extra cash account denominated IDR in GL and in Banking, representing “Future US$” account figure.
2. Import all trial balance figures in IDR.
3. For each month that was migrated, use Fund Transfer screen in Banking to move Future US$ account balance out of the temporary IDR cash account and into the real USD$-denominated Banking Cash Account. Use proper month-end dates and exchange rates for the month on the Fund Transfer.
4. When all money is moved and translated to the USD$ Bank Account, inactivate the temporary extra account denominated IDR.  

I hope this helps you.

Laura