CSV health check
Find missing columns, invalid amounts, ambiguous dates and incomplete source rows.
Source rows
3- Errors
- 0
- Review findings
- 0
- Rows without errors
- 3
Illustrative calculation · AUD where amounts are shown.
| Row | Column | Original value | Finding | Severity |
|---|---|---|---|---|
| 0 | All checked fields | No structural or value findings in this file. | Passed |
See how the number is made.
Recognised headers include Reference or Invoice, Date or Invoice date, Staff or Employee, Item or Description, and Amount or Total. Category, Tax and Reported commission are optional. Unknown categories and absent tax are shown for review. This checks structure and values, not whether the source report is complete.
The working
Each row is checked against the named source fields; findings retain the original row and column.
The sample contains three valid source rows. Replacing 2026-09-21 with 04/05/2026 asks you to choose a numeric date convention.
- Detected separator: comma. Row numbers count CSV records, with the header as row 1; a quoted field can span physical lines.
- A clean file check does not establish that the source report is complete or that the calculation assumptions are correct.
Use the calculation basis and rules you have agreed. A tool result is a working record; it does not establish an entitlement or send a payment.