Netmend

Netmend · Guides · Import a PDF bank statement into QuickBooks

Import a PDF bank statement into QuickBooks

The reliable way into QuickBooks is a bank feed, or the bank’s own QBO or CSV download. When all you have is a PDF statement, convert it to the CSV shape Intuit documents, then upload it. This page sticks to those official columns and the checks that catch a bad file before it hits the register.

Free tool in your browserNo accountFrom $20 if you want it done

Convert a statement PDF now

Defaults are a starting point. Change the number format to match the PDF. The file never leaves your computer.

No file at hand? (fictional data)

How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.

Prefer the bank’s file, or the feed

If the bank offers a live connection, or a .QBO (QuickBooks), .QFX (Quicken) or official CSV download, use that and skip the PDF. Several banks on our guides already do this for recent activity — for example U.S. Bank documents CSV, QFX and QBO for up to three years, and PNC documents QBO and QFX. A PDF conversion is for older months, a statement someone emailed you, or a bank that only issues a PDF.

The two CSV layouts QuickBooks Online accepts

From Intuit’s official article “Format CSV files in Excel to get bank transactions into QuickBooks” (updated 24/08/2026, checked 13/11/2026), you can upload either:

Intuit also tells you to: remove zeros (leave those cells blank); fix any transaction that shows numbers in the Description column; save as a Windows CSV on a Mac; use one date format (they recommend dd/mm/yyyy); and split off weekday text such as “20/11/2018 TUE” with Data → Text to Columns (space-delimited). Each bank’s own CSV is different, and some bank CSVs simply will not import until you reshape them to one of the two layouts above. If the bank offers QFX, QBO or OFX instead, Intuit suggests trying that route.

For credit-card files, Intuit warns that transactions may appear in reverse sign — a payment can look negative because it reduces the card balance. Upload those rows into a credit-card account, not a bank account. See also our card-statement guide.

Convert the PDF, then reshape

The tool below reads the statement in your browser. Leave the file on your computer. Pick a UK/US or European number format to match the PDF. After you download the CSV:

  1. Keep only the transaction rows. Delete headings, headers, footers, “balance brought forward” lines and interest summaries unless they are real movements you want in the register.
  2. Reshape to Date / Description / Amount, or Date / Description / Credit / Debit. If your PDF had Money in and Money out, those become Credit and Debit (or a single signed Amount).
  3. Check that opening balance + deposits − withdrawals equals the closing balance printed on the PDF. If it does not, stop. A wrapped description has usually been read as a new row, or a summary total has been kept as a transaction.
  4. In QuickBooks Online, upload the CSV into the right account (Banking / Bank transactions → upload) and map the columns. Review every line before you accept it.

Do not also import the same period from a bank feed, or you will create duplicates. If the account is already connected, only upload dates the feed does not cover.

Sources (checked 13/11/2026). Official product help is linked in the text. Menus and templates change: treat the current screen in QuickBooks, Xero or your bank as the authority.

Need it done for you? From $20

The free tool is for a clean, text-based PDF. For scans, password files, a packed year of documents or a layout that has to match QuickBooks or Xero, we convert them and check the totals against each document.

Done-for-you conversion
$20 / 20 pages

75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.

Need it done for you? From $20
Privacy

Your file is processed only for the order and deleted after delivery. This page itself never uploads the file.

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.

FAQ

Can I upload the PDF straight into QuickBooks?

No. QuickBooks Online wants a CSV in the 3-column or 4-column layout, or a bank-feed / QBO file. Convert the PDF first and tick the totals.

Which is better, 3 columns or 4?

Whichever matches the statement you have with less editing. Money-in / money-out PDFs usually become 4 columns. A single signed amount becomes 3 columns. Both are official.

Why did QuickBooks reject my dates?

Mixed formats, or a day of the week left in the date cell, are the usual causes. Use one format and strip “TUE”-style suffixes, as Intuit documents.

Related guides

Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services