How to import a PDF bank statement into QuickBooks
QuickBooks Online imports bank transactions from CSV, not PDF. How to turn a statement PDF into a CSV QuickBooks accepts, and what to check first.
Key takeaways
- QuickBooks Online imports bank transactions from files such as CSV, QBO, QFX and OFX — not from PDF.
- A QuickBooks CSV needs either three columns (date, description, amount) or four (date, description, credit, debit).
- Import one account at a time and check the statement reconciles before uploading.
Bank feeds don't always cover what you need. The connection breaks, the account is closed, or you're catching up on months from before the feed existed. In those cases the PDF statement is your source of truth — but QuickBooks Online can't read a PDF. You need a CSV.
The CSV format QuickBooks expects
QuickBooks Online accepts a simple bank CSV in one of two layouts. Menu names and limits change from time to time, so check Intuit's current help pages, but the structure has been stable:
- Three columns: Date, Description, Amount — with money out as negative numbers.
- Four columns: Date, Description, Credit, Debit — with money in and out in separate columns.
- One consistent date format throughout the file.
- No currency symbols, no totals rows and no blank lines in the middle.
Step by step
- Convert the PDF statement into transactions (see bank statement PDF to Excel).
- Check that opening balance plus all transactions equals the closing balance.
- Save the transactions as a CSV in the three- or four-column layout.
- In QuickBooks, open bank transactions and choose to upload from file.
- Pick the matching QuickBooks account and map the columns.
- Review the imported transactions before accepting them.
Avoid duplicates
If a bank feed is already pulling some of the same dates, uploading a statement on top will create duplicates. Upload only the date range the feed is missing, and look closely at the boundary days. Overlapping statements cause the same problem — our duplicates guide covers it.
Exporting from PaperSpend
PaperSpend exports a QuickBooks-ready bank statement CSV directly. Because QuickBooks imports one bank account at a time, the export is per account: choose the account and date range, download, and upload it to the matching account in QuickBooks. Every row has already been reconciled against the original statement.
Frequently asked questions
Can QuickBooks import a PDF bank statement?
No. QuickBooks Online imports bank transactions from files such as CSV, QBO, QFX or OFX. Convert the PDF to CSV first.
What columns does a QuickBooks bank CSV need?
Either three columns — Date, Description, Amount — or four — Date, Description, Credit, Debit.
How do I avoid duplicate transactions when importing into QuickBooks?
Only upload the dates your bank feed doesn't already cover, and review the first and last days of the range before accepting the import.
