Bank Reconciliation Template - W/O Cheque Number

Description
In an effort to match the bank statement balance to ledger balance for the relevant bank account, bookkeepers and accountants must go through a fair bit of effort every month. When Transactions volume is high, they might have to spend fair part of their workday reconciling bank balance to the ledger. Additionally, it creates unnecessary pressure for staff involved in the month end reporting to complete bank reconciliation and relevant workings by a predetermined date / deadline.
Previously, with the use of the cheque books and similar tools of banking a reference number was available to match the transactions between ledger and bank statement, which provided some sort of comfort to the accountant.
In Todays' world of online banking the cheque book is almost eliminated. With absence of reference number, reconciliation requires lot of manual effort.
I have created the attached template using my excel skills and knowledge about bank reconciliation process, to provide help and share my best understanding, with those who go through this painful area of accounting/ banking every now and then
in the attached bank reconciliation template, follow few easy steps to copy the data from your ledger and bank statement extract in provided template and have your reconciliation items highlighted for you automatically.