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

[@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

[@romelanis]

I even watching 6 year from recording. Many thanks.

[@migashope7282]

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

[@Shahidtrading]

THANK YOU SO MUCH FOR THIS VIDEO

[@shahbazsekandar9246]

Amazing and remarkable

[@fouziaaftab7288]

Its quiet time saving thanks

[@mosesdavies8302]

I love your video... Do u have a practice file that I can download and practice with?

[@hasinarafenoarisoa7063]

THANK YOU SO MUCH
Could you make videos about bank renconciling with outstandings, please?

[@RR-et6zp]

Thanks. Great help

[@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

[@bengali_lady_in_himachal]

Thanks mate

[@DjCallebson]

Good video sir, do you mind sharing a copy of the recon sheet? i want to see the formulas

[@alishabeerali5709]

Thanks, I enjoyed ur Vedios, plz share ur excel sheet

[@lalkherritesh]

very nice video sir..

[@kenxxx8318]

Thank you sir

[@SamuelB818]

whats a way to make sure the amounts in cash book and bank match per reference? Thanks

[@thomasscaria9803]

Thanks, great video

[@NagaRaju-sc6hk]

Nice video bro

[@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

[@kudzanaimbire3281]

every transaction that goes through the bank must have a reference number.

[@sandeepdodda2890]

So while posting journal do we have that same reference number ?

[@aqoonbaahsan8128]

EXACTLY, I HAVE THE SAME PROBLEM

[@minupalasakruthi5904]

Sir please I want soft copy please provide link to download

[@angelclarke1942]

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

[@08066904089]

hi, please do you have a video of bank reconciliation without a reference code

[@t-bone7988]

Subscribed!

[@hamzakashif4379]

👍..deserve like

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

[@rahat-ul-nisa21]

Thanks🙂

[@coollife4471]

Thanks

[@rajaramlasiwa7949]

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

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

[@rinkykadam7301]

Good vedio

[@caaman93]

Awesome

[@odibeliclement2622]

Pls can u share a copy of the reconciliation sheet

[@85MA]

Sir What if we dont have unique reference number in one of the statements?

[@maghazali6290]

Same question can you find the solution?

[@khalilgana8688]

What about the template?

[@niyasa8293]

Sri.,
can I get a copy of this excel sheet?

[@tiktokergamer4597]

Hi sir
Plz upload next video related to this

[@tiktokergamer4597]

David Brown thanks ..!! Really appreciated

[@KartingApexKing]

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

[@worldtour5634]

vlookup will confuse with similar amount

[@davidbrown2204]

Yes, as long as the references are unique. it will work and the formulas that return an error are the unreconciled references, just like the MATCH function.

[@saleet1000]

Wow 😳

[@davidbrown2204]

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.

[@nomobarnabas1093]

please is the F4 the function 4 u are talking about. I did not get that please well.
help me out.

[@iamSixFeetTall]

F4 is on ur keyboard

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

[@TD24686]

K A I was

[@ajb5114]

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

[@davidbrown2204]

It is always a pain isn't it, I did another video for just that scenario, watch it here ua-cam.com/video/-8ZLvGM-HDA/v-deo.html

[@amulrawal4574]

Thanks mate