Hi accounting team, I would like to create F*oreign Currency Variance posting rules* for the 58XXXX Funds Transfer account. This way, when there is a booking to transfer funds in foreign currency from one bank to another, NetSuite can record a realized foreign exchange gain or loss. Let's take the following example: Journal Entry #1 on the entity SAS (local currency EURO) Date = 01/01/2023 DEBIT 580000 Funds Transfer - 6430$ (6336,48€) CREDIT 512100 Bank A - 6430$ (6336,48€) Journal Entry #2 on the entity SAS (local currency EURO) Date = 01/03/2023 CREDIT 580000 Funds Transfer - 6430$ (6391.49€) DEBIT 512200 Bank B - 6430$ (€6391.49) When the funds arrive on the Bank B account, there is an exchange loss of 55.01€ (6391.49 - 6336,48), NetSuite should create the following entry (Expected Result): DEBIT 666000 Financial foreign exchange losses 55,01€. CREDIT 580000 Funds Transfer 55.01€. What would be the best way to configure foreign posting rules to handle these use cases? Currently it looks like NetSuite is re-evaluating the balance of my 580000 Funds tranfer account at the end of the period to post an Unrealized gain/loss exchange difference that is reversed at the beginning of the next month.

you need to be using bank FX rate for the journals. At the end of the month it will still revalue everything to the last day of the month rate but your bank reconciliation will be easier