Employee ID Crosswalk Worksheet

Timekeeping → payroll · identity review

Match records before moving hours

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 review

Build and review your crosswalk

Work in an approved internal file. These checkboxes are a temporary reading aid; they do not save or approve a mapping.

1. Check the identity evidence

Keep one row per scoped source record

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

Similar IDs are not the same record

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.

Illustrative crosswalk review; identifiers are exact strings
Source IDTarget IDFindingDisposition and action
0017P041Evidence confirms this employment record.Ready; retain evidence and reviewer.
17P086Different record; keep 17 and 0017 as distinct identifiers.Ready; preserve both exact keys.
0248UnconfirmedNo verified target in the authorized roster.Hold; payroll owner checks setup and identity.
0402P099Target also assigned to source 0403.Hold; investigate the collision.
0403P099Same scoped target as source 0402.Hold; resolve both relationships together.
2 ready for mapping review · 3 on hold · 5 records accounted for

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.

Resolve exceptions without guessing

Missing target or blank identifier

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.

Duplicate, reused or conflicting keys

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.

Inactive record, transfer or rehire

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.

Leading zeros or other characters changed

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.

Method and next steps

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.

Why exact text and format-specific review matter

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.

Found our Employee ID Crosswalk Worksheet useful? Bookmark and share it.

Facebook
X
LinkedIn
Email
WhatsApp
Print
Blue employee record cards linked across two systems beside a review checklist on white.

Trusted By

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand