How to Import Bank Transactions into QuickBooks Online

Turn a PDF bank statement into a QBO or 3‑column CSV and bring it into QuickBooks Online without installing anything.

AI extraction can contain errors. Verify the output against the source document before using it for accounting, reporting or any decision.

🤖
AI Table Extraction

Text PDFs are parsed on our server; scans are read by GPT-5 vision

📊
Excel, CSV, Word, PowerPoint

One result, any format from the Download menu: .xlsx, .csv, .docx, .pptx

🧾
Statements → QuickBooks, Xero

Bank and card statements export to .qbo, .ofx and import-ready CSV for QuickBooks and Xero

🔒
No Registration

3 files a day free, files deleted right after processing. Pro: $9/mo, no daily limit

Short answer: To import bank transactions into QuickBooks Online from a PDF, drop the statement into PDF2XLS (free for 3 files/day, 10 MB, scans OK). Download either a QuickBooks .qbo or QuickBooks Online 3‑column CSV, then in QBO go to Transactions → Bank transactions → Upload from file and map Date, Description, Amount.

  • Free tier: 3 files/day, no signup
  • Size limit: 10 MB per PDF
  • Accounting outputs: QuickBooks .qbo, QuickBooks Online 3‑column CSV, OFX, Xero CSV
  • Scans/photos: Supported via GPT‑5 vision
  • Privacy: Processed on our server; scans go to OpenAI for table reading; files deleted after processing

What’s the fastest way to get PDF bank transactions into QuickBooks Online?

Convert the PDF to a QBO file or a 3‑column CSV (Date, Description, Amount) with PDF2XLS, then use QuickBooks Online’s Upload from file flow to bring the transactions into the right account.
  1. Upload your PDF statement. Use the widget above to add the file (up to 10 MB). Native PDFs and scanned statements both work.
  2. Wait for the table to be read. If the tool detects a Date and an Amount (or Debit/Credit), the Download menu will include accounting formats such as QuickBooks .qbo and a QuickBooks Online CSV.
  3. Download QBO or the 3‑column CSV. Pick “QuickBooks .qbo” for Web Connect or “QuickBooks Online CSV (Date, Description, Amount).” If accounting outputs aren’t offered, take .xlsx and shape it, then save as CSV.
  4. In QuickBooks Online, go to Upload from file. Open Transactions → Bank transactions → Upload from file. Choose the bank/credit card account (or create one) for these lines.
  5. Map columns if you chose CSV. Match Date → Date, Description → Description, Amount → Amount. Outflows should be negative; if your statement had separate Debit/Credit, our CSV signs Amounts for you.
  6. Import and review. After upload, the lines appear under For review. Categorize, add payees, and confirm before adding to the register.

Should I use .QBO or the 3‑column CSV?

Both work in QuickBooks Online. QBO (Web Connect) is purpose‑built for QuickBooks and usually needs less mapping. The 3‑column CSV is universal and gives you more control when you want to adjust descriptions or signs first. For CSV‑specific shaping tips, see our CSV for QuickBooks Online guide.

If your PDF is a scan or photo

Scanned statements are handled automatically—no OCR toggle needed. Upload the image‑based PDF; GPT‑5 vision reads the table. If you don’t see accounting formats in Download, get .xlsx, check that columns are aligned, then export CSV and import to QuickBooks. For scan‑quality tips, skim OCR for scanned PDFs.

Doing it without our tool

If your bank website offers a QBO or CSV export, download that and import directly—fastest path. Excel’s Get Data from PDF can help with text‑based PDFs, but it doesn’t handle scans and can jumble multi‑line descriptions. For very short statements, copy‑paste into Excel, fix columns, save as CSV, then upload to QuickBooks Online.

What to check before you trust the import

Make sure the data you brought in matches the statement totals and format you expect.
  • Reconcile totals: do the imported transactions net to the statement’s change in balance?
  • Date format: ensure the CSV dates match your QuickBooks locale (MM/DD/YYYY vs DD/MM/YYYY).
  • Signs: expenses negative, deposits positive. Parentheses in PDFs must become negative signs.
  • No running balances: QuickBooks needs transaction lines only, not balance columns.
  • Duplicates: avoid overlapping date ranges across multiple imports.
  • Stray rows: headers/footers or stamp lines shouldn’t become transactions.
If you’re reconciling month‑end, this bank reconciliation worksheet in Excel can speed up your check.

QuickBooks says “We couldn’t upload your file” — what now?

This usually comes down to format or mapping. Use a 3‑column CSV with headers exactly “Date, Description, Amount,” UTF‑8 encoding, and a consistent date format. Remove currency symbols and extra commas inside descriptions. If your file is large, split it into smaller CSVs and import in chunks. Our QuickBooks Online CSV download already follows these conventions.

How PDF2XLS treats statements and your data

Accounting outputs (QBO, OFX, QuickBooks Online CSV, Xero CSV) appear only when the table contains a Date and an Amount or Debit/Credit column; otherwise you’ll get .xlsx/.csv and can import from there. Files are processed on our server in Germany and deleted right after processing. Scanned pages are sent to the OpenAI API for table recognition (not used for training); PDFs with real text layers stay on our server. Want to start? Convert your PDF now.

FAQ

Both import transactions. QBO (Web Connect) is QuickBooks’ own format and usually needs less mapping. The 3‑column CSV (Date, Description, Amount) is universal and easy to edit first. If one fails, try the other—QuickBooks supports both flows.

Yes, if the statement table has a Date and an Amount (or Debit/Credit). PDF2XLS can produce QBO or a 3‑column CSV. Ensure expenses are negative and credits are positive before importing so QuickBooks classifies them correctly.

Open the file in Excel or Google Sheets and convert the Date column to a consistent format (e.g., MM/DD/YYYY). Save as UTF‑8 CSV and re‑import. During mapping, confirm QuickBooks detects the format shown in your file.

No. Files are processed on a server in Germany and deleted right after processing. Scanned/image pages are sent to the OpenAI API for table recognition and aren’t used for model training. PDFs with a text layer aren’t sent to any AI provider.

Download .xlsx, open it, and check that rows and columns are correct. If needed, move data into Date, Description, Amount, then export as CSV and import to QuickBooks Online. The tool only offers accounting formats when Date and Amount are present.

Imported lines land in For review. You’ll still need to confirm or categorize them in QuickBooks. Bank rules and vendor matching can help, but manual review is recommended before adding to the register.