This is a sample from a payroll file I have to work with, it lists employee number, different types of earnings, & check date. The goal is to get a subtotal per employee that lists the employee's total wages and other earnings. I can't get my head around how to do this, can someone offer some suggestions? I'm trying to do this in C#. Some employees may have only one line, other employees may have lines with no regular wage types, only deductions/earnings (bonuses, insurance, etc...)

Code:
240	     TN	DP	800.00	1696.65	.00	.00	.00	.00	65	46.20	11/10/11
    240	TN	DP	800.00	1696.65	.00	.00	.00	.00	66	124.83	11/10/11
    240	TN	DP	800.00	1696.65	.00	.00	.00	.00	72	5.27	11/10/11
    240	TN	DP	800.00	1696.65	.00	.00	.00	.00	ZC	1933.75	11/10/11
    240	TN	DP	800.00	1643.55	.00	.00	.00	.00	65	46.20	11/25/11
    240	TN	DP	800.00	1643.55	.00	.00	.00	.00	66	122.18	11/25/11
    240	TN	DP	800.00	1643.55	.00	.00	.00	.00	72	5.27	11/25/11
    240	TN	DP	800.00	1643.55	.00	.00	.00	.00	ZC	1893.87	11/25/11
    240	TN	DP	.00	.00	.00	.00	400.00	.00	66	20.00	12/09/11
    240	TN	DP	800.00	1595.25	.00	80.00	.00	.00	65	46.20	12/09/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	65	.00	07/08/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	67	.00	07/08/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	69	.00	07/08/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	72	.00	07/08/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	74	.00	07/08/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	ZC	1299.03	07/08/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	65	181.85	07/22/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	67	12.46	07/22/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	69	.00	07/22/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	72	22.15	07/22/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	74	.00	07/22/11
    242	TN	DP	1538.46	.00	.00	.00	.00	.00	ZC	1124.70	07/22/11