HomeArticlesExcel & Business Math 27: Bank Reconciliation Made Easy Excel & Business Math 27: Bank Reconciliation Made Easy By Juan Cameron November 8, 2019 Articles, Blog 23 Comments Tags:Arrange All, Business Math, Busn 135, checks and Bank Reconciliation, Conditional Formatting, Data Validation, excel, Excel Business Math, Excel Math, excelisfun, format or highlight a row in a checkbook register, Highline College, how we perform bank reconciliation, Math Excel, Michael Girvin, Mike Girvin, Mixed Cell References, New Window, show to show two worksheets from the same workbook side-by-side, View Tab, why bank reconciliation Related Posts Combo classes – Webflow tutorial Getting a Head Start in the Industry – Designer vs. Developer #15 Using inspect element for CSS styles About Author admin 23 Comments Syed Muzammil Mahasan Shahi February 15, 2018 Thank you Mike for this EXCELlent video Reply Ameed Azfar February 15, 2018 Much love! Great video Mike! Reply Kevin Carter February 15, 2018 Why didn’t I have a teacher like you in school??? Oh, that’s right, computers weren’t yet invented back then! 😃😃😃 Reply Ismail Ismaili February 15, 2018 You are Just an awesome teacher thank you so much Mr. Mike i swear this video helped a lot thank you so much Reply Tulsidas Jamnani February 16, 2018 Thanks for this video….. Sir, please make some videos with Google sheets app ….Because many users are using excel in there mobile phones …… Like me…. Reply George Nuer February 16, 2018 Mike, your videos are so amusing. You are actually teaching accounting alongside excel. I wish I knew all these excel tricks years ago but still not too late. I use to have excel bank reconciliations but NOT as excellent as am learning from you. Thanks for the knowledge. Reply John Borg February 17, 2018 Thanks Mike. Always Learning new things. The New Window to see different sheets in the same workbook is amazing and very helpful. I didn't know that. Thankyou SIR 🙂 Reply Malina C. February 17, 2018 Finance simple way – thank you, Mike! Reply Phone Excel Time February 17, 2018 Bank Reconciliation I learned this way Bank A/c from our side view use Real a/c Journal Entry Rule that Debit what's come in & credit what goes out & our Bank a/c but from Bankers point of view use Nominal A/c Journal entry Rule Debit all Expenses(withdrawal)&losses (charges)& credit all Income(Deposits)& Gains.This way You never goes wrong… Reply Hugh Robinson February 18, 2018 Thank you for this video. Reply NeoGeoSNK February 21, 2018 most of the accounting or finance classes focus on the fundamental, basic concepts, such as financial statements, analyzing financial ratios, corporate finance, cash flow, PV, cost of debt, equity. Banking reconciliation is not one of the topics that taught in undergrads or even in Grad school. I am not sure if things have changed but the faculty certainly did not cover this topic at my grad school finance program. Thank you for sharing this topic ! Reply Gerald Sardua February 26, 2018 Thanks Mike. Reply Enny Kraft March 24, 2018 Can someone please explain to me why checks are still in use in the US? I'm from Germany and here checks have been abolished many years ago. Thank you! Reply con Dev April 4, 2018 At the last step in row 21 the formula didn't work in my excel sheet though I have added plus and minus as you did. Reply 5%LowBattery April 6, 2018 I’m being asked to do a daily bank reconciliation 😖 (so that they can catch any fraud…I just think it’s to make my life more difficult) I wonder if this video can help? I download the bank activity and account register. Is there a way to make it more automatic with lookups? Reply Nadine Edleman July 16, 2018 Mike, Is there a place I may purchase your spread sheet templates for checking and bank reconcilliation? Reply Tagenarine1987 July 23, 2018 Hi Mike. Is there a way to use power query to do Bank Reconciliation. Im looking for a solution where I just have a folder for the bank statement and a folder for the cash book and just by clicking refresh the query auto generates a list of Checks and Deposits in the bank statement and not in the cash book and a separate list for items in the cash book but not in the bank statement as well as completing the Reconcile form automatically. Reply Myung-Hee Hayes August 31, 2018 Hi Mike!! It took a while to finish this, but I managed.Thanks again… Excel is really FUN!😁 Reply brizzx32 January 9, 2019 Mike is like a Superhero!!! Reply Sylvia Lopez June 7, 2019 Video begins @13:56 if you want to get into the action to you intuitive, big picture, intuitive people. Because Mike is too detail oriented for us intuitive. Reply Aisha Manners July 3, 2019 This can be performed so much easier. This is too much manual work and not automated. Download the bank statement in excel or csv, download activity from account ledger, perform v-look ups on reference numbers, document numbers or check numbers (which ever is used by your bank). What ever comes back with an error you research those items to eliminate the variances. Reply Marcos Hernández Muñoz July 6, 2019 you are a genius! I love your videos! Reply Rita Butts October 19, 2019 Where do I get the forms? Reply Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Save my name, email, and website in this browser for the next time I comment.