A bank statement holds your account number, your balance and every payment you have made, so how you convert it matters as much as whether the numbers come out right. Below are the four common methods, what goes wrong with each, and how to check the result.
Before you start: get the right PDF
- Use the e-statement from net banking or your statement email, not a scan or a phone photo of a printed page. E-statements contain real text that software can read. Scans are pictures of text and need OCR first. See how to tell whether your PDF is scanned.
- Have the password ready if the PDF is protected. Banks usually explain the password format in the email the statement came with.
- Note the opening and closing balances printed on the statement. You will use them to check the converted sheet.
Method 1: Copy and paste
Select the transaction table in your PDF viewer, copy it and paste it into Excel. This works for a few rows, but statements rarely paste cleanly: a whole row often lands in a single cell, descriptions that wrap onto two lines become extra rows, and page headers and footers repeat in the middle of the data. Expect to fix it by hand, and use Data → Text to Columns to split merged cells.
Privacy: everything stays on your computer. Effort: high for anything longer than a page.
Method 2: Excel's built-in PDF import
Microsoft 365 Excel on Windows can read tables from a PDF: Data → Get Data → From File → From PDF. Excel lists the tables it finds, usually one or more for each page, and you load or combine them in Power Query.
It runs on your own computer, which is good for privacy. The downsides are that each page often comes in as a separate table with slightly different columns, wrapped descriptions can split across rows, and some password-protected PDFs have to be unlocked first. The feature isn't in every edition of Excel.
Privacy: local. Effort: medium, with a learning curve if you haven't used Power Query.
Method 3: Online PDF-to-Excel converters
General-purpose converter websites are quick, but most of them upload your file to their servers to process it. For a bank statement, that means a third party receives your name, account number and full transaction history. Before using one, read its privacy policy: how long it keeps files, whether people can view them, and where its servers are. If you are converting a client's statement, you may also have professional or contractual duties about sharing it.
Privacy: depends entirely on the service. Effort: low, but you still have to check the output.
Method 4: A converter that runs in your browser
Some tools, including StatementSieve, run the conversion inside your browser with JavaScript. The PDF is read from your disk into the page and turned into a spreadsheet there. It is never sent to a server.
You can check this claim for any tool rather than taking it on trust. Open your browser's developer tools (F12), go to the Network tab, then convert a statement. You will see the page load its own scripts and font files, but no request should carry your PDF or its contents.
StatementSieve also checks every row against the running balance and flags rows that don't add up, so a misread number can't slip into the export unnoticed. Support for SBI, HDFC Bank and ICICI Bank layouts is still experimental: it has been tested on sample statements and is being checked against real ones. Other banks may work but are unverified, and scanned statements aren't supported.
Privacy: local. Effort: low.
Whichever method you use, check the numbers
Every method can silently drop a row, merge two rows or misread a figure, especially across page breaks. Two checks catch nearly all of these:
- Running balance: for each row, the previous balance plus the credit minus the debit should equal the balance printed on that row.
- Totals: the opening balance plus all credits minus all debits should equal the closing balance.
This guide gives the Excel formulas for both checks, including for statements that list the newest transaction first.
Common clean-up problems
-
Amounts stored as text. A number that is left-aligned, or a sum that comes out as 0, usually
means the cell holds text. Select the column and use Data → Text to Columns → Finish, or wrap
the value in
VALUE(). -
"Dr" and "Cr" after the balance. Some statements print balances like
1,250.00 Cr. These have to become plain numbers, with debit balances negative, before any formula works. - Dates in the wrong format. Statements printed as day-month-year can be read as month-day-year if your Excel uses US settings. Check a date with a day above 12 to be sure.
- Repeated headers and "page total" rows. Remove them before totalling, or they get counted twice.