+ Reply to Thread
Results 1 to 10 of 10

Automation required for bank reconciliation

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    india
    MS-Off Ver
    13
    Posts
    14

    Automation required for bank reconciliation

    Hi,

    In my workbook I have 2 sheets- Bank Statement and Bank Book.
    So, I want a code which matches the entries in both sheets and would bring a unique number(say 0001) in "matching reference" column of the respective rows in both the sheets.

    Now the matching of entries should be on various combinations:
    "Date+Description+Amount" should match and bring the unique number in the respective entries in both the sheets else match
    "Description+Amount" and bring the unique code.


    Thanks in advance!
    Attached Files Attached Files
    Last edited by yogyata26; 02-15-2019 at 02:07 AM. Reason: Attaching workbook

  2. #2
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    137

    Re: Automation required for bank reconciliation

    Please attach your workbook, easier to work that way.
    Tuomas "Banaanas" Savonius
    Trying to give back now when I actually can do some VBA

  3. #3
    Registered User
    Join Date
    02-11-2019
    Location
    india
    MS-Off Ver
    13
    Posts
    14

    Re: Automation required for bank reconciliation

    Since this is my first post it is not allowing me to attach any file or link or images!
    Is there any other way I can send you the workbook?

  4. #4
    Valued Forum Contributor
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    735

    Re: Automation required for bank reconciliation

    The paperclip Icon is broken. you are allowed to upload excel workbooks

    1. Click Go advanced right bottom under the replybox.
    2. Scroll down to the "Manage Attachments" under the advanced text editor
    3. pick the file to upload and choose upload.
    4. close the window
    5. complete your message text and post your message with the attachement

    (attachement does not always show under attachement link. try to p"review post" to see if the attachment was added. )

  5. #5
    Registered User
    Join Date
    02-11-2019
    Location
    india
    MS-Off Ver
    13
    Posts
    14

    Re: Automation required for bank reconciliation

    Hi

    Thanks for guiding me!

    This is my workbook.
    Attached Files Attached Files
    Last edited by yogyata26; 02-14-2019 at 07:01 AM.

  6. #6
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    137

    Re: Automation required for bank reconciliation

    Could you give a clear example of the workbook that you provided?

  7. #7
    Registered User
    Join Date
    02-11-2019
    Location
    india
    MS-Off Ver
    13
    Posts
    14

    Re: Automation required for bank reconciliation

    As I said I have 2 sheets in my workbook - Bank Statement and Bank Book.
    So Basically I have to reconcile entries in Bank Statement sheet with entries in Bank Book sheet.

    For reconciling I have to use various combinations for matching.

    Here is the procedure:

    If the "Date & Description & Amount" of a row in the first sheet matches with "Date & Description & Amount" of any other row in second sheet then I should get a unique code/number in the "Matching Reference" cells of the both the rows

    If it does not match,
    then match the "Description & Amount" in both the sheets as earlier and bring the unique code.

    If this also does not match then show "unmatched" in "Matching Reference" cell.

    I have attached a fresh sheet!
    Hope this is understandable!
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-24-2015
    Location
    hyderabad
    MS-Off Ver
    2003
    Posts
    24

    Re: Automation required for bank reconciliation

    Seems like a very interesting task.

  9. #9
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    137

    Re: Automation required for bank reconciliation

    Allright. Sorry for taking so long, I was away for a week and this took some time to figure out.

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    02-11-2019
    Location
    india
    MS-Off Ver
    13
    Posts
    14

    Re: Automation required for bank reconciliation

    Works flawlessly! Thanks a lot!

+ 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