To complete Form 5500, which reports the status of a company’s 401(k) plan, data must be gathered from various sources. The key sources include:

• Payroll Journal: This document details each employee's salary and 401k contributions.
• Employee information: This includes data on employee benefits and payroll elections.
• Deferral Records: A record of deferral changes from the company’s 401k provider.

In this module, we will extract, prepare, combine, and transform data from these sources to identify any discrepancies between the deferrals reported by the 401(k) provider and those derived from payroll records.

By the end of this module, you will gain insights into the data preparation process and enhance your ability to ensure accurate reporting.

Follow along using: 401k.zip Start Lesson