Intercompany reconciliation

[njbeancounter]

Below is an inter-company analysis I am working on. It shows that the books of Company A has a $10 receivable from Company B. However, on Company B books, there is a payable to Company A in the amount of $9.

I need to include an analysis showing A receivable compared to B payable, and then the rest of the companies as well. Is there a relatively easy way to compile this, as there are MANY combinations and I need to capture them all.

Thanks in advance...

A/R
a b c d e f g h i j k l m n o p q r s t
a 10 20
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum



A/P
a b c d e f g h i j k l m n o p q r s t
a
b 9
c 15
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s

 

[Roxxien]

Hello njbeancounter,

Is it possible for you to use one of the possibility of those to put your information?
Guidelines for Forum Use

It will truly help to follow everything.

I understand that you need something to see the difference between 2 numbers. But what those you want? Spotlight? Colored Cells? Message Box?

After that, what are talking about the "many combination"?

 

[njbeancounter]

I cant seem to get the html maker to work...its been that kinda day...

 

[Roxxien]

In that case, can you put less row and column? because is see to many letter for just 2 number in each block.

After that, you answer to my question?