For HRIS, payroll, benefits and IT
HRIS and payroll integration guide
Payroll can only pay what the HRIS sends it. This guide maps the data that moves between HR and payroll, how it moves, how to test it and how to prove it arrived.
What flows from HR to payroll, and back
The HRIS is the system of record for people data. Payroll is the system of record for pay results. Each event below starts in one and finishes in the other.
| Event | What the HRIS sends | What payroll does with it | Watch for |
|---|---|---|---|
| New hire | Legal name, SSN, address, hire date, job, pay rate, pay group, FLSA status, work location, tax forms and cost center. | Creates the payroll record and pays from the hire date. | A hire entered after the cutoff misses the first payday. New hires must be reported to the state within 20 days of hire, or sooner where the state requires. |
| Rehire | The same data as a new hire, on the original person record if your process reuses it. | Reactivates the person and resets pay group, tax setup and deductions as needed. | Duplicate records, and old deductions or bank details coming back. A rehire after 60 or more consecutive days apart is reported as a new hire. |
| Job, pay or status change | The new values and the effective date. | Pays the new rate from the effective date, and recalculates past periods when the change is back-dated. | Back-dated changes create retro pay. Future-dated changes must not apply early. |
| Location change | The new work or home address and its effective date. | Updates state and local tax withholding and unemployment reporting. | A new state may need new tax accounts first. Remote workers' home and work locations can differ. |
| Leave of absence | Leave type, start date, expected return date and paid or unpaid status. | Stops or changes pay and decides how deductions are handled while away. | Benefit deduction arrears, and leave pay from outside insurers or state programs. |
| Termination | Termination date, last day worked, reason and final pay details. | Pays final pay, stops recurring pay and ends deductions. | Late terminations cause overpayments. Federal law does not require an immediate final paycheck, but some states do (DOL). |
| Tax setup | Federal Form W-4 and state withholding forms, often from self-service. | Sets income tax withholding. | Forms captured in HR but never sent to payroll. |
| Benefit deductions | Plan, coverage level, employee and employer amounts, and start and stop dates. | Takes deductions and records employer contributions. | Start dates in the middle of a pay period, and deductions that miss the first paycheck. |
| Time and attendance | Approved hours, overtime, time off and premiums, by day. | Pays hours and premiums. | Unapproved time, and time for people not yet active in payroll. |
| Bank details | Account and routing numbers and split rules, from a verified channel. | Pays by direct deposit. | Payroll diversion fraud. See the direct deposit controls. |
What payroll sends back
- Pay results
- Gross pay, deductions, taxes and net pay by pay date, for total rewards and analytics.
- Deduction status
- Deductions that were not taken in full, and arrears to collect.
- Hours of service
- Hours paid by month, when the HRIS or benefits team tracks ACA full-time status.
- Year-to-date and W-2 data
- Totals HR may need for reports and employee questions.
- Costing
- Pay and employer costs by cost center, for Finance and the general ledger.
- Errors and rejects
- Records payroll could not load, back to the HRIS team to fix at the source.
Preview what a single change will do with the employee change impact tool.
Effective dating and retro
Every HR change carries two dates: the day someone entered it and the day it takes effect. Payroll pays from the effective date.
- Future-dated: entered before it takes effect. The integration holds it until the right pay period.
- Current: takes effect in the period being processed. It must arrive before the cutoff.
- Back-dated: takes effect in a period already paid. Payroll recalculates those periods and pays or recovers the difference.
A fictional back-dated raise
| Step | Detail |
|---|---|
| Employee | Riley Sample (fictional), paid biweekly at Juniper Ridge Supply (fictional) |
| Old rate | $24.00 an hour |
| New rate | $25.50 an hour, effective the first day of pay period 20 |
| Entered | During pay period 22, after periods 20 and 21 were already paid |
| Hours already paid at the old rate | 160 straight-time hours in periods 20 and 21 |
| Retro owed | 160 × $1.50 = $240.00, paid as a retro earning on the next payroll |
If those periods had overtime, the overtime pay changes too. Try your own numbers in the retro pay calculator.
House rules for effective dates
- Never overwrite history to make a report look right.
- Use a correction for a mistake and a new change for a real event.
- Agree how far back payroll will process retro without extra approval.
- Flag changes that cross a quarter, a tax year or a plan year. Payroll may need to handle them differently.
Integration methods
Most organizations use more than one. Whatever suite you use, such as Workday, UKG, ADP, SAP SuccessFactors or Oracle, check its current integration documentation. Ask which methods it supports for your setup.
File-based (SFTP)
The HRIS writes a file on a schedule and sends it over SFTP. Payroll loads it before each cutoff.
Good for: Clear audit trail, easy to replay and simple to test.
Watch for: Run times, failed transfers, format changes and missed delta records.
API
One system calls the other's API to read or send changes, on a schedule or as they happen.
Good for: Faster updates and quick error feedback.
Watch for: Rate limits, retries, credential expiry and how effective dates are handled.
Middleware and iPaaS
An integration platform sits in the middle to map fields, schedule jobs and log errors.
Good for: Many systems, complex mappings and central monitoring.
Watch for: One more system to secure, monitor and document.
Vendor-delivered connectors
A prebuilt connector from the HR or payroll vendor, or a partner.
Good for: Common systems paired in common ways.
Watch for: Fit with your configuration, custom fields, and who supports it after go-live.
Spreadsheet loads
A person loads a template file of changes, such as a mass pay change.
Good for: One-time and annual changes.
Watch for: Bad loads change many records at once. Test in a sandbox first. See vendor import templates.
Full file or changes only?
A full file sends every in-scope person each time. It catches missed changes, but it is larger and slower. A changes-only (delta) file sends only what changed since the last run. It is smaller, but a failed run can drop changes.
Many teams send changes each run and a full file on a schedule as a safety net.
Change control and testing
Every change that can touch pay goes through the same steps. Payroll is a partner at each one.
Request
Describe the need, the people affected, the payroll impact and the date needed.
Assess impact
List every system, file, report and security role the change touches. Ask payroll, benefits and Finance.
Build in a sandbox
Never build or test in production.
Test
Run unit, integration and user tests. Add a parallel test for anything that changes pay.
Approve
Get sign-off from the data owners and payroll. The builder should not approve their own change.
Release
Move it to production away from payroll processing days, quarter-end and year-end.
Watch the first payroll
Check the first results closely, then close the change.
Types of testing
| Test | What it proves | When |
|---|---|---|
| Unit test | One mapping, field or calculation works by itself. | While building. |
| Integration test | Data moves end to end, from HRIS entry to payroll result, including errors and rejects. | Before user testing. |
| User acceptance test | The change meets the business need, tested by the people who will use it. | Before approval. |
| Parallel test | Old and new setups give the same pay for the same data, employee by employee. | Before a new system or integration goes live. |
| Regression test | Things that already worked still work after a change or vendor release. | Before every release and major change. |
Test cases every HRIS to payroll integration needs
- New hire, and a new hire entered after the cutoff
- Rehire, including a rehire with old deductions on file
- Two changes for one person on the same day
- Future-dated and back-dated changes
- Transfer to a new state, and a remote worker with a different home state
- Leave of absence and return
- Termination, then final pay
- Legal name change, and names with accents, hyphens and apostrophes
- Benefit change in the middle of a pay period
- Blank, zero and very large values
Before a vendor release, rerun these as your regression script in a sandbox or preview tenant. Use fictional or masked data.
Reconciliation: prove it arrived
An integration that ran is not the same as one that worked. These checks prove HR and payroll agree. List every difference with a reason and an owner.
| Check | Compare | How often |
|---|---|---|
| Headcount | Active employees in the HRIS by pay group, against people paid on the payroll register. | Every payroll |
| New hires | Hires effective in the period, against first-time payees. | Every payroll |
| Terminations | Terminations, against anyone paid after their termination date. | Every payroll |
| Pay rates | HRIS rates, against payroll rates for everyone. | Monthly and after mass changes |
| Deductions | Benefit elections, against payroll deductions, against carrier invoices. | Monthly |
| Locations | HRIS work and home locations, against payroll tax setup. | Monthly and before year-end |
| Cost centers | HRIS cost centers, against general ledger mapping. | Monthly |
Payroll ties its own register to the bank and the general ledger. See the payroll controls workspace.
Common integration errors and how to fix them
Fix the cause at the source, not only the paycheck. Then add a test case so it cannot return unnoticed.
| Symptom | Likely cause | How to fix it |
|---|---|---|
| A new hire is missing from payroll | Entered after the run, a required field is blank, or the record was rejected. | Check the reject report, fix the field in the HRIS and resend. Add a pre-cutoff check of hires. |
| Paid at the old rate | Entered after the cutoff, wrong effective date, or a future-dated row was overwritten. | Confirm the effective date in the HRIS, then let payroll calculate retro. Try the retro pay calculator. |
| The same person twice in payroll | A rehire created a new ID, or records were matched on the wrong key. | Inactivate the duplicate with payroll. Match on employee ID, never on name. |
| Paid after termination | The termination was late or not sent, or the pay group did not end. | Enter the termination, stop the payment if you can, and follow your overpayment process within state law. |
| Deduction missing or doubled | Plan code not mapped, wrong start date, or the change was sent twice. | Tie elections to deductions, fix the mapping, then refund or catch up with approval. |
| Wrong state tax | Work or home location wrong, not sent, or not mapped to a tax code. | Fix the location in the HRIS with the right effective date. Payroll then corrects withholding. |
| File rejected | Format change, new required field, bad characters or a different date format. | Compare the file with its specification. Check recent releases and configuration changes, then retest in a sandbox. |
| Names look garbled | Accented letters or apostrophes are not supported by the file encoding. | Agree on the encoding with the vendor, and test names with accents, hyphens and apostrophes. |
| Costs post to suspense | A new or inactive cost center is not mapped in payroll or the general ledger. | Map new cost centers before first use, and run an unmapped code report every month. |
| Changes missing after a failed run | A changes-only file skipped records when a run failed. | Rerun from the last good point or send a full file. Add alerts for failed runs. |
| The integration ran, but nothing changed | The change is future-dated, or the integration's date rule leaves it out. | Check how the integration picks effective dates, and write the rule down. |
| Name and SSN mismatch notices | A name or SSN was keyed wrong, or not updated after a legal name change. | Validate with SSNVS, correct at the source with documents, and tell payroll before W-2's. |
For system-specific help, use troubleshooting and vendor help.
Checklist
Go-live checklist
Use it for a new integration, a new system or a major change. Every item needs an owner and evidence.
- Every field is mapped, with an owner in the data dictionary.
- Test scripts passed for hires, rehires, changes, back-dated and future-dated changes, transfers, leaves, terminations and name changes.
- Parallel test results are reviewed, and every difference has a reason.
- Reconciliation reports are built for headcount, hires, terminations, rates and deductions.
- Security roles follow least privilege and segregation of duties.
- Error alerts go to named people, with a backup.
- Run times are set around payroll cutoffs and shared on the calendar.
- SFTP keys, API credentials and certificates are stored securely, with expiry dates tracked.
- A rollback plan is written and tested.
- Cutover steps are timed, with an owner for each.
- The support model is ready: queue, severities and vendor contacts. See the support playbook.
- HRIS, payroll, benefits, IT and Finance have signed off.
- Hypercare is planned for the first payrolls.
- Documentation is stored where the support team can find it.
Who does what: a RACI for HRIS and payroll
A starting point to adjust for your organization. Each row has one accountable team.
- R
- Responsible: does the work
- A
- Accountable: owns the outcome and signs off
- C
- Consulted: gives input before
- I
- Informed: told after
| Activity | HRIS | Payroll | Benefits | IT | Finance |
|---|---|---|---|---|---|
| Hires, changes and terminations in the HRIS | A/R | C | I | I | I |
| Data dictionary and field owners | A/R | C | C | C | C |
| Integration build and monitoring | A | C | C | R | I |
| HR to payroll code mapping | R | A | C | C | C |
| Earning, deduction and tax setup in payroll | C | A/R | C | I | C |
| Benefit plans, rates and elections | C | C | A/R | I | C |
| Deduction tie-out to carrier invoices | I | R | A | I | C |
| Headcount reconciliation | A/R | R | I | I | I |
| Cost centers and general ledger mapping | C | R | I | I | A |
| HRIS security roles and access reviews | A/R | C | C | C | I |
| Single sign-on and user provisioning | C | I | I | A/R | I |
| Vendor release testing | A/R | R | R | C | I |
| Payroll processing and the payroll register | I | A/R | I | I | C |
| Payroll funding and journal entries | I | R | I | I | A |
| Year-end W-2 data | R | A/R | C | I | C |
| ACA hours, offers and Forms 1095-C | R | C | A/R | I | I |
Keep the integration records
Integration files, logs and approvals are part of your payroll records. Store them with the same care as the payroll register.
- Under the FLSA, keep payroll records at least 3 years. Keep time cards and wage rate tables at least 2 years (29 CFR 516.5 and 516.6, DOL Fact Sheet 21).
- Keep employment tax records at least 4 years after the tax is due or paid, whichever is later (IRS).
- Validate names and SSNs with SSNVS only for current or former employees and wage reporting, never before hiring (SSA rules).
Your own retention schedule may keep records longer. See the retention answer on the HRIS Desk.
Integration questions
What is an HRIS to payroll integration?
It is the connection that moves employee changes from the HRIS into payroll. It can be a file, an API, middleware or a vendor connector. Whatever the method, it needs mapping, testing and monitoring. Compare the methods.
Is an API better than a file?
Not always. APIs can move changes faster and give quick error feedback. Files are simpler to audit and replay. Choose what your systems support well and your team can monitor. Integration methods.
How often should the HRIS send changes to payroll?
At least once before every payroll cutoff, with time to fix errors. Sending changes daily lets problems surface before the cutoff. Agree on the schedule with payroll and share it. What payroll needs, and when.
What is a parallel test?
You run payroll in the old and new setups with the same data and compare results by employee. Every difference needs a reason before go-live. Include a regular payroll and one with unusual events. Testing types.
How do we reconcile HR headcount to payroll?
Compare active employees in the HRIS with people paid on the payroll register, by pay group. List anyone active but unpaid, or paid but inactive, with a reason. Do it every payroll. Reconciliation checks.
Who should own the HRIS to payroll integration?
Name one accountable owner, often the HRIS team, with IT building it and payroll approving mappings. Write it down in a RACI chart. Shared ownership with no single owner leaves gaps. See the RACI.
More for HRIS and payroll teams
- HRIS DeskStart-here paths, 24 plain answers, a support playbook, a data audit checklist and an HRIS calendar.
- HRIS glossaryHR systems terms from access review to worker type, in plain language.
- Employee change impactSee what an HR change does to pay, taxes and deductions before you enter it.
- Retro pay calculatorWork out what a back-dated rate change owes for periods already paid.
- Bonus gross-up calculatorFind the gross bonus that delivers a target net amount.
- Working with payrollWhat payroll needs from HR, Finance, IT and managers, and by when.
- Payroll controls workspaceRoles, reviews, segregation of duties and audit-ready evidence.
- Payroll glossaryPayroll words such as gross-to-net, FICA and supplemental wages.
Official sources
Each legal or regulatory fact on this page was checked on these official pages on November 9, 2026.
- eCFR, 29 CFR part 516 subpart A: records employers must keep under the FLSA (sections 516.2, 516.5, 516.6 and 516.7)
- U.S. Department of Labor Fact Sheet 21: recordkeeping requirements under the FLSA
- U.S. Department of Labor: last paycheck
- IRS: how long should I keep records (employment tax records, at least 4 years)
- HHS Administration for Children and Families, Office of Child Support: new hire reporting
- 42 U.S.C. 653a, State Directory of New Hires (U.S. Code, 2024 edition, GovInfo)
- Social Security Administration: Social Security Number Verification Service (SSNVS)
- Social Security Administration: SSNVS rules of use