What to check in the source export
Card activity can include merchant descriptions, foreign-currency amounts, refunds, settlement payments and fees. The issuing bank determines the report layout.
Guide: find your card statementUpload an existing CSV or XLSX transaction export, verify amounts and columns, and convert it for accounting.
Important distinction: American Express merchant/acquiring reports can contain transaction details exported as CSV/XLS. This does not establish that consumer card statements use the same CSV layout. Use the actual export from your card account.
Official provider documentationDrop CSV or XLSX files here
One CSV shows a transaction preview. Multiple CSV/XLSX files form a batch with a file list, verified transaction counts and total credits. Successful exports can be downloaded together as a ZIP. MT940/CAMT.053 require account details and balances per file.
Card activity can include merchant descriptions, foreign-currency amounts, refunds, settlement payments and fees. The issuing bank determines the report layout.
Guide: find your card statementFor QuickBooks, review date, description, amount and debit/credit mapping; the input bank's export is not necessarily the same as the target accounting import.
American Express: CSV → QBO
CSV/XLSX: Transactions are already in rows. Check the actual date, amount, description and any separate debit/credit columns.
For accounting imports, date, amount, sign and description must match the selected target profile.
For card statements, review merchant narratives, refunds, foreign currencies, fees and statement payments to avoid duplicate counting.
Use a transaction or statement CSV exported by your bank or card issuer. A PDF statement requires a separate workflow.
Dates, debit/credit signs, currencies, fees and account identifiers vary by report. Check unmatched columns and missing statement balances.