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

A guide to Child Trust Fund accounts

A guide to Child Trust Fund accounts

Although the UK government no longer contributes to child trust funds, existing funds continue to earn income tax-free. Funds may be transferred from one financial institution to another, and parents should look for the best deal. This article acts as a guide to child trust fund accounts.
All about asset based lenders

All about asset based lenders

Large corporations and businesses often require both large and small amounts of capital during the initial period of starting their business venture. They also require short-term financing to consistently maintain production in order to meet demand, buy equipment or to increase the inventory. Asset-based lending is one such source of financing or loan offered against an asset, akin to a secured loan. This article provides detailed information about asset-based lending.
How do I use a savings calculator?

How do I use a savings calculator?

Many people have a set goal in mind when it comes to their savings. Due to that, they will want to know how much they will need to put into their savings account to get to the total that they have in mind, or how much they are currently putting in each month will add up to at the end of a term.
How to refinance bad credit

How to refinance bad credit

You have poor credit because you have defaulted on your credit obligations during the last seven years. Peer-to-peer lenders will only allow you to borrow money if you have good credit. If you want to refinance with bad credit, you will need to be a homeowner. Provided that you have sufficient equity in your property, you can get a bad credit home loan.