Bank Tools ยท QuickBooks
QuickBooks Reconciliation Questions
QuickBooks problems are usually not caused by the software itself. They are caused by inconsistent boundaries, bad imports, duplicate transactions, and undocumented adjustments. The correct workflow is to reconcile to the official bank statement ending balance, then explain differences with clean supporting documentation.
Core rule
Reconcile QuickBooks to the official statement ending balance. Do not reconcile to random exports, screenshots, or partial transaction lists.
Clean model:
statement ending balance = cleared transactions + verified adjustments
Most common causes of mismatch
- Duplicate imported transactions
- Wrong opening balance
- Incorrect statement period
- Pending items treated as cleared
- Manual adjustments without documentation
What accountants want
- Official statement PDF for the exact period
- Clear explanation of any adjustment
- No duplicate transactions
- One clean reconciliation boundary
Common QuickBooks reconciliation issues
Opening balance is wrong
This usually means prior reconciliations were changed, transactions were deleted, or an import created duplicate history. Fix the source issue. Do not patch the problem by forcing the current month to balance.
Duplicate bank feed entries
Duplicate entries make reconciliation impossible. Clean duplicates before reconciling and confirm that each transaction appears once.
Statement period mismatch
If your report boundary is not the same as the official statement boundary, the numbers will not match. Use the exact statement start and end dates.
Uncleared items confusion
QuickBooks reconciliation should focus on cleared transactions that belong to the statement period. Pending or uncleared items should not be forced into the period.
Manual adjustments with no audit trail
Unsupported manual adjustments reduce trust and create future errors. Every adjustment needs a reason and supporting document.
Recommended workflow
- Download the official statement PDF for the exact period.
- Verify the beginning and ending balances.
- Identify duplicates and incorrect imports before reconciling.
- Reconcile cleared transactions only.
- Create one PDF bundle with the statement and supporting documents.