Sam-I-Am
06/18/2026, 11:16 PMCeligo AI
06/18/2026, 11:16 PMAI generated answer (using internal Slack threads):Foreign Currency Revaluation in Multi-Book Accounting works by adjusting the value of foreign currency transactions to reflect the current exchange rate. This process is necessary to accurately represent the value of foreign currency denominated transactions in the company's base currency. In NetSuite, the foreign currency revaluation process is typically run at the end of each accounting period. It adjusts the value of open Accounts Payable (AP) and Accounts Receivable (AR) transactions that are denominated in a foreign currency. The revaluation process calculates the unrealized foreign exchange (FOREX) gains or losses based on the difference between the original exchange rate (when the transaction was recorded) and the current exchange rate. In the context of a cutover data review, the correct approach would be to import the open ARs and APs using the original foreign currency amount and original exchange rate. Then, a reversing Journal Entry (JE) should be created on the first day of the new period (e.g., 7/1/21) to reverse the unrealized FOREX gains and losses recorded on the last day of the previous period (e.g., 6/30/21). This way, when the foreign currency revaluation process is run in NetSuite, the new unrealized FOREX is the net of the reversal and the cumulative as of the end of the new period (e.g., 7/31/2021). For foreign currency bank accounts, the full foreign currency balance should be loaded with the exchange rate as of the end of the previous period (e.g., 6/30). This ensures that the revaluation process correctly adjusts the value of the foreign currency balance. For non-AR, non-AP, and non-bank accounts, NetSuite revalues all foreign currency transactions posted into these accounts from day one. This includes all debit and credit balances as of the end of the period. In the case of projects paid out in foreign currency, the foreign exchange revaluations are now separate transactions as of the NetSuite 2021.1 release. These transactions are not automatically assigned to the project, even if the bill they are created from is assigned to the project. A workaround for this issue could be to create journals that create the General Ledger (GL) impact that will affect the project. This could involve creating a journal that exactly negates the currency revaluation at the point of bill payment. ****** 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
06/18/2026, 11:17 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.853820801
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.849914551
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843444824
Celigo AI
06/18/2026, 11:17 PM