+ Reply to Thread
Results 1 to 6 of 6

Help Required on Bank Reconcoliation

  1. #1
    Registered User
    Join Date
    01-25-2020
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    3

    Help Required on Bank Reconcoliation

    dear fellows, i want help on bank reconciliation, where in 1st sheet in put pendinf cheques of last month and in 2nd sheet i put GL and in 3rd sheet i put Bank statement.
    In bank statement, aal cheques need to be cleared in Reconciliation or in GL, Pendind entries of debit side of banks statement will be shown in addition side and not checked entries, which are not present in GL, will be shown in Les column..... can i have any macros or programming where all entries been automatically been checked and deleted , because i have large bank satatement and reconciliation to make bank reconciliation easier.... if any one can guide me then i will he thankfull ....
    waiting for response plz.
    Attached Files Attached Files
    Last edited by sarfrazxyz; 01-26-2020 at 04:33 AM. Reason: attachment

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Help Required on Bank Reconcoliation

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Help Required on Bank Reconcoliation

    To prepare properly macros and formulas we need Excel file sample.
    Please prepare a short one removing personal information.
    - Battle without fear gives no glory - Just try

  4. #4
    Registered User
    Join Date
    01-25-2020
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    3

    Re: Help Required on Bank Reconcoliation

    sample file is attached

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Help Required on Bank Reconcoliation

    Can you give detailed examples according to your file, which explain what you want to achieve.
    Note: Avoid or explain, technical words like aal, GLS

  6. #6
    Registered User
    Join Date
    01-25-2020
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    3

    Re: Help Required on Bank Reconcoliation

    i need to mark cheque numbers of sheet 3 in my sheet 1, if all cheques are matched with sheet one cheque then it will not be add or less in sheet 1. if any thing appears that is not present in sheet 1 or sheet 2 then it will appear in sheet 1.

+ 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] Automation required for bank reconciliation
    By yogyata26 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-29-2020, 11:35 PM
  2. [SOLVED] Post bank transactions to bank Recon as individual amounts instead of sums
    By SjMaxwell in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-16-2018, 03:15 AM
  3. [SOLVED] Simple Conditional Formating Help Required - If Blank then Red Bold text required
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2014, 12:23 PM
  4. Help required in matching data in required format
    By pravindwd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2013, 09:03 PM
  5. [SOLVED] Excel 2007 : Find bank balance in bank statement
    By Baldev Kumar in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:58 PM
  6. Excel bank statement to Sage Automation - Advice required!
    By dantray in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 10:22 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