Banking & Reconciliation
Troubleshoot reconciliation differences from missing items, duplicates, wrong dates, transfers, fees, and opening balances.
Best for: users stuck with a bank, credit card, or loan reconciliation difference.
Important: This article is general bookkeeping education. It is not tax, legal, payroll, or accounting advice. Rules and correct treatment can depend on entity type, industry, location, software setup, and professional judgment.
Do not force a reconciliation difference. Check statement date, ending balance, missing items, duplicates, wrong amounts, and transfers first.
What this means
A reconciliation difference means the books do not yet agree with the statement. The difference is a clue that needs review.
Forcing differences can hide missing income, duplicate expenses, incorrect transfers, or prior-period errors.
Core concepts
Wrong statement date or balance creates immediate differences.
Fees, interest, checks, deposits, or imports may be missing.
Duplicate imports can overstate income or expenses.
Transfers need both sides matched correctly.
Step-by-step workflow
- Gather the source records. Save statements, receipts, reports, screenshots, contracts, confirmations, or notes that support a reconciliation difference.
- Identify the business event. Decide what actually happened before choosing a category or changing a report.
- Match the money movement. Compare the bookkeeping record to bank, credit card, loan, payroll, or platform activity.
- Choose the right treatment. Separate income, expense, asset, liability, equity, transfer, and owner activity instead of using one catch-all category.
- Review for duplicates and timing. Look for repeated entries, missing transactions, old balances, refunds, chargebacks, and period cut-off issues.
- Save final notes. Keep a clear explanation so the owner, bookkeeper, or accountant can understand the decision later.
Review checklist
- The period, account, and source report being reviewed are clearly identified.
- Transactions are not duplicated or counted in the wrong period.
- Unclear items are placed on a question list instead of guessed.
- Supporting documents are saved in the monthly records folder.
- The final report or template includes notes for unusual activity.
Common mistakes to avoid
- Guessing from the bank description only. Bank descriptions are helpful but often incomplete.
- Using miscellaneous too often. Too many miscellaneous entries make reports less useful.
- Skipping documentation. A correct number is harder to defend when the source is missing.
- Ignoring balance sheet effects. Some activity affects assets, liabilities, or equity rather than the P&L.
Example review map
| Area | What to review |
|---|---|
| Documents | Confirm the files supporting a reconciliation difference are saved and named clearly. |
| Category | Confirm the category describes the business purpose and account type. |
| Balance | Confirm any related bank, card, loan, tax, payroll, or owner balance makes sense. |
| Questions | List missing details and assign follow-up before closing the month. |
| Handoff | Save a short note for the owner, bookkeeper, accountant, or tax preparer. |
FAQ
Should I make an adjustment?
Only when appropriate and supported. It is better to find the source difference.
Can bank feeds be wrong?
Feeds can duplicate, omit, or delay items. Always compare to the statement.
Can I use this with a KanderBooks template?
Yes. Use the article as a workflow guide, then use the matching KanderBooks template to organize amounts, notes, dates, confirmations, and review questions.
When should I ask a professional?
Ask a qualified bookkeeper, accountant, payroll provider, or tax professional when the item affects taxes, payroll, loans, prior-period reports, legal compliance, or financial statements used outside the business.
Was this tutorial helpful?
Your feedback helps improve the KanderBooks tutorial library.