1. Create a new Employee query in Payroll, Query.
2. Select the Dynamic format.
3. On the Criteria tab, make no selections.
NOTE: If you have a large number of inactive or terminated employees that would have no 2009 data, then you can add the following:
Employee, Current Status, Operator Equals, Active.
4. On the Output tab, make the following selections (a screenshot is attached for your reference):
Employee, Employee Full Name
Employee Summary, Gross Pay - on the filters tab that appears, Pay Date equals Calendar YTD
Employee Summary, Non-cash benefits - on the filters tab that appears, Pay Date equals Calendar YTD
Employee Summary, Deductions - on the filters tab that appears, Pay Date equals Calendar YTD
Employee Summary, Taxes - on the filters tab that appears, Pay Date equals Calendar YTD
Employee Summary, Net Pay - on the filters tab that appears, Pay Date equals Calendar YTD
Employee Summary, Employer benefits - on the filters tab that appears, Pay Date equals Calendar YTD
5. On the Sort tab, sort as desired.
6. Run the query.