Bank Reconciliation Example

What is a bank reconciliation statement?

A bank reconciliation statement compares the cash balance on a company’s balance sheet with the amount shown on its bank statement. This process helps identify any necessary accounting adjustments to ensure the company's cash records are accurate. Regular bank reconciliations are essential for maintaining accurate financial records.

Form 944 guide: federal tax return for small businesses

Example of a bank reconciliation statement

Let's say ABC Manufacturing has an ending balance of $10,000 in its books while the bank statement shows a balance of $12,000. Upon investigation, ABC Manufacturing discovers two discrepancies:

  1. Outstanding Check: A $1,000 check issued to a supplier still needs to clear the bank.
  2. Missed Deposit: A $3,000 customer deposit should have been recorded in the company's books.

To reconcile the balances, ABC Manufacturing will:

  • Adjust for the Outstanding Check: Deduct the $1,000 from the bank statement balance to $11,000.
  • Record the Missed Deposit: Add the $3,000 to the book balance, increasing it to $13,000.

After these adjustments, the adjusted bank balance ($11,000) and the adjusted book balance ($13,000) still do not match. Further investigation reveals that a bank fee of $500 was not recorded in the company’s books. Adjusting for this fee:

  • Deduct the Bank Fee: Subtract the $500 bank fee from the adjusted book balance of $13,000, resulting in a final book balance of $12,500.

Now, both balances are closer but still not equal. The remaining $500 discrepancy prompts further investigation and is eventually traced to a transposition error in recording a deposit. Once corrected, the bank balance and book balance match at $12,000, completing the reconciliation process.

Understanding the bank reconciliation statement

Bank reconciliation statements confirm the processing of payments and deposits. They help identify discrepancies between the bank balance and the book balance, allowing for necessary adjustments. Typically, accountants prepare reconciliation statements monthly.

How to perform a bank reconciliation

You will need your company ledger and the current and previous month’s bank statements to perform bank reconciliation. While many online templates can assist, a simple spreadsheet is often sufficient.

  1. Enter the Closing Balance: Start with the closing balance from the previous month.
  2. Adjust for Outstanding Items: To get the adjusted cash balance, subtract any checks in transit and add back any deposits not yet cleared.
  3. Account for Bank Charges and Interest: Add any accrued interest and subtract charges, fines, or NSF checks not recorded in your business ledger.
  4. Match Transactions: Ensure that the sums of cleared deposits and checks match the bank's records. The final balance should be reconciled.
  5. Investigate Discrepancies: If there are differences, identify any overlooked entries or potential bank errors.

Benefits of a bank reconciliation statement

  • Fraud Detection: Reconciliation reports help identify fraudulent activities, such as altered checks.
  • Error Identification: They also reveal errors that can impact financial reporting, ensuring accurate profitability assessments.
  • Financial Management: Regular reconciliations prevent errors from compounding and help manage financial flows effectively.

1099-K form: Everything you need to know.

Summary

Bank reconciliation statements are essential for identifying errors, omissions, and fraud. Regularly performing reconciliations helps businesses detect issues before they escalate and ensures accurate financial management. This simple yet effective process is crucial for maintaining financial health.

Fun fact

Did you know? The concept of bank reconciliation dates back to ancient Babylonian merchants, who used clay tablets to reconcile their accounts with those of their trading partners, ensuring accuracy in their financial dealings.

Send us a hi on LinkedIn.