From statement to working spreadsheet.

A bank statement is a record, while a spreadsheet is a working surface. Conversion helps move transactions between them, but the source statement remains the reference for every date, description, and amount.

Choose the best source available

Use a PDF downloaded directly from the bank when possible. Photographs, faxed pages, and low-resolution scans give extraction less reliable information. Check that the statement includes all pages and covers the period you intend to process.

Open a password-protected file with the bank’s instructions first. Only remove its password if you are authorized to do so.

Convert one statement first

Use Bank Statement to Excel, upload the file, and download the workbook. Begin with one representative statement before building a larger workflow around the result.

The bank’s layout matters more than its name. A current-account statement, credit-card statement, and investment report may each organize their data differently, even when issued by the same bank.

Review every column’s meaning

Confirm which column represents money in and which represents money out. Check how negative signs, parentheses, fees, and refunds are represented. Dates may use day-first or month-first ordering; do not infer the format from a single ambiguous date.

Descriptions that span two lines can accidentally become separate records. Repeated page headers and balance summaries should not be mistaken for transactions.

Reconcile against the original

Compare transaction counts page by page. Where the statement supports the calculation, check that the opening balance plus credits minus debits equals the closing balance. A difference is a reason to investigate, not a reason to edit a total until it matches.

Keep a raw extraction sheet and make cleanup changes in a copy. Do not upload a workbook to accounting software until its fields and totals have been checked against the bank-issued record.