Bank Statement PDF to Excel Converter

First, check whether your online banking offers the same months as a CSV or spreadsheet download, which is already a table. If not, or its history is too short, save each statement PDF from online banking instead of scanning paper copies. A PDF your bank generated normally holds real text, which converts far more cleanly than a picture of a page.

Gather every statement for the period, in date order, and don't assume 12 a year. In the US, Regulation E requires a statement for a personal account for each monthly cycle with an electronic transfer, and at least quarterly otherwise¹. So a quiet savings account can skip months with nothing missing.

Excel can read a PDF itself: choose Data > Get Data > From File > From PDF, then pick the tables it finds. Microsoft's version chart lists this import for Microsoft 365 plans on Windows, but not for Excel for Mac².

Expect cleanup, whatever you use. A statement is laid out for printing, so any converter has to work out rows and columns from where the text sits. Microsoft says its import finds tables with an algorithm that, by default, treats border lines as only one hint among many³. It also notes that rows running onto several lines aren't always identified properly.

Use plain columns: date, description, amount and the balance the statement prints. Choose one way to show money out, either negative amounts in a single column or separate money-in and money-out columns. If the rows are headed for bookkeeping software, read its import instructions first and match its columns and date format.

Copy each description exactly as the bank printed it, since it usually names who was paid, and give check numbers their own column. Add a source column as well, such as "March, p. 2." When someone questions a number months from now, it points to one page instead of a stack of PDFs.

Store the PDFs with the sheet, too. Without a canceled check, the IRS says you may be able to prove payment with a highly legible account statement⁴. It must show the amount, the payee's name and the posting date, plus the check number for a check. If yours lists checks by number alone, keep the check images too.

Many statements print only the month and day on each row, with the year in the header. Microsoft calls two-part dates "inherently ambiguous," and Excel puts one like 12/28 in the current year⁵. Add the year from the statement period yourself, and take care with any statement that runs from December into January.

Keep the date the statement prints. For electronic transfers on a personal account, Regulation E has the statement show the date each one was credited or debited¹, which can differ from the date on a receipt.

• Turn every form of money out, such as 125.00-, (125.00) or DR, into a negative number.
• Join a description that wraps onto a second line to the row above it.
• Delete page headers, balance-forward lines and daily balance summaries; none are transactions.
• Fix amounts stored as text, which won't add up, with Excel's Convert to Number.

Every statement gives you numbers to test against. For a personal account, Regulation E requires the balance at the beginning and at the close of the statement period¹. Run these checks on each statement.

1. 1

   Check the arithmetic

   The opening balance plus every amount, with money out negative, should equal the closing balance. Note any gap in dollars.

2. 2

   Find where it breaks

   Add a running balance (the row above plus this amount) and compare it with each balance the statement prints. The first mismatch shows where a line is missing, doubled or misread.

3. 3

   Compare the totals

   If the summary lists total deposits and withdrawals, or a count of each, match yours to them.

4. 4

   Chain the statements

   Each statement should open at the last one's closing balance. If not, a statement is missing or two overlap.

5. 5

   Check possible duplicates

   Two rows with the same date and amount can both be real, like two identical coffees. Check the PDF before deleting either.

Matching the statement proves the conversion, not your books. As the IRS notes, a statement balance may not agree with your books⁴. It can include bank charges you haven't entered, and leave out deposits made after its date or checks that hadn't cleared. Finding those is the job of a bank reconciliation.

Shorten account numbers to their last four digits before you share the sheet. Then match each line to its receipt with the expense and receipt template, or use the rows as the actuals in a 13-week cash flow forecast.

If you'd rather skip the cleanup, drop the PDFs into the converter at the top of this page. River reads every page, scans included, fills in the years, checks each statement against its printed balances and lists any line it couldn't read.