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!
|