Bank Reconciliation Statements (Edexcel IGCSE Accounting)
Revision Note
Written by: Dan Finlay
Reviewed by: Lucy Kirkham
Purpose of a Bank Reconciliation Statement
What is the purpose of a bank reconciliation statement?
If the balance on the bank statement is different to the bank balance in the cash book, then the business produces a bank reconciliation statement
This is a statement which explains why the balances are different
The cash book can be updated with missing transactions that are on the bank statement
However, the business cannot update the bank statement with missing transactions that are in the cash book
A bank reconciliation statement is needed to show these
It contains details of any:
Unpresented cheques
Uncredited deposits
Errors
Preparing a Bank Reconciliation Statement
How do I prepare a bank reconciliation statement?
STEP 1
Update the cash book using the bank statementCalculate the updated balance
STEP 2
Start the bank reconciliation statement with the updated balance in the cash bookIf the balance is on the credit side then this means the bank should be overdrawn
Put the value in brackets and treat it as a negative number
STEP 3
Add any unpresented chequesThese are the credit entries in the cash book that are missing from the bank statement
If there is more than one, then
Add these amounts together in a separate column of the bank reconciliation statement
Put the total in the end column
Add the total to the balance in the cash book
STEP 4
Subtract any outstanding lodgementsThese are the debit entries in the cash book that are missing from the bank statement
If there is more than one, then
Add these amounts together in a separate column of the bank reconciliation statement
Put the total in the end column
Subtract the total from the balance in the cash book
STEP 5
Deal with any bank errorsIf the error has decreased the balance on the bank statement then subtract this amount from the balance in the cash book
If the error has increased the balance on the bank statement then add this amount to the balance in the cash book
STEP 6
Check that this amount is equal to the bank balance shown on the bank statementIf the balance is negative, then the bank balance should be overdrawn
This means the bank balance should have a debit balance
Examiner Tips and Tricks
Compare the cash book and the bank statement. If a transaction appears on both of them, then put a tick next to the transaction in the cash book and on the bank statement. Then you just need to use the unticked entries in the cash book to complete a bank reconciliation statement.
Can I start the bank reconciliation statement with the balance shown on the bank statement?
You can create the bank reconciliation statement using the reverse order:
Start with the balance shown on the bank statement
Subtract the unpresented cheques
Add the outstanding lodgements
Check that it is equal to the balance shown in the cash book
Examiner Tips and Tricks
Always double-check whether the balance is positive or negative. This is the main reason why students lose marks in an exam!
Worked Example
Leo is a sole trader. On 31 March 2024, his bank statement showed that his business bank account was $345 overdrawn. On the same date, his cash book showed a credit balance of $395. Leo identified that some transactions were entered into his cash book but did not appear on his bank statement. These transactions are shown in the following extract of the cash book.
Extract of Cash Book (Bank columns)
Date | Details | $ | Date | Details | $ |
Mar 9 | Jacob | 500 | Mar 5 | Pru | 200 |
29 | Commission receivable | 300 | 23 | Wages | 750 |
Leo also noticed an error on his bank statement. A cheque paid for $100 for office expenses had been mistakenly processed twice by the bank.
Prepare the bank reconciliation statement for Leo at 31 March 2024.
Answer
The cash book has a credit balance
Therefore this is a negative amount
The credit entries are the unpresented cheques
Add their total to the cash book balance
The debit entries are the outstanding lodgements
Subtract their total from the cash book balance
The error has caused his bank balance to be lower than it should be
Therefore, subtract the amount of the bank error from the cash book balance
Leo’s business bank account is overdrawn
So the bank reconciliation statement will end with a negative amount
Leo
Bank Reconciliation Statement at 31 March 2024
$ | $ | |
Balance per bank statement | (395) | |
Unpresented cheques | ||
Pru | 200 | |
Wages | 750 | |
950 | ||
Outstanding lodgements | ||
Jacob | 500 | |
Commission | 300 | |
(800) | ||
Bank error | (100) | |
Balance per cash book | (345) |
Alternatively, it can be presented starting with the balance in the cash book.
Leo
Bank Reconciliation Statement at 31 March 2024
$ | $ | |
Balance per cash book | (345) | |
Unpresented cheques | ||
Pru | 200 | |
Wages | 750 | |
(950) | ||
Outstanding lodgements | ||
Jacob | 500 | |
Commission | 300 | |
800 | ||
Bank error | 100 | |
Balance per bank statement | (395) |
Last updated:
You've read 0 of your 5 free revision notes this week
Sign up now. It’s free!
Did this page help you?