Bank Reconciliation 30 September 2021

1. What Is a Bank Reconciliation?

A bank reconciliation is the process of comparing a companys cash book (or ledger) with the bank statement for a specific period. The aim is to identify and explain any differences so that the balances agree. This control procedure helps detect errors, fraud, timing differences, and unrecorded transactions.

2. Why the 30September2021 Cutoff?

September302021 marks the end of the third fiscal quarter for many organisations. Completing the reconciliation at this date provides:

• Accurate quarterly financial statements.
• Timely detection of unauthorized withdrawals before the yearend close.
• A baseline for cashflow forecasting for the upcoming quarter.

3. Key Documents Required

4. StepbyStep Reconciliation Process

Step 1 Start With the Bank Statement Balance

Take the closing balance on the September302021 bank statement as the starting point.

Step 2 Add Deposits In Transit

Identify any cash receipts that have been recorded in the cash book but do not appear on the statement (e.g., a deposit made on September29 that cleared on October2). Add these amounts to the statement balance.

Step 3 Subtract Outstanding Cheques

List all cheques issued before September30 that have not cleared the bank. Subtract the total from the adjusted bank balance.

Step 4 Adjust for Bank Fees and Interest

Record any service charges, monthly fees, or interest earned that appear on the bank statement but were not yet entered in the cash book. Debit fees, credit interest, and adjust the cash book accordingly.

Step 5 Reconcile Differences

If the adjusted bank balance still differs from the cash book balance, investigate:

• Data entry errors (e.g., transposed digits).
• Duplicate entries.
• Bank errors (rare, but possible).

Step 6 Document the Reconciliation

Prepare a reconciliation statement showing each adjustment and the final matched balances. Signatures of the preparer and reviewer provide internal control.

5. Sample Reconciliation Statement (Illustrative)

Bank Statement Closing Balance (30Sep2021)           $45,800.00+ Deposits in transit                                 $3,200.00- Outstanding cheques                                $2,750.00- Bank service charges                                 $45.00+ Interest credited                                   $12.00-------------------------------------------------------------Adjusted Bank Balance                                 $46,217.00Cash Book Balance (30Sep2021)                       $46,217.00-------------------------------------------------------------Reconciliation Difference                             $0.00        

The numbers above are examples only; replace them with the actual figures for your organisation.

6. Common Issues Encountered in September 2021

During the third quarter of 2021 many entities faced unique challenges that impacted reconciliation:

• COVID19 related stimulus payments: Government relief funds often arrived as electronic transfers, sometimes delayed in posting.
• Currency fluctuations: Companies with multicurrency accounts needed to adjust for exchangerate gains or losses.
• Increased cyberfraud alerts: Unauthorized ACH transactions required swift investigation and reversal.

7. Internal Controls and Best Practices

• Perform reconciliations at least monthly; quarterly for lowvolume accounts.
• Separate duties the person recording transactions should not be the one reconciling.
• Maintain a clear audit trail with supporting documents attached to the reconciliation file.
• Use accounting software that automates the matching of bank feeds to ledger entries.
• Review any outstanding items older than 30 days with management for possible writeoffs.

8. Reporting the Results

After the reconciliation is complete, the following should be communicated:

1. Prepared by name and date.
2. Reviewed by name, title, and date of review.
3. Summary of adjustments fees, interest, errors corrected.
4. Any unresolved items with proposed actions.

This report becomes part of the quarterly financial package submitted to senior management and external auditors.

9. Conclusion

Reconciliation of the bank account as at 30September2021 is a critical control that ensures the integrity of the financial records for the quarter. By following a systematic approachgathering the necessary documents, applying the adjustment steps, investigating discrepancies, and documenting the outcomeorganizations can safeguard cash, maintain accurate reporting, and meet regulatory expectations.