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

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

Where to find competitive boat loan rates

Where to find competitive boat loan rates

As most people do not have ten thousands of dollars stashed away, the majority of person will need to think about boat loans before they buy a boat. As marine loans can be expensive, it is important for buyers to look around for competitive boat finance interest rates.
How to secure finance for property

How to secure finance for property

Finance for property is secured by taking an asset-based loan from the bank or any lending institution. Property financing is through taking a loan like mortgage and car loan from the bank, and pay back the loan including the interest charges in monthly instalments over the specified number of years. The process of getting a secured loan is elucidated in this article.
The benefits of a safe deposit box

The benefits of a safe deposit box

Most banks will offer to their customers a safety deposit box located at the bank for a nominal fee. As there are many benefits to having this type of box, it is recommended that bank customers purchase one. Having a safety deposit box means that users can store precious items in a safe location other than their home.
What is a guaranteed bad credit personal loan?

What is a guaranteed bad credit personal loan?

A guaranteed bad credit personal loan is a loan that is given to a borrower with bad credit. Lenders will not do a credit check for this type of loan, they only make sure that they charge you high interest rates. This is because this type of loan is high risk, lenders will give you a loan despite your bad credit history.