Compare 2 Excel Sheets (Easy Bank Reconciliation)

Never waste time hunting for missing transactions again! In this tutorial, I'll show you how to easily reconcile your bank statements with your accounting records using Excel pivot tables - no complex formulas needed.

🔗LINKS


Resources:

#Excel #PivotTables #Accounting #ExcelTutorial #BusinessTips

[wmfield]

This is a really smart approach to an often tedious but essential responsibility of every accountant. Thanks for passing it along.

[bigbasildogs]

Thank you again... It's so very cool to see yet another practical use of pivot tables. With just a few modest, mostly tactical, differences, I have been using pivot tables to reconcile everything with 2 or more "conflicting sources of truth" very similarly for years. Wish I'd seen your video before I demonstrated this technique at a seminar last week. Cheers!

[garys]

This comes once in a while in our business and when it does it really is like looking for a needle in a haystack. I can almost (almost) say that I can't wait for the next time so that I can try this out. Thank you very much for your generosity in sharing your knowledge!

[rouellanchesr.]

This is so useful, Jon. Thanks for your generosity in sharing your knowledge!

[XAbuBadrX]

This is really helpful, thank you very much for posting this

[tamaragoldyn]

Like always, clear and right to the point

[kkravch]

Great summary. I know it is a matter of preference, but we usually do [DR]-[CR] so the CR numbers are always negative. Also, you can filter by Value to get rid of all zeros before you start investigating with dates.

[barttitulaerexcelbart]

Thanks John. To sort any column you just right click and select Sort. Double click on a cell to see the details would also help (drill down). very practical video 👍

[feminel]

This just answered a year long question for me. Thank you

[JonathanExcels]

I have used Avery similar technique many times. I typically filter the row labels based upon the difference column not being equal to zero.

[lucsaint-onge]

thank's ! this is solving something that just happen to me !

[mobidic]

This video offers a helpful perspective for those familiar with traditional Excel methods. However, the demonstrated process involves more steps than necessary. While I was able to refresh my memory on the specific function I was seeking, the solution could have been achieved more efficiently.

[alexrosen]

This was a really good and useful tutorial 👏🙏👌

[GeertDelmulle]

Hey Jon, I would activate the filter buttons in the report area of the Pivot Table and filter out the zeros, we don’t need those.

[LibPenseur]

❤❤❤❤❤❤❤💥💥💥💥 would like to express my sincere gratitude to Mr. Jon, a truly remarkable individual, and his platform, Excel Campus, for their invaluable insights and generosity in sharing extensive knowledge and expertise in Excel and Advanced Excel with learners worldwide. It has been a privilege to learn from such an inspiring mentor, whose guidance has been of immense help both in my workplace and at home💥💥💥💥❤❤❤❤❤❤❤❤❤

[NinoEngi]

or, after you paste the 2nd data, you filter the date decreasing and you highlight duplicate values. Non highlighted rows are unique values

[IvanCortinas_ES]

The link is broken, Jon. Thank you for this tutorial!!!

[siddhantbhuwania]

Hi, what if the bank statement has several values which sums up and only then ties back to the value in account books?

[richardhay]

Do a step by step video on how to move check registers from QB to Excel. It's easy to transfer QB reports but registers are not so obvious

[pauljamieson]

So I have 2 different sheets. 1 sheet has all users in a specific Department of the business. The other sheet has ALL users of that business and all associated groups they belong to .. Using the User Names as the Key from both sheets I need to find all the groups each user is in... I have tried this as a Pivot table, but I need the whole table to be visible as I cannot get a pivot table to do that .. Thx