View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Sample Data:

Spreadsheet 1
Check # Check Dt Name Tot Gross Total Ded. Total Taxes Net Pay
123456 2005-09-16 Doe, John 1,794.62 196.40 206.38 1,391.84

Spreadsheet 2
Check # Check Dt Name Plan Typ Deductn Cd Ded Class Curr Dedn
123456 2005-09-16 Doe, John Life BASLIF Before-Tax 1.15
123456 2005-09-16 Doe, John Medical GRBOSN Before-Tax 51.68
123456 2005-09-16 Doe, John Retirement Plans ORPAET Before-Tax 143.57
123456 2005-09-16 Doe, John Retirement Plans TRSL01 Before-Tax 0.00
123456 2005-09-16 Doe, John Life BASLIF Nontaxable Benefit 1.15
123456 2005-09-16 Doe, John Medical GRBOSN Nontaxable Benefit 155.04
123456 2005-09-16 Doe, John Retirement Plans ORPAET Nontaxable
Benefit 285.34
123456 2005-09-16 Doe, John Retirement Plans TRSL01 Nontaxable
Benefit 0.00

Spreadsheet 3
Check # Check Dt Name Tax Class St Curr Tax
123456 2005-09-16 Doe, John FICA Med Hospital Ins / EE $U 25.26
123456 2005-09-16 Doe, John Withholding $U 147.04
123456 2005-09-16 Doe, John FICA Med Hospital Ins / ER $U 25.26
123456 2005-09-16 Doe, John Withholding LA 34.08

Thanks for your help!