•Spreadsheet validation - The Receipt form validates the data using lists of values, date formats, field lengths and some other field level validation.
•Upload validation – The upload process will perform the worksheet validation above, as well as the validation within the API.
Data keyed directly into the worksheet (not via the Receipts forms) will be validated when it is uploaded. If you wish to check anything before it is uploaded, simply open the form. Fields with invalid data will be highlighted in red and mandatory fields will be yellow.
