Excel tutorial: Quick Bank Reconciliation in Excel

About this tutorial:

Video duration: 6:59
Learn a quick and smart way to perform reconciliation tasks in Excel. Here we use a Bank Reconciliation example, but this technique can be used in any reconciliation.

Also, remember to check our other reconciliation videos our the reconciliation playlist.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

23 thoughts on “Excel tutorial: Quick Bank Reconciliation in Excel

    MigAs Hope

    (December 15, 2019 - 1:20 am)

    thank you very much sir for sharing. Short yet concise 😉

    Yusuf Abdullahi Yusuf

    (December 15, 2019 - 1:20 am)

    Kuma really enjoyed it, and have gotten it when needed

    Fouzia aftab

    (December 15, 2019 - 1:20 am)

    Its quiet time saving thanks

    Sumeesh Ramankutty

    (December 15, 2019 - 1:20 am)

    a simple but powerful excel template for reconcilation…
    visti FB link below…


    oe sp

    (December 15, 2019 - 1:20 am)

    Match and vlookup both cannot figure the difference if values are similar. It is appliacable only for unique values as per my experience.

    K A

    (December 15, 2019 - 1:20 am)

    Dear, how will find the references in bank ledger in books, we cant be maintained the same as bank specified in statement. because we passed the the entry at the time of transaction and it will be reflected in bank after say 2-3 days. so only ch. no. could be matched with bank statement and not neft or other references. so i think its not possible. ITS NOT USABLE….


    (December 15, 2019 - 1:20 am)

    Sir please i want reconciliation sheet can you provide in download links

    AJ B

    (December 15, 2019 - 1:20 am)

    You do not see bank references in every transaction in UK bank statements, therefore this video is irrelevant.

    Shahbaz Sekandar

    (December 15, 2019 - 1:20 am)

    Amazing and remarkable

    Naga Raju

    (December 15, 2019 - 1:20 am)

    Nice video bro

    Arsalan Ali

    (December 15, 2019 - 1:20 am)

    nice demonstration

    Ritesh lalkher

    (December 15, 2019 - 1:20 am)

    very nice video sir..

    Sovan Pal

    (December 15, 2019 - 1:20 am)

    Thanks mate

    Rinky Kadam

    (December 15, 2019 - 1:20 am)

    Good vedio

    Anubhav Garg

    (December 15, 2019 - 1:20 am)

    Hey sir,
    In addition to wat you explained, what if in Column 1 i have two enteries of similar amount debited from my account and in kq cash book there is just 1 entry…by using look up chqrt both debit entries qill b reconciled , but in qctuql i need only 1 debit to b reconciled as i have 1 entey in mq cash book
    Plz mail the solutipn @ anubhavgarg77@gmail.com

    thomas scaria

    (December 15, 2019 - 1:20 am)

    Thanks, great video

    minupala sakruthi

    (December 15, 2019 - 1:20 am)

    Sir please I want soft copy please provide link to download

    Blessed 94

    (December 15, 2019 - 1:20 am)

    what if you use the vlookup option..to link the references with the transaction figure.

    arslan hamid44

    (December 15, 2019 - 1:20 am)

    Hi sir
    Plz upload next video related to this

    MD Shahid

    (December 15, 2019 - 1:20 am)


    David Brown

    (December 15, 2019 - 1:20 am)

    Hi Omer, I see that a lot. What you need to do is identify how you would reconcile this scenario manually and then breakdown that manual process into steps, lastly each of those steps can then be automated.

    So let me know what steps you would like to automate. For example, some bank statements can only be reconciled with by specific text in the description fields, in this case, you will need to create a table of all possible descriptions and what they mean, then you use a brilliant array formula construct to solve it.

    Let me know what your specific problem is and it can be the basis of my next video.

    Omer Shariff

    (December 15, 2019 - 1:20 am)

    Nice video. However in the event where my bank statement doesn't have reference numbers then how do I go about it. Your assistance is much appreciated. Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *