+ Reply to Thread
Results 1 to 9 of 9

Reconciling two worksheets -Intercompany Reconciliation

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    5

    Post Reconciling two worksheets -Intercompany Reconciliation

    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

  2. #2
    Registered User
    Join Date
    09-22-2011
    Location
    Washington, USA
    MS-Off Ver
    Excel 2003,2007, 2010
    Posts
    85

    Re: Reconciling two worksheets -Intercompany Reconciliation

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

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Reconciling two worksheets -Intercompany Reconciliation

    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

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,131

    Re: Reconciling two worksheets -Intercompany Reconciliation

    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.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    09-18-2012
    Location
    Dushanbe,Tajikistan
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Reconciling two worksheets -Intercompany Reconciliation

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

  6. #6
    Registered User
    Join Date
    09-20-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Reconciling two worksheets -Intercompany Reconciliation

    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.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-18-2012
    Location
    Dushanbe,Tajikistan
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Reconciling two worksheets -Intercompany Reconciliation

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

  8. #8
    Registered User
    Join Date
    09-20-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Reconciling two worksheets -Intercompany Reconciliation

    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.

  9. #9
    Registered User
    Join Date
    09-20-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    5

    Post Re:Intercompany Reconciliation -Accounts

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1