Article summary
Reconcile the actual TXT submission and original Facebook screening workbook by full phone number. Separate duplicate inputs, blank statuses, and genuinely missing rows.
Put the TXT file you actually submitted beside the original Excel export from the same job. Match on the complete phone number. Pasting by row position can misalign every result after the first missing row.
First, check what is visible
Confirm the job and download time. Clear filters and look for hidden rows or additional sheets. If a row is missing in a colleague's working copy, look in the original workbook. When the source contains the row, you can repair the copy or handover without running the screening job again.
Next, count the unique submitted numbers
Imagine 100 valid input lines, four of which repeat an earlier number. You have 96 unique numbers to reconcile. The workbook contains 95 matches and no extra numbers. That leaves one unmatched input. A second number that appears in Excel with a blank status belongs in a different group.
Keep both phone columns as text and make separate comparison columns in a verified common format. Include the country code where it applies. Use the complete value rather than its trailing digits. If two formats might refer to the same number but you cannot establish the match, set the pair aside for review.
Reconcile in both directions
- Input has a number and the export does not. Keep the number and job reference. Verify the submission and download. Recheck the affected number if needed.
- Export has a number the submission does not. Look for a mismatched file or formatting change. Resolve the source before writing the result back.
- Both contain the number, but the status is empty. Record that the row exists and the status is pending. Keep it separate from explicitly unregistered results.
The handover can show three figures. The submitted line count, the unique number count, and the number of matched results. Keep the exception list with the original files so the next person can pick up the specific rows instead of repeating the whole reconciliation.
