Excel Budgeting from Bank Statements on Mac

Guide · Mac + iOS

Excel budgeting import from bank statements is simple when you have a direct CSV feed. When your bank only gives you monthly PDFs — the situation for most credit unions, regional banks, and older accounts — you need a middle step. The cleanest path is: convert each PDF to CSV with a dedicated tool, merge the CSVs into one sheet, add a Category column, then pivot by month. The same CSV imports into Excel, Numbers, Google Sheets, YNAB, Copilot Money, Monarch Money, and Rocket Money. This guide walks through that whole workflow on a Mac — with the iPhone app as an on-the-go option.

What you actually need

Every personal-finance tool — from a hand-rolled spreadsheet to YNAB — is built on three columns:

Date — when the transaction hit your account
Description — the merchant or counterparty, plus whatever reference the bank includes
Amount — positive for deposits, negative for withdrawals (or the other way round, depending on the tool)

A fourth column — Balance — is useful for sanity-checking the import, because you can scroll to the last row and confirm it matches the statement's closing balance. After import, you'll add a Category column yourself. Everything else on a bank statement — check number, merchant city, reference code, statement page number — is optional.

If you try to skip the CSV step and copy-paste rows directly from the PDF, you'll hit every failure mode in the broken-copy-paste guide: merged columns, lost signs, split rows. Don't.

Step 1 — Get clean CSV from the converter

Download Bank Statement PDF Converter from the Mac App Store. It's a single-purpose tool built for this — not a suite utility with fifty features you'll never use.

Drag a folder of statement PDFs into the app. A year of monthly statements is twelve files.
Let smart detection find the transaction table on each one. It finds the table even when banks bury it between marketing pages and statement summaries.
Switch to transactions-only mode to hide headers, footers, and account summaries — so your CSV contains transactions and nothing else.
Review side-by-side (original PDF on one side, extracted table on the other) and scan for anything odd.
Export CSV for each statement, or batch-convert the whole folder in one pass with a consistent column structure.

The Mac app also exports XLSX, TSV, Markdown, XML, and plain text. For budgeting, CSV is the most portable — every spreadsheet app and every budgeting tool reads it.

Files stay on your device while you select and review them. No accounts, no trackers, no resale.

On-the-go: iPhone + iCloud Drive

If you get statements by email on your phone, the iPhone app handles the same conversion with the same accuracy. Open the PDF in the PDF Bank Statement Converter app from Files, Mail, or iCloud Drive. Export CSV via the share sheet and save it to iCloud Drive. Next time you sit down at your Mac, the CSV is waiting in the same folder — no USB cable, no Airdrop ritual.

Step 2 — Merge statements into one sheet

Open each CSV in Excel, Numbers, or Google Sheets. If you have twelve monthly files, the simplest move is to paste them all into a single sheet under one header row. Make sure the columns line up — the converter produces consistent column order across every statement, so this usually just works.

A minimal budget sheet looks like this:

Date        Description                          Amount    Balance   Category
2026-01-03  WHOLE FOODS MARKET #10403 SEATTLE WA  -84.22    3,915.78
2026-01-03  STARBUCKS STORE 00428                 -6.45     3,909.33
2026-01-04  ACH DEPOSIT — EMPLOYER PAYROLL        +3,200.00 7,109.33
2026-01-05  NETFLIX.COM LOS GATOS CA              -15.99    7,093.34

Format the Date column as a date, the Amount and Balance columns as numbers, and leave Category blank for now.

Step 3 — Categorize

This is the part a live bank feed in Mint, YNAB, or Copilot would automate for you. Without that feed, you do it once per merchant — and it stays done, because you can copy the category down to every future transaction from the same merchant.

Ten to fifteen categories is enough for most people:

Groceries
Restaurants & coffee
Rent / mortgage
Utilities
Transport (gas, transit, rideshare)
Subscriptions
Health
Shopping
Travel
Income
Transfers (between your own accounts)

Use Excel's Find & Replace or Sheets' filter to categorize by merchant keyword. "STARBUCKS" → Restaurants & coffee. "CHEVRON" → Transport. "NETFLIX" → Subscriptions. A 300-row year takes maybe 20 minutes the first time. Subsequent months take five.

Step 4 — Pivot for category totals

The single most useful report you can build from categorized transactions is a month-by-month spend grid. Pivot tables make it a 30-second job.

In Excel:

Select the full range including headers.
Insert → PivotTable → New Worksheet.
Drag Category to Rows.
Drag Date to Columns. Excel will group it by month automatically; if it doesn't, right-click a date cell and choose Group → Months.
Drag Amount to Values. Set it to Sum.

The result is a grid: categories down the left, months across the top, totals in every cell. Negative numbers are spending; positive is income. Add a total row at the bottom and you have a cash-flow summary for the year.

In Google Sheets the flow is identical — Insert → Pivot table, same field assignments. In Numbers, pivots are a more recent feature but follow the same logic.

Step 5 — Optional: import the CSV into YNAB, Copilot, or Monarch

If you already use a budgeting app and just need a way to get older history in, the same CSV works.

YNAB. File Import → choose your account → pick the CSV. YNAB asks you to map the date, payee, and amount columns. Full instructions in YNAB's docs (UI may have moved — check current YNAB documentation).
Copilot Money. On macOS or iOS, go to the account and look for the CSV import option in settings. Copilot handles category mapping after import. Menu exact labels shift between releases; check Copilot's help center for the current flow.
Monarch Money. Web app, under the account's settings, look for the upload-from-file option. Same three-column format. UI changes periodically; confirm with Monarch's current docs.
Rocket Money. Import support is more limited; the CSV workflow is useful mainly for reviewing history outside the app.

This matters most for the first month after you adopt a new budgeting app — the moment when you want to see 12 months of history instead of waiting a year to accumulate it. Convert the PDFs, import the CSVs, and your new app has context from day one.

A few practical notes

If you have more than one account (checking + savings + credit card), keep them in separate sheets or tabs. Don't merge them into one file until after categorizing — the same merchant can mean different things on different accounts.
Transfers between your own accounts should be categorized Transfer, not Income or Expense. Otherwise you'll double-count.
If your bank uses parentheses for negatives — (125.00) — the converter preserves the sign in CSV as -125.00, which is what every spreadsheet app expects.
Scanned PDFs from older statements work too. See the scanned statement guide for the OCR workflow.

For a broader desktop walkthrough, see Convert Bank Statement PDFs to Excel on Mac. For the iPhone-first version of this workflow, see Convert a bank statement on iPhone. If you reconcile specific retailer charges — Amazon, Target, Costco — separately from your budget, there's also Reconcile retailer purchases on Mac.

Get the apps

Download Bank Statement PDF Converter on the Mac App Store for the desktop workflow, or PDF Bank Statement Converter on iPhone & iPad for conversion on the go. Same accuracy, same underlying detection, different surface for different moments. Free to try, no accounts, your statements stay on your device.

FAQ

What columns do I need for a personal budget from bank statements?

Three: transaction date, description, and amount. A running balance is useful for sanity-checking, and a category column gets added after import. Every other column on a bank statement — check number, reference code, statement page number — is optional.

Can I import the CSV into YNAB, Copilot Money, or Monarch Money?

Yes. YNAB, Copilot, and Monarch all accept CSV imports with date, payee/description, and amount columns. The converter's CSV export maps directly to the fields those apps expect. You may need to pick the account in the app before importing.

Why not use my bank's direct CSV download?

Many banks — especially smaller regional banks, credit unions, and business accounts — only offer PDF statements, or their CSV export is limited to the last 90 days. If you're building a budget from a full year of history, PDF conversion is often the only way to get older months.

Does the iPhone app work for this?

Yes. On iPhone you can convert a bank statement PDF directly from Files, Mail, or iCloud Drive and export CSV via the share sheet. Save to iCloud Drive and the file appears on your Mac for import into a spreadsheet or budgeting app.

How do I category-total spending in Excel?

Add a Category column, assign one to each row, then insert a pivot table with Category as rows, Month as columns, and Amount as values (summed). You get a month-by-month spend grid for every category — the foundation of any personal budget.

Personal budget in Excel — imported from bank statements.