QuickBooks Online 3-Column CSV Template
The QBO 3-column format is the simplest way to import bank transactions into QuickBooks Online. It uses just three columns — Date, Description, and Amount — where positive values are credits and negative values are debits. Upload your bank statement PDF and we'll generate this format automatically.
Files are validated locally, split into chunks, then uploaded directly to secure storage.
Format: Date, Description, Amount · Negative = debit, Positive = credit
Drag & drop PDF statements
Click to choose files · Bulk upload supported
PDF only · Up to 100 MB and 1,000 pages per file
QBO 3-Column Format Explained
The 3-column CSV is one of QuickBooks Online's accepted bank transaction import formats. Here's exactly how each column works.
Date column
Transaction date. QuickBooks import files should use one consistent date format throughout. Exact Statement defaults QBO exports to MM/DD/YYYY and lets you switch if your workflow requires a different format.
Description column
Free-text field for the transaction description or memo. This appears as the transaction description in your QBO register. Special characters are sanitized to avoid encoding issues.
Amount column
A single numeric value. Negative amounts (e.g., -1250.00) represent debits (money out). Positive amounts (e.g., 500.00) represent credits (money in). No currency symbols or thousands separators.
Sample: 3-column CSV
Date,Description,Amount | 01/15/2025,Stripe Payout,1280.45 | 01/16/2025,Office Rent,-1450.00 | 01/17/2025,AWS Invoice,-372.88 | 01/18/2025,Client Payment,950.00
When to use 3-column
Use the 3-column format when you want the simplest possible import. It works for all QBO bank and credit card accounts. If you prefer separate Credit and Debit columns, use the 4-column format instead.
Auto-generated from PDF
Upload your bank statement PDF above and select 'QBO 3-column' as the output format. We'll extract transactions and format them exactly as QBO expects — no manual template filling needed.
QBO 3-Column CSV Template — Frequently Asked Questions
A QBO 3-column CSV has a single header row (Date,Description,Amount) followed by one row per transaction. Example: Date,Description,Amount followed by 01/15/2025,Stripe Payout,1280.45 then 01/16/2025,Office Rent,-1450.00. Negative amounts are debits, positive amounts are credits.
QuickBooks Online import files should keep the same date format on every row. Exact Statement defaults QBO exports to MM/DD/YYYY, and you can switch the date format if your workflow requires a different convention.
The 3-column format (Date, Description, Amount) is simpler and uses a single Amount column where the sign determines debit vs credit. The 4-column format (Date, Description, Credit, Debit) separates debits and credits into two columns. Both are accepted by QBO — use whichever you find easier to review.
In QBO, go to Banking (or Transactions > Bank transactions). Click the dropdown next to 'Link account' and select 'Upload from file'. Choose the CSV, select the target bank account, confirm the column mapping (Date, Description, Amount), and click Import. Review the preview, then confirm.
Yes — that's exactly what Exact Statement does. Upload your bank statement PDF using the tool above, select 'QBO 3-column' as the output format, preview the extracted transactions, and download. No manual template filling required.
Common causes: (1) Inconsistent dates within the same file. (2) Currency symbols or thousands separators in the Amount column — amounts must be plain numbers like -1450.00. (3) Extra or missing columns. (4) Blank rows or extra header rows. Our converter avoids these issues by formatting the output specifically for QBO.
Have another question? Email support@exactstatement.com.
Generate Your QBO 3-Column CSV Now
Upload a PDF bank statement and get a QuickBooks Online-ready 3-column CSV in minutes — Date, Description, Amount, formatted correctly.