LedgerMatch
USAA CSV Export: Column Layout & Reconciliation Guide
USAA exports two description fields in every row — a cleaned "Description" and a raw "Original Description" full of payment-processor codes like "POS PURCHASE TERMINAL 4819". Choosing the wrong one fills your ledger with unreadable strings. USAA also includes Pending transactions in the same file as cleared ones, creating false unmatched exceptions. This tool uses the cleaned Description field and removes Pending rows before download.
CSV format at a glance
- Date format: MM/DD/YYYY
- Amount layout: one signed amount column
- Negative values are debits. Positive values are credits.
Where to export the CSV
Sign in → Accounts → select account → Download Transactions → CSV
Common import issues
- USAA includes both "Description" (cleaned) and "Original Description" (raw network string). Use Description for reconciliation — Original Description is often a code string like "POS PURCHASE TERMINAL 4819 AMAZON".
- Filter the Status column to "Cleared" before uploading. Pending transactions will cause false unmatched exceptions.
Useful setup tips
- Map Date → Date, Description → Description, Amount → Amount. Ignore Original Description, Category, and Status.
- USAA's cleaned Description field is among the best in the industry — merchant names are readable and rarely need manual correction.