Three columns
Date, Description, Amount
Money leaving the account is a negative Amount; money coming in is positive. This format is the simplest when each source transaction already has a reliable signed amount.
03/08/2026OFFICE SUPPLY-126.42
ACCOUNTING IMPORT · QUICKBOOKS
Bank statement to QuickBooks CSV.
Extract posted transactions from a PDF or clear scan, check the numbers, and export the exact three- or four-column bank transaction layout you choose. This is a dedicated import file, not our general seven-column CSV under a different name.
No QuickBooks connection required · PDF, PNG or JPG input · CSV download after validation
IMPORT FORMAT / 03 COLUMNSQuickBooks
| Date | Description | Amount |
|---|---|---|
| 03/08/2026 | NORTHSTAR OFFICE SUPPLY | -126.42 |
| 05/08/2026 | CLIENT TRANSFER | 2400.00 |
Switch to four columns in the result workspace when you need separate Credit and Debit values.
Statement workspace
Make a QuickBooks import file from your statement.
PDF, PNG or JPG · up to 10 MB · no bank login required
- Dates and descriptions
- Debits, credits and balances
- Excel, CSV and JSON export
Drop your bank statement here
or choose a file from your device
TWO ACCEPTED LAYOUTS
Choose the columns QuickBooks expects.
QuickBooks Online documents both bank-transaction CSV layouts. Select one after extraction; the download contains only those columns, in the documented order. See Intuit’s format guide ↗
Four columns
Date, Description, Credit, Debit
Each transaction puts a positive value in either Credit or Debit and leaves the other cell empty. The exporter checks for mixed directions and does not fill blank cells with zeroes.
05/08/2026CLIENT TRANSFER2400.00blank
Why the two formats are not interchangeable
A general statement export may include Reference and Balance, which are useful for reconciliation but do not belong in these QuickBooks import layouts. The dedicated exporter leaves those columns out. In three-column mode, it retains the transaction’s sign. In four-column mode, it separates that same movement into Credit or Debit and writes the opposite cell as empty, not as zero. Review the direction of a refund, transfer or credit-card payment before importing; selecting the wrong account type can change how the movement appears in QuickBooks.
The downloadable samples use fictional transactions. Compare them with your chosen layout before converting a real statement, and use the general CSV only when you need a flexible working file rather than a QuickBooks-specific import.
BEFORE THE DOWNLOAD
Catch format errors while the source is still in view.
Dates from a statement can be ambiguous, and an extracted debit can disagree with a signed amount. This page checks every transaction before enabling its QuickBooks download. It never invents a date or silently rounds a money value to make a row pass.
The editable table accepts corrections. Enter dates as YYYY-MM-DD; the exporter converts them consistently to DD/MM/YYYY by default, or to MM/DD/YYYY if you select that option. Match the date format during QuickBooks import.
- Valid calendar dateRejects unclear text and impossible dates, including an invalid leap day.
- Non-zero, two-decimal amountStops missing, zero or over-precise values so they can be checked against the PDF.
- One money directionFlags rows with both debit and credit, or a signed amount that conflicts with the extracted direction.
- Review cues remain visibleLow-confidence extraction markers still ask you to compare the original statement before upload to QuickBooks.
IMPORT WORKFLOW
From PDF to the correct bank account.
1. Extract and compare
Upload a statement you are authorized to process. PDF pages count toward your page allowance; a photo counts as one page. Compare dates, descriptions and amounts with the original. For a difficult scan, use the OCR comparison workspace first.
2. Download the dedicated CSV
Choose three or four columns and a consistent date format. Review the on-page preview, correct any blocking issue, then download the QuickBooks CSV. The general CSV and Excel exports remain available separately if you need a working copy.
3. Map and review in QuickBooks
In QuickBooks Online, open Bank transactions, choose the correct bank or credit-card account, and upload the CSV. Map each file column to the matching QuickBooks field, confirm the date interpretation, then inspect the transactions before completing import. Menu names can vary by region.
QUICKBOOKS QUESTIONS
Know what goes into the file.
This tool prepares a bank transaction CSV; it does not post transactions to your accounting account automatically.
Can I upload the original PDF directly to QuickBooks?+
Some QuickBooks Online versions offer their own PDF or image upload. This page serves a different need: a reviewable, explicitly mapped CSV that you can inspect before manual import. If you already have a clean bank-native CSV, you may not need to convert the PDF.
Why is my QuickBooks download disabled?+
The validator lists the row and reason: usually a non-ISO date, an empty description, a zero or over-precise amount, or conflicting debit and credit values. Correct the editable row using the statement as evidence. The download unlocks as soon as the issues clear.
Is the four-column file just the general CSV with fewer headers?+
No. It uses QuickBooks’ documented Date, Description, Credit, Debit order, writes a positive value into only one money column per row, and leaves the other blank. The three-column version instead uses a signed Amount.
What should I check after importing?+
Choose the matching bank or credit-card account, review the first and last imported rows, check money-in versus money-out, and watch for transactions already brought in by a bank feed. Keep the original statement for reconciliation. For another accounting workflow, see the Xero CSV tool.