QuickBooks Online 4-Column CSV Template
The QBO 4-column format separates credits and debits into their own columns — Date, Description, Credit, and Debit. Some bookkeepers prefer this layout for easier visual verification. 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, Credit, Debit · Each row uses only one of Credit or Debit
QBO 4-Column Format Explained
The 4-column CSV splits money-in and money-out into separate columns. Here's how each column works and when to choose this format over 3-column.
Date column
Transaction date. Most QuickBooks Online CSV imports use MM/DD/YYYY. Exact Statement defaults QBO exports to MM/DD/YYYY and lets you switch if your regional workflow requires a different format.
Description column
Free-text field for the transaction description or memo. Appears as the transaction description in your QBO register. Special characters are sanitized.
Credit column (money in)
Positive numeric value for deposits and incoming payments. Leave blank (empty) for debit transactions. No currency symbols — just a plain number like 1280.45.
Debit column (money out)
Positive numeric value for withdrawals and outgoing payments. Leave blank (empty) for credit transactions. Enter as a positive number (e.g., 1450.00, not -1450.00).
Sample: 4-column CSV
Date,Description,Credit,Debit | 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 4-column
Choose 4-column when you want credits and debits in separate columns for easier visual verification. This format is especially useful when reviewing imported transactions before reconciliation.
QBO 4-Column CSV Template — Frequently Asked Questions
A QBO 4-column CSV has a header row (Date,Description,Credit,Debit) followed by one row per transaction. For deposits, the Credit column has a value and Debit is blank. For withdrawals, the Debit column has a value and Credit is blank. Example: 01/15/2025,Stripe Payout,1280.45, (credit) and 01/16/2025,Office Rent,,1450.00 (debit).
No. In the 4-column format, both Credit and Debit values are positive numbers. The column itself determines the direction — Debit means money out, Credit means money in. Entering negative values in the Debit column may cause QBO to misinterpret the transaction.
The 3-column format uses a single Amount column where negative = debit and positive = credit. The 4-column format separates these into two columns (Credit and Debit), each containing only positive values. Both are accepted by QBO. The 4-column format is preferred by bookkeepers who want clearer debit/credit visibility at a glance.
In QBO, go to Banking > Upload from file. Select your CSV, choose the target bank account, and map the columns: Date, Description, Credit, and Debit. QBO will auto-detect the format in most cases. Preview the transactions and confirm the import.
Yes. Upload your bank statement PDF using the tool above and select 'QBO 4-column' as the output format. The converter extracts transactions and splits amounts into separate Credit and Debit columns automatically.
Common causes: (1) Both Credit and Debit have values on the same row — only one should be filled per transaction. (2) Negative values in the Debit column — use positive numbers only. (3) A date format your QuickBooks import flow does not expect — most QBO imports use MM/DD/YYYY. (4) Extra columns or blank rows. Our converter handles all of these formatting rules automatically.
Have another question? Email support@exactstatement.com.
Generate Your QBO 4-Column CSV Now
Upload a PDF bank statement and get a QuickBooks Online-ready 4-column CSV — Date, Description, Credit, Debit — formatted correctly.