LedgerMatch

Discover Card CSV Export: Column Layout & Reconciliation Guide

Discover has two problems Amex does not share. First, its date column is named "Trans. Date" (with a period), and some CSV parsers reject column names containing punctuation, leaving the date field entirely blank. Second, Discover includes a Post Date alongside the Trans. Date and a Category column — neither needed for reconciliation — that bloat the file and cause positional mapping tools to land on the wrong columns. This tool normalises "Trans. Date" to "Date", drops the extra columns, and flips the reversed sign convention so Discover data imports cleanly.

CSV format at a glance

  • Date format: MM/DD/YYYY
  • Amount layout: one signed amount column
  • Positive values are charges (money out). Negative values are payments or credits. Same reversed convention as Amex.

Where to export the CSV

Sign in → Manage → Download Center → Download Transactions → CSV

Common import issues

  • Discover's date column is named "Trans. Date" — with a period. Some CSV parsers treat the period as a separator and misread the column name, leaving every date blank on import.
  • Discover uses a reversed sign convention — charges are positive. This is the same direction as Amex but the reason is independent: Discover and Amex each make this choice separately in their export systems.
  • Cashback rewards and statement credits appear as negative Amount rows. After sign-flipping they become positive — a credit to your account. Exclude them from reconciliation if your ledger does not record rewards.
  • Discover exports by date range (up to 7 years), not by billing cycle. This is the opposite of Amex, which is statement-scoped.

Useful setup tips

  • Map Trans. Date → Date, Description → Description, Amount → Amount. Flip the sign if reconciling against a debit-negative ledger.
  • Skip Post Date and Category columns — they add noise without value for reconciliation.
  • When filtering cashback or rewards rows, look for "CASHBACK BONUS" or "REWARDS REDEMPTION" in the Description column.

Explore related resources