1. Ask your bank for a spreadsheet first
Many online-banking sites and apps can export transactions as CSV or Excel as well as PDF. When yours can, that file is the cleanest start: it comes from the bank’s own records, so there is nothing to misread. Look next to the statement download for an export or download option, and choose the same date range as the statement. The PDF stays the official record; the export is the one to calculate with.
2. Use Excel’s own PDF import
Excel can import tables from a PDF through Power Query’s PDF connector: in Excel’s Get Data menu, choose to get data from a PDF file, pick the statement, select the table or tables it finds, and load them or transform them first. By default it joins similar tables on consecutive pages into one, which is what a statement that runs across pages needs.
Where it struggles is the statement’s layout rather than its numbers. Microsoft’s own documentation says multi-line rows might not be identified properly and suggests cleaning them up afterwards — and on a bank statement a long description that wraps onto a second line is exactly that. Expect to merge wrapped descriptions, delete repeated page headers, and move amounts that landed in the wrong column. (Source: Microsoft Learn, Power Query PDF connector.)
3. Use a converter that reads the statement
A converter built for statements reads the document the way a person does — date, description, money out, money in, balance — rather than looking for table borders. The MyFulus converter above does that for any bank’s PDF or CSV, opens password-locked PDFs with their password, keeps Arabic descriptions as printed, keeps a third decimal place for Kuwaiti, Bahraini and Omani amounts, and writes the file in the layout QuickBooks, Xero or Zoho Books imports. Its last step is the check below, done for you.
Whatever you used: check it against the statement
A conversion with one line missing looks exactly like a complete one. The statement carries its own proof, and three checks catch almost everything:
- Opening to closing. Opening balance, plus every credit, minus every debit, must equal the closing balance to the last fils or cent.
- The running balance. If the statement prints a balance beside each line, each line must move it by exactly its own amount. The first line where it does not is where a transaction is missing, duplicated or misread.
- Printed totals. If the statement prints total debits and total credits, your two columns must add up to them exactly.
Then look for the usual slips: dates with day and month swapped (any date after the 12th exposes it), page headers or “balance brought forward” lines counted as transactions, and an amount that landed in the debit column when the statement printed it as a credit.
Quick answers
Can I convert a password-protected bank statement PDF to Excel?
Yes, once it is open. The password is in the email your bank sent the statement with, often your date of birth or part of your card number. The MyFulus converter asks for it, uses it once to open the file in memory and never stores it.
Why do the dates come out wrong after converting?
Gulf banks usually print dates as DD/MM/YYYY and US banks as MM/DD/YYYY. A tool that guesses the wrong order swaps day and month on every date up to the 12th, which looks plausible and is wrong. Check a date after the 12th of a month: if it failed to convert or became a different date, the order was guessed wrong.
How do I know no transaction was missed?
Take the opening balance, add every credit and subtract every debit. You must land exactly on the closing balance printed on the statement. If the statement prints a running balance beside each line, each line must move it by exactly its own amount, and the first line where it does not is where a transaction is missing or misread.
Is it safe to upload a bank statement to an online converter?
Read what the site keeps before you upload. MyFulus reads the file in memory, never writes it to disk or a database, deletes the converted lines within the hour, and never asks for a bank login. If a converter does not say what it keeps, assume it keeps everything.