Timekeeping → payroll · identity review
Use this worksheet to connect each source employee record to the correct destination payroll record. Keep a versioned crosswalk and a separate list of unresolved matches, so an ID problem has an owner before the next transfer.
Bring: authorized source and destination rosters, employer/pay-group scope, effective dates and the receiving format’s current identifier rules.
Start the crosswalk reviewWork in an approved internal file. These checkboxes are a temporary reading aid; they do not save or approve a mapping.
For this worksheet, the review key is the source ID together with its employer/pay-group context and effective period. Write the destination’s required key and context explicitly. Do not assume an employee number is unique across every company or provider account.
Use a documented one-to-one relationship within that scope as the starting convention. If the provider supports separate employments or another legitimate relationship, document that rule and review those records separately. Never merge records because names match.
Select the text below, copy it and paste into an approved worksheet. Set ID columns to text before importing or entering IDs. Use sanitized examples on shared screens; keep actual employee information in approved systems.
Copying this header creates no records and submits nothing. The fields are a suggested review structure, not an import file specification.
Fictional worked example · one employer and pay group
Five source employment records are in scope for one transfer period. In this example, independent authorized roster evidence confirms the first two relationships. The next record is unmatched, and two others point to the same target.
| Source ID | Target ID | Finding | Disposition and action |
|---|---|---|---|
| 0017 | P041 | Evidence confirms this employment record. | Ready; retain evidence and reviewer. |
| 17 | P086 | Different record; keep 17 and 0017 as distinct identifiers. | Ready; preserve both exact keys. |
| 0248 | Unconfirmed | No verified target in the authorized roster. | Hold; payroll owner checks setup and identity. |
| 0402 | P099 | Target also assigned to source 0403. | Hold; investigate the collision. |
| 0403 | P099 | Same scoped target as source 0402. | Hold; resolve both relationships together. |
The manual check is 2 + 3 = 5 scoped source records. Matching this count does not prove identity accuracy. Resolve the three held records against authorized evidence, then save a new reviewed version; do not invent targets or delete records to make counts agree.
Keep the row on Hold. A blank is unknown, not zero and not permission to create a new employee. Ask the authorized destination owner to confirm setup, source identity and the correct receiving key. Record the evidence and next action.
Inspect the scoped source and destination rosters together. Check whether the cause is a transcription error, duplicated record, different employer context or legitimate separate employment. Hold affected relationships until the owner documents the resolution. Do not merge people or remove time entries from this worksheet.
Compare effective dates, the actual employment record and provider rules. An inactive record may still have authorized final hours; a rehire may use a different record. Route the exception to the payroll owner rather than silently excluding hours, reactivating a record or reusing an old key.
Return to the original authoritative export. Preserve identifiers as text before spreadsheet conversion. Do not add zeros or strip spaces, punctuation or prefixes based on appearance; document any transformation required by the receiving specification and test its actual output.
This is a manual identity-review worksheet, with no matching algorithm, approval automation or calculated score. The unit counted in the example is a scoped source employment record, not necessarily a distinct person or an import detail row. No denominator, percentage threshold or rounding rule is used.
If no records are in scope, record that outcome and have the scope reviewed; do not claim a successful mapping rate. Missing scope, unknown targets and contradictory evidence remain unresolved. Retain every in-scope record as Ready, Hold or an explicitly authorized exclusion so the review can be traced.
Before changing production settings, use your provider’s supported test or preview process and check the accepted destination records. After identity mapping is resolved, continue with payroll import validation for hours, codes, control totals and retry handling, then the payroll reconciliation checklist for the wider run.
Microsoft’s identifier-formatting guidance explains how numeric conversion can remove leading zeros and alter long codes. Applying a later display format does not recover the original identifier. Preserve the original roster and verify the actual exported text.
TimeTrex’s Payroll Export Report documentation describes selected-period time and earnings exports for third-party payroll software, with format-specific employee identifiers. Confirm the chosen destination’s current specification; this crosswalk is not a configuration instruction. The report is unnecessary when processing payroll directly within TimeTrex.
Method reviewed November 6, 2026. Review labels and workflow are suggested organization-selected conventions. All example IDs and outcomes are fictional. Use the browser’s print command for a paper reference; review page breaks and scaling before relying on the printed copy.
Disclaimer: This worksheet supports an internal employee-record mapping review; it does not identify people, validate an import, approve payroll or establish legal compliance. Provider formats, multiple employments and rehire handling require verification in the receiving system. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.