Msafder

How To Prepare a bank reconciliation statement steps and examples

How to Prepare a Bank Reconciliation Statement: Steps and Example

A bank reconciliation statement is a document which shows the difference between the bank balance in your cash book and the balance on your bank statement. Often it can be difficult to match them due to delays with cheques and unknown bank charges. Having a bank reconciliation will allow you to clearly see what your actual bank balance is and will show any errors.

This article will explain what a bank reconciliation is, how it should be prepared and provide an example of a reconciliation using rupees.

Key Takeaways

  • It will show the difference between the balances.
  • The difference is caused by timing differences and differences in the books.
  • First update your cash book. Then adjust the bank balance to account for the timing differences. You should always end up with the same value on both sides of the reconciliation. If not, there will be errors to find.
  • Bank reconciliations should be done every month.

What Bank Reconciliation Means

A bank reconciliation will match your cash balance with your bank statement. This will create a bank reconciliation statement to show the causes of the differences between the balances and confirm they match once adjustments have been made. This is usually done by the accountants or finance department.

This will ensure the cash balance in your books is accurate. It will help you spot any double payments, incorrect amounts or anything you aren’t familiar with. This is an essential part of keeping your books accurate and will make auditing much easier as you will know why all your cash balances are there.

Lenders and investors will want you to keep your books organized by reconciling. Find out more in our accounting and bookkeeping for fundraising guide.

Why the Two Balances Differ

There will be many reasons why the balances do not match. They will be due to timing differences and some may not have been recorded in your books. There may also be a few errors. These are outlined in the table below.

Reason Appears In Adjustment
Deposit in Transit Cash Book + Bank
Uncleared Cheque Cash Book – Bank
Bank Charge Bank Statement – Cash
Profit/Markup Bank Statement + Cash
Direct Payment from Customer Bank Statement + Cash
Bounced Cheque Bank Statement – Cash
Error Both Adjust incorrect entry

In Pakistan it is common to have withholding tax taken out of your profit or cash withdrawal. This will be picked up on your statement first so you will need to record this in your cash book.

Basic Rules to Follow

  • Always use the same date. Usually the end of the month.
  • Always update your cash book first.
  • Only adjust the bank balance for timing differences.
  • Ensure all entries have been ticked. List any differences.
  • Forward uncleared cheques from previous months.

    How to Prepare a Bank Reconciliation Statement Steps and Example - M Safdar

How to Prepare a Bank Reconciliation

  1. Firstly identify your closing balances from the cash book and bank statement.
  2. Compare them and tick any that match.
  3. List any differences in the bank statement.
  4. List any differences in cash book.
  5. Record these in your cash book to give you your adjusted cash book balance.
  6. Adjust your bank statement to add in any deposits in transit and subtract any uncleared cheques. You should now have matching balances.

If they do not match, double check there are no errors with transposing numbers, missing entries or incorrect signs.

Example Using Rupees

Note: This is just an example. On the 31st October 2026 your cash book shows a balance of Rs 485,000 and your bank statement shows a balance of Rs 512,500.

Differences:

  • Uncleared cheque of Rs 40,000 to a supplier.
  • Uncleared deposit of Rs 25,000 on the 31st October.
  • Bank charges of Rs 1,500.
  • Unrecorded profit of Rs 4,000.
  • Direct payment from customer of Rs 10,000.

Step 1: Update Cash Book

Item Amount
Cash Book Balance Rs 485,000
Less: Bank Charges (Rs 1,500)
Plus: Profit Credited by the Bank Rs 4,000
Plus: Direct Payment from Customer Rs 10,000
Adjusted Cash Book Balance Rs 497,500

Step 2: Adjust Bank Statement

Item Amount
Bank Statement Balance Rs 512,500
Plus: Deposit in Transit Rs 25,000
Less: Uncleared Cheque (Rs 40,000)
Adjusted Bank Balance Rs 497,500

As you can see, you now have a matching balance of Rs 497,500. This is your cash balance and should be included in your financial statements.

Bank Reconciliation Format in Excel

To create a simple bank reconciliation in Excel you will need to have three columns, Description, Amount and Tick Box. You will need to split your template into two sections, one for adjusting your cash book and one for adjusting your bank statement. See tables above. Finally create a row to show the difference between the two adjusted balances. If this is zero you are finished.

Ensure you have one sheet per month. Forward your uncleared cheques list onto the next sheet.

Common Errors

  • Forgetting to include items from previous months. Ensure you list any uncleared cheques/deposits in transit until they have cleared.
  • Incorrect signs. If you have a bounced cheque or bank charges you will need to reduce your cash book. If you add this in you will increase the difference.
  • Leaving it until the end of the year. Small issues can build up and become hard to find. Having a professional bookkeeping system means you will reconcile monthly.
  • One person completing. Ensure whoever is entering the payments isn’t completing the reconciliation.
  • Not looking at small differences. If there is a difference of a few hundred rupees this could indicate an error.

Bank reconciliations are a basic form of internal control. Larger firms like TAG & Co will provide services relating to business assurance and risk management.

Ready To Complete Your Monthly Reconciliation?

Trying to identify why the balances don’t match can take up a lot of time which most owners won’t have. M Safdar FCA can help you complete your bank reconciliation statement each month as part of our accounting services. We can also help you put a process in place for your team to complete. Find out more about our accounting and bookkeeping services in Pakistan. Contact us.

FAQs

What is a bank reconciliation?
A bank reconciliation is when you match your cash book balance to your bank statement balance and identify any differences.

Why is my cash book balance different to my bank?
Cheques and deposits take time to clear. There may be bank charges or credits which haven’t been added in your books. There could also be errors.

How often should I complete a bank reconciliation?
Bank reconciliations are commonly completed monthly. However, businesses with high volumes of transactions may complete them weekly.

Who completes a bank reconciliation?
Bank reconciliations are usually completed by your accountant or finance department. It should be reviewed by somebody who doesn’t handle cash.

What is a deposit in transit?
A deposit in transit is money you have added to your books but hasn’t been added to your account.

What is an uncleared cheque?
An uncleared cheque is a cheque you have issued and added to your books but hasn’t been cashed by the payee.

Can a bank reconciliation detect fraud?
A bank reconciliation can help detect any unusual/unauthorized payments but will not fully detect any fraud.

 

Scroll to Top