Intercompany Matrix

Hi Michael,

I think this depends on the size of data you are reconciling.

We build an IC Reconciliation Matrix when comparing transactions accounts multiples accounts. These could be two columns of data side by side, or multiple accounts/companies that we have to pivot.

If have a reference column you could use the Match function and Index to balance it

If you have transactions broken into separate amount you might need to write a SUMIFS formula.

If you could provide more detail we can offer suggestions on the techniques.

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector