Docs · File formats
Expense Claim Review CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Employee | Yes | employee, employee name, employee full name, full name, submitter, submitted by | Dana Whitfield |
| Employee ID | employee id, employee number, employee no, emp id, employee code, staff id | E1001 | |
| Manager / approver | manager, manager name, approver, approver name, approved by, reports to | Priya Shah | |
| Report ID | report id, report number, report key, report name, report, expense report | ER-3101 | |
| Expense ID | expense id, transaction id, entry id, line id, item id, entry key | TX-881201 | |
| Transaction date | Yes | transaction date, expense date, date, date of expense, purchase date, txn date | 2026-09-08 |
| Merchant | merchant, merchant name, vendor, vendor name, payee, supplier | Marriott Chicago Downtown | |
| Amount | Yes | amount, expense amount, total, total amount, claimed amount, amount claimed | 289.00 |
| Category / expense type | expense type, category, expense category, expense type name, parent expense type, spend category | Hotel | |
| MCC | mcc, merchant category code, mcc code | 7011 | |
| Payment type | payment type, payment method, paid by, funding source, payment, card type | Corporate Card | |
| Reimbursable | reimbursable, is reimbursable, reimbursable (y/n), out of pocket | Yes | |
| Personal | personal expense, personal, is personal, personal (y/n) | No | |
| Receipt ID | receipt id, receipt number, receipt no, receipt #, receipt ref, receipt reference | F-77812 | |
| Country | country, country code, expense country, location country, transaction country, merchant country | US | |
| Distance | distance, business distance, distance claimed, claimed distance, total distance, distance travelled | 120 | |
| Distance unit | distance unit, mileage unit, unit of measure, uom, unit, units | mi | |
| Route distance | route distance, calculated distance, map distance, mapped distance, expected distance, system distance | 118 | |
| Round trip | round trip, roundtrip, return trip, return journey | No | |
| From | origin, from, from location, start location, start address, start | Chicago office | |
| To | destination, to, to location, end location, end address, end | Milwaukee client site | |
| Mileage rate | mileage rate, rate per mile, rate per km, rate per kilometre, rate per kilometer, rate | 0.76 | |
| Nights | nights, number of nights, no of nights, room nights, hotel nights, nights stayed | 1 | |
| Attendees | attendees, number of attendees, no of attendees, attendee count, guests, headcount | 1 |