Why balances don't tie after conversion (top 10 causes + fixes)

When balances don't tie after conversion, systematic troubleshooting saves time. Here are the top causes and how to fix them.

Top 10 balance mismatch causes

1. Missing transactions: Statement period doesn't include all days, or transactions are on a separate page not included in the PDF.Fix: Request complete statement or check for additional pages.
2. Duplicate imports: Same statement converted twice and transactions counted twice.Fix: Remove duplicates using Excel's remove duplicates feature.
3. Pending vs posted: Pending transactions included in one balance but not the other.Fix: Exclude pending transactions from reconciliation or wait for them to post.
4. Sign errors: Credits and debits reversed (positive shown as negative or vice versa).Fix: Review transaction types and correct sign convention.
5. Fee transactions: Fees deducted separately not included in transaction list.Fix: Check statement summary for fees and add as separate line items.
6. Interest calculations: Interest posted on different dates than expected.Fix: Verify interest posting dates against account terms.
7. Multi-currency rounding: FX conversions create rounding differences.Fix: Allow small rounding tolerances (typically $0.01-$0.10) for FX accounts.
8. Statement cut-off timing: Transactions on statement end date may post the next day.Fix: Verify cut-off time (often 11:59 PM) and adjust date filters accordingly.
9. Internal transfers: Transfers between accounts counted in both accounts.Fix: Identify and exclude internal transfers from reconciliation.
10. OCR errors: Scanned PDFs with misread amounts.Fix: Spot-check large transactions manually and correct misread values.

Systematic troubleshooting process

1. Calculate the difference: Expected balance - Actual balance = Variance
2. Search for transactions matching the variance amount (might be a single missing or duplicate transaction).
3. Check transaction counts: Statement says 150 transactions but Excel shows 148 = 2 missing.
4. Validate date ranges: Ensure statement period matches your reconciliation period exactly.
5. Review statement summary: Fees, interest, and adjustments listed separately may not be in transaction detail.