Spreadsheet: e27dbdce-d72f-4c55-b064-7efafe5d5c0a
Sheet: Calculator

This calculator is for estimating purposes ONLY.  This will calculate net pay based on information entered and will provide a reasonable approximation of net pay. You do not need to do any calculations, the tool will do the calculations.
http://www.obfs.uillinois.edu/payroll/
MONTHLY NET PAY CALCULATION    2013
Gross Dollar Overpayment Recapture
Monthly Gross Pay |  |  | 0 |  | IF APPLICABLE
Gross Amount to be deducted |  |  | 0 |  | MEDICARE GROSS CALCULATION:
Monthly Gross Pay after Overpayment deduction |  |  |  |  | Monthly Gross Pay
 |  |  |  |  | Add: Monthly Taxable Benefits
ADDITIONS to Taxable Gross: |  |  |  |  | Minus:
Excess Life (Current Month amt from Earnings Statement) |  |  |  |  | Health Insurance
Taxable Benefits |  |  | 0 |  | Dental Insurance
Taxable Benefits cont. |  |  | 0 |  | Life Insurance
Taxable Benefits cont. |  |  | 0 |  | DCAP
Total Taxable Benefits |  |  |  |  | MCAP
 |  |  |  |  | Parking
PRE-TAX DEDUCTIONS: |  |  |  |  | Transit Benefit
SURS (this amount will be calculated based on the Gross Pay after the furlough) |  |  |  |  | Medicare Earnings
Health [NAME] employee (Current Month amt from Earnings Statement) |  |  |  |  | Medicare Withholding |  | 0.0145
Health Insurance- dependents(Current Month amt from Earnings Statement)
Dental Insurance (Current Month amt from Earnings Statement)
State Optional LIfe - employee (Current Month amt from Earnings Statement)
403b plan Flat Rate (Current Month amt from Earnings Statement)
403b plan Percentage enter percentage in column B
457 plan (Current Month amt from Earnings Statement)
SURS buy back (Current Month amt from Earnings Statement)
Parking  (Current Month amt from Earnings Statement)
Transit Benefit Deduction (Current Month amt from Earnings Statement)
Dependent Care Assistance (Current Month amt from Earnings Statement)
Medical Care Assistance (Current Month amt from Earnings Statement)
Total Pre-Tax Deductions
AFTER TAX DEDUCTIONS:
Prudential LTD (Current Month amt from Earnings Statement)
U of I Life (Current Month amt from Earnings Statement)
Spouse Life and Dependent Life (Current Month amt from Earnings Statement)
Total Charities (Add all Charities (Current Month amt from Earnings Statement)
Ad&D (Current Month amt from Earnings Statement)
Child Support/Alimony (Current Month amt from Earnings Statement)
Garnishments (Current Month amt from Earnings Statement)
Other Involuntary Deductions (Current Month amt from Earnings Statement)
Other Miscellaneous Deductions (Current Month amt from Earnings Statement)
[NAME] 403b Flat Rate (Current Month amt from Earnings Statement)
[NAME] 403b plan Percentage enter percentage in column B
Union Dues (Current Month amt from Earnings Statement)
Total After Tax Deductions
 |  | Enter # of Allowances
TAXABLE GROSS
[NAME] | MARRIED | 0
TAX AMOUNT FILING MARRIED | tax amount
ADDITIONAL WITHHOLDING or FILING EXEMPT
TOTAL FEDERAL TAX WITHHOLDING
TAXABLE GROSS | SINGLE | 0
TAX AMOUNT FILING SINGLE | tax amount
ADDITIONAL WITHHOLDING or FILING EXEMPT |  |  | 0
TOTAL FEDERAL TAX WITHHOLDING
ILLINOIS
TAXABLE GROSS
STATE W4 ALLOWANCES |  | 0
ADDITIONAL WITHHOLDING or FILING EXEMPT
TAX AMOUNT | tax amount
NET PAY CALCULATION |  | W4- MARRIED STATUS | W4- SINGLE STATUS
GROSS
Total Pre-Tax Deductions
TAX WITHHOLDING - FEDERAL
TAX WITHHOLDING - STATE
MEDICARE if you are not subject to Medicare type 0
Total AfterTax Deductions
 |  | [NAME] | [NAME]
NET PAY
 |  | [NAME] | [NAME]
NET PAY not subject to Medicare