QuickBooks Online imports CSV — not PDF. This hub covers everything between a bank statement PDF and a clean QuickBooks import: the CSV schema QBO expects, the per-bank import guides, duplicate handling, multi-account workflows, and the accountant batch process for serving multiple clients.
Last updated 2026-10-26
QuickBooks Online's Banking screen accepts three file formats: CSV (3-column or 4-column), QBO (Web Connect), and OFX. PDF is not on the list. The 3-column format is Date · Description · Amount (signed). The 4-column adds separate Debit and Credit columns.
ClearlyLedger emits a QuickBooks Online CSV in the selected three- or four-column layout. Choose the date format expected by your QuickBooks Online import settings before upload.
Re-importing a month that overlaps a previous import is the most common QuickBooks data-entry mistake. ClearlyLedger's batch flow runs duplicate detection on date + amount + normalized description so overlapping months collapse to a single set of rows.
Per-bank guides below cover how each statement's reference IDs interact with QuickBooks' match-vs-add logic in the Banking screen.
Bank-specific quirks change how the CSV needs to be shaped: HSBC trims long reference strings, Chase splits ATM withdrawals into two lines, HDFC concatenates UPI metadata across rows. The per-bank import guides in the cluster below cover the exact handling.
On any paid plan, you can batch multiple PDFs from different clients in one upload, get a per-file QuickBooks CSV out, and keep all source PDFs zero-retention. The accountants pillar covers the full workflow.
How each major bank's statement maps into a QuickBooks-ready CSV.
No. QuickBooks Online accepts CSV, QBO (Web Connect), and OFX — not PDF. ClearlyLedger converts the PDF to a QuickBooks-ready CSV that imports without column remapping.
QuickBooks' Banking screen runs match-vs-add logic on incoming rows against your live bank feed. ClearlyLedger preserves the bank's reference IDs and amount precision so QBO can match cleanly. Cross-file duplicate detection prevents re-importing the same month twice.
QuickBooks Desktop's Web Connect flow requires a .qbo file, which ClearlyLedger does not currently offer. The supported QuickBooks CSV export on this page is for QuickBooks Online; do not rename that CSV to .qbo.
No. The CSV ships in QuickBooks' expected shape — Date, Description, Debit, Credit. QBO auto-detects the layout on first import for the account and reuses it for subsequent files.
Loading interactive converter… Try ClearlyLedger free