Mapping payroll journal data to Certified Payroll reports

To generate accurate Certified Payroll reports, TradeSeal needs to know how to interpret the columns in your payroll journal (check stub) export.
 

How Mapping Works

Each column in your payroll journal must be assigned to the correct bucket on the WH-347 form — such as:

• Gross wages
• Withheld taxes
• Fringe benefit contributions
• Other deductions
• Net pay

TradeSeal uses field names and values in your file to understand what each column represents. That’s why column headers matter — consistent naming helps ensure correct mapping.
 

🔧 Who Controls the Mapping?

• You and your payroll provider can define the column names used in the export.
• TradeSeal Support helps you map these columns to the appropriate CP categories.
   

✅ Best Practices

• Ask your payroll provider to include descriptive and consistent column headers.
• When possible, follow TradeSeal’s standard field names to reduce setup time.
• If you are unable to use standard field names, contact [e-mail] for help with advanced mappings.
   

Once mappings are established, TradeSeal will remember them for future uploads — keeping your compliance process smooth and reliable.