Reconciliation guide

How do I check a converted bank statement against its balances?

Compare the opening balance plus deposits minus withdrawals with the closing balance, then spot-check each running balance and every row against the source statement.

Start with the statement’s opening balance

Use the opening balance printed on the statement period, not the balance after its first transaction. Add all deposits, subtract all withdrawals, and compare the result with the stated closing balance.

Worked result: 1,000.00 + 300.00 − 125.50 − 62.00 = 1,112.50. The arithmetic discrepancy is 0.00.

Worked example with invented figures

This table mirrors the built-in synthetic statement. Amounts and descriptions are invented and do not describe a real account. Dates use DD/MM/YYYY; for example, 03/04/2026 means 3 April 2026.

Invented three-row statement with a 1,000.00 opening balance
DateDescriptionWithdrawalDepositRunning balance
03/04/2026Studio supplies125.50—874.50
05/04/2026Project credit—300.001,174.50
07/04/2026Service charge62.00—1,112.50

Withdrawals: 187.50. Deposits: 300.00. Net change: +112.50. Closing balance: 1,112.50.

Check each running balance too

For each transaction, compare the previous balance plus a deposit or minus a withdrawal with the next printed balance. In the invented example, 1,000.00 − 125.50 = 874.50; 874.50 + 300.00 = 1,174.50; and 1,174.50 − 62.00 = 1,112.50.

  1. Confirm the statement period and choose the correct date convention if the dates are ambiguous.
  2. Compare the first and last transaction, plus any flagged or unusually large row, with the source.
  3. Check that debits are withdrawals and credits are deposits.
  4. Compare transaction totals and running balances with the statement.
  5. Resolve review warnings before using the spreadsheet or accounting export.

For several statements, follow the combined-workbook review guide and check each file’s balances separately, along with accounts, currencies, and overlapping periods.

Troubleshooting a nonzero discrepancy

A nonzero discrepancy is a reason to investigate, not a diagnosis of one particular cause. Work through these checks in order and verify changes against the statement.

  1. Confirm that the selected rows, account, currency, and opening and closing balances all cover the same statement period. Exclude another account or an overlapping statement before comparing totals.
  2. Read the opening and closing values directly from the source, including their signs and decimal places. An opening balance is not the balance after the first transaction; do not count balance summaries as transactions.
  3. Verify debit/credit direction and numeric types with individual source rows and running balances. Check minus signs, parentheses, decimal separators, and whether amounts are already signed. Count either signed amounts or split withdrawals and deposits once.
  4. Compare the source and worksheet row by row for omitted or duplicate rows, including page breaks, wrapped descriptions, and repeated headers. A row count alone cannot identify every omission or duplication.
  5. Check fees, interest, refunds, and other adjustments against the source. Include each actual transaction once, with its confirmed direction; do not insert an invented adjustment just to force a match.
  6. Check dates against the source convention and period boundaries, including the first and last rows. For yearless dates, retain text until the statement period or source confirms the year, and review December/January transitions individually. Preserve source order when checking running balances.
  7. Inspect underlying numeric precision and rounding, not only displayed amounts. Compare the source’s decimal places and transaction totals; do not dismiss a small difference or overwrite it without finding an explanation.
  8. Recalculate after each confirmed correction and use running balances to narrow the remaining difference. More than one issue may contribute. If the discrepancy persists, keep the source and unresolved rows available for review before using the export. Even a match is not proof of completeness; mistakes can offset one another.

What a matched balance does—and does not—prove

A zero discrepancy shows that the amounts currently represented in the extracted rows agree with the selected opening and closing balances. It cannot prove that no transaction was omitted, duplicated, dated incorrectly, or assigned the wrong description. Check the source statement as well as the arithmetic.

ExtractMint’s balance check is a review aid. No bank-specific format has been independently validated against real statements, and unfamiliar layouts may need manual correction.