intercompany reconciliation

**sibyxa** · 08-18-2009, 12:36 PM

Hi All

Looking for a solution for reconcile intercompany transactions within 2 spreadsheets

I need some expert advise in how to develope a macro function to reconcile amount lines.

The example attached will give you some idea of what I am talking about

Thank you!

**modytrane** · 08-18-2009, 01:10 PM

I am not sure what results you are looking for.
Look at the sample attached.
Look at B6 and E6. Are those figures correct?
What do you want to enter in B9, E9, B11 and E11?
Explain the logic as to how those figures are to be calculates.
I am not sure if you need any macros.
You may be able to do it just with formulas.
modytrane

**sibyxa** · 08-18-2009, 01:44 PM

Thanks for your immediate reply

X co. receivable means Y co payable and X co payable means X company Receivable. Some cases this will not match becz invoices not received in time from other company

My requirements

1) To match the exact amount between co. X & Y, If match then fill "R" under reconciled column

2) Unmatched items will show seperate spreadsheet named "Reco". (Invoice to book by X co. means invoices not received from Y)

B9 = Invoices not booked yet E9 = Balance after adjustments

Hope u understand and sorry for my English

Thanks

**modytrane** · 08-18-2009, 02:21 PM

I am still not very clear.
Are you looking to match the Amount figures or do you need to match the invoice numbers.
I would think that you have to match the invoice numbers.
In that case, let's take the first invoice on both sheets [X Co Data and Y Co data]. The amount shows as 1546.00, but the invoice numbers are different.
How do account for that? Do you consider this invoice matched or not?
It would help if you fill out a few lines with real data and explain the logic of how the result shold be calculated.
modytrane