Intercompany reconciliation

njbeancounter

Board Regular
Joined
Oct 7, 2002
Messages
154
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Roxxien

Active Member
Joined
Jul 5, 2017
Messages
289
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"?
 

Roxxien

Active Member
Joined
Jul 5, 2017
Messages
289
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?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,098
Messages
5,466,637
Members
406,493
Latest member
Hazem Hassan

This Week's Hot Topics

Top