Bank reconciliations are the single most effective control a small‑to‑mid‑size business can run each month. By matching the cash balance in the general ledger to the balance reported by the bank, you expose timing gaps, unrecorded fees, and even fraud before they become material problems. The process is straightforward, but it only works when you treat it as a formal internal‑control activity, not a quick “check‑off” at month‑end.
Book vs Bank Balances
The first step is to compare the statement balance (the figure on the bank’s monthly statement) with the book balance (the cash account in QuickBooks). A difference is normal; the key is to understand why it exists.
Timing differences – Deposits that have been entered in the ledger but have not yet cleared the bank, and checks that have been written but not yet presented, create a gap. These items are not errors; they are simply in transit.
Reconciliation schedule – Your reconciliation worksheet should list each timing adjustment and any other reconciling items. When you add the adjustments to the statement balance, the result must equal the adjusted book balance. Any mismatch signals a missing entry or a potential misstatement that needs investigation.
Common Timing Adjustments
Two categories dominate timing gaps:
Deposits in transit – Imagine you recorded a $3,200 client payment on the 28th, but the bank processes it on the 2nd of the next month. The deposit sits in transit until the statement cut‑off. List it as a reconciling item and clear it when the bank shows the deposit.
Outstanding checks – A check for $1,150 printed on the 30th may sit with the vendor for several days. Until the bank debits the account, the check remains outstanding. Track checks older than 60 days; they often indicate lost paperwork or a vendor dispute that needs resolution.
Unrecorded Activity
Banks frequently post items that never make it into the books unless you look for them.
Bank fees & interest – Monthly service fees, wire fees, and earned interest appear on the statement. If they are not recorded, the book balance will be overstated. Create a small “Bank Service Charges” expense line for each fee.
ACH debits & merchant holds – Automatic payments (e.g., subscription services) and temporary holds on credit‑card transactions reduce the available balance but may not be reflected in QuickBooks until the settlement date. Add these as reconciling items and post them once cleared.
Segregation of Duties
Effective internal controls require that no single person can both initiate and conceal a misstatement.
Dual‑control principle – The employee who performs the reconciliation must never have the authority to sign checks, approve wires, or release payments. This separation prevents a person from covering up unauthorized disbursements by simply “adjusting” the reconciliation.
Manager sign‑off – After the reconciliation is complete, a higher‑level manager (controller, owner, or designated supervisor) must review the report, verify the supporting documentation, and sign off. Their independent review adds a layer of assurance that the reconciliation is accurate and complete.
Do / Avoid
Do
- Reconcile every bank and credit‑card account within a few days of the statement cutoff.
- Investigate any outstanding checks or deposits older than 60 days; resolve or write‑off as appropriate.
- Enforce strict separation between payment release authority and the reconciliation function.
Avoid
- Forcing a reconciliation to balance by entering unexplained “plug” journal entries.
- Allowing the same person who signs checks to also perform the bank reconciliation.
- Ignoring small reconciling discrepancies; they often mask larger errors or fraud.
A disciplined monthly reconciliation, backed by clear segregation of duties, catches unrecorded fees, timing floats, and fraudulent activity before they affect financial reporting.
Takeaway: Treat the bank reconciliation as a formal control, not a perfunctory task, and it will protect your cash ledger every month.
Top comments (0)