LedgerMatch
U.S. Bank CSV Export: Column Layout & Reconciliation Guide
U.S. Bank hides the real merchant name in the Memo column, not the Name column — so bookkeepers who map Name as their description end up with generic labels like "PURCHASE" or "ACH DEBIT" instead of actual vendor names. Check transactions store the check number in Memo too, which gets lost if the column is skipped. This tool maps Memo as the primary description field and falls back to Name only when Memo is blank.
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 → My Accounts → select account → Export → Spreadsheet (Excel/CSV)
Common import issues
- U.S. Bank splits description across two fields: Name and Memo. The Name field is often a generic category like "PURCHASE" while Memo has the actual merchant name. Map Memo as your primary description.
- U.S. Bank limits CSV exports to 12 months. For older data, use the statement PDF or contact support.
- Check transactions show the check number in the Memo field, not in a dedicated column.
Useful setup tips
- Map Memo → Description for richer merchant names. If Memo is blank for some rows, fall back to Name.
- Date, Amount, and Memo are the three columns you need. Transaction type is redundant with Amount sign.