Spreadsheet: 225440d1365007540-reformatting-data-audit-report-sample
Sheet: Data

SSN | Company Code | Payroll Name | File Number | Birthdate | Hire Date | Rehire Date | Termination Date | Accumulator Description | Amount
 | ZYC | Doe, Jane 1 | 001617 |  | 2003-12-01 00:00:00 |  |  | 401k [NAME] | 2867.61
 | ZYC | Doe, Jane 1 | 001617 |  | 2003-12-01 00:00:00 |  |  | 401k Elig Comp | 27904.2
 | ZYC | Doe, Jane 1 | 001617 |  | 2003-12-01 00:00:00 |  |  | 401k [NAME] | 957.42
 | ZYC | Doe, Jane 1 | 001617 |  | 2003-12-01 00:00:00 |  |  | Reg Hours Ytd | 1457.59
 | ZYC | Doe, Jane 1 | 001617 |  | 2003-12-01 00:00:00 |  |  | [NAME] | 27904.2
 | ZYC | Doe, Jane 2 | 002064 |  | 2012-06-04 00:00:00 |  |  | 401k Elig Comp | 21202.03
 | ZYC | Doe, Jane 2 | 002064 |  | 2012-06-04 00:00:00 |  |  | Ot  Hours Ytd | 15.53
 | ZYC | Doe, Jane 2 | 002064 |  | 2012-06-04 00:00:00 |  |  | Reg Hours Ytd | 1064.89
 | ZYC | Doe, Jane 2 | 002064 |  | 2012-06-04 00:00:00 |  |  | [NAME] | 21202.03
 | ZYC | Doe, [NAME] 3 | 002061 |  | 2012-04-09 00:00:00 |  |  | 401k Elig Comp | 32047.68
 | ZYC | Doe, [NAME] 3 | 002061 |  | 2012-04-09 00:00:00 |  |  | Ot  Hours Ytd | 2.75
 | ZYC | Doe, [NAME] 3 | 002061 |  | 2012-04-09 00:00:00 |  |  | Reg Hours Ytd | 1347.41
 | ZYC | Doe, [NAME] 3 | 002061 |  | 2012-04-09 00:00:00 |  |  | [NAME] | 32047.68
 | ZYC | Doe, [NAME] | 001063 |  | 1991-09-03 00:00:00 |  |  | 401k [NAME] | 16707.85
 | ZYC | Doe, [NAME] | 001063 |  | 1991-09-03 00:00:00 |  |  | 401k Elig Comp | 167078.19
 | ZYC | Doe, [NAME] | 001063 |  | 1991-09-03 00:00:00 |  |  | Reg Hours Ytd | 2032.08
 | ZYC | Doe, [NAME] | 001063 |  | 1991-09-03 00:00:00 |  |  | [NAME] | 167078.19
 | ZYB | Doe, [NAME] | 007010 |  | 2011-02-01 00:00:00 |  |  | 401k Elig Comp | 82074.98
 | ZYB | Doe, [NAME] | 007010 |  | 2011-02-01 00:00:00 |  |  | Reg Hours Ytd | 1960.08
 | ZYB | Doe, [NAME] | 007010 |  | 2011-02-01 00:00:00 |  |  | [NAME] | 82074.98
 | ZYB | Doe, [NAME] | 007027 |  | 2012-10-08 00:00:00 |  |  | 401k Elig Comp | 5515.09
 | ZYB | Doe, [NAME] | 007027 |  | 2012-10-08 00:00:00 |  |  | Ot  Hours Ytd | 3.07
 | ZYB | Doe, [NAME] | 007027 |  | 2012-10-08 00:00:00 |  |  | Reg Hours Ytd | 351.33
 | ZYB | Doe, [NAME] | 007027 |  | 2012-10-08 00:00:00 |  |  | [NAME] | 5515.09
 | ZYC | Doe, [NAME] | 002050 |  | 2011-12-01 00:00:00 |  | 2012-01-04 00:00:00 | 401k Elig Comp | 1728.41
 | ZYC | Doe, [NAME] | 002050 |  | 2011-12-01 00:00:00 |  | 2012-01-04 00:00:00 | Ot  Hours Ytd | 13.6
 | ZYC | Doe, [NAME] | 002050 |  | 2011-12-01 00:00:00 |  | 2012-01-04 00:00:00 | Reg Hours Ytd | 91.63
 | ZYC | Doe, [NAME] | 002050 |  | 2011-12-01 00:00:00 |  | 2012-01-04 00:00:00 | [NAME] | 1728.41
 | ZYC | Doe, [NAME] | 001808 |  | 2000-06-26 00:00:00 |  |  | 401k Elig Comp | 35537.91
 | ZYC | Doe, [NAME] | 001808 |  | 2000-06-26 00:00:00 |  |  | 401k [NAME] | 683.04
 | ZYC | Doe, [NAME] | 001808 |  | 2000-06-26 00:00:00 |  |  | Ot  Hours Ytd | 17.3
 | ZYC | Doe, [NAME] | 001808 |  | 2000-06-26 00:00:00 |  |  | Reg Hours Ytd | 1891.64
 | ZYC | Doe, [NAME] | 001808 |  | 2000-06-26 00:00:00 |  |  | [NAME] | 35537.91
 | ZYC | Doe, [NAME] | 001864 |  | 2004-04-15 00:00:00 | 2009-09-28 00:00:00 |  | 401k Elig Comp | 27109.6
 | ZYC | Doe, [NAME] | 001864 |  | 2004-04-15 00:00:00 | 2009-09-28 00:00:00 |  | Ot  Hours Ytd | 0.44
 | ZYC | Doe, [NAME] | 001864 |  | 2004-04-15 00:00:00 | 2009-09-28 00:00:00 |  | Reg Hours Ytd | 1935.64
 | ZYC | Doe, [NAME] | 001864 |  | 2004-04-15 00:00:00 | 2009-09-28 00:00:00 |  | [NAME] | 27109.6
 | ZYC | Doe, [NAME] | 001557 |  | 2002-04-03 00:00:00 |  |  | 401k [NAME] | 1416.15
 | ZYC | Doe, [NAME] | 001557 |  | 2002-04-03 00:00:00 |  |  | 401k Elig Comp | 47205.11
 | ZYC | Doe, [NAME] | 001557 |  | 2002-04-03 00:00:00 |  |  | Ot  Hours Ytd | 32.53
 | ZYC | Doe, [NAME] | 001557 |  | 2002-04-03 00:00:00 |  |  | Reg Hours Ytd | 1905.09
 | ZYC | Doe, [NAME] | 001557 |  | 2002-04-03 00:00:00 |  |  | [NAME] | 47205.11
 | ZYC | Doe, [NAME] | 002079 |  | 2012-10-22 00:00:00 |  |  | 401k Elig Comp | 4206.88
 | ZYC | Doe, [NAME] | 002079 |  | 2012-10-22 00:00:00 |  |  | Ot  Hours Ytd | 1.08
 | ZYC | Doe, [NAME] | 002079 |  | 2012-10-22 00:00:00 |  |  | Reg Hours Ytd | 302
 | ZYC | Doe, [NAME] | 002079 |  | 2012-10-22 00:00:00 |  |  | [NAME] | 4206.88
 | ZYB | Doe, [NAME] | 001499 |  | 2000-09-28 00:00:00 |  |  | 401k Elig Comp | 79804.24
 | ZYB | Doe, [NAME] | 001499 |  | 2000-09-28 00:00:00 |  |  | 401k [NAME] | 326.32
 | ZYB | Doe, [NAME] | 001499 |  | 2000-09-28 00:00:00 |  |  | Reg Hours Ytd | 1896.08
 | ZYB | Doe, [NAME] | 001499 |  | 2000-09-28 00:00:00 |  |  | [NAME] | 79804.24
 | ZYC | Doe, [NAME] 10 | 001961 |  | 2009-05-11 00:00:00 |  | 2012-11-12 00:00:00 | 401k Elig Comp | 99108.07
 | ZYC | Doe, [NAME] 10 | 001961 |  | 2009-05-11 00:00:00 |  | 2012-11-12 00:00:00 | Reg Hours Ytd | 1738.74
 | ZYC | Doe, [NAME] 10 | 001961 |  | 2009-05-11 00:00:00 |  | 2012-11-12 00:00:00 | [NAME] | 99108.07
 | ZYC | Doe, [NAME] | 001812 |  | 1988-11-01 00:00:00 |  | 2012-10-31 00:00:00 | 401k [NAME] | 2337.2
 | ZYC | Doe, [NAME] | 001812 |  | 1988-11-01 00:00:00 |  | 2012-10-31 00:00:00 | 401k Elig Comp | 15581.35
 | ZYC | Doe, [NAME] | 001812 |  | 1988-11-01 00:00:00 |  | 2012-10-31 00:00:00 | Reg Hours Ytd | 582.55
 | ZYC | Doe, [NAME] | 001812 |  | 1988-11-01 00:00:00 |  | 2012-10-31 00:00:00 | [NAME] | 15581.35
 | ZYC | Doe, [NAME]  4 | 001949 |  | 2008-10-13 00:00:00 |  | 2011-11-16 00:00:00 | 401k Elig Comp | 1000
 | ZYC | Doe, [NAME]  4 | 001949 |  | 2008-10-13 00:00:00 |  | 2011-11-16 00:00:00 | [NAME] | 1000
 | ZYC | Doe, [NAME]  5 | 001501 |  | 2000-10-02 00:00:00 |  |  | 401k [NAME] | 1743.6
 | ZYC | Doe, [NAME]  5 | 001501 |  | 2000-10-02 00:00:00 |  |  | 401k Elig Comp | 58122.08
 | ZYC | Doe, [NAME]  5 | 001501 |  | 2000-10-02 00:00:00 |  |  | 401k [NAME] | 1851.59
 | ZYC | Doe, [NAME]  5 | 001501 |  | 2000-10-02 00:00:00 |  |  | Reg Hours Ytd | 1912.08
 | ZYC | Doe, [NAME]  5 | 001501 |  | 2000-10-02 00:00:00 |  |  | [NAME] | 58122.08
 | ZYC | Doe, [NAME] | 001866 |  | 2003-09-08 00:00:00 |  | 2012-06-08 00:00:00 | 401k Elig Comp | 14869.6
 | ZYC | Doe, [NAME] | 001866 |  | 2003-09-08 00:00:00 |  | 2012-06-08 00:00:00 | Ot  Hours Ytd | 11.17
 | ZYC | Doe, [NAME] | 001866 |  | 2003-09-08 00:00:00 |  | 2012-06-08 00:00:00 | Reg Hours Ytd | 826.55
 | ZYC | Doe, [NAME] | 001866 |  | 2003-09-08 00:00:00 |  | 2012-06-08 00:00:00 | [NAME] | 14869.6
 | ZYC | Doe, [NAME] | 002016 |  | 2010-09-13 00:00:00 |  |  | 401k Elig Comp | 31379.77
 | ZYC | Doe, [NAME] | 002016 |  | 2010-09-13 00:00:00 |  |  | Ot  Hours Ytd | 36.61
 | ZYC | Doe, [NAME] | 002016 |  | 2010-09-13 00:00:00 |  |  | Reg Hours Ytd | 1880.37
 | ZYC | Doe, [NAME] | 002016 |  | 2010-09-13 00:00:00 |  |  | Retroactive E Ytd | 42
 | ZYC | Doe, [NAME] | 002016 |  | 2010-09-13 00:00:00 |  |  | Retroactive H Ytd | 3
 | ZYC | Doe, [NAME] | 002016 |  | 2010-09-13 00:00:00 |  |  | [NAME] | 31379.77
 | ZYC | Doe, [NAME] | 007013 |  | 2011-07-01 00:00:00 |  |  | 401k Elig Comp | 34314.63
 | ZYC | Doe, [NAME] | 007013 |  | 2011-07-01 00:00:00 |  |  | Ot  Hours Ytd | 75.09
 | ZYC | Doe, [NAME] | 007013 |  | 2011-07-01 00:00:00 |  |  | Reg Hours Ytd | 1937.45
 | ZYC | Doe, [NAME] | 007013 |  | 2011-07-01 00:00:00 |  |  | [NAME] | 34314.63
 | ZYC | Doe, [NAME] 15 | 001533 |  | 2001-08-23 00:00:00 |  |  | 401k Elig Comp | 45967.95
 | ZYC | Doe, [NAME] 15 | 001533 |  | 2001-08-23 00:00:00 |  |  | Reg Hours Ytd | 1872.08
 | ZYC | Doe, [NAME] 15 | 001533 |  | 2001-08-23 00:00:00 |  |  | [NAME] | 45967.95
 | ZYB | Doe, [NAME] | 001895 |  | 2007-11-26 00:00:00 | 2009-04-15 00:00:00 |  | 401k Elig Comp | 32282.7
 | ZYB | Doe, [NAME] | 001895 |  | 2007-11-26 00:00:00 | 2009-04-15 00:00:00 |  | Ot  Hours Ytd | 43.93
 | ZYB | Doe, [NAME] | 001895 |  | 2007-11-26 00:00:00 | 2009-04-15 00:00:00 |  | Reg Hours Ytd | 1895.94
 | ZYB | Doe, [NAME] | 001895 |  | 2007-11-26 00:00:00 | 2009-04-15 00:00:00 |  | [NAME] | 32282.7
 | ZYB | Doe, [NAME] | 007024 |  | 2012-06-25 00:00:00 |  | 2012-10-25 00:00:00 | 401k Elig Comp | 6102.1
 | ZYB | Doe, [NAME] | 007024 |  | 2012-06-25 00:00:00 |  | 2012-10-25 00:00:00 | Ot  Hours Ytd | 2.96
 | ZYB | Doe, [NAME] | 007024 |  | 2012-06-25 00:00:00 |  | 2012-10-25 00:00:00 | Reg Hours Ytd | 573.77
 | ZYB | Doe, [NAME] | 007024 |  | 2012-06-25 00:00:00 |  | 2012-10-25 00:00:00 | [NAME] | 6102.1
 | ZYC | Doe, [NAME] | 001072 |  | 2008-11-10 00:00:00 |  |  | 401k Elig Comp | 37579.94
 | ZYC | Doe, [NAME] | 001072 |  | 2008-11-10 00:00:00 |  |  | Ot  Hours Ytd | 26.8
 | ZYC | Doe, [NAME] | 001072 |  | 2008-11-10 00:00:00 |  |  | Reg Hours Ytd | 1968.03
 | ZYC | Doe, [NAME] | 001072 |  | 2008-11-10 00:00:00 |  |  | [NAME] | 37579.94
 | ZYC | Doe, [NAME]  6 | 001675 |  | 2005-05-31 00:00:00 |  |  | 401k [NAME] | 8709.01
 | ZYC | Doe, [NAME]  6 | 001675 |  | 2005-05-31 00:00:00 |  |  | 401k Elig Comp | 43545
 | ZYC | Doe, [NAME]  6 | 001675 |  | 2005-05-31 00:00:00 |  |  | Ot  Hours Ytd | 9.86
 | ZYC | Doe, [NAME]  6 | 001675 |  | 2005-05-31 00:00:00 |  |  | Reg Hours Ytd | 1855.68
 | ZYC | Doe, [NAME]  6 | 001675 |  | 2005-05-31 00:00:00 |  |  | [NAME] | 43545