Netmend · Guides · 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.
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)
Check the totals against the original PDF before you use the file. If a column is in the wrong place, try “Every text row”, or send it to us.
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.
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.
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.
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:
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.
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.
75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.
Need it done for you? From $20Your 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.
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.
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.
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.
Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services