How to Convert a Bank Statement PDF to Excel on Mac (and Check It Adds Up)
Turning a bank statement into a spreadsheet is one of the most common reasons people go looking for a PDF to Excel tool, and one of the riskiest to get wrong, because a single misplaced digit changes your numbers. It is also data you should think twice about uploading anywhere. This guide shows a method that stays on your Mac and ends with a check that proves the result is right.
Quick answer: Look for a CSV or Excel download in your online banking first, since it is the cleanest source. If you only have a PDF with selectable text, copy the transactions into Excel, split them into Date, Description, Debit, Credit and Balance columns, convert text to numbers, and run a balance check: opening balance plus credits minus debits must equal the closing balance. Only then categorise.
Start with the bank, not the PDF
Before converting anything, check what your bank offers. Many online banking sites let you download transactions as CSV or similar formats for a date range, and a download straight from the bank avoids every problem below. The layout and the options differ from bank to bank, so look under the statements or transactions section, and ask support if you cannot find an export. Use the PDF route when the bank only provides PDFs, when you are working from an old paper statement, or when someone else sent you the file.
Step 1: Check the PDF has selectable text
Open the statement in Preview and search for a merchant name with ⌘F. If it is found, the PDF has a text layer. If not, the statement is a scan, and our guide to converting a scanned PDF to Excel explains the OCR route and the extra checking it demands.
Step 2: Copy the transactions
Follow the method in our guide to copying a table from a PDF into Excel on Mac. In Preview, hold ⌥ and drag a rectangle over the transaction list, copy it, and paste it into a blank sheet. Do one page at a time and paste each below the last. Leave out the page headers, the summary boxes and the marketing text.
Step 3: Split and clean
Statement layouts vary, but most arrive as one text string per row. Use Data > Text to Columns to separate the date, description and amounts, then clean the result as described in our guide to cleaning PDF data pasted into Excel. Specific points for statements:
Debit and credit may be one column with a suffix such as Dr and Cr, or with negative numbers. Split them into two columns so debits and credits are never confused.
Descriptions wrap onto two lines, leaving a row with no date. Fill the date down, then join the description lines and delete the extras.
Opening and closing balances often sit above and below the table. Copy them into their own cells.
Dates may be day-first. Check a date after the 12th of a month to confirm the order.
| Date | Description | Debit | Credit | Balance | Check |
|---|---|---|---|---|---|
| 2026-03-01 | Opening balance | 1,500.00 | |||
| 2026-03-02 | Card payment, Grocer | 42.10 | 1,457.90 | Previous balance - debit + credit - balance = 0 | |
| 2026-03-03 | Salary | 2,000.00 | 3,457.90 | Same check on every row | |
| 2026-03-05 | Direct debit, Utility | 88.00 | 3,369.90 | Same check on every row |
Step 4: Prove it adds up
This is the step that separates a trustworthy workbook from a hopeful one. Add a Check column that tests every row. If the balance is in column E, debits in C and credits in D, put this in F3 and fill it down:
=ROUND(E2 - C3 + D3 - E3, 2)
Every value should be 0. A non-zero cell shows exactly which row is wrong: a missed transaction, a misread digit, or a debit entered as a credit. Then do the overall check: opening balance plus the sum of credits minus the sum of debits must equal the closing balance printed on the statement. If you only have a statement without running balances, rely on that overall check alone and compare the count of transactions with the page.
Step 5: Lock the values and name things
Once the checks pass, copy the cleaned columns and paste them as values with our paste values shortcut, then delete the raw paste. Format the range as a table and give the columns clear headers. Keep the original PDF alongside the workbook. If the figures are ever questioned, you want to show where each row came from.
Step 6: Categorise the transactions
Build a small lookup table of keywords and categories, then use a formula to match each description. With Microsoft 365, in a Category column:
=IFERROR(INDEX(Cats[Category], MATCH(TRUE, ISNUMBER(SEARCH(Cats[Keyword], B3)), 0)), "Uncategorised")
This looks for any keyword from the lookup table inside the description and returns the matching category. In older versions of Excel, confirm it with ⌃⇧Return so it works as an array formula. Fill it down, filter for Uncategorised, add keywords for those rows, and repeat until almost nothing is left. Our guide to AutoFilter shortcuts on Mac speeds up the filtering.
| Keyword in description | Category |
|---|---|
| Grocer | Food |
| Utility | Bills |
| Salary | Income |
| Transfer | Transfers |
Step 7: Summarise
With clean, categorised data, a pivot table gives you spending by category and month in a few clicks. Our complete guide to pivot tables in Excel for Mac shows how, and the guide to building a monthly report in Excel on Mac turns it into something you can send. If you do this for clients, the advice in Excel for accountants on Mac is worth a look.
Privacy: keep statements local
A bank statement contains account numbers, names, employers and spending habits. The method above never leaves your Mac. Online converters are convenient, but they require uploading the file, so read their retention policy first, or skip them. Delete working copies when you are done, and avoid leaving statements in your Downloads folder.
Importing into accounting software
If the destination is accounting software, check its import requirements before you format anything. Packages differ on required columns, date formats, whether debits and credits share one signed column, and whether a header row is expected. Matching their template saves rework. Save the final file as CSV UTF-8 when asked for a CSV, as described in our guide to converting a PDF to CSV on a Mac.
Common mistakes
Skipping the balance check. A table that looks right can be off by one row.
Mixing up debits and credits when they are in one column.
Missing a transaction at a page break.
Leaving amounts as text.
Uploading statements to unknown websites.
Deleting the original PDF after conversion.
Frequently asked questions
Can I convert a bank statement PDF to Excel for free?
Yes, with copy and paste in Preview and Excel, or with the free Tabula tool, as long as the PDF has selectable text.
Why do my balances not match?
A row is missing, a digit was misread, or a debit and a credit were swapped. The Check column shows which row.
Does this work for credit card statements?
The same steps apply. Credit card statements often show charges as positive numbers and payments as negative, so check the sign convention.
What if my statement is a scan?
Use OCR first, then be extra careful with the balance check, since recognition errors are common in numbers.
Will different banks need different steps?
The layouts differ, so the split step differs. The checking and categorising steps are the same for every bank.