By continuing your visit to this site, you accept the use of cookies. They ensure the proper functioning of our services and display relevant ads. Learn more about cookies and act

Not yet registered? Create a OverBlog!

Create my blog

A template for bank reconciliation

A bank reconciliation statement helps to reconcile the balance as per the company’s accounting records with the balance as per the bank’s statement as on a particular date. Differences may exist between these two balances because of many reasons. Bank reconciliation is performed by the accounts department of all companies. This article is a bank reconciliation template which can help.

Creating a bank reconciliation template

Balance as per bank statement as on (particular date): Add: Checks received but not deposited (referred to as outstanding lodgements) These are accounted for by the company in their books but have yet to be deposited in the bank account. So, naturally, the bank statement will not reflect these entries. Therefore, they have to be added to the balance as per bank statement. Add: Recurring payments debited by the bank These payments may not have been accounted by the company on a particular date, so they must be added back to the bank balance. These include bank charges and interest charged by the bank. Less: Checks issued but not presented (referred to as unrepresented checks) A company may issue checks to vendors or others. The company will account for these in their books. However, if these checks are not deposited by the parties, then naturally they will not be lodged in the bank for payment. Therefore, they will not reflect in the bank statement. These have to be deducted from the balance per bank statement. Less: Direct credits made in the bank account When direct payments are made to a company’s bank account (example: dividend, interest), the bank statement will show them as credits and add them to the balance. However, the company’s account departments may not have noted these. So, to reconcile the balances, these direct credits must be deducted from the balance as per bank statement. Or, if the balance as per the company’s book is taken as the starting point for reconciliation, then these entries must be added. = Balance as per company's accounts as on (particular date):

Final word

The bank reconciliation statement template must be created by someone who knows how to work with spreadsheet programs (like MS Excel). Additionally, advanced spreadsheet program users can even pull in data from accounting software. A frequent bank reconciliation process can help the organisation stay up-to-speed with its actual bank balance.

Same category articles Banking

All about: Maybank Group

All about: Maybank Group

Maybank is the Malaysia's largest banking and financial group, with operations in Indonesia, the Philippines and a number of other countries in various continents. It has assets totaling more than 100 billion US dollars, and is ranked as one of the world’s top 120 banks. It has 384 domestic branches and an additional of 190 branches around the world.
All about: Lloyds Banking Group

All about: Lloyds Banking Group

Lloyds Banking Group was founded in the midst of the recession that resulted from the credit crunch in January 2009. With more than 30 million customers, it has the largest private shareholder base in the UK, and claims to provide more current accounts, savings, personal loans, credit cards and mortgages than any other of the UK banks. In England and Wales, Lloyds TSB and Halifax are its main brands - in Scotland, it is the Bank of Scotland.
Bank credit cards: Compare and contrast

Bank credit cards: Compare and contrast

There are so many different types of credit cards that you can apply for that it makes it difficult to know which is the best one. With so many banks now offering zero percent balance transfer cards, it can make it harder to know how to compare each one. Here are a few things that you should look out for.
How to get approval for an Egg loan

How to get approval for an Egg loan

Egg bank UK have been a beloved credit card and loans company for many years. Unfortunately, and as stated on the egg loans home page, as of April 2011, they have transferred their ownership to Barclays Banking Ltd. Although existing Egg credit account customers can continue to use their accounts, the company is no longer taking on new customers.