QuickBooks Bank Reconciliation Not Matching? Why Outstanding Check sand Timing Differences CauseIt

Key takeaways

• Most bank reconciliation differences are timing issues, especially outstanding checks that have been recorded in QuickBooks but have not yet cleared the bank.
• In one construction client investigation, a check-clearing discrepancy appeared serious until the issue was traced to a prior-period clearing error.
• Never force a reconciliation to balance with a journal entry before identifying the actual cause of the difference.
• A simple five-step investigation can usually determine whether the difference is timing, an entry error, a duplicate, a bank charge or something that needs escalation.

What causes a bank reconciliation difference?

Before tracing a mismatch, start with the common causes. Timing is the most frequent explanation, but it is not the only one.

A real example: one check, two investigation sessions

We were brought in to investigate a check-clearing discrepancy for a construction client. One check written to a subcontractor appeared to be causing a mismatch between the bank register and QuickBooks. The client’s instinct was that something had gone wrong with the payment itself.

After tracing the transaction across two full sessions, matching the check number, payee, issue date and actual bank clearing date against both the QBO bank feed and the physical bank statement, the discrepancy resolved to something simple: a prior-period clearing error.

The check had been issued and cleared correctly. It was recorded in a different accounting period from when the bank processed it. No fraud, no lost funds, just timing that looked alarming until someone traced it end to end.

Why does this happen so often in construction and project businesses?

• Batch payments. Checks are issued around draw schedules and payroll cycles, often at month-end, exactly when timing gaps straddle a close.
• Longer float on subcontractor checks. Smaller subcontractors may not bank daily, so checks can sit longer before being deposited.
• Mixed automation. Part of the process runs through the bank feed and part is manual, so small sequencing differences can look bigger than they are.
• Period-end pressure. When the books must close, it can be tempting to force an adjustment instead of tracing the actual clearing date.

How do you fix a bank reconciliation that will not balance? A 5-step process

1. Isolate the specific check or transaction. Pull the exact check number and payee before touching anything else.
2. Compare three dates. Compare the issue date, QuickBooks recorded date and bank cleared date. Most discrepancies become visible once these dates are lined up.
3. Check the period boundary. If the item sits near a month-end, investigate timing before assuming there is an accounting error.
4. Confirm against the bank register, not just the feed. Bank feeds can lag or batch items in ways that hide the actual clearing date.
5. Document the resolution. A note such as “prior-period clearing timing, no correction needed to the underlying transaction” saves the next person from repeating the work.

When is a reconciliation difference actually fraud?

Timing is the likely answer, but not always. Escalate when you see a gap in the check number sequence with no voided record, a payee or amount that differs from what you issued, a payment you do not recognize, or a difference that keeps growing month after month instead of clearing.

Those are signs to involve the bank and review approvals rather than immediately adjusting the books. The objective is to determine what actually happened before changing the accounting records.

What should UK businesses know?

The mechanics are the same in the UK, although payments run through Bacs, Faster Payments and CHAPS rather than ACH and wires, and cheques clear on different schedules.

Clean reconciliations matter more as digital reporting requirements expand. Under Making Tax Digital for Income Tax, sole traders and landlords with qualifying income over £50,000 were due to start from 6 April 2026, with the threshold falling to £30,000 in April 2027 and £20,000 in April 2028. Quarterly digital updates are far easier when bank records are already reconciled.

The real lesson

Not every mismatch is a mistake, and not every mismatch needs a journal entry. The bigger risk is an owner or bookkeeper who force-adjusts the books, turning a non-issue into an actual error.

Trace first. In many cases, the money was never lost; it simply landed in a different accounting period.