Bank Reconciliation Calculator

Reconcile your cash book balance with your bank statement to identify discrepancies, outstanding transactions, and ensure your accounting records are accurate.

Cash Book Balance

Balance shown in your accounting records

Add: Deposits in Transit

Deposits recorded in cash book but not yet on bank statement
Total Deposits in Transit: $2,500.00

Less: Outstanding Checks

Checks written but not yet cleared at the bank
Total Outstanding Checks: $1,150.00

Bank Statement Balance

Balance shown on bank statement

Add: Bank Credits Not in Books

Interest earned, direct deposits not yet recorded
Total Bank Credits: $25.00

Less: Bank Charges Not in Books

Bank fees, NSF charges, automatic debits not recorded
Total Bank Charges: $25.00

Bank Reconciliation Statement

Starting from Cash Book
Cash Book Balance $15,000.00
Add: Deposits in Transit +$2,500.00
Less: Outstanding Checks -$1,150.00
Adjusted Cash Book Balance $16,350.00
Starting from Bank Statement
Bank Statement Balance $13,650.00
Add: Bank Credits Not in Books +$25.00
Less: Bank Charges Not in Books -$25.00
Adjusted Bank Balance $13,650.00
Difference $2,700.00

Accounts Do Not Match

There is a discrepancy that needs to be investigated.

Discrepancy: $2,700.00

Reconciliation Breakdown

What is Bank Reconciliation?

Bank reconciliation is the process of comparing your company's cash book (internal accounting records) with your bank statement to ensure they match. This critical accounting procedure helps identify discrepancies, errors, and fraudulent activities while ensuring the accuracy of financial records.

A bank reconciliation statement reconciles the cash balance in a company's cash book with the corresponding balance in the bank statement. The two balances often differ due to timing differences, bank charges, errors, or items recorded by one party but not the other.

Adjusted Cash Book Balance = Cash Book Balance + Deposits in Transit - Outstanding Checks

Adjusted Bank Balance = Bank Statement Balance + Bank Credits - Bank Charges

When reconciliation is complete, both adjusted balances should match.

Why is Bank Reconciliation Important?

Regular bank reconciliation provides numerous benefits for businesses of all sizes:

How to Perform Bank Reconciliation

1

Gather Documents

Collect your bank statement, cash book, and any supporting documents such as deposit slips, check stubs, and receipts for the reconciliation period.

2

Compare Opening Balances

Verify that the opening balance on your bank statement matches the opening balance in your cash book. If they differ, investigate last month's reconciliation.

3

Check Off Matching Items

Compare each transaction in your cash book with the bank statement. Mark items that appear in both records. This is called "ticking and bashing."

4

Identify Outstanding Items

List deposits in transit (recorded in cash book but not yet on bank statement) and outstanding checks (written but not yet cleared).

5

Record Bank-Only Items

Identify items on the bank statement not in your cash book: interest earned, bank charges, direct deposits, automatic payments, and NSF checks.

6

Prepare Reconciliation Statement

Create the bank reconciliation statement showing adjustments to both balances. The adjusted balances should match.

Common Reconciling Items

Item Description Adjustment
Deposits in Transit Deposits made but not yet processed by bank Add to Bank Balance
Outstanding Checks Checks written but not yet cashed Subtract from Bank Balance
Bank Service Charges Monthly fees, wire transfer fees Subtract from Cash Book
Interest Earned Interest credited by bank Add to Cash Book
NSF Checks Returned checks due to insufficient funds Subtract from Cash Book
Direct Deposits Electronic transfers not yet recorded Add to Cash Book
Automatic Payments Scheduled payments not yet recorded Subtract from Cash Book
Errors Recording mistakes in either record Correct the error

Example Bank Reconciliation

Given Information:

  • Cash Book Balance: $15,000
  • Bank Statement Balance: $13,650
  • Deposit in transit: $2,500
  • Outstanding checks: $800 + $350 = $1,150
  • Bank interest earned: $25
  • Bank service fee: $25

Reconciliation:

Adjusted Cash Book = $15,000 + $25 (interest) - $25 (fee) = $15,000

Adjusted Bank = $13,650 + $2,500 (deposits) - $1,150 (checks) = $15,000

Both balances match!

When to Perform Bank Reconciliation

The frequency of bank reconciliation depends on your business size and transaction volume:

Common Reconciliation Errors

  • Transposition errors: Writing $540 instead of $450
  • Omission: Forgetting to record a transaction
  • Duplicate entries: Recording the same transaction twice
  • Wrong amount: Recording incorrect transaction amounts
  • Timing differences: Recording in wrong period

Best Practices for Bank Reconciliation

1. Reconcile Promptly

Perform reconciliation as soon as you receive your bank statement. The longer you wait, the harder it becomes to identify and resolve discrepancies.

2. Maintain Documentation

Keep copies of all reconciliation statements and supporting documents. This creates an audit trail and helps with future reconciliations.

3. Segregate Duties

When possible, have different people handle cash receipts, disbursements, and reconciliation. This internal control helps prevent fraud.

4. Investigate All Differences

Never ignore discrepancies, no matter how small. Small differences may indicate larger problems or systematic errors.

5. Use Reconciliation Software

Accounting software can automate much of the reconciliation process, reducing errors and saving time.

Frequently Asked Questions

What if my bank reconciliation doesn't balance?

If your reconciliation doesn't balance, systematically check for: arithmetic errors, transposition errors, omitted items, duplicate entries, items recorded in wrong periods, and bank errors. Compare each item line by line, and consider using check digits to catch transposition errors (differences divisible by 9 often indicate transposed numbers).

How long should outstanding checks remain outstanding?

Generally, checks become "stale" after 6 months and banks may refuse to honor them. If a check has been outstanding for more than 3 months, contact the payee to confirm receipt. For very old outstanding checks, consult your accountant about reversing the entry and following unclaimed property laws.

Should I adjust my cash book for outstanding items?

No, deposits in transit and outstanding checks are timing differences that will clear automatically. However, you SHOULD adjust your cash book for items like bank charges, interest earned, NSF checks, and errors that the bank has recorded but you haven't.

What's the difference between a bank reconciliation and a cash reconciliation?

Bank reconciliation compares your cash book to your bank statement. Cash reconciliation (or cash count) verifies physical cash on hand against the cash register or petty cash records. Both are important internal controls but serve different purposes.

Can bank reconciliation detect all fraud?

While bank reconciliation is an important fraud detection tool, it cannot catch all types of fraud. It's most effective at detecting unauthorized disbursements and timing manipulations. Combine it with other controls like segregation of duties, approval requirements, and regular audits for comprehensive fraud prevention.