In this tutorial I have explained an efficient method for performing bank reconciliation in Excel by comparing exported Tally data with bank statement entries using Pivot Tables.
The process begins by consolidating both datasets into a single sheet, where entries are clearly labeled as “As per Tally” or “As per Bank” to distinguish the sources. It is essential to align the data correctly, ensuring that Debit and Credit figures are placed in their respective columns, even if this requires swapping column positions.
Once the data is prepared, the video guides you through creating a Pivot Table that organizes dates in rows and sources in columns, while ensuring the value settings are converted from “Count” to “Sum” to display accurate totals.
Finally, the tutorial explains how to calculate variances by applying manual formulas (such as `B6-C6`) adjacent to the Pivot Table, allowing you to drag the calculation down to identify day-wise differences and spot timing adjustments.
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
