---
{"type":"list","title":"A Reconciliation Checklist for Converted Bank Statements","listId":151986,"canonicalUrl":"https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements","visibleItemTotal":7,"creator":{"id":"liveswapface","name":"liveswapface","url":"https://listium.com/@liveswapface"},"stats":{"views":9,"likes":0,"followers":0},"category":"finance","publishedAt":"2026-11-09T08:53:33.226Z","updatedAt":"2026-11-09T08:54:40.282Z","fields":[{"id":0,"name":"Name","type":"PrimaryText"},{"id":1,"name":"What to verify","type":"Text","format":"long"},{"id":2,"name":"Link","type":"URL"}]}
---

# A Reconciliation Checklist for Converted Bank Statements

By [@liveswapface](https://listium.com/@liveswapface)

9 views · 0 likes · 0 followers  
Published 9 November 2026 · Updated 9 November 2026

Category: finance

A machine-readable statement makes sorting faster, but it does not prove the converted data is correct. Keep the original file, work from a copy, and reconcile the output before importing it into a ledger. This checklist separates extraction errors from genuine transactions.

  

If your source is a PDF or image, \[bank file tool\](https://bankfiletool.com/) can be used to turn the statement into a table for review. I am connected with the tool. The checks below still matter no matter which converter you use: column labels, amount signs, duplicates, missing rows, and opening-to-closing balance.

  

Do not upload statements you are not authorized to process. Redact sensitive details before sharing a sample for troubleshooting, and retain the original statement as the reference of record.

## Items

### 1. [Preserve the original file and statement period](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/0/preserve-the-original-file-and-statement-period)

Item ID: `0`

- What to verify: Keep an untouched copy. Record the institution, date range, currency, and opening and closing balances before conversion so every later check has a fixed reference.
- Link: -

### 2. [Inspect the imported column map](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/1/inspect-the-imported-column-map)

Item ID: `1`

- What to verify: Inspect the first rows of the output. Confirm that transaction date, description, debit, credit, and balance landed in the intended columns; watch for wrapped lines or merged cells.
- Link: -

### 3. [Normalize debits, credits, dates, and currency](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/2/normalize-debits-credits-dates-and-currency)

Item ID: `2`

- What to verify: Choose one convention for withdrawals and deposits. Check the decimal separator, negative sign, currency symbol, and date format before importing into accounting software.
- Link: -

### 4. [Compare transaction count and date range](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/3/compare-transaction-count-and-date-range)

Item ID: `3`

- What to verify: Compare the first and last dates and the number of transactions with the source statement. A missing page or duplicated header can otherwise look like valid data.
- Link: [https://bankfiletool.com/](https://bankfiletool.com/)

### 5. [Flag duplicates, reversals, and missing lines](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/4/flag-duplicates-reversals-and-missing-lines)

Item ID: `4`

- What to verify: Search for identical dates, amounts, and descriptions, then check apparent duplicates against the source. Reversals and pending transactions should be reviewed rather than silently removed.
- Link: -

### 6. [Reconcile opening and closing balances](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/5/reconcile-opening-and-closing-balances)

Item ID: `5`

- What to verify: Opening balance plus deposits minus withdrawals should equal closing balance, allowing for the institution’s sign convention. If the result differs, trace the first mismatch by date.
- Link: -

### 7. [Spot-check exported rows against the source](https://listium.com/@liveswapface/151986/a-reconciliation-checklist-for-converted-bank-statements/6/spot-check-exported-rows-against-the-source)

Item ID: `6`

- What to verify: Sample rows from the beginning, middle, and end of the converted file. Compare each amount and description to the original PDF or image; correct extraction errors before any final import.
- Link: -