Mada za sehemu hiiPrepare bank reconciliation statementsMada 2
- Describe a Bank reconciliation statement (meaning, importance, reasons for inconsistencies, and the key terms used)
- Prepare adjusted cash book and bank reconciliation statement
Preparing Adjusted Cash Book and Bank Reconciliation Statement
A business keeps its own record of bank transactions in the cash book (bank column), while the bank also keeps a record in the bank statement. These two records often show different balances because of timing differences — transactions recorded by the business may not yet appear in the bank statement, and vice versa. The adjusted cash book brings the business records up to date by recording items the bank has already processed but the business does not know about yet. The bank reconciliation statement then explains the remaining difference between the adjusted cash book balance and the bank statement balance.
- Unpresented cheque (outstanding cheque): A cheque issued by the business but not yet presented to the bank for payment. It appears in the cash book but not in the bank statement.
- Uncredited cheque (deposit in transit): A cheque received and deposited by the business but not yet cleared by the bank. It appears in the cash book but not yet in the bank statement.
- Direct debit (adjusting item): Items the bank has already recorded but the business has not — such as bank charges, standing orders. These must be entered in the cash book to update it.
- Direct credit (adjusting item): Items the bank has credited to the account but the business has not recorded — such as dividends, interest, or direct deposits by customers.
Compare each entry in the cash book with the bank statement:
| Item | Found in Cash Book | Found in Bank Statement | Treatment |
|---|---|---|---|
| Unpresented cheque | Credit side | Not yet shown | Reconciling item |
| Uncredited cheque | Debit side | Not yet shown | Reconciling item |
| Bank charges | Not yet entered | Debit side | Adjusting item — credit cash book |
| Standing order | Not yet entered | Debit side | Adjusting item — credit cash book |
| Dividend received | Not yet entered | Credit side | Adjusting item — debit cash book |
| Direct deposit by customer | Not yet entered | Credit side | Adjusting item — debit cash book |
| Dishonored cheque (received) | Already debited | Not shown | Adjusting item — credit cash book |
The adjusted cash book starts with the unadjusted balance, then adds direct credits and subtracts direct debits.
Worked Example — Bitekerezo Makusaro
The unadjusted cash book balance on 31st December 2021 is TZS 19,648,643 (debit). The bank statement shows:
- Dividend of TZS 65,400 (direct credit) — not in cash book
- Standing order (rent) of TZS 350,000 (direct debit) — not in cash book
- Bank charges of TZS 3,200 (direct debit) — not in cash book
Adjusted Cash Book (Bank Column)
| Date | Details | TZS | Date | Details | TZS |
|---|---|---|---|---|---|
| 31/12 | Balance b/d | 19,648,643 | 31/12 | Standing order — rent | 350,000 |
| 31/12 | Dividend | 65,400 | 31/12 | Bank charges | 3,200 |
| 31/12 | Balance c/d | 19,360,843 | |||
| 19,714,043 | 19,714,043 |
The adjusted balance is TZS 19,360,843. This is the true bank balance to report in the financial statements.
Using the adjusted cash book balance and the reconciling items:
- Add: Unpresented cheques (cheques issued but not yet presented)
- Less: Uncredited cheques (cheques deposited but not yet cleared)
Bank Reconciliation Statement as at 31st December 2021
| TZS | |
|---|---|
| Adjusted balance as per cash book | 19,360,843 |
| Add: Unpresented cheques | 3,200,000 |
| 22,560,843 | |
| Less: Uncredited cheques | 6,940,000 |
| Balance as per bank statement | 15,620,843 |
This matches the bank statement balance, confirming the reconciliation is correct.
You can also start with the bank statement balance and work back to the cash book balance:
| TZS | |
|---|---|
| Balance as per bank statement | 15,620,843 |
| Add: Uncredited cheques | 6,940,000 |
| 22,560,843 | |
| Less: Unpresented cheques | 3,200,000 |
| Adjusted balance as per cash book | 19,360,843 |
You can also prepare the reconciliation without first adjusting the cash book. In this case, all items causing difference are treated as reconciling items:
Bank Reconciliation Statement (using unadjusted balance)
| TZS | |
|---|---|
| Balance as per cash book (unadjusted) | 19,648,643 |
| Add: Unpresented cheques | 3,200,000 |
| Dividend (direct credit) | 65,400 |
| 22,914,043 | |
| Less: Uncredited cheques | 6,940,000 |
| Standing order — rent | 350,000 |
| Bank charges | 3,200 |
| Balance as per bank statement | 15,620,843 |
When errors are found in the cash book, correct them in the adjusted cash book:
- Error overstating payments: Reduce the payment entry
- Error understating receipts: Increase the receipt entry
- Dishonored cheque (cheque received but dishonored): Credit the cash book to reverse the original receipt
When the business has an overdraft, the treatment of reconciling items is reversed:
- Unpresented cheques add to the overdraft
- Uncredited cheques subtract from the overdraft
Bank Reconciliation Statement (Overdraft)
| TZS | |
|---|---|
| Overdraft as per adjusted cash book | 17,535,500 |
| Add: Uncredited cheques | 5,720,000 |
| 23,255,500 | |
| Less: Unpresented cheques | 4,350,000 |
| Overdraft as per bank statement | 18,905,500 |
- Balance the cash book (bank column) at the required date
- Obtain the bank statement for the same period
- Compare each entry in the cash book with the bank statement
- Identify adjusting items (direct debits and credits) — update the cash book
- Identify reconciling items (unpresented and uncredited cheques) — use in reconciliation statement
- Prepare the adjusted cash book
- Prepare the bank reconciliation statement starting with either balance
A small shop owner in Iringa who sells soft drinks to local restaurants keeps a cash book recording all money paid into and out of the business bank account. Every month, when they receive the bank statement, they compare it with their cash book to prepare a bank reconciliation. They discover items like bank charges for maintaining the account, standing orders for rent, and any cheques from customers that have not yet cleared. This process helps them know the exact amount of money in the bank for their financial statements and ensures no money is missing due to errors or fraud.
Swali
Which of the following best describes deposits in transit (uncredited cheques)?
Ingia ili kuwasilisha jibu lako na lihesabiwe katika umahiri wako.
Ingia ili kufanya mazoeziMwalimu
Umekwama? Niulize chochote kuhusu mada hii.
Ingia ili kumuuliza Mwalimu wa AI wa Sonza kuhusu swali hili.
Ingia ili kuuliza