Procurement Management  ·  Level 5
Financial Accounting
Chapter 6: Prepare bank reconciliation statements
📚 3 Topics
⚑ What you will be able to do

By the end of this chapter, you will be able to:

  • Identify discrepancies between the cash book and bank statement accurately and according to accounting principles.
  • Update the cash book’s bank column balance correctly following accounting guidelines.
  • Prepare a clear and accurate bank reconciliation statement using proper accounting methods.

Mastering these skills will help you ensure financial records are accurate and reliable, which is essential for successful business management.

Compiled by: David Owino

Bank reconciliation statements are essential tools for procurement professionals managing organizational finances in Kenya. They help verify that the cash book maintained by the procurement office aligns with the bank’s records, ensuring accurate tracking of cash inflows and outflows. Discrepancies between the cash book and bank statement often arise due to timing differences, errors, or unrecorded transactions, which must be identified and resolved to maintain financial integrity and support effective procurement decision-making. Understanding how to prepare these statements enables procurement managers to detect fraud, prevent budget overruns, and maintain accountability in public and private sector organizations.

6.1 Cash book and bank statement balance discrepancies

Discrepancies between the cash book and bank statement balances are common in procurement management due to differences in recording timing, bank charges, and errors. These differences can mislead financial reporting if not reconciled promptly. Procurement officers in institutions such as county government offices or SACCOs must be adept at identifying and explaining these discrepancies to ensure that payment records accurately reflect actual cash positions.

6.1.1 Items appearing in the cash book but not in the bank statement

Items recorded in the cash book but absent from the bank statement typically arise from timing differences or unprocessed transactions. Procurement officers must understand these differences to explain why the bank balance appears lower or higher than the cash book balance.

Outstanding Cheques

Outstanding cheques are payments issued by the procurement department and recorded in the cash book but not yet cleared by the bank. These cheques reduce the cash book balance but do not appear in the bank statement until the bank processes them. For example, a procurement officer at a county hospital may issue a cheque to a supplier, which the bank processes several days later, causing a temporary mismatch.

Deposits in Transit

Deposits in transit refer to cash or cheque deposits recorded in the cash book but not yet reflected in the bank statement. This delay can occur when deposits are made late in the day or during weekends. For instance, a procurement unit in a university might deposit funds on a Friday afternoon, but the bank statement will only show the deposit on the following Monday.

Errors in Recording Deposits or Payments

Errors such as recording the wrong amount or duplicating entries in the cash book cause discrepancies. Procurement staff may accidentally record a supplier payment twice or enter the incorrect figure for a deposit, leading to differences with the bank statement. Such mistakes require careful review and correction.

Bank Charges Not Yet Recorded in the Cash Book

Sometimes bank charges or fees are deducted directly by the bank but not yet recorded in the cash book. Procurement officers must update the cash book to reflect these deductions for accurate reconciliation. For example, a SACCO may incur monthly service fees that appear only on the bank statement until recorded in the cash book.

6.1.2 Items appearing in the bank statement but not in the cash book

Items appearing on the bank statement but missing from the cash book often indicate transactions the procurement department has not yet recorded. These differences highlight the need for regular cash book updates and cross-checking against bank statements.

Bank Direct Credits

Direct credits such as refunds, interest earnings, or funds transfers made directly into the organization’s bank account appear on the bank statement but may be missing from the cash book if not promptly recorded. For example, a procurement office at a retail business may receive a refund from a supplier, reflected in the bank statement before updating the cash book.

Bank Charges and Fees

Bank charges such as transaction fees or penalties deducted by the bank reduce the balance on the bank statement but may not be recorded in the cash book until identified during reconciliation. Procurement managers at county governments often find these charges appear unexpectedly on statements.

Unpresented Cheques

Unpresented cheques are cheques issued by the procurement department but not yet cleared by the bank. While these reduce the cash book balance, they may not appear on the bank statement if the payee has not presented them for payment. This timing difference causes discrepancies.

Errors by the Bank

Banks may sometimes make errors such as incorrect posting of amounts, which show on the bank statement but not in the cash book. Procurement managers must identify and report these errors to the bank for correction to maintain accurate financial records.

6.1.3 Errors

Errors in either the cash book or bank statement contribute significantly to discrepancies and must be identified and corrected during reconciliation. Procurement professionals require a systematic approach to uncovering these mistakes to ensure financial statements are reliable.

Errors in the Cash Book

These include incorrect entries such as wrong amounts, duplicated transactions, or omitted entries. For instance, a procurement clerk might mistakenly record a payment of Ksh 50,000 as Ksh 5,000, leading to an overstated cash book balance. Regular review and comparison with bank statements help detect such errors.

Errors in the Bank Statement

Bank errors such as incorrect debits or credits can occur due to processing mistakes. For example, a bank might debit a procurement account twice for the same transaction. Identifying these errors requires careful scrutiny of transaction details and prompt communication with the bank.

Reversal of Transactions

Sometimes transactions are reversed due to errors or disputes, appearing on the bank statement but not reflected in the cash book. Procurement staff must update their records to reflect these reversals to maintain accuracy.

Timing Errors

Timing errors occur when transactions are recorded in the wrong accounting period in either the cash book or bank statement. For procurement units in universities or hospitals, this can affect month-end reporting and requires adjustment during reconciliation.

Practice Questions

  1. Explain how outstanding cheques cause discrepancies between the cash book and bank statement in a procurement context. (5 marks)

  2. Identify and explain five types of items that may appear in the bank statement but not in the cash book. (10 marks)

  3. Describe four common errors that can occur in the cash book and how they affect bank reconciliation statements. (8 marks)

  4. How can timing differences between deposits in transit and bank processing affect the bank reconciliation process for a county government procurement office? (7 marks)

  5. Discuss the steps a procurement officer should take upon discovering an error in the bank statement during reconciliation. (10 marks)

The rest of this chapter
🔒

Create a free account to open more of this chapter.

Free: practical guides, quick cards, workplace scenarios and more.

Create a free account
🔒6.2 Update the cash book

Updating the cash book is a critical step in maintaining accurate financial records within procurement management. The cash book records all cash and bank transactions, reflecting payments and receipts relevant to procurement activities. In Kenyan organization…

🔒6.3 Bank reconciliation statement

Bank reconciliation is a vital control process that compares the cash book records with the bank statement to identify and explain differences. For procurement professionals in Kenya, preparing a bank reconciliation statement ensures that the organization's fi…

Chapter Summary

This chapter focused on understanding the discrepancies between cash book and bank statement balances, highlighting key differences that arise when items appear in the cash book but not in the bank statement, and vice versa. It examined common causes of such differences, including unpresented cheques and deposits in transit, as well as errors that may occur in recording transactions. The process of updating the cash book was explained, emphasizing the importance of incorporating bank charges, direct deposits, and corrections to maintain accurate records. Finally, the chapter detailed the preparation of the bank reconciliation statement, a critical tool that aligns the cash book balance with the bank statement balance by accounting for timing differences and errors. Through these steps, the chapter provided a comprehensive approach to ensuring the accuracy and reliability of financial records in relation to bank transactions.

Self-Assessment

🔒 PDFDownload this self-assessment, with answers

A. Written Assessment

  1. What are the common reasons for discrepancies between the cash book and bank statement balances? (3 marks)
  2. Identify three types of transactions that may appear in the cash book but not in the bank statement. (3 marks)
🔒26 more in this section.

Chapter Examination Questions

🔒 PDFDownload these examination questions, with worked answers

SECTION A (40 Marks) - Answer ALL Questions

  1. Explain why a cheque issued by a procurement officer at a county government office might appear in the cash book but not yet in the bank statement. (4 marks)
  2. Identify three types of items that could appear in the bank statement but not in the cash book of a SACCO. (4 marks)
🔒18 more in this section.

Chapter Practical Activities

Practical 1: Identify discrepancies between cash book and bank statement

Procurement Management · Level 5
Financial Accounting
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Identify and list all discrepancies between the cash book and bank statement for April 2024 highlighting differences with correct amounts.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Red penCash book for April 2024
Blue penBank statement for April 2024
Calculator
Ruler 30 cm
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Cash book for April 20241 copy per Candidate
2Bank statement for April 20241 copy per Candidate
3Red pen1 Pc per Candidate
4Blue pen1 Pc per Candidate
5Calculator1 Pc per Candidate
6Ruler 30 cm1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: VERIFYING CASH BOOK AND BANK STATEMENT
Wore appropriate personal protective equipment (if applicable to office environment)
(Award 1 mark for correct PPE usage or office appropriate safety)
1
Carefully compared dates of transactions in cash book and bank statement
(Award 1 mark for checking dates match, 1 mark for noting mismatches)
2
Checked amounts for each transaction in cash book against bank statement
(Award 1 mark for each correct comparison up to 3)
3
Highlighted discrepancies clearly using red pen on both documents
(Award 1 mark for each document correctly marked, 1 mark for clarity)
3
Calculated and noted the difference amounts accurately using calculator
(Award 1 mark for each correctly calculated discrepancy up to 3)
3
Listed all discrepancies with correct references (date, description, amount) in a clear and organized manner
(Award 1 mark for each correctly listed discrepancy up to 4)
4
Sub-Total16
PRODUCT CHECKLIST
All discrepancies between cash book and bank statement are correctly identified and listed with accurate amounts
(Award 1 mark for each correctly identified discrepancy up to 7)
7
Sub-Total7
GRAND TOTAL23
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)

Practical 2: Identify items in cash book not appearing in bank statement

Procurement Management · Level 5
Financial Accounting
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Identify and mark all items appearing in the cash book but not in the bank statement for March 2024 and record them clearly in the provided notebook.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Red penCash book (March 2024)
Blue penBank statement (March 2024)
Ruler (30 cm)Notebook for recording items
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Cash book (March 2024)1 copy per Candidate
2Bank statement (March 2024)1 copy per Candidate
3Red pen1 per Candidate
4Blue pen1 per Candidate
5Ruler (30 cm)1 per Candidate
6Notebook for recording items1 per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: IDENTIFYING AND MARKING ITEMS
Wore appropriate personal protective equipment (if applicable)
(Award 1 mark for wearing appropriate PPE such as eye protection if required)
1
Carefully examined the cash book and bank statement side by side
(Award 1 mark for each correct step: comparing dates, amounts, and references)
3
Marked all items appearing only in the cash book using red pen
(Award 1 mark for each correctly marked item up to 3 marks)
3
Used blue pen to mark items appearing in both documents
(Award 1 mark for correct use of blue pen on matched items)
1
Recorded all items found only in the cash book accurately in the notebook with date, description, and amount
(Award 1 mark for each correctly recorded item up to 5 marks)
5
Maintained neatness and clarity in marking and recording
(Award 2 marks for clear, legible, and organized markings and notes)
2
Sub-Total15
PRODUCT CHECKLIST
All items present only in the cash book are correctly identified, marked, and recorded with accurate date, description, and amount
(Award 2 marks for each correctly identified and recorded item up to 10 marks)
10
Sub-Total10
GRAND TOTAL25
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)
🔒

Free: practical guides, quick cards, workplace scenarios and more.

Create a free account
🔒Identify Bank Statement Items Missing in Cash BookPractical 3
🔒Detect and correct errors in cash book and bank statementPractical 4
🔒Update cash book with unrecorded bank statement itemsPractical 5
🔒Update cash book for unrecorded cash book itemsPractical 6
🔒Prepare Bank Reconciliation Statement from Updated Cash BookPractical 7
🔒Explain effects of errors on bank reconciliationPractical 8
🔒Prepare bank reconciliation statement by reconciling outstanding cheques and deposits in transitPractical 9
🔒Prepare a full bank reconciliation statement for the month of March 2024Practical 10
Flashcards 20 cards Study deck ▾
Question
1

↻ Tap card to reveal answer
🔒

18 more in this section.

Create a free account
Test Yourself 17 questions Start quiz ▾
0%
0 / 2
🔒

15 more in this section.

Create a free account
Am I competent?

At the start of this chapter we promised you would be able to:

  • Identify discrepancies between the cash book and bank statement accurately and according to accounting principles.
  • Update the cash book’s bank column balance correctly following accounting guidelines.
  • Prepare a clear and accurate bank reconciliation statement using proper accounting methods.

Tick each one you can genuinely do.

So, are you there yet?

You're competent when you can confidently do 50% or more of what this chapter promised.

Sign in to record how you're doing.