Expense Import CSV
Import expenses in bulk using a CSV file. Supports both per-vehicle and global (fleet-wide) expenses.Download a sample file: expense-import-sample.csv
Field Reference
| CSV Column | Required | Type | Description |
|---|---|---|---|
| date | Yes | date | Expense date (YYYY-MM-DD format) |
| category | Yes | text | Expense category (see list below) |
| description | Yes | text | Description of the expense |
| amount | Yes | numeric | Dollar amount (positive number) |
| vehicle | No | text | Vehicle name or plate (omit for global expenses) |
| vendor | No | text | Vendor/payee name |
Supported Categories
| Category | Description |
|---|---|
| maintenance | Oil changes, repairs, parts |
| insurance | Vehicle or fleet insurance |
| cleaning | Car washes, detailing |
| parking | Parking fees, garage rental |
| fuel | Gas or charging costs |
| registration | DMV registration fees |
| inspection | Safety/emissions inspections |
| software | Apps and subscriptions |
| communication | Phone, internet |
| marketing | Advertising, listings |
| supplies | Cleaning supplies, key copies |
| tolls | Toll expenses (manual entry) |
| depreciation | Vehicle depreciation |
| other | Anything else |
Parsing Rules
- Amount should be a positive number (no
$sign) - Date must be in
YYYY-MM-DDformat - Vehicle field is matched against existing vehicle names or license plates — if no match, the expense is created as a global expense
- Category must match one of the supported categories (case-insensitive)
- Empty rows are skipped