We have a clearing account that we currently reconcile using the Balance Sheet.
I'm having an issue with the Balance sheet and consolidated exchange rates. Our account has multiple Subsidiaries in different currencies - primarily USD and GBP. If I run the balance sheet with the ending period of June 2025 there's an 80k difference in the balance at May31st than if I run the balance sheet with the ending period of May 2025. This is due to the Consolidated exchange rate having changed June 1 2025. When I run the Balance sheet with June 2025 as the end period it uses the June 2025 Consolidated exchange rate and applies it against all FX transactions back to the beginning of our Netsuite use.
Is there a better way to reconcile this account as the balance of it should be 0 or near 0 and this just doesn't seem possible using the Balance Sheet due to the consolidated exchange rates.