ADP Workforce (WFN) Now: Extract and Required Data Guide
Guide users to access ADP WFN, extract, format, and upload payroll data efficiently.
This guide walks you through how to access ADP WFN, extract the required data, and format files so you can complete your setup successfully.
Overview Checklist
Access
Data Extraction
Data Formatting
Access Walkthrough
- Log into your ADP WFN account.
- Go to Setup β Tools β Support β Client Contact Change
- Click Add New Contact
- Select NO, to indicate you are not adding an employee.
- Enter the requested information:
- First Name: Payroll
- Last Name: Support
- Email Address: setup@checkhq.com
- Phone Number (if asked): 856-830-6462
If not going through Checks embedded setup process DO NOT use the setup@checkhq.com email. Use an email that you have access to.
- Scroll down to Access Settings
- Select No, let me choose the options manually to begin selecting settings.
- Select:
- Company Codes β Select all companies you'd like to give access to.
- Administrator Access β click Product User as a drop-down, or another similar option if available.
- Product Access β Select Yes for Workforce Now access.
- Contact Settings & Roles β Select Payroll and ensure that Secondary Contact is marked.
- Click Submit
- Confirm user profile created has access to People and Payroll Processing
- Go to Setup β Security β Access Permissions β Manage People
- Search for the Payroll Support user and select their name
- Navigate to Payroll Processing Access and ensure the profile has View Access
- Navigate to People Access and ensure the profile has the Same Access as Payroll Processing
Data Extraction Steps
Direct Deposit
Employee Demographics
ADP WFN does NOT have a report for Workplaces or Earning Rates
- Navigate to Reports & Analytics β Reports Dashboard
- Click on Employee Census
- May be under βTrending Nowβ or you can search in the search bar
- Who Appears on this Report- If multiple accounts under login, hit X, on any that should not be included in this report.
- Whatβs Displayed on this Report - No changes needed
- Appearance and Other Settings β Click on pencil icon
- Update Tax ID and Date of Birth to Not Masked
- Leave all other settings as they are
- Save
- Run as Excel
Direct Deposit
- Navigate to Reports & Analytics β Standard Reports β Personal & Employment
- Search for Direct Deposit Information
- Who Appears on this Report- If multiple accounts under login, hit X, on any that should not be included in this report.
- Whatβs Displayed on this Report - No changes needed
- Appearance and Other Settings β Click on pencil icon
- Group by Name
- Tax ID = Not Masked
- Bank Account Details = Not Masked
- Report information as of = Today
- Available Deduction Codes = Select all
- Save
- Run as Excel
Withholdings
- Navigate to Reports & Analytics β Standard Reports β Personal & Employment
- Search for Employee Profile
- Who Appears on this Report- If multiple accounts under login, hit X, on any that should not be included in this report.
- Whatβs Displayed on this Report β Click on pencil icon
- Personal Information: Uncheck all except Personal Profile
- Employment Information: Uncheck All
- Pay Information: Uncheck all except Tax Withholdings
- Statutory Compliance: Uncheck All
- Talent Profile: Uncheck All
- Save
- Appearance and Other Settings β Click on pencil icon
- Group by Name
- Tax ID = Not Masked
- Report information as of = Today
- Save
- Run as Excel
Deductions
- Navigate to Reports & Analytics β Standard Reports β All Standard Reports
- Search for Voluntary Deductions
- Who Appears on this Report- If multiple accounts under login, hit X, on any that should not be included in this report.
- Whatβs Displayed on this Report β No changes needed
- Appearance and Other Settings β Click on pencil icon
- Group by Name
- Available Deduction Codes β Select All
- Save
- Run as Excel
Historical Payrolls
- Navigate to Reports & Analytics β Pay Statement History β Payroll History
- Who Appears on this Report- If multiple accounts under login, hit X, on any that should not be included in this report.
- Whatβs Displayed on this Report β Click on pencil icon and Add the following:
- Period Beginning Date
- Period Ending Date
- Worked in State
- Worked in Department
- Federal Tax - Employer
- State Tax - Employer
- Local Tax - Employer
- Federal Taxable
- State Taxable
- Local Taxable
- Save
- Appearance and Other Settings β Click on pencil icon
- Group by Name
- Request Period β select the desired date range
- Q1 (1/1 - 3/31)
- Q2 (4/1 - 6/30)
- Q3 (7/1 - 9/30)
- Q4 (10/1 - 12/31)
- Save
- Run as Excel
Multi-State - Use the Worked in Department to determine the correct state for unemployment
Use the employee rates to split SUI/SDI manually before importing
Company Tax Information
- Navigate to Setup β Payroll β Tax Jurisdictions
- View the Tax ID for each tax line item.
- Click into the tax line item to view the full ID and Rate, if applicable.
Screenshots allow you to record critical Tax IDs, Rates, and more since this is not available via a downloadable report.
Tax Returns
- Navigate to Reports & Analytics β Federal/State/Local Tax Documents - 940/941
- Federal Tab β Check the boxes of appropriate Q/Year needed.
- State Tab β Check the boxes of appropriate tax documents needed.
- If starting in Q1, pull the prior quarter's return (Q3 or Q4) to confirm tax information.
- If starting mid-year, pull every closed quarters return in the current year.
Obtaining closed quarter(s) tax filings is required and will allow you to tie out each quarter to ensure balancing with the transfer of historical data.
Tax documents serve dual purpose for setup:
- Allows you to tie out closed quarters in the current year when importing the historical data.
- Provides required information to complete the Tax Parameters.
Data Formatting
Refer to Help Article - Data Formatting for details on how to format reports for a smooth import experience.