How to import a bank statement PDF into QuickBooks Online
Updated November 19, 2026 · Ruslan Vorobev, founder of Statement to Excel
QuickBooks Online imports bank transactions from a live bank feed or from a CSV, QBO, OFX or TXT file. It can also take the account statement itself as a PDF or image: in Bank transactions, open Link account, choose Upload from file and upload the statement. Its AI extracts the transactions and shows them next to the statement, and Intuit asks you to review everything before you save and to reconcile afterwards.
Converting the PDF to a CSV first is still the better route when you want each statement checked against its opening and closing balance before anything reaches QuickBooks, when you have many statements or several accounts in one PDF, when you want the rows in Excel for review, or when you use QuickBooks Desktop or Xero. The rest of this guide covers that route.
If your bank still offers a QBO or OFX download for those months, use it: QuickBooks reads those files without column mapping. The steps below are for when you only have the PDF.
What QuickBooks needs in the CSV
- Either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit).
- In the 3-column layout, money in is positive and money out is negative.
- One date format for every row. For US accounts that is usually MM/DD/YYYY.
- Leave Amount, Credit or Debit empty when the value is zero.
- No balance column, no account number, and no header or footer lines copied from the statement.
- At most 350 KB and 1,000 lines per upload. For a longer period, split it into several files.
| Date | Description | Amount |
|---|---|---|
| 01/02/2026 | VERIZON WIRELESS | -282.80 |
| 01/07/2026 | MOBILE CHECK DEPOSIT | 767.02 |
Step 1. Turn the PDF into a CSV
Copying rows out of a PDF by hand works for a few lines, but on a full statement columns merge, withdrawals lose their minus sign, and descriptions that wrap become extra rows. A converter built for bank statements does it in one go. With Statement to Excel you drop the PDF in and download QuickBooks Online CSV: 3 columns, MM/DD/YYYY dates, money out as negative numbers, and empty cells for zero amounts. Scanned statements work too.
Step 2. Check the totals before you import
Once transactions are in QuickBooks, a missing or doubled row means hunting through the register later. Check first: the opening balance plus all transactions must equal the closing balance printed on the statement. Statement to Excel does this for every statement and shows by how much it is off and which rows to check. Doing it by hand? See how to check a converted statement against its balances.
Step 3. Upload the file in QuickBooks Online
- Open Bank transactions (All apps, then Accounting, then Bank transactions).
- Select the account tile, open the Link account dropdown and choose Upload from file. If the account isn't connected to a bank feed, choose Upload transactions.
- Drag in the CSV and select Continue.
- Pick the QuickBooks account the transactions belong to and select Continue.
- Match the columns to Date, Description and Amount (or Credit and Debit), then select Continue.
- Select the transactions to import, select Continue, confirm with Yes, then select Done.
The rows land in For review, where you categorize or match them as usual.
Common problems
- File too large or too many lines: split the period into smaller files (350 KB and 1,000 lines per upload).
- Dates rejected or in the wrong month: the file mixes date formats, or day and month are swapped. Use one format for the whole file.
- Duplicates: if the account also has a bank feed, the uploaded period can overlap with feed transactions. Upload only the dates the feed doesn't cover, and match anything that shows up twice.
- Signs reversed: in the 3-column layout deposits must be positive and withdrawals negative. If everything came in backwards, the file used the opposite convention.
Have a PDF statement to convert?
Excel, QuickBooks or Xero CSV in about 30 seconds, checked against the statement's balances. The first 10 pages are free, no signup.
Convert a statement