An Excel file is validated against the selected transaction type. Expected formats of an Excel file for different transaction types are available here Supported Excel file formats. The case when this validation fails is described below.
Step 1. Click [...] button.
A standard Windows Select dialog opens.
Step 2. Choose an Excel file in either xlsx or xls format.
Greenrain Submission analyses the file data to identify expected transaction type. When done, Transaction type box fills with its value.
Step 3. Click Generate E-Claim Transactions.
Greenrain Submission assumes the selected Excel file contains data for the selected transaction type and validates its structure accordingly. If any worksheet or column is missing, the following error dialog appears.
Step 4. Click Yes.
A dialog with found errors appears. Otherwise this workflow is stopped to allow user fixing found errors and start again.
Step 5. Click See expected Excel file format.
Supported Excel file formats page opens in browser. You can review expected data in an Excel file and download desired template.
Step 6. Click Close.
The dialog with found errors closes.