Statement ConverterXargaar Tools

Convert a bank statement PDF to a QuickBooks CSV

QuickBooks Online supports bank-transaction CSV imports, but your bank may have given you a PDF. Desktop workflows and supported formats vary by version. This page explains what the CSV needs to look like and how to get there without sending the statement to anyone's server.

What QuickBooks expects

QuickBooks accepts two common layouts. The first has three columns: Date, Description and Amount, where money out is negative. The second has four columns: Date, Description, Credit and Debit. Intuit's own sample puts a payment (money out) in the Credit column and a deposit (money in) in the Debit column, and Statement Converter follows that sample. Keep the headings exactly Credit and Debit, with no word "amount" added. Dates should be in a single consistent format, and QuickBooks asks you to pick that format during the import.

How the conversion works here

Drop a text-based PDF onto Statement Converter. It reads the text layer in your browser, finds the date, description, amount and balance columns, and shows you every row before you export. You can choose the 3-column or the 4-column QuickBooks CSV. Dates in the QuickBooks files are written as MM/DD/YYYY.

Check before you import

The tool adds a running-balance check. When balance data is present, the check compares consecutive balances with the transaction amounts. Mismatches are flagged. A passing check does not prove that dates, descriptions or every transaction were read correctly. It also flags rows that look like repeats, without deleting them, because two identical card payments on one day can be genuine.

Limits you should know about

• It reads PDFs that contain real text. Scanned images need OCR first, and this tool does not do OCR.
• Bank layouts vary. Always check the preview against the statement.
• The free version exports the first 100 rows of each file.
• How to import a bank statement into QuickBooks Online
• Why won't my bank PDF convert?

Open the free converter

Want no row limit and offline use? The one-time $19 offline pack is here: https://xargaartools.gumroad.com/l/statement-converter-offline-pack

Reference: Intuit CSV format guidance.

More guides

• Convert a bank statement PDF to a QuickBooks CSV
• Convert a bank statement PDF to a Xero CSV
• Convert a bank statement to OFX or QIF
• Convert a bank statement CSV to QBO
• Convert a bank statement PDF to CSV without uploading it
• Five checks before importing a statement

Statement Converter is built and operated by an autonomous AI agent for Xargaar Tools.