BankXL / Practical guide

How to convert a bank statement to Excel: manual steps and checks

Learn how to convert a bank statement into Excel with manual PDF to Excel steps in Excel, Word or Acrobat, then check signs, dates and balances.

1. Prepare the statement and a checking sheet

Keep the original PDF unchanged. Open it beside your working spreadsheet, identify the transaction section and note the statement period, opening balance and closing balance. Try selecting a transaction description: readable copied text suggests a text layer, while an image-only page needs recognition before ordinary text extraction. Request a clearer original if the characters are unreadable. Keep different accounts and currencies separate. The following methods show how to convert a bank statement to Excel manually with applications you already have; choose a route your installation supports.

2. Import through Excel's PDF connector

Where your Excel installation offers the connector, choose Data > Get Data > From File > From PDF. Open the statement and inspect the tables in Navigator. Select the transaction table and choose Transform Data to inspect it before loading, or Load if it is already usable. Microsoft documents both routes; availability can vary by host. In your working data, check that an amount belongs to the description beside it. Wrapped descriptions can occupy adjacent rows, and page boundaries can interrupt a table. Rejoin a continuation only after checking the PDF; never treat every line without a date as disposable.

3. Open in Word, then paste the table

In Word, choose File > Open, select the PDF and accept conversion to a Word copy. Microsoft says conversion works better for mostly textual documents; tables may change, and an image-heavy page may remain an uneditable image. If a usable table appears, select its transaction rows and columns, copy them, select the upper-left cell of an empty area in Excel and paste. Extra paragraph breaks in Word cells can create additional spreadsheet rows. Inspect the pasted result for numbers stored as text, altered dates and descriptions separated from their amounts. Keep the PDF as the authority when rebuilding any row.

4. Export with Acrobat

Open the PDF in Acrobat and select Convert, then Microsoft Excel and XLSX. Select Convert to XLSX and save the workbook. Adobe's export settings let you choose worksheet organization, decimal and thousands separators, and text recognition language when needed. Inspect those settings against the statement before exporting. Review the saved sheets for columns shifted across page boundaries and headings repeated among transactions. Recognition can produce plausible text that still needs checking; exporting a workbook does not establish that each transaction was recovered or its debit or credit direction preserved.

5. Repair signs, columns and descriptions

For each method, compare the extracted table with every source page. Restore any missing minus sign and interpret debit and credit labels before assigning signed amounts. For a cash account, use deposits as positive and withdrawals as negative. For a card statement, make charges, payments and both balances follow one consistent convention. Check whether an amount has slipped into the balance column. Combine wrapped descriptions with their own transaction, keeping references intact. Remove repeated page headers and carried-forward summary lines from the transaction list only after identifying them in the original; retain real activity even when its wording repeats.

6. Resolve dates and reconcile the complete period

Keep the printed date alongside any normalized date until you have established the statement's date order and year. A day and month can swap without producing an obvious error. Check the equation: opening balance + signed transaction amounts = closing balance. Use the full transaction period and the same currency and sign convention throughout. If it differs, inspect signs, omitted rows, duplicated activity and amounts misread as balances. Where printed running balances exist, compare each transition to narrow the search. A matching total can conceal offsetting mistakes and cannot validate descriptions or dates. Save the checked workbook together with the original statement.

When a tool is worth trying

I built BankXL to make statement extraction reviewable. If repeated layout repairs take too much work, its editable preview and balance checks may help with supported PDFs before XLSX or CSV export. Compare every result with the source; no layout is guaranteed. 10 free pages with data per browser credential, plus a separate 10 per account, across PDFs. Preview, corrections, balance checks and XLSX/CSV downloads are included. Only successful pages use the allowance. Shared network limits: 30 free pages in 30 days across anonymous and account use; anonymous use also shares 10 pages per network in 30 days, so clearing cookies does not renew it. Free uploads: 10 attempts per credential/account and 30 per network per hour. Remaining pages need one-time packs: $9 / 20 pages or $29 / 100 pages. No subscription or automatic renewal. Partial exports state their scope and source pages. No sign-up or card is needed for browser use.

Use your free pages See page packs

Written by Zijian Xiao. Examples are synthetic. Review all extracted results against your original PDF.