Payroll W2 reconciliation transformation
Project overview and objectives
A global fashion retailer was unable to reconcile employee W2’s with source payroll data, resulting in significant risk of unknown W2 misstatements.
The company engaged Clearsulting to design and implement a W2 data reconciliation process using BlackLine Transaction Matching as the reconciliation tool. Goals of this project were to:
- Reconcile both HR source system and actual W2 data from ADP
- Enable testing of W2 data for the complete employee population
- Quickly identify and report on specific W2 errors
What we did
Designed and implemented a future state W2 reconciliation process that included:
- Reviewing current state documentation and manual reconciliation process
- Documenting future state data flow and reconciliation requirements
- Designing and documenting future state process to satisfy all business requirements
- Implementing BlackLine Matching tool to complete W2 reconciliation process
Liaised with IT and BlackLine development teams to develop and test data imports, which involved:
- Documenting future state configuration design for source data and ADP matching
- Configuring and testing matching solution based on approved design
- Training end users on using the matching module and executing the future state W2 reconciliation