Free during beta · No sign-up

Bank statement to QuickBooks CSV

A QuickBooks-ready CSV — three columns, Date, Description, Amount, money out negative — generated from your reviewed transactions, not the raw extraction.

Choose a bank-statement PDF Download a sample QuickBooks CSV

The sample is a synthetic statement — no real bank, person, or account — and the excerpt shown is taken from that exact file, byte for byte.

Sample QuickBooks CSVstatementstudio-sample-quickbooks.csv · synthetic data

Date,Description,Amount01/05/2026,BACS SALARY ACME LTD MAY PAY,3250.0002/05/2026,CARD PURCHASE TESCO STORES 4381,-46.8203/05/2026,ATM WITHDRAWAL HIGH STREET CASH MACHINE REF 778221,-80.0004/05/2026,DIRECT DEBIT CITY ENERGY,-124.40

The first lines of the sample file — the three-column header QuickBooks Online’s manual CSV upload expects.

What you download

Three columns, nothing to reverse-engineer.

QuickBooks Online reads a 3-column transaction CSV. This export writes exactly that shape — the conventions below are the file's whole contract.

Date: Slash-separated dates — dd/mm/yyyy, or mm/dd/yyyy when the statement itself is US-formatted. Intuit’s guidance asks for one consistent format per file and recommends dd/mm/yyyy.
Description: The reviewed description, flattened to a single line and protected against spreadsheet-formula execution.
Amount: One signed column: money in positive, money out negative. A value of exactly zero is left blank — QuickBooks’ formatting guidance asks for blank cells, not 0.00.
Deliberately absent: No currency, balance, source-page, or review-status columns — the 3-column upload doesn’t read them. If you want the full documented detail beside your books, keep the generic CSV too.

Reviewed, then exported

Convert a bank statement to QuickBooks — with the checking done first.

Every row is extracted beside its source page and checked against the statement's balances before it becomes a line in the file. Here is one reviewed row, written the way QuickBooks' CSV upload reads it:

Date	Description	Amount	Source page
4 May 2026	DIRECT DEBIT CITY ENERGY	(£124.40)	1

04/05/2026,DIRECT DEBIT CITY ENERGY,-124.40

Step through the review on sample data How the whole flow works

What this file is — and isn’t

A file you import yourself. Nothing is linked.

StatementStudio writes a file; you upload it inside QuickBooks Online using Intuit’s manual upload flow. There is no account link, no feed, and nothing keeps running between StatementStudio and your books after you download. QuickBooks shows its own import preview before anything is committed.

Importing into QuickBooks Online

Download your reviewed QuickBooks CSV.
In QuickBooks Online, open Bank transactions and choose Upload from file.
Select the CSV and match the Date, Description, and Amount columns when prompted.
Review the transactions QuickBooks shows, then confirm the import.

Intuit documents the format and the flow in Format CSV files to get bank transactions into QuickBooks and Manually upload transactions into QuickBooks Online.

Stated limits

When this export refuses to generate.

These are designed boundaries, not bugs — the export refuses rather than writing a file QuickBooks would mishandle.

Over 1,000 rows: QuickBooks documents a 1,000-row limit for manual CSV uploads, so this export refuses to generate a longer file. Split a longer statement into more than one job.
More than one currency: The 3-column format has no currency column, so a mixed-currency statement can’t be represented — the export refuses rather than importing unlabelled amounts.
Missing dates or amounts: Every row needs a date and a signed amount. If a reviewed row lacks either, this export stays unavailable until the row is resolved in review.

Review your transactions before importing, and check the import preview in your accounting software.

Other formats

Need a different shape?

OFX: QuickBooks Online’s file upload also accepts OFX — a single statement file with stable transaction IDs. Bank statement to OFX
Xero CSV: Books live in Xero instead? The same reviewed rows export in Xero’s four-column shape. Bank statement to Xero CSV
Everything else: The bank statement converter lists every output, and the generic CSV keeps all documented columns.

Questions

About the QuickBooks CSV output

Is this a QuickBooks Online CSV or a QBO file?

CSV. QuickBooks Online accepts a manual CSV upload with Date, Description, and Amount columns, which is exactly what this export produces.

Why don’t you offer a QBO file?

QBO files need bank-issued identifiers that a statement PDF doesn’t contain, so we don’t generate them. QuickBooks imports our CSV instead.

Is there a row limit?

Yes — QuickBooks documents a 1,000-row limit for manual CSV uploads, so this export refuses to generate a file above that. Split a longer statement into more than one job.

How are debits and credits shown?

One signed Amount column — money out is negative. Cells that would be exactly zero are left blank, matching QuickBooks’ CSV formatting guidance.

Do you support mixed-currency statements?

No — if a statement shows more than one currency, this export can’t be generated, because the QuickBooks CSV format doesn’t carry a currency column.

Free during beta

Convert a bank statement to QuickBooks CSV — and check it first.

Choose a bank-statement PDF See a sample conversion