Comprehensive Guide to Daily Bank Reconciliation

Core Concepts of Bank Reconciliation

• Definition of the Cashbook: A business maintains its own internal record of all financial transactions involving cash entering or leaving the entity. This ledger is referred to as the cashbook.     * Examples of entries found in a cashbook include transactions such as "customer paid $£400$ for services" or "paid $£200$ for supplies."
• Definition of the Bank Statement: The bank keeps a separate, independent record of the business's transactions from the bank's perspective, which is known as the bank statement.
• The Reconciliation Process: Bank reconciliation is the act of comparing the business's cashbook against the bank statement to ensure they both result in a single, accurate cash balance.     * It is very common for these two records not to match.     * The process involves identifying every discrepancy, explaining each one, and ultimately arriving at a unified, correct cash balance.

Strategic Importance of Performing Reconciliations

• Ensuring Accuracy of Reported Cash: The primary goal is to resolve discrepancies between the cashbook and the bank statement. If the figures differ, the reconciliation identifies which record is correct—or how both must be adjusted—to determine the true cash position of the business.
• Prevention and Detection of Fraud: Reconciliation serves as a critical internal control to catch fraudulent activities.     * Internal Fraud Example: An employee might write themselves a check. This transaction would appear on the bank statement when cashed but would be suspiciously absent from the company's cashbook.     * External Theft Example: A customer might make a payment that is subsequently stolen by an employee. In this case, the payment would be recorded in the cashbook but would never appear on the bank statement.
• Catching Human Errors: The process identifies various clerical mistakes made during data entry, including:     * Typos: General misspelling or incorrect character entry.     * Transposition Errors: Recording digits in the wrong order (e.g., writing $53$ instead of $35$).     * Account Misallocation: Recording payments against the wrong ledger or account.
• Capturing Unrecorded Bank Activities: Certain transactions are initiated by the bank and will not be recorded in the cashbook until the statement is reviewed. These include:     * Bank service fees and charges.     * Processing of direct debits.
• Verification of Cash Flow Integrity: Monthly or daily reconciliations ensure that the business's cash flow data is trusted and reliable.     * Inversion of Records: It is important to note that the company's records (cashbook) and the bank's records (bank statement) operate as mirrors. In the company's cashbook, "cash in" is recorded as a debit and "cash out" is recorded as a credit. Conversely, on the bank statement, these entries are reversed.

Understanding Timing Differences

Timing differences occur when a transaction is legitimate and recorded in one set of books but has not yet been processed or recognized by the other party's records.

• Transactions in the Cashbook Not Yet in the Bank Statement:     * Outstanding Lodgements (also referred to as Outstanding Cheques): This occurs when a business receives a payment, such as a check, and records it in the cashbook immediately. For example, if a check is received and banked at $4:00\,pm$ on a Friday, the business records it that day. However, because the bank has not yet cleared the funds, the amount will not appear on the bank statement for that period. This difference is explained during the reconciliation.     * Unpresented Cheques: This occurs when the business writes a check to a supplier and records the outflow in its cashbook. The bank statement will not reflect this until the supplier actually deposits the check and the bank processes it.
• Transactions on the Bank Statement Not Yet in the Cashbook:     * Bank Charges or Fees: Costs levied by the bank for account maintenance or services.     * Interest: Interest earned on the account balance or interest charged on overdrawn amounts.     * Direct Debits and Standing Orders: Automated, recurring payments that the bank processes directly.     * Unknown Customer Receipts: Payments made directly into the bank account by customers that the business was not aware of and therefore had not yet recorded in the cashbook.     * Bounced Cheques: Checks previously recorded as receipts that the bank later rejects due to insufficient funds.

Error Identification and Categorization

During reconciliation, various errors may be discovered, most commonly within the company's own records, though bank errors do occasionally occur.

• Common Cashbook Errors:     * Incorrect Figures: For example, entering a value of $£530$ as $£350$.     * Duplicate Entries: Recording the same transaction more than once.     * Wrong Quantities: Incorrectly noting the number of items or the volume of a transaction.     * Postings to Wrong Accounts: Directing a transaction to an incorrect general ledger account.     * Missing Entries: Entirely omitting a transaction that should have been recorded.
• Bank Errors: While rare, the bank may occasionally make a mistake on the statement. These are discovered during reconciliation, after which the business must contact the bank to initiate a correction.

The Step-by-Step Reconciliation Process

To ensure accuracy, the process must be performed methodically and with discipline.

1. Document Acquisition: Obtain both the bank statement and the cashbook for the exact same financial period.
2. Matching (Ticking Off): Systematically compare the two documents and tick off every transaction that appears in both records.
3. Bank Statement Analysis: Identify items that appear only on the bank statement. Categorize these as either "bank-only items" (like fees or direct debits) or "bank errors."
4. Cashbook Analysis: Identify items that appear only in the cashbook. Categorize these as either "timing differences" (like outstanding lodgements or unpresented cheques) or "cashbook errors."
5. Updating the Cashbook: Adjust the cashbook by recording the bank-only items (fees, interest, etc.) and correcting any cashbook errors found. This results in an Adjusted Cashbook Balance.
6. Building the Reconciliation Statement: Create the formal document that bridges the gap between the bank statement and the adjusted cashbook.

• Final Goal: At the conclusion of this process, the reconciled bank statement balance and the reconciled (adjusted) cashbook balance must be equal.

Format of the Bank Reconciliation Statement

The following structure is used to reconcile the balance shown on the bank statement back to the adjusted cashbook balance:

• Balance per bank statement: $£X,XXX$
• Add: Outstanding lodgements: $£XXX$
• Less: Unpresented cheques: ($£XXX$)
• Less: Bank errors (if any): ($£XXX$)
• Adjusted bank balance: $£X,XXX$