The intercompany balances matrix is not merely a reconciliation table, it is the “balance engineer” of holding groups and sister companies. In financial engineering, this matrix represents the “filter” that prevents the inflation of profits or the creation of fictitious assets caused by internal transactions. It ensures that every riyal recorded as a “debit” in Company A is matched by a riyal recorded as a “credit” in Company B. Having an organized matrix means you are managing your group of companies with a mindset of unified transparency, which simplifies the “elimination” process when preparing consolidated financial statements and protects the group from the risk of accounting errors that could mislead decision makers or regulators.
Why do you need an intercompany balances matrix template?
- Settling intercompany variances: identify the reasons for balance mismatches (such as invoices in transit or payments not yet recorded) and resolve them before closing the financial period.
- Facilitating consolidation: provide ready data for tax and accounting elimination procedures, accelerating the issuance of the group’s financial statements.
- Controlling internal cash flows: track loans, transfers, and mutual services between branches or subsidiaries to ensure that defined credit ceilings are not exceeded.
- Tax and regulatory compliance: document VAT and calculate it automatically on intercompany transactions to ensure accurate tax returns for each legal entity individually.
Who benefits from the template
- Group CFOs: to ensure the integrity of consolidated financial reports and oversight of subsidiaries’ financial positions.
- Chief accountants and accountants: to perform periodic reconciliations and ensure that intercompany transactions are recorded at the right time on both sides.
- External auditors: who use the intercompany balances matrix as a core audit tool to verify the accuracy of mutual balances and confirm they are free from material misstatements affecting the fairness of the statements.
- Treasury and investment officers: to monitor liquidity levels distributed across the group’s entities and improve working capital management.
Strategic elements of the intercompany balances matrix template
For the intercompany balances matrix template to achieve its control objectives, it must include the following technical components:
- Entity matrix: a table that maps the companies (debtor on rows, creditor on columns).
- Transaction data: (entry number, transaction type: supply, loan, services, date).
- Variance analysis: a dedicated field to note the reasons for mismatches (timing differences).
- Reconciliation status: a color indicator (green for matched, red for variance) to quickly highlight any deviations.
How to use the intercompany balances matrix template (in 5 steps)
To ensure your group’s accounts match and are free from errors, follow these steps:
- Enter company balances (debit side)
Start by entering the balances due to Company A from the other sister companies. Record each amount against the corresponding company in the matrix.
- Record the matching balances (credit side)
Ask the sister companies to provide their credit balances toward your company. Enter this data in the corresponding cells. The template will instantly calculate the difference between the two figures.
- Identify the causes of the “variance”
If a difference appears in red, move to the “variance settlement” table. Look for transactions recorded by one party but not the other (such as goods in transit). Log these amounts as “adjustments” until the difference reaches zero.
- Reconcile VAT
Ensure that the VAT amounts calculated on intercompany invoices are identical on both sides. Correct use of the template ensures that VAT is captured and calculated automatically, boosting the efficiency of your documentation cycle and preventing double taxation.
- Approval and elimination
Once final reconciliation is reached, use the unified figures to post elimination entries when preparing the group’s balance sheet. This step ensures the consolidated statements reflect only transactions with “external parties”.
Frequently asked questions
What is the intercompany balances matrix?
It is a control tool that ensures accounts match between sister companies. Every riyal posted as a “debit” in the first company must be matched by a riyal posted as a “credit” in the second.
Why do variances appear between sister companies?
Because of timing factors, such as goods or financial transfers sent by one party that have not yet reached the other, or differences in the timing of VAT recognition.
What is “elimination”?
It is the removal of intercompany transactions when preparing consolidated financial statements, because a group cannot profit from itself. The matrix is what provides the accurate figures for this removal.
How does the matrix protect the group from a tax perspective?
It ensures that the output VAT at the seller matches the input VAT at the buyer, preventing errors in the tax returns of each legal entity.
Expert tip from Qoyod
Manual reconciliation between companies is an accounting “maze”. Excel templates give you the structure, but the Qoyod system gives you strategic visibility through branch and group management, which reconciles intercompany operations in real time. When your companies are connected through a single cloud system, reconciliation shifts from a month end ordeal into an automated accounting entry that keeps the group’s balances aligned at all times, supporting your accelerated growth and protecting your financial stability.
[Align your group’s accounts and keep your numbers balanced, try Qoyod for free now]