Inter-company reconciliation with excel

Hi all,

First of all I am glad found this forum

with all due request let me tell my requirement,

In my group of company we prepare a sheet to summarize all inter company transactions.So basically we take one company and check from whom money should receive and to whom payable,Therefore we take all companies accounts packs and find out their receivables and payables and put in to the excel Grid (attached herewith)
Latest-Inter com. reconciliation 31.12.2014.xlsx

As you can see in attached sheet company AQQ should receive $200 from company YHH (Cell E10) but when check YHH payables list it only shows $100 payable to AQQ (N5)

So I need your help to summarize this excel sheet to a table (using formulas or anything) to show Each company's data as follows,

eg -

1.What are the receivables balances of AQQ company and what those companys actually have recorded as payable to AQQ and show the difference if does not tally.

2.What are the payable balances of AQQ company and what those companys actually have recorded as receivable from AQQ and show the difference if does not tally.

Thanks in advance.