A tab-delimited file created from vendor database or IT department.
The sales file only needs 3 columns in the following order for the upload process.
DES Customer #: These are the customer numbers currently on the Contract Sales Reporting Worksheet.
Customer Name: This is used as a reference for any processing errors.
Sales Amount: Sales dollars rounded to the nearest dollar.
The file upload option is available on the “Select Contract & Reporting Period” screen. If the Import sales from file option is selected, you will be able to select your file from your personal computer or network drive. After the file has been uploaded and processed, you will be able to review, edit and submit the sales report.
The Contract Sales Reporting Worksheet can be found on the Login Screen (Figure 1). The worksheet lists all customer/organizations to be used as a tool to gather customer/organization sales data offline before logging on and reporting sales.
To create a tab-delimited file using the Excel Contract Sales Reporting Worksheet, go to to the Contract Sales Reporting System login page and choose the link to the Contract Sales Reporting Worksheet.
Figure 1. Contract Sales Reporting System Login Screen.
Sales Reporting Worksheet
Choose the appropriate Reporting Year and Report Quarter, and then click View Report.
To export the report to an Excel document, click the dropdown box, Select a format.
Choose Excel, and then click Export (Figure 2).
Figure 2. Contract Sales Reporting Worksheet.
A File Download dialog box will appear. Choose Save (Figure 3).
Note: The document may take some time to load.
Figure 3. File Download dialog box.
Rename, choose a location to save the document and then click Save (Figure 4).
Figure 4. Save As dialog box.
Enter Sales Data into Excel File
Open the saved Excel file and enter your sales data in the appropriate column (Figure 5).
To import the document, it must be in the format displayed in Figure 5.
The columns with Customer Number, Customer Name and Sales are required.
Sales amounts must be entered to the nearest dollar.
Figure 5. Enter sales data into saved Contract Sales Reporting Worksheet Excel file.
If the file did not load, see instructions for Error Uploading Report File.
Click Process Sales to begin processing.
Note: The sales processing may take a few minutes. Please wait for message to confirm that the upload processing is complete. Please do not attempt to navigate to other screens whilt the file is being processed.
Figure 10. Processing uploaded sales file.
Successful File Upload and Processing
After processing the sales file, as message will provide status and processing information (Figure 11). At this time, the sales data has been uploaded and processed. You must still review and submit the sales report.
Click Review Sales (Figure 11).
Figure 11. Successful file uploading and processing message from importing sales data.
Review Sales Screen
Review your sales data. Use the buttons below to review, edit and submit your sales report (Figure 12).
Click Submit Sales Report, to complete your sales reporting.
Figure 12. Contract Sales Reporting System review sales.
Error Uploading Report File
If a file fails to import correctly, an error message will appear. The following are possible reasons the file failed to upload and process correctly:
File is not saved in a tab-delimeted file. Re-save file in proper tab-delimited format and repeat file import process.
File is not in the proper format of Customer #, Customer Name and Sales. Reformat the file and repeat import process.
Sales amount data not in correct format. Open file in Excel, right click on sales amount column and select Format Cells. Select Number from the category options and change decimal places to zero. Click Ok. Save file again in tab-delimited format. Repeat file import process.