Bank Statement PDF to Excel for a Monthly Budget

What the bank statement looks like after conversion

In the sample statement, the converter found two tables: a four-column summary with the opening balance, total credits, total debits and closing balance, and the transaction list with Date, Description, Reference, Debit, Credit and Balance. Each transaction landed on its own row with the amount in the correct column, and empty cells stayed empty, so a payroll deposit shows a blank Debit and 2,107.50 under Credit.

Amounts such as 1,450.00 and 86.42 became real numbers, shown in blue in the preview. The summary figure ($3,602.47) was recognized as an accounting-style negative and stored as -3602.47, so it subtracts correctly in a formula. Reference numbers like 000184 kept their leading zeros as text, which is what you want for an ID.

Dates such as 08/01 stay as text. That is deliberate: a converter cannot know whether 08/01 means August 1 or January 8, and guessing wrong would scramble a whole month. Convert them in Excel once you know the format, as shown below.

Settings that suit a bank statement

• Untick Include text outside tables before dropping the file. The bank's name, address block and legal footnotes then stay out of the sheet, leaving just the tables.
• Keep One sheet per page for a single statement. For a statement that runs across three or four pages, switch to All pages on one sheet so every transaction sits in one list you can filter.
• Check the counts line. The sample reads 1 page, 2 tables detected, 42 numbers. If a multi-page statement shows fewer tables than pages, look at the page that is missing; it may be a scanned insert or a page of disclosures.

Very long account numbers are protected too. Any digit string longer than 15 characters stays as text, because Excel cannot store more than 15 significant digits and would silently round a card or account number.

Turn the rows into a monthly budget

Once the transactions are in Excel, a few simple steps turn them into a spending picture:

• Add a Category column next to Description and label each line: rent, groceries, transport, utilities, fun. With 19 lines this takes a couple of minutes; sort by Description first so repeated merchants sit together.
• Build a small summary with SUMIF, for example =SUMIF(G:G,'Groceries',D:D) style formulas, or insert a pivot table on the Category and Debit columns.
• Convert the dates if you need them: select the Date column and use Text to Columns with the MDY format, then add the statement year.
• Check the math: the sum of the Credit column should match the credits total in the summary row, and the last Balance should match the closing balance, 3,030.89 in the sample.

In the sample, rent of 1,450.00 and a credit card payment of 1,100.00 account for more than two thirds of the month's debits, which is the kind of pattern that is hard to see on paper.

When to download CSV instead

Many budgeting apps and spreadsheets for household finances import transactions from a CSV file. The CSV button writes each value as plain text: 1,450.00 becomes 1450 and ($3,602.47) becomes -3602.47, with no currency symbols. The file is UTF-8 with a byte-order mark and uses a leading apostrophe to neutralize any text cell that starts with an equals sign, which protects you if a merchant name was crafted to look like a formula.

Before importing, delete the summary rows so only the header and the transactions remain, and check which column order your app expects. Most want a date, a description and either a single signed amount or separate debit and credit columns.

If a statement page is a scan, the converter reports that the page has no selectable text. For those pages, use PDF to JPG and then Image to Text (OCR), and check every amount against the paper copy.

Step-by-step

Common mistakes to avoid

Pro tips

Frequently asked questions