QuickBooks CSV Date and Amount Format Requirements | Complete Import Guide

QuickBooks CSV Format Overview

QuickBooks Online supports CSV imports for bank transactions, but has strict formatting requirements that often conflict with how payment processors like Stripe and PayPal export their data.

The critical requirement: QuickBooks Online accepts ONLY 3-column or 4-column CSV files for bank transaction imports. Files with more columns will be rejected with an error.

QuickBooks 3-Column Format (Recommended)

Column 1: Date (MM/DD/YYYY)

Column 2: Description (plain text)

Column 3: Amount (positive for deposits, negative for fees/expenses)

Example QuickBooks-Compatible CSV:

Date,Description,Amount
01/15/2025,Stripe payment from John Smith,96.80
01/15/2025,Stripe processing fee,-3.20
01/16/2025,PayPal sale - Order #12345,48.25

This format is simple, intuitive, and matches how most bank statements appear. However, getting your Stripe and PayPal data into this format requires understanding several critical formatting rules.

Date Format Requirements

Required Format: MM/DD/YYYY

QuickBooks Online expects dates in MM/DD/YYYY format. This is the US-standard date format and the most reliable choice for QBO imports.

Format	Example	Works?
MM/DD/YYYY	01/15/2025	✓ Yes (recommended)
M/D/YYYY	1/5/2025	⚠ Maybe (not guaranteed)
YYYY-MM-DD	2025-01-15	⚠ Maybe (not guaranteed)
ISO 8601	2025-01-15T10:30:25Z	✗ No
DD/MM/YYYY	15/01/2025	✗ No (US QBO)

Date Formatting Rules

Use leading zeros: 01/05/2025, not 1/5/2025 (more reliable)
Use 4-digit years: 2025, not 25
No day-of-week labels: Not "Mon 01/15/2025" or "1/15/2025 (Tuesday)"
No time components: Date only, no hours/minutes/seconds
Consistent formatting: Use the same format for every row in the file
Date cell only: The cell should contain ONLY the date, no other text

Why Stripe Dates Don't Work

Stripe exports dates in ISO 8601 UTC format like 2025-01-15T10:30:25Z. This international standard includes date, time, and timezone information. QuickBooks cannot parse this format and will reject the import. The date must be converted to 01/15/2025 before importing.

Amount Format Requirements

Required Format: Numeric with Period Decimal

QuickBooks expects amount values to be plain numbers with a period decimal separator and exactly 2 decimal places.

Format	Example	Works?
Period decimal, 2 places	96.80	✓ Yes
Negative with minus sign	-3.20	✓ Yes
Large amount, no commas	1500.00	✓ Yes
With currency symbol	$96.80	✗ No
With thousands comma	1,500.00	✗ No
Parentheses for negative	(3.20)	✗ No
Comma decimal separator	96,80	✗ No (US QBO)

Amount Formatting Rules

Use period (.) as decimal separator: 96.80, not 96,80
Always include 2 decimal places: 96.80, not 96.8 or 96
Remove all commas: 1500.00, not 1,500.00
Remove currency symbols: 96.80, not $96.80
Use minus sign for negatives: -3.20, not (3.20) or {3.20}
No spaces or extra characters: Just the number and optional minus sign

Positive vs Negative Amounts

In the 3-column QuickBooks bank transaction format, the sign of the amount determines whether it's money IN or money OUT:

Positive Amounts (+)

Money deposited to your bank account

• Revenue from sales
• Stripe/PayPal net deposits
• Refunds received
• Customer payments

Negative Amounts (-)

Money deducted from your bank account

• Processing fees
• Refunds issued to customers
• Chargebacks
• Business expenses

Example: Stripe $100 Charge

A $100 Stripe charge with $3.20 fee would appear as TWO transactions:

Date,Description,Amount
01/15/2025,Stripe payment from John Smith,96.80
01/15/2025,Stripe processing fee,-3.20

Net effect: $96.80 deposited to your bank account ($100.00 - $3.20 = $96.80)

Common Formatting Errors

Here are the most common reasons QuickBooks CSV imports fail, and how to fix them:

Error: "Columns aren't mapped correctly"

Cause: Your CSV has more than 4 columns, or column headers don't match expected names.

Fix: QuickBooks only accepts 3 or 4 columns for bank transactions. Stripe exports have 9+ columns (balance_transaction_id, created_utc, available_on_utc, currency, gross, fee, net, reporting_category, description). You must reduce to just Date, Description, Amount.

Error: "Date format not recognized"

Cause: Dates are in ISO 8601 format (2025-01-15T10:30:25Z) or another unsupported format.

Fix: Convert all dates to MM/DD/YYYY format. Remove time components and timezone information. Use leading zeros for single-digit months and days.

Error: "Invalid amount format"

Cause: Amounts contain currency symbols ($), thousands separators (,), or use comma decimal separators.

Fix: Strip all currency symbols and commas. Use period (.) as decimal separator. Format to exactly 2 decimal places. Use minus sign (-) prefix for negative values.

Error: File size too large

Cause: CSV file exceeds QuickBooks' 350 KB limit.

Fix: Split your CSV into multiple files, each under 350 KB. Import them one at a time. This typically happens with 3+ months of high-volume transaction data.

Warning: Transactions import but amounts are wrong

Cause: Fee sign convention mismatch. Stripe fees are positive (+3.20), but QuickBooks expects fees as negative (-3.20).

Fix: Stripe stores fees as positive numbers in their CSV (the fee is subtracted from gross). When converting to QuickBooks format, fees must be negated to represent money OUT. This is critical for accurate bookkeeping.

Stripe and PayPal Format Differences

Both Stripe and PayPal export data that is incompatible with QuickBooks, but for different reasons:

Stripe Balance Transactions CSV

Date Format:

2025-01-15T10:30:25Z

ISO 8601 UTC with timezone

Columns:

9+ columns including: balance_transaction_id, created_utc, available_on_utc, currency, gross, fee, net, reporting_category, description

Fee Convention:

Fees are positive (+3.20)

Formula: Net = Gross - Fee

Amount Format:

Period decimal, no currency symbols (100.00)

PayPal Activity Download CSV

Date Format:

1/15/2025

M/D/YYYY (closer to QBO format)

Columns:

41 total columns including: Date, Time, TimeZone, Name, Type, Status, Currency, Gross, Fee, Net, and 31 others

Fee Convention:

Fees are negative (-3.93)

Formula: Net = Gross + Fee

Amount Format:

Period decimal, no currency symbols (125.00)

Key Insight: Fee Sign Convention

One of the most confusing aspects of converting payment CSVs to QuickBooks format is the fee sign convention:

Stripe: Stores fees as positive (+3.20). Formula: $100.00 - $3.20 = $96.80
PayPal: Stores fees as negative (-3.93). Formula: $125.00 + (-$3.93) = $121.07
QuickBooks: Expects fees as negative (-3.20) in the Amount column to represent money OUT

When converting Stripe to QuickBooks, you must negate the fee (+3.20 becomes -3.20). When converting PayPal to QuickBooks, the fee sign is already correct.

Comparison: Same $100 Transaction

Stripe CSV Format

gross: 100.00
fee: 3.20
net: 96.80

PayPal CSV Format

Gross: 100.00
Fee: -3.20
Net: 96.80

QuickBooks Format

Row 1: 96.80
Row 2: -3.20
(Two separate transactions)

How TrestleFinance Handles Formatting

TrestleFinance automatically handles all the formatting conversions required to go from Stripe/PayPal CSVs to QuickBooks-compatible format:

Date Conversion

Automatically converts Stripe's ISO 8601 UTC timestamps (2025-01-15T10:30:25Z) to QuickBooks MM/DD/YYYY format (01/15/2025). Handles PayPal's M/D/YYYY by padding with leading zeros.

Fee Sign Normalization

Detects whether fees are positive (Stripe) or negative (PayPal) and normalizes them to QuickBooks' expected format (negative for money OUT). Stripe's +3.20 becomes -3.20. PayPal's -3.93 stays -3.93.

Column Reduction

Strips down Stripe's 9+ columns and PayPal's 41 columns to QuickBooks' required 3 columns: Date, Description, Amount. Preserves essential transaction details in the Description field.

Amount Formatting

Ensures all amounts use period decimal separators, exactly 2 decimal places, no currency symbols, and no thousands separators. Validates that all numbers are properly formatted before export.

Transaction Splitting

Breaks each payment into TWO QuickBooks transactions: one for the net deposit (positive) and one for the fee (negative). This matches how QuickBooks expects bank transaction data and makes categorization easier.

Description Sanitization

Removes commas, newlines, and special characters from descriptions that could break CSV format. Limits description length to 250 characters for QuickBooks compatibility.

The Result: Import-Ready CSV

After TrestleFinance processes your Stripe or PayPal CSV, you get a file that:

✓ Has exactly 3 columns (Date, Description, Amount)
✓ Uses MM/DD/YYYY date format with leading zeros
✓ Contains properly formatted amounts with period decimals and 2 decimal places
✓ Has negative values for fees and positive values for deposits
✓ Contains clean descriptions without commas or special characters
✓ Is ready for direct import to QuickBooks Online with zero manual editing

Ready to Convert Your CSV Files?

Upload your Stripe or PayPal CSV and get a QuickBooks-compatible file in seconds.

Try TrestleFinance Free