Quick Bank Reconciliation in Excel

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. • Reconciliation with th...

[@leomile7335]

Not clear if he manually entered all the data in the sheets? That is very time consuming. Looking for answers as I have to reconcile manually at my job, so any solution is better than pen and pencil.

[@omee437]

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

[@rajaramlasiwa7949]

Is there any idea to reconcile bank statement using Excel in QuickBooks and Odoo to reconcile thousands of bank transactions per month?

[@romelanis]

I even watching 6 year from recording. Many thanks.

[@khalilgana8688]

What about the template?

[@angelclarke1942]

It is possible for me to get a copy of this excel sheet?

[@ajb5114]

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

[@santdnyaneshwar9920]

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....

[@saeedalam4386]

How we use vlookup or Match function If data entered in worksheet without a unique reference or blank reference against which we match our record I need your help kindly reply me.

[@raymondakam1274]

The video is clear , please can you do a clearer video of this type

[@yusufabdullahiyusuf5233]

Kuma really enjoyed it, and have gotten it when needed

[@lennoxmatainaho136]

Amazing content! very clear and easy to follow through

[@Shahidtrading]

THANK YOU SO MUCH FOR THIS VIDEO

[@migashope7282]

thank you very much sir for sharing. Short yet concise ;)

[@fouziaaftab7288]

Its quiet time saving thanks

[@shahbazsekandar9246]

Amazing and remarkable

[@RR-et6zp]

Thanks. Great help

[@hasinarafenoarisoa7063]

THANK YOU SO MUCH

[@arsalanali2713]

nice demonstration

[@abdelwasieibrahim6039]

Such helpful video. Do you mind sharing the sample XLS file you are working on in the description section. thank u in advance