Once reconciled, record entries in the "Eliminations" tab. For a $20,000 internal loan, you would debit Payable and credit Receivable to remove them from the consolidated balance sheet. Best Practices for Excel-Based Reconciliation
Necessary for multi-currency transactions to account for foreign exchange rate fluctuations. intercompany transactions reconciliation template excel
The utility of the template is realized through a disciplined 6-step workflow Identification : List all transactions occurring between entities. Once reconciled, record entries in the "Eliminations" tab