We have multiple subsidiaries with different levels and different currencies. Normally after we run our intercompany eliminations the intercompany payable and intercompany receivable account for the consolidated company equals 0. Now for some reason there is about $3k net between them and has been for a couple of months. To find the difference I was thinking I could just run a list of transactions, eliminate the ones that offset and look at the remaining items. Unfortunately whether I run a transaction search or a transaction report, the transactions do not tie to the change in the balance sheet from before the problem existed until now. I also tried to drill into the receivable and the payable accounts and the beginning balance shown does not tie to the balance sheet, nor do the transactions.
Does anyone know of a way to run a report that will show a proper rollforward of the intercompany receivable and payable accounts that will tie to the balance sheet?
I also found an intercompany reconciliation in Netsuite, but when I run it it tells me no data was found.
By the way, almost all of our intercompany transactions are done via journal entries or shared vendor billing.
Thank you in advance