How to import a PDF bank statement into YNAB

By Kayabyte · Last updated 28 October 2026

You want old or missing transactions in YNAB, but your bank only sent a PDF, or direct import doesn’t cover your bank. YNAB can import files, but not PDFs. This guide covers getting from a PDF to a file YNAB accepts, and the traps that make the result look fine until your account balance is off.

Menu names in YNAB change between versions and between the web app and the mobile apps, so treat the labels below as a guide.

1. Ask for a file first

Check your bank’s website for a transaction download: CSV, OFX, QFX or QIF. YNAB’s file import takes CSV and also OFX, QFX and QIF, and a bank file avoids every formatting problem below. If the bank only offers PDF, continue.

2. Build a YNAB CSV by hand

YNAB’s CSV import wants a simple layout. The documented columns are a date, a payee, a memo, and either an outflow and inflow pair or a single amount column. Check YNAB’s current help page for the exact headers; they have changed over time.

Copy the transaction table from the PDF and paste into Excel or Numbers.
Split the pasted text into columns (Text to Columns).
Rename or arrange columns: Date, Payee, Memo, Outflow, Inflow.
Put money leaving the account in Outflow and money arriving in Inflow, both as positive numbers. If your statement has one signed column, split it with two formulas, then paste values.
Make dates a single consistent format.
Export as CSV (UTF-8 if offered, so accented payee names survive).

3. Import into YNAB

On the web app, open the account and look for the option to import a file (often “Import” or “File Import”, depending on version). Choose your CSV. YNAB shows the transactions for you to review, marks likely duplicates, and lets you approve them. Check the date format YNAB chose, because a wrong day/month guess is the most common mistake. If dates look swapped, cancel and fix the CSV.

4. What goes wrong

Signs flipped. A credit card statement shows purchases as positive and payments as negative; a checking statement is the opposite. If your Outflow and Inflow columns are swapped, every transaction is wrong but plausible. Test with one transaction you recognize.
Wrapped descriptions split a payee over two rows.
Starting balance. YNAB doesn’t care about statement balances. If your first import starts mid-month, your YNAB account balance won’t match the bank until you enter the right starting balance or an adjustment. Check this before budgeting.
Duplicates. If you already have some of the transactions through a linked account, importing the same days again can double them. YNAB’s duplicate detection is a help, not a guarantee.
Cleared status. Imported transactions usually arrive uncleared; reconcile afterwards.

A check that takes a minute: in the spreadsheet, add up inflows minus outflows, add the statement’s opening balance and compare with the closing balance. Equal means probably nothing was lost.

5. Where Balanced helps

Balanced is a Mac app we make that turns the PDF into a checked file. Open the statement (text PDF, or a scan or photo, read with Apple’s on-device text recognition) and the preview shows the table it found. You can correct column roles, the date order (day/month or month/day) and how signs are handled, which covers the biggest problems above. It then checks that opening balance plus transactions equals closing balance, and the running balance per row if your statement has one. If not, it says which rows and the difference, and exporting needs an explicit “Export anyway”.

Choose YNAB CSV from the Export button. Prefer OFX or QFX instead? Those are in the list too, along with CSV, Excel, QIF and others. No AI guessing: every number is copied from your statement and checked, and files are processed on your Mac and never leave it.

Limits: it depends on the statement layout, so check the preview; badly skewed or low-quality scans can fail; a password-protected PDF needs unlocking first with the password from your bank. We can’t promise it reads every bank.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file. Pro is USD 59 per year or USD 7.99 per month, up to 3 Macs, cancel anytime, with a 30-day money-back on the first payment. See pricing and help. macOS 14 or later.

6. After importing

Compare the YNAB account balance to the bank’s at the statement date.
Spot-check three transactions: first, last, one refund.
If a month looks off, see why converted statements don’t add up.