How to Upload the Daily Cancel Report

1. Download the DCS Cancels/Extensions Sheet as CSV File.

2. On your CSV File, look for the first entry of the day and delete all previous entries but do not remove the first row with the header names, it is required! Delete all date, agent and notes columns as well. Final input will be looked like the photo below.

IMPORTANT: Make sure that you checked all entries, if the dates was encoded correct and the order numbers are not in the scientific format like 1.0E+09.

3. Save your CSV File on your desktop. The file format is default as CSV (Comma delimited), do not change it.

4. Login to Click Verify Portal https://portal.clickverify.xyz/admin

• Click menu button in top left corner
• Click Straight Sale Continuity Rebill report
• Once in report, click Batch CSV link

• Click Choose File > Select your saved CSV File > Click Upload

---

NOTES

1. Error message clearly states that there are invalid date/s on your CSV File. If you will encounter - look for the error, fix it and do re-upload.

2. It is advisable to do two batches of uploads for the whole shift coverage.