Home > Forum Home > Analyzing Corporate Financial Data > Intercompany Reconciliation Share

Intercompany Reconciliation

Excel Help for Intercompany Reconciliation in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Intercompany Reconciliation

Rate this:
(4/5 from 2 votes)
ConfusedGood Morning guys
I wasn’t sure where to post this thread but I need help in excel regarding a sheet am working on. As you can see in the pic.

I have a list of three months inter-company transactions that I want excel to highlight the amounts that don't have a match.

I tried conditional formatting but the problem is when there is two 1000 figures in Debit and one 1000 figure in credit .. conditional formatting tells me there is a match !!

What I need is a formula that would match the figure and highlight those which are extra.

Regards
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
You could try using a conditional formatting formula with the difference between COUNTIF functions of debits and credits of the amount.  If there are more or less debits of the same amount with credits then the conditional format could be applied.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Intercompany Reconciliation in the