LedgerMatch
KeyBank CSV Export: Column Layout & Reconciliation Guide
KeyBank places the Amount column before the Description column — the opposite of every other major US bank. Tools that assume the standard Date → Description → Amount order silently swap the two fields, leaving you with transaction descriptions full of dollar amounts and amount cells containing merchant names. This tool maps KeyBank columns by header name rather than position, so the non-standard order never causes a mismatch.
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 Activity → CSV
Common import issues
- KeyBank's column order is non-standard: Date, Amount, Type, Description. The Amount column comes before Description, which trips up tools that assume the standard Date → Description → Amount layout.
- KeyBank descriptions can be very short — often just "POS PURCHASE" or "ACH DEBIT". Cross-reference with the KeyBank app for full merchant names.
Useful setup tips
- In LedgerMatch's column mapper, verify each column manually — the non-standard column order can cause auto-detection to swap Amount and Description.
- Map Date → Date, Amount → Amount, Description → Description. Skip Transaction Type.