Statement to QuickBooks CSV

To import credit card statements into QuickBooks Online you need a clean CSV — correct columns, date format and sign convention. This guide shows how to make a QuickBooks-ready CSV from a statement PDF — free and private.

Step 1: PDF → Excel → CSV

1. Free converter kholo → card issuer select do → upload the statement PDF
2. Download the Excel file (Date, Description, Debit, Credit)
3. Excel me File → Save As → CSV (UTF-8)

Step 2: QuickBooks CSV Format

QuickBooks Online ka bank-import CSV format:

Date,Description,Amount
01/15/2026,Amazon,129.99
01/20/2026,Payment,500.00

Or the 4-column format works too: Date, Description, Debit, Credit — map them with QuickBooks' mapping wizard.

Step 3: Import in QuickBooks Online

1. QuickBooks Online → Banking → File Upload
2. CSV file select do
3. Mapping: Date → Date, Description → Description, Debit → Debit, Credit → Credit
4. Account chuno (Amex liability account ya credit card account)
5. Preview check do → Import

Step 4: Reconcile

Import ke baad Accounting → Reconcile me jao, statement ending balance daalo aur transactions match do — difference zero hone par Finish. Poori detail: Reconcile Amex in QuickBooks.

Common Import Mistakes

• Debit/Credit ulta mapping — preview me hamesha check do
• Duplicate import — ek mahina ek baar import do
• Date format — QuickBooks uses the US format (MM/DD/YYYY); if your statement is DD/MM, convert it first
• Fees aur interest rows miss mat do

Frequently Asked Questions