Reconciling two worksheets -Intercompany Reconciliation

[ShyamSN]

Dear All,

I want to reconcile two work sheets.Basically DR Column and Cr Column in General Ledger with other DR and CR Column of General Ledger having thousands of rows.(Intercompany reconciliation)

Do you any standard reconciling macros to run and highlight the common values.

Please help

Thanks

Shyam

[pmalen]

You might try using SUMIF if the account numbers are next to the dollar amounts.

[ShyamSN]

Sumif doesn't help for this reconciliation, since I want to compare and eliminate to worksheets with the same values.
Any macros available for this

[Richard Buttrey]

Your request isn't clear - at least to me.

Please upload your workbook or at least a representative sample and add examples of the results you expect to see.

[mahmud9935]

Could you please post a file, because I have my tools to reconcile accounts in accounting.

[ShyamSN]

Needs to comapare Sheet A -Debit and Credit Columns with Sheet B Debit and Credit Colums and highlight the uncompared Debit and Credit values.
My actual sheet is having thousands of rows.

[mahmud9935]

See attachment. If I did not understand u please correct me

[ShyamSN]

Thank you for your response.
Here you are comparing the column A of sheet A with Sheet B.
What I need is to compare only the Debit and Credit columns of Sheet A with Sheet B not column A.Basically we are checking only Debit & Credit column values, whatever Debit and Credit value we've in sheet A matching with Debit and Credit values of Sheet B and findout the unmatched one's.

[ShyamSN]

Dear Experts,

I need to reconcile two excel sheets.Sample attached.
My sheet will contain thousand of rows.
Hope somebody might have solved similar reconciliation in the past.If so please forward that thread or attachment.

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

My requirements

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

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 and E9 = Balance after adjustments
Please help.