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

Project detail

Financial close

Ready to see how our digital finance consulting services can help?
Let's Talk
Featured Insight
Guide: How to reach touchless P2P nirvana
Download Now