Results 1 to 3 of 3

Bank statement and cashbook reconciliation

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    ghana
    MS-Off Ver
    7
    Posts
    4

    Smile Bank statement and cashbook reconciliation

    I have two table: BANK STATEMENT and CASH BOOK Firstly, want to compare the amounts, if they are equal then Secondly, check the narration if at least three or four letters match, will pair them. If amount is equal but none of the narration matches, will unmatch them. I have attached an excel to explain it further and this is also an example
    BEFORE

    BANK STATEMENT
    29-Mar-16 SF REDT IFO NAANA GRACE N/R 1,000.00
    24-Mar-16 SF IFO SOLOMON TEYE T N/T 1,000.00
    30-Mar-16 SF REDT IFO SAMUEL MANU N/R 1,000.00
    19-Jan-16 SF REDT IFO CLEMENT ASANDENAM 1,018.56
    16-Mar-16 REDT OF SF IFO STEPHEN ASIEDU ASANTE 1,084.29


    CASH BOOK
    29-Mar-16 Samuel Kyei Manu 1,000.00
    24-Mar-16 Solomon Teye Tettey 1,000.00
    15-Jan-16 Clement Asandenam 1,018.56
    23-Mar-16 Naana Graham Grace 1,000.00
    23-Jul-15 SF IFO Paul Boateng 1,091.07

    AFTER

    BANK STATEMENT CASH BOOK

    24-Mar-16 SF IFO SOLOMON TEYE T N/T 1,000.00 24-Mar-16 Solomon Teye Tettey 1,000.00
    29-Mar-16 SF REDT IFO NAANA GRACE N/R 1,000.00 23-Mar-16 Naana Graham Grace 1,000.00
    30-Mar-16 SF REDT IFO SAMUEL MANU N/R 1,000.00 29-Mar-16 Samuel Kyei Manu 1,000.00
    19-Jan-16 SF REDT IFO CLEMENT ASANDENAM 1,018.56 15-Jan-16 Clement Asandenam 1,018.56
    16-Mar-16 REDT OF SF IFO STEPHEN ASIEDU ASANTE 1,084.29
    23-Jul-15 SF IFO Paul Boateng 1,091.07
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bank Reconciliation with VBA
    By kazdima in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2016, 03:08 PM
  2. Bank Reconciliation - Help
    By Lourenço in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2015, 09:13 AM
  3. Bank Reconciliation
    By Accountant0607 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-24-2014, 10:32 PM
  4. Bank Reconciliation
    By kfoote in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 12-04-2013, 04:45 PM
  5. Bank Reconciliation VBA Help
    By showgun3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 12:26 AM
  6. Bank Reconciliation
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2012, 03:17 PM
  7. [SOLVED] A Bank Statement Reconciliation template
    By slidergirl1 in forum Excel General
    Replies: 1
    Last Post: 07-22-2006, 03:50 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