Intercompany reconciliation

njbeancounter

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

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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"?
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top