Bank statement preparation checklist: PDF to a reconciled spreadsheet

Prepare downloaded bank records once: extract PDF rows, check dates and signs, review overlapping periods and reconcile balances before combining files.

Last checked: November 9, 2026

Keep the source account and period visible

Use a bank’s native CSV or Excel download when it covers the required period. Otherwise collect complete statement documents and retain their originals. Keep one account and currency per working table and label the source month and page. A transaction viewing window, an export date limit and a statement archive can differ; consult the bank’s own instructions before treating a missing month as unavailable.

Extract rows from a PDF

Where your Excel installation includes the PDF connector, choose Data > Get Data > From File > From PDF, inspect the detected tables and transform them before loading. Check description wraps and page boundaries. Tabula offers region selection, a preview and export for text-based PDFs; it cannot process scanned documents. For a scan, use a suitable OCR workflow and compare every recovered value with the image. Manual entry may be practical for a small gap.

Verify dates, decimals and transaction signs

Confirm the date order against an unambiguous source date. Check decimal separators and review at least one withdrawal, deposit, fee, refund and card payment that occurs in your source. Remove repeated headings, carried-forward labels and summary totals from the transaction set. Keep genuine repeated payments unless the source confirms a duplication. A card statement can use a different purchase and payment convention from a deposit-account ledger.

Review overlapping coverage before appending

Compare the end of one source period with the start of the next. A recent activity export and a monthly statement may include the same transactions even when their filenames differ. Keep a record of the source files and dates already included. Resolve overlaps against the original rows before appending them; do not delete two similar entries solely because their date and amount match.

Reconcile each complete statement

Calculate opening balance plus signed activity and compare it with the printed closing balance for the same account and period. Check page transitions, row counts and individual transactions even when the arithmetic agrees: two offsetting errors can balance. Resolve differences at the source rather than adding an unexplained balancing row. Reconcile each month before joining it to a longer history, and keep missing pages or incomplete periods visible.

Where BankXL fits

BankXL accepts supported PDF layouts and exports CSV or XLSX with a Balance check sheet; no bank layout is guaranteed. Limits are 15 MiB, 100 pages and 3,000 transactions. Encrypted PDFs and decimal-comma amounts are unsupported. Its no-account, no-card trial covers the first two pages with data from one PDF, searching at most six pages, subject to network and capacity limits. A partial trial cannot reconcile a longer statement. See pricing and FAQ.

Pricing · FAQ

Check two pages with data free See page packs FAQ

Written by Zijian Xiao; verify the bank-by-bank sources and your original records before using an export.