LedgerMatch
Chase Bank CSV Export: Column Layout & Reconciliation Guide
Chase exports look clean but hide a critical trap — pending transactions appear in the file without a Posting Date, causing silent date errors that QuickBooks rejects entirely. The redundant "Details" and "Type" columns also confuse most import tools into mapping the wrong field as your amount. This tool reads only Posting Date, Description, and Amount, automatically skipping the noise columns and stripping pending rows before you download.
CSV format at a glance
- Date format: MM/DD/YYYY
- Amount layout: one signed amount column
- Negative values are debits (money out). Positive values are credits (money in).
Where to export the CSV
Sign in → Accounts → select account → Download Account Activity → CSV
Common import issues
- Pending transactions appear in the export but have no Posting Date — they will cause blank-date errors. Always export after all transactions are fully posted.
- The "Details" column and the Amount sign both encode debit/credit. Use Amount sign only; the Details column causes confusion if mapped directly.
- Long descriptions may be truncated at 50 characters for some transaction types (e.g. wire transfers). Cross-reference your Chase activity page if a description looks cut off.
- Chase exports up to 7 years of history. Narrow your date range before downloading to avoid importing duplicate transactions from prior periods.
Useful setup tips
- Map "Posting Date" as your Date column, "Description" as Description, and "Amount" as Amount. Ignore Details, Type, Balance, and Check #.
- If your ledger uses a different sign convention (positive for all), use LedgerMatch's sign-flip option during column mapping.
- Run the export 2–3 business days after month-end to ensure all pending transactions have posted.