Import a Bank Statement PDF into YNAB
Convert a bank statement PDF into a YNAB-ready CSV with Outflow and Inflow columns. Runs in your browser. The YNAB layout is free.
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it.
Steps for personal budgeting
- Download last month's statement for your everyday account as a PDF (scanned PDFs aren't supported).
- Open the PDF in the converter above by dropping or tapping.
- Delete transfers between your own accounts so they don't count as spending.
- Set Export layout to Ynab layout (free), choose Download CSV, then load it into your budget.
What the file looks like
| Date | Payee | Memo | Outflow | Inflow |
|---|---|---|---|---|
| 08/01/2026 | Payroll deposit | 3100.00 | ||
| 08/03/2026 | Grocery store | 142.18 | ||
| 08/10/2026 | Gas station | 48.73 |
Sample rows, Ynab layout setting.
YNAB notes
- YNAB's File-Based Import matches CSV columns to Date, Payee, Memo, Outflow and Inflow. The Ynab layout uses exactly those headers, with spending in Outflow and deposits in Inflow, and the other cell left blank. $0 rows are left out.
- File-Based Import works in the YNAB web app or on an iPad, not on phones. Drag the CSV anywhere into YNAB and the Import Transactions window opens.
Why it fits personal budgeting
YNAB works best when every transaction is in the plan, including the ones from before you started or from an account you don't link. Convert the statement with the Ynab layout and use File-Based Import.
After importing, give every new transaction a category and approve it. If the account was new to YNAB, check that the imported balance matches your bank's balance on the same day, and add a reconciliation adjustment only if you understand the difference.
Tip: If your YNAB account starts on a certain date, YNAB will offer to include or exclude earlier rows. Exclude them unless you mean to adjust past months.
Questions
Do I need to link my bank to YNAB?
No. File-Based Import is for exactly this: bringing in transactions from a file without linking the account.
Will categories come in with the file?
No. YNAB doesn't import categories from files, so you'll assign them in YNAB after importing.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.