Not every account connects to QuickBooks. A closed account, a bank with no direct feed, a credit card that never linked — sometimes the only record you have is a PDF statement. QuickBooks Online can't read a PDF, but it happily imports a CSV. This walkthrough takes you from that PDF to categorized transactions in your register, with a reconciliation check in the middle so you're not importing numbers you haven't verified.
Step 1 — Download the statement as a PDF
Log in to your bank and download the statement for the period you need as a PDF — the same file you'd save for your records. If you only have a paper statement, a clear scan works too, though born-digital PDFs (downloaded straight from the bank) extract most reliably.
Step 2 — Convert the PDF to a QuickBooks CSV
QuickBooks Online imports a simple 3-column CSV: Date, Description, Amount. Drop your PDF into the bank statement to QuickBooks Online converter (or the more general bank statement to QuickBooks page) and convert. A long statement is automatically split so each file stays under QuickBooks' 350 KB / 1,000-line upload limit.
Prefer a bank-feed-style import instead of a CSV? Convert to a .QBO (Web Connect) file instead — QuickBooks treats it like a downloaded feed, with stable transaction IDs so nothing double-imports.
Step 3 — Review the rows that don't reconcile
This is the step most PDF-to-CSV tools skip. Before you trust the file, the converter runs a balance-reconciliation check: it confirms the opening balance plus every transaction equals the closing balance, and that each printed running balance ties to the next. Any row that doesn't add up is flagged for review, not silently exported as correct. Open the flagged rows against the original statement and fix or confirm them before you import — a misread amount is far cheaper to catch here than after it's in your books.
Step 4 — Upload it in QuickBooks Online
In QuickBooks Online, go to Transactions → Link account → Upload from file. Select the CSV, then map the columns when prompted: Date to date, Description to description, Amount to a single signed amount column (money out negative). Pick the bank account the statement belongs to and continue. QuickBooks shows you the transactions for review before anything is added.
Step 5 — Categorize and add
Work through the imported list, assign a category to each transaction (QuickBooks will suggest some based on past activity), and add them to the register. If you split the statement into multiple CSVs in Step 2, upload them one after another against the same account.
If you'd rather work in a spreadsheet first
Some bookkeepers like to sort, total, or clean up transactions before importing. Convert to a plain bank statement CSV, open it in Excel or Google Sheets, tidy it, then upload the result the same way. Either path ends up as the same import in QuickBooks.
Formatly is a conversion utility, not financial, tax, or accounting advice. Always review converted transactions against your original statement before relying on them.
Related
- Bank statement → QuickBooks Online → the converter used above
- PDF → QBO (Web Connect) → import as a bank feed instead
- Bank statement → CSV → work in a spreadsheet first
- Convert vs manual entry → when each is worth it
- All supported formats →