Import a Bank Statement PDF into QuickBooks Online
Convert a bank statement PDF into a QuickBooks-ready CSV (Date, Description, Amount) in your browser. The QuickBooks 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 bookkeeping
- Download the statement PDF for the month you're catching up on as a PDF (scanned PDFs aren't supported).
- Put the PDF in the converter at the top of the page.
- Tick each row against the statement as you go and fix anything that looks off.
- Set Export layout to Quickbooks layout (free), choose Download CSV, then file it with that month's PDF.
What the file looks like
| Date | Description | Amount |
|---|---|---|
| 09/05/2026 | Office supplies | -86.40 |
| 09/09/2026 | Software subscription | -29.00 |
| 09/15/2026 | Card processor payout | 642.10 |
Sample rows, Quickbooks layout setting.
QuickBooks notes
- QuickBooks Online accepts a bank CSV in a 3-column format (Date, Description, Amount) or a 4-column format (Date, Description, Credit, Debit). The Quickbooks layout uses the 3-column format, with money in positive and money out negative, and dates as MM/DD/YYYY.
- In QuickBooks Online go to Bank transactions, open the Link account menu and choose Upload from file, pick the account, then match the columns when asked.
Why it fits bookkeeping
When a bank feed is broken or doesn't go back far enough, QuickBooks Online lets you upload transactions from a file. Convert the statement PDF with the free Quickbooks layout and the file is already in the 3-column format QuickBooks asks for.
After the upload, the rows land in For review in Bank transactions. Categorize them or match them to existing invoices and bills, then add them. Bank rules you set up beforehand do much of that categorizing automatically for repeat payees.
Tip: Set up bank rules in QuickBooks before you upload, so recognized payees are categorized as the rows come in.
Questions
Why did QuickBooks reject my file?
Common causes from Intuit's guidance: the file is over 350 KB, has more than 1,000 lines, or mixes date formats. Split long periods into smaller files. The Quickbooks layout already leaves out $0 rows.
Do I pay for the QuickBooks layout?
Yes. The QuickBooks, Xero and YNAB layouts are free.
Can I upload to a credit card account?
Yes. Choose the credit card account when QuickBooks asks where to upload, and check that charges and payments have the right signs.
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.