Step 1: Understand the Rejection Criteria 0:00
- Recognize that UnitedHealthcare files can be rejected based on the date in cell D2.
- The system checks if the date falls within the current month.
Step 2: Identify the Current Date 0:11
- Confirm the current date (e.g., January 1st, January 6th).
- Note that any date in January (1-1 to 1-31) will lead to a rejection.
Step 3: Change the Date in Cell D2 0:32
- Modify the date in cell D2 to a future date (e.g., change it to 2-2).
- Ensure the new date does not fall within the rejection criteria.
Step 4: Save Changes 0:46
- Save the changes made to the file after adjusting the date.
Step 5: Upload to ComTrack 0:54
- Upload the modified file to ComTrack.
- Confirm that the file is now accepted as UnitedHealthcare.
Cautionary Notes
- Be cautious of duplicate entries that may arise from this process.
- Check file management later to remove any duplicates if necessary.