How to reconcile your bank account in QuickBooks every month

A staffing company owner we work with found a $4,100 difference between her QuickBooks balance and her bank statement in June. She assumed it was a timing issue and moved on. Four months later the gap was $9,700. It included a $6,400 vendor payment entered twice and a $2,800 check from a client that had never made it into the books. A monthly reconciliation would have caught both errors the month they occurred.

What bank reconciliation actually is

A bank reconciliation is the monthly process of comparing your bank statement to your QuickBooks records and confirming they agree. Every legitimate difference between the two has an explanation: a check you wrote that has not cleared, a deposit you recorded that arrived after the statement date, a bank fee you have not yet entered. When those explained differences account for the full gap, the reconciliation is complete. Unreconciled books make it easy to miss duplicate entries, undeposited funds, and unauthorized transactions for months at a time.

Common causes of reconciliation differences

Outstanding checks left unreviewed. A check is recorded in QuickBooks the day it is written. The bank does not see it until it clears. Most checks clear within two weeks. A check outstanding for 60 days means the vendor lost it, the check was never received, or it was never mailed. Each of those outcomes requires a different follow-up.

Deposits recorded before they post. A deposit entered on the last business day of the month may appear on the bank statement the following day. That one-day lag is normal. A deposit in transit that reappears on the following month’s outstanding list is not. It usually means the physical deposit was never made.

Bank fees and charges not entered. Wire fees, returned-check fees, monthly service charges, and stop-payment fees appear on the statement before they appear in QuickBooks. If they are not entered during reconciliation, they remain missing from the expense record and the books run higher than the bank.

Duplicate entries. When the same bill or receipt is entered twice, expenses are overstated and the QuickBooks balance is lower than the bank balance. Duplicate entries are the most common source of unexplained differences in small business books, and they grow harder to untangle the longer they go unaddressed.

Third-party processor timing. Stripe, Square, and PayPal hold funds one to three business days before depositing them. If income is recorded when payment is received but the deposit lands the next business day, the month-end figures will be off by a day. That difference should be small and consistent. If it grows month over month, something is being missed in the entry workflow.

What the difference looks like in practice

A property management company closed April with a QuickBooks balance of $88,400. The bank statement showed $84,200. The $4,200 difference broke down as follows.

Correcting the duplicate entry and adding the wire fee brought the books to $84,200. Reconciliation complete.

Why unreconciled books create real problems

An unreconciled account is a blind spot. A $200 mistake in February can grow to a $2,400 unexplained gap by December because no one caught it early. Each month it goes uncorrected, it becomes harder to trace the original source.

The more concrete risk is unauthorized transactions. A $340 fraudulent charge does not stand out in a busy bank feed. It does stand out in a reconciliation where every line must be accounted for. Small businesses that reconcile monthly catch unauthorized transactions significantly faster than those that do not.

Duplicate expense entries also distort the Profit and Loss report (P&L). If inflated costs carry into the year-end books, the financial statements are wrong. Fixing months of accumulated errors during a year-end review takes considerably more time than finding them one month at a time, and it often requires reviewing the original source documents for each entry.

What a properly reconciled account looks like

For clients we work with, bank reconciliation is a fixed step at the monthly close. It runs after all transactions are entered and before the P&L is reviewed.

Every bank account is reconciled monthly: primary checking, payroll, savings, and any money market accounts. Transactions are matched one by one, not as batch totals. Outstanding items are listed and reviewed each month. Any check or deposit that has been outstanding for more than 45 days triggers a follow-up before the reconciliation is marked complete.

A clean reconciliation typically takes 15 to 45 minutes for a small business. It takes considerably longer when it has not been done in several months and requires backtracking through old statements to find where the records diverged.

Best practices for monthly bank reconciliation

• Reconcile within the first two weeks of the following month while transactions are still fresh and bank feed errors are easier to trace to the original source document.
• Never adjust the opening balance to force a reconciliation to close. Find the error. A forced balance conceals the problem and guarantees a larger discrepancy the following period.
• When a check has been outstanding for more than 45 days, contact the payee to confirm receipt. If the check was lost or never cashed, issue a stop payment and reissue it. Leaving it open does not make the liability go away.
• Save the reconciliation report as a PDF after each period. A complete set of reconciliation reports is evidence that accounts were verified on a regular schedule, which matters during audits and reviews.
• If the reconciliation is off by a small, consistent amount every month, look for a recurring fee or a systematic timing difference in how income is recorded. A pattern usually points to a process problem rather than a one-off entry error.

Three questions worth asking

1. When was the last time your primary bank account was formally reconciled in QuickBooks, and does the reconciliation report for that period still exist?
2. Are there any checks in your outstanding list that have been sitting there for more than 60 days?
3. Is there a difference of more than a few hundred dollars between your bank statement balance and your QuickBooks balance right now?

If the answers are uncertain, the gap between your books and your bank has likely been growing. Send us your most recent bank statement alongside a QuickBooks balance sheet for the same date. We will identify where the differences are and what needs to be corrected.