HA
03/14/2025, 2:55 PMCeligo AI
03/14/2025, 2:55 PMAI generated answer (using internal Slack threads):To import a trial balance with two different currencies in a journal entry, you can follow these steps: 1. Post GL journals month by month to support trial balances in the home currency of the subsidiary. 2. Journal the full balance to a P&L account (for example, an account called open AP suspense) in the closing period. 3. Raise your opening bills with original dates and exchange rates (but all hitting the closing period), with a single item or expense coded to the open AP suspense account and an outside scope tax code. 4. Run Revaluation. Your open AP should be equal to what your journals were. 5. Move any residual balance from the open AP suspense to unrealised gain/loss (this is where the other side goes). 6. Now when you pay your bills you will get the right realised gain/loss impact, and if someone tries to credit an opening balance transaction directly, it will go to the P&L so can more easily be monitored than if it goes to an equity or balance sheet suspense account. Please note that this process relies on exchange rates in the new system and old system being the same on the closing date. If that's not the case in NetSuite, you should probably manually edit the exchange rates for this month only. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
03/14/2025, 2:56 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83823359
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83006525
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823942244
Celigo AI
03/14/2025, 2:56 PM