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 Telegram Group
Join Our WhatsApp Group
