How to Verify a Converted Bank Statement Before Reconciliation
By Asad · Published
A spreadsheet that looks tidy can still contain a missed payment or a duplicated deposit. PDF extraction recovers text and positions; it does not certify the account record. Review the converted transactions against the original statement before reconciling them with your ledger. The procedure below checks extraction, rather than providing accounting advice.
Start with the original statement period
Keep the bank’s PDF alongside your workbook. Record the account identifier, currency, statement period and opening and closing balances. Do not combine statements in different currencies into one total. For a long statement, note how many transaction pages it contains and check that rows from the final page are present. The source PDF remains the authoritative record for this comparison.
Compare transaction count and row boundaries
Review every page, not just the first few rows. Repeated table headings, brought-forward balances and totals can be mistaken for transactions. Conversely, a wrapped description can attach to the next payment. Compare dates and descriptions with the PDF, and remove only rows you have positively identified as non-transactions. Save your reviewed copy under a new filename.
Verify signs with a worked example
For a simple account using debit as money out and credit as money in, an opening balance of 1,000 plus credits of 250 minus debits of 100 gives a closing balance of 1,150. This is an illustrative check, not a universal bank convention: credit-card liabilities, overdrafts and other statement layouts may use different signs. Follow the labels and balance movement on your own statement.
Investigate discrepancies rather than forcing totals
If the balances do not agree, inspect decimal separators, missing fees, duplicated lines, reversed signs and page-break rows. Search the original PDF for the amount of the discrepancy, but do not insert a balancing transaction simply to make the result agree. Correct the extraction only when the source supports the change. A real bank-record error belongs with the bank, not in a modified conversion.
Keep the import separate from reconciliation
First verify extraction, then compare the reviewed bank data with your accounting records. Matching a closing balance alone cannot detect offsetting errors. Import a backup or test copy, check the destination’s duplicate handling, and retain the source statement and reviewed workbook. If you discover an unfamiliar charge in the original statement, follow your bank’s reporting process promptly.
Sources and further reading
These primary references explain the format or workflow discussed in this guide. External applications can differ from EasyPDFEdit.
Continue with the tool and related guides
Use bank statement to excel for the next step, or browse all PDF tools. Keep the original file and verify the downloaded result.