How to convert a bank statement PDF to Excel
Start with the original PDF downloaded from your bank. Open it and try selecting a transaction description. If you can copy a few recognizable words, it is a good candidate for text extraction. A photo or scan may need optical character recognition (OCR) first.
In this guide
- Start with one statement period
- Check how the tool reads each row
- Use a balance check before exporting
- Keep a traceable workbook
- Choose the workbook or CSV route
- Decide what one transaction looks like
- Turn a difficult line into a reliable row
- Check a mismatch without losing your edits
- Handle a file that the converter cannot read
Start with one statement period
Choose a single month and note the period, currency and account identifier printed on the first page. Keep the PDF open alongside the converter. A single month is small enough to check line by line and makes it easier to spot an unfamiliar layout.
Check how the tool reads each row
Choose the PDF in the bank statement tool and inspect the extracted rows. Compare a deposit, a withdrawal and an entry with a long description against the original. A description wrapped across two lines can appear as two rows. A statement can also repeat its headings at the start of each page.
If your statement has both a transaction date and a posting date, decide which belongs in your workbook. Check a date beyond the twelfth of the month to confirm the day and month order. Keep reference numbers that start with a zero as text.
Use a balance check before exporting
For a deposit account with credits and debits in separate columns, add total credits to the opening balance and subtract total debits. For example, an opening balance of 1,200.00 plus deposits of 450.00 minus payments of 186.75 gives 1,463.25. Compare that result with the statement’s closing balance. A match is a useful check, though two omitted entries can cancel each other out.
Keep a traceable workbook
Export the reviewed rows and name the file by account nickname and statement month. Keep a copy of that first export before adding formulas, categories or pivot tables. If a later total looks wrong, you can trace it back to the original PDF.
Choose the workbook or CSV route
Use the bank statement to Excel converter when the next person will open the result as a worksheet, compare rows, or add calculations. The download is an XLSX workbook with one extracted table. It does not reproduce the bank's letterhead, alternating row colors, charts, or page layout. Those elements help a human read a PDF, but they rarely belong in a transaction register. Keep the original document beside the workbook whenever the printed arrangement carries meaning, such as an amount appearing under a particular account heading.
Choose the PDF to CSV tool if another application asks for a delimited text file instead. Check its import instructions before converting. One application might expect a single signed amount and another might require separate debit and credit columns. Neither file extension tells you which convention the recipient uses. Write down the fields the destination wants, and compare them against a small statement export before committing time to a year's worth of documents.
Try the controls with fictional data
Opening a sample is a practical way to see the difference between extracting and editing. Select Try a sample and find the office supplies transaction. Change its description to a more specific label, leave the amount intact, and export. Open the download and find your new wording. The sample begins with prepared rows, so it teaches the controls without predicting how accurately your own bank's layout will convert. Choosing a different PDF starts another extraction. Download rows you intend to keep before switching files or closing the tab.
Decide what one transaction looks like
Consider a fictional two-page deposit statement. Page one begins with the account title, the statement period and an opening balance of 1,200.00. Below the header, three amounts appear: a deposit of 450.00, a debit of 36.75 and a debit of 150.00. Page two starts with the same column names and finishes with a closing balance of 1,463.25. A person sees three transactions immediately. A text extractor also sees the title, dates, opening line, repeat headings and closing line. Treat the on-screen row count as a count of extracted lines until you have identified the entries.
In this example, keep the opening and closing figures somewhere you can reference them. In the transaction area, keep one row for each deposit or payment. If the opening balance is included as a deposit as well as a starting figure, the workbook will appear to have an extra 1,200.00 of activity. If the closing balance becomes a transaction, it can inflate the activity without looking unusual to someone who only glances at the amounts. Use a separate worksheet area for control figures when you add calculations after export.
Locate the columns from the page itself
Read the printed column headings from left to right and follow one entry all the way across the page. A deposit statement might print Date, Description, Payments out, Payments in and Balance. A blank under Payments out may be entirely legitimate for a deposit. In the converter, look at the blank and the two populated cells on either side. If the deposit amount appears in the Balance column, inspect other lines with the same blank pattern before correcting the first row. Several transactions might share the same alignment error.
Check what happens at a change of section. A page titled Account summary may have different columns from the detailed transactions. An interest summary can contain amounts that already appear on dated transaction lines. Remove unwanted lines only after locating their counterparts in the PDF. Leave the original statement intact to answer questions about the source of a figure. If a statement contains several accounts or currencies, preserve their boundaries in your working copy and check each group independently.
Turn a difficult line into a reliable row
Suppose the PDF prints “Harbor Office” on the first line and “Supplies order 00481” directly underneath, with a date and amount only on the first line. In the editor, compare the continuation with the nearest dated entry above and below. When the spacing makes the relationship clear, edit the first description to read “Harbor Office Supplies order 00481.” Then remove the leftover continuation row. If the lower line has its own date or amount, pause and inspect the source. Similar merchants can generate consecutive genuine transactions.
Separate displayed amounts from usable numbers
An amount printed as 1,240.50, a value in parentheses, and an amount with a currency symbol can arrive as text in the exported workbook. This converter writes simple decimal amounts such as 1240.50 as numeric cells and preserves many other representations as text. A visible currency symbol alone does not settle how a spreadsheet stored the cell. If a sum misses a line, try a small test in the downloaded workbook using =ISNUMBER(C2), adjusting the address to the actual amount cell. A false result is a prompt to inspect the value before changing it.
Record the statement's convention before normalizing anything. On a deposit account, a payment already listed as a positive value under Withdrawals should generally be subtracted once when calculating the movement. Applying a minus sign during cleanup and then subtracting the column again reverses its effect. In the example above, start with the two printed withdrawal amounts, total them to 186.75 and subtract that total once. Credit card statements can express balances differently, so follow the arithmetic printed on that particular statement.
Keep descriptive references intact
A reference such as 000481 and a payment of 481.00 look related to a spreadsheet, but their jobs are different. The reference identifies a record and the amount belongs in arithmetic. Preserve the zeros and compare the exported reference with the PDF before linking it to another list. For long digit strings, inspect the complete contents of the cell as well as its displayed width. Avoid applying one numeric conversion to every column. Microsoft's guide to leading zeros and long numbers explains why importing identifiers as text matters.
Check a mismatch without losing your edits
If the worksheet closes at a different amount, calculate the size and direction of the difference first. A difference of 36.75 in the worked example suggests investigating the smaller withdrawal. A difference of 73.50 could be a 36.75 item moving in the opposite direction. These are clues, not diagnoses. Compare entries in statement order and mark the last row that agrees with the printed running balance. An error first visible on page two often becomes easier to find when you check the final line of page one beside the first line of page two.
For a statement with no running balances, check transactions in smaller groups. Count the dated entries on each source page, total the incoming and outgoing amounts separately and compare the export one group at a time. Equal totals can conceal two missing payments with opposite signs. Equal counts can conceal an amount attached to the wrong merchant. A combination of counts, amounts and sampled descriptions gives the reviewer three different ways to detect a problem. The statement balance troubleshooting guide walks through a separate discrepancy example.
Handle a file that the converter cannot read
The file picker accepts digital PDFs up to 25 MB. The editor also checks extracted table size, with a maximum of 1,800 rows and 50 columns. A statement can hit the row limit even if its file size looks small because address lines, page headings and other text count during extraction. For a very large document, use smaller authorized statement PDFs or divide a copy into consecutive page ranges with a suitable PDF utility. Label the ranges and check their boundary transactions before joining the resulting worksheets.
If the tool requests an unlocked PDF, obtain an authorized readable copy through the usual statement download process. A scanned page needs a selectable text layer before this extractor can read it. Adobe documents how to recognize text in scanned PDFs. After OCR, inspect a few dates, decimal points and account references in the searchable copy. Recognition can make a scan readable while still confusing a zero and the letter O. Using a different export format does not repair a digit already misread in the source.