+ Reply to Thread
Results 1 to 3 of 3

automatically compare the bank book & accounts book

  1. #1
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    automatically compare the bank book & accounts book

    Hi,

    Trying to automatically compare the bank book & accounts book by adding a unique code to each match (say 1000)

    The match should be on several levels:

    1. When there is a full match of Date + Description + Amount
    2. Partial match (the date in the bank books a few days after the invoice let's say 4 days)
    3. Partial match ((the description is different between the invoice and the bank, let's say the invoice for XXX and the bank shows YYY)
    4. Partial match (the amount rounded in the invoice is 99.9 and in Bank 100)

    When there is no full match of all the parameters I expect to get the best weighted match i.e. the closest amount to the amount on the invoice, the closest date to the invoice and the closest description to the invoice.



    Thanks in advance
    Attached Files Attached Files
    Last edited by sryair; 10-29-2020 at 05:28 AM.

  2. #2
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    Re: Matching Macro

    Of course when there is no reasonable match then mark as no match

    Also emphasize that the amount should be very close in a slight deviation of the decimal fraction + -

  3. #3
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    Re: automatically compare the bank book & accounts book

    Hope i managed to clarify the requested code

+ 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. Replies: 18
    Last Post: 10-08-2017, 04:17 AM
  2. [SOLVED] Alter Matching Sub From matching two Ranges to matching one range and list
    By capson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2015, 10:48 PM
  3. [SOLVED] Utter macro (and forum) noob seeks string fragment matching macro help
    By Knownowt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-05-2015, 02:04 PM
  4. Matching Macro
    By kartikeyadawar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-11-2014, 06:42 AM
  5. [SOLVED] Matching Macro, Matching Dr. to Cr.
    By kartikeyadawar in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-15-2013, 12:19 AM
  6. Macro - matching
    By dcmb in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 02-11-2009, 01:44 AM
  7. matching macro
    By novice_excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2007, 01:25 AM

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