+ Reply to Thread
Results 1 to 2 of 2

Excel Bank reconciliation with vba Macro

  1. #1
    Registered User
    Join Date
    08-06-2020
    Location
    spring valley valley NY
    MS-Off Ver
    2019
    Posts
    1

    Excel Bank reconciliation with vba Macro

    Hi all
    i wrote a vba macro to help with reconciliation of a excel Check Register with downloaded banks transaction, I attached it here for people who find it useful.

    see the attached excel sheet for an example, also note the settings in the named range bank_reconcile_settings
    this was built and tested on transactions downloaded from chase, there might be some changing needed for different banks (see the line Interchangeable transactions names)
    Attached Files Attached Files
    Last edited by nykbakery; 08-11-2020 at 11:17 AM. Reason: updated file

  2. #2
    Registered User
    Join Date
    05-05-2021
    Location
    USA
    MS-Off Ver
    MO 365
    Posts
    6

    Thumbs up Re: Excel Bank reconciliation with vba Macro

    Thank you, nykbakery.

+ 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. Bank Reconciliation using Excel macros
    By ANGIE90 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2018, 12:37 PM
  3. Reconciliation Bank Account Macro Using Unique Identifiers
    By A10Hughes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2015, 03:36 AM
  4. bank reconciliation.
    By elias jahangir in forum Excel General
    Replies: 3
    Last Post: 05-29-2014, 01:34 PM
  5. bank reconciliation using excel
    By Rajat goel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2013, 06:21 AM
  6. [SOLVED] How would you do a bank reconciliation in excel.
    By Sim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2013, 10:47 PM
  7. Bank Reconciliation
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2012, 03:17 PM

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