Revenue Schedule CSV Validator

Revenue schedule imports fail for predictable reasons. This validator catches them all before you hit “import”:

• Misnamed columns
• Inconsistent date formats
• Missing values
• Start dates that fall after end dates

1. Column detection — Automatically maps your headers to standard revenue schedule fields using 50+ common aliases (contract_id, total_value, start_date, etc.)
2. Data type validation — Checks every cell: amounts must be numeric, dates must be parseable, required fields must not be blank
3. Business logic checks — Start date must precede end date. Unusually long contracts (>5 years) are flagged. Zero or negative values trigger warnings.

Supports CSV and TSV files with auto-detected delimiters. Quoted fields and escaped characters are handled correctly.