BankSheet
Convert — free

Guides

Convert a bank statement PDF to a QuickBooks-ready CSV

BankSheet (getbanksheet.com) turns a text-based bank statement PDF into a CSV you can review and then import into QuickBooks Online. The QuickBooks preset is Date, Description, and Amount. It is not a .QBO file, not a Web Connect file, and not a direct QuickBooks connection.

Can QuickBooks Online read a PDF statement directly?

In the US, yes. Intuit's US help (updated 24 August 2026) says QuickBooks Online accepts an English PDF or image bank statement and uses AI to extract the rows for you to review before you save. Intuit's UK help does not offer that upload: it asks for a QBO or CSV file and says to convert a PDF bank statement with a third-party tool first. A converter such as BankSheet is still useful when you want an independent opening-to-closing balance check before those rows land, a CSV workpaper, or the three-column Date, Description, and Amount preset. BankSheet does not produce .QBO or Web Connect files, and it does not connect to QuickBooks directly.

What the QuickBooks CSV preset contains

After the preview looks right, switch the export preset to QuickBooks and download CSV. The same three columns are used if you download Excel for a workbook review. QuickBooks Online’s file upload expects the CSV.

  • Columns: Date, Description, Amount.
  • Amount is one signed column. Credits (money in) are positive. Debits (money out) are negative.
  • The Standard preset is a different file: Date, Description, Debit, Credit, and Balance. Use Standard for a workpaper. Use QuickBooks when you want the three-column import shape.
  • That download is not a .QBO file, not OFX or QFX, and not a Web Connect file. BankSheet does not sign in to QuickBooks or push a bank feed. Account mapping, categories, payee cleanup, duplicate review, and import confirmation stay with you.

Reconcile and preview before import

Read the preview table and the opening-to-closing balance check before you download. A pass means the extracted movements explain the printed balance change within the documented tolerance. It does not mean QuickBooks will accept every row unchanged. If the check fails or is incomplete, compare the preview to the PDF before you import. Method: How BankSheet checks balances.

How to import the CSV in QuickBooks Online

  1. Convert the PDF. Upload the text-based statement and wait for the preview table. Open the converter.
  2. Check the balance. Use the opening-to-closing panel as the pre-import sanity check. Do not treat a fail or an incomplete result as ready to file. How BankSheet checks balances.
  3. Download the QuickBooks CSV. Choose the QuickBooks preset, then download CSV. Excel is fine for review; the Online upload path wants CSV.
  4. Upload the file in QuickBooks Online. Open Transactions, then Bank transactions, and select the bank account. Choose Upload from file (on many accounts that sits under Link account). Map Date, Description, and Amount, and confirm the rows import into that account. New rows land for review. QuickBooks has not categorized them.
  5. Finish the books in QuickBooks. Match possible duplicates, categorize, clean payees, and reconcile to the statement closing balance.

Menu names in QuickBooks Online change. If you do not see Upload from file, use that account’s file upload or import statement action and map the same three columns.

FAQ

Can QuickBooks Online read a PDF statement directly?
In the US, yes. Intuit's US help (updated 24 August 2026) says QuickBooks Online accepts an English PDF or image bank statement and uses AI to extract the rows for you to review before you save. Intuit's UK help does not offer that upload: it asks for a QBO or CSV file and says to convert a PDF bank statement with a third-party tool first. A converter such as BankSheet is still useful when you want an independent opening-to-closing balance check before those rows land, a CSV workpaper, or the three-column Date, Description, and Amount preset. BankSheet does not produce .QBO or Web Connect files, and it does not connect to QuickBooks directly.
Does BankSheet connect directly to QuickBooks?
No. There is no QuickBooks sign-in, bank feed, or Web Connect handoff. You download a CSV and import it yourself.
What does the QuickBooks CSV preset change?
It sets the columns to Date, Description, and Amount. Credits are positive and debits are negative. It does not create a .QBO, OFX, or Web Connect file, and it does not change the on-screen preview, which still shows debit and credit separately.
Should I reconcile the CSV before importing?
Yes. Preview the rows and read the opening-to-closing check first. Use that result to decide whether the extract is fit to import. QuickBooks reconciliation is a later step, after the file is in the account. Related: How BankSheet checks balances.
Can I import a scanned PDF?
BankSheet reads text in the PDF. A scanned or image-only statement may produce few or no rows, and it may be flagged as likely scanned. Do not import an empty or unchecked file. Get a text PDF from the bank portal when you can.
Why might I need to edit a row or map an account after conversion?
The CSV has dates, descriptions, and amounts from the statement. It does not know your chart of accounts, preferred payee names, or which rows are duplicates of an existing bank feed. Those edits happen in QuickBooks, or in the spreadsheet before upload.

Related