Convert PDF bank statements for QuickBooks

1. Add your PDF statements. Drag one or more PDF bank or credit card statements into the converter, or click to choose them. Password-protected files ask for the password, which is used only on your device.
2. Check the preview. Transactions appear in an editable table with dates, descriptions, money in, money out and balance. The balance check flags any row that does not add up, so you can fix it in a click.
3. Download QuickBooks (CSV or OFX). Export to Excel (.xlsx), CSV, OFX or JSON, or copy the table straight into Google Sheets. Nothing is uploaded at any point.

When you need this

Bank feeds usually only reach back a limited number of months, some banks do not offer a feed at all, and new clients often arrive with nothing but a folder of PDF statements. Typing those transactions in is slow and invites mistakes. Converting the PDFs into an import file lets you bring months or years of history into QuickBooks in minutes, then categorise and reconcile as usual.

Option 1: OFX (no column mapping)

Click OFX after converting. The file contains each transaction's date, signed amount, description and a unique ID, plus the closing balance. In QuickBooks Online, go to the banking or transactions area, choose to upload transactions from a file, select the OFX, and pick the QuickBooks account it belongs to. Because the format is standardised there is nothing to map.

Option 2: CSV (most control)

Click CSV to get Date, Description, Debit, Credit, Amount and Balance columns. QuickBooks Online accepts two layouts:

• Three columns: Date, Description, Amount, where Amount is negative for money out. Map the converter's Amount column.
• Four columns: Date, Description, Credit, Debit with positive numbers. Map Credit and Debit.

During upload, QuickBooks asks which date format the file uses. Set the converter's Date format to match before exporting, for example MM/DD/YYYY for a US company file or DD/MM/YYYY for UK, Australian and Indian files, and choose the same option in the upload screen. Exact menu names vary between QuickBooks versions and regions.

Get the data right before it reaches your books

Errors are much easier to fix before import than after. Use the converter's balance check: if every row reconciles against the statement's running balance, you know nothing was skipped or misread. Correct any shaded rows directly in the preview, delete opening-balance lines or transfers you do not want imported, and then export. Read the step-by-step QuickBooks import guide for screenshots-free instructions and common error messages.

Credit card statements

Card statements list purchases as positive numbers and payments with a minus sign or CR. The credit card converter recognises this and outputs purchases as money out. When you import into a QuickBooks credit card account, preview a few lines to confirm charges increase the balance owed, and use Flip signs if your setup expects the opposite.

• Full guide: import into QuickBooks
• Bank statement to Excel
• Bank statement to CSV
• Bank statement to Xero
• Credit card statement converter
• Bank statement to JSON
• Banks by country

Bank-feed uploads in QuickBooks are built for data files such as CSV, OFX, QFX and QBO rather than PDFs. Convert the PDF here first, then upload the CSV or OFX file in QuickBooks.

Both work. OFX carries dates, amounts and unique transaction IDs in a standard structure, so there is no column mapping. CSV gives you more control and is easier to inspect or edit first. If one is rejected, try the other.

No. The converter exports OFX, CSV, Excel and JSON. QuickBooks Online accepts OFX and CSV uploads. QuickBooks Desktop typically expects QBO Web Connect files, so check what your version supports before relying on it.

Credit card accounts and bank accounts treat signs differently. Preview a few rows after mapping; if charges appear as payments, use Flip signs in the converter and export again, or switch between the one-column and two-column layout during import.

Only import date ranges that are not already in the register or bank feed, and review the For Review list before accepting. QuickBooks may match some imported lines to existing records automatically.