+ Reply to Thread
Results 1 to 2 of 2

Reconciliation Bank Account Macro Using Unique Identifiers

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    United States, CO
    MS-Off Ver
    2013
    Posts
    1

    Reconciliation Bank Account Macro Using Unique Identifiers

    Hey,

    I am working on building a reconciliation for my company's mortgage accounting. The mortgage division is growing fast and soon there will be far to much data to reconcile manually.
    I have been able to produce a solid excel 2010 worksheet for the GL data and the "Bank" data. The data has been formatted the same from both sources. (Shown Below)

    Now I need to write a Macro that will compare the GL and Bank transactions against each other for two or more unique identifiers, highlight the transactions that net to zero, and move the transactions that net to another worksheet.

    My VBA knowledge is low and I have been looking to many sources but can't seem to get any formulas to work. Can anyone see a formula that would work by looking at this problem I am working on. Thank you for your help and time.

    Trx Date Account Account Description Debit Credit DR (CR) Description Loan Number (Unique Identifier)
    3/5/2015 GL Mortgage - Loans held for sale 128,000.00 0.00 128,000.00 Mar 2015 Mortgage Funding 115000080
    3/5/2015 Bank - 0 0 -128,000.00 *borrower name 115000080
    3/12/2015 GL Mortgage - Loans held for sale 0.00 -128,000.00 -128,000.00 Mar 2015 Mortgage Sales 115000080
    3/12/2015 Bank - 0 0 128,000.00 *borrower name 115000080

  2. #2
    Registered User
    Join Date
    08-31-2015
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    2

    Re: Reconciliation Bank Account Macro Using Unique Identifiers

    I am looking for same answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Macro to simplify large bank reconciliation
    By signgain82 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2018, 01:46 AM
  2. [SOLVED] Bank Reconciliation with VBA
    By chrism_cfu in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 02-17-2016, 06:24 PM
  3. Replies: 3
    Last Post: 07-07-2015, 02:42 PM
  4. Bank Reconciliation - Help
    By Lourenço in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2015, 09:13 AM
  5. Bank Reconciliation
    By ravogt91 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2014, 08:22 AM
  6. Bank Reconciliation VBA Help
    By showgun3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 12:26 AM
  7. Bank Reconciliation
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2012, 03:17 PM

Tags for this Thread

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