Spreadsheet: cc177041-7ee4-42e5-b581-8aa953e06b8c
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.  You will need to enter information from your earning statement and NOA.Instructions on how to use the form can be found under [NAME] at:
http://www.obfs.uillinois.edu/payroll/
To complete this form you need to know your deduction amounts.  These can be found on your earnings statement.  To retrieve your electronic earnings statement log on to NESSIE and go to the Compensation tab:
Link to NESSIE
Instructions to access your Earnings Statement:
BIWEEKLY NET PAY CALCULATION    2013
[NAME]
Scheduled hours per pay period for full time employees typically 75 or 80
Number of overtime hours at time and a half |  |  |  |  | IF APPLICABLE
Number of overtime hours at time and a half |  |  |  |  | MEDICARE GROSS CALCULATION:
 |  |  |  |  | Monthly Gross Pay
Gross pay |  |  |  |  | Add: Monthly Taxable Benefits
 |  |  |  |  | Minus:
 |  |  |  |  | Health Insurance
ADDITIONS to Taxable Gross: |  |  |  |  | Dental Insurance
Excess Life (Current Month amt from Earnings Statement) |  |  | 0 |  | Life Insurance
Taxable Benefits |  |  | 0 |  | DCAP
Taxable Benefits cont. |  |  | 0 |  | MCAP
Taxable Benefits cont. |  |  | 0 |  | Parking
Total Taxable Benefits |  |  |  |  | Transit Benefit
 |  |  |  |  | Medicare Earnings
PRE-TAX DEDUCTIONS: |  |  |  |  | Medicare Withholding |  | 0.0145
SURS (this amount will be calculated based on the Gross Pay)
Health [NAME] employee (Current amt from Earnings Statement) |  |  | 0
Health Insurance- dependents(Current amt from Earnings Statement)
Dental Insurance (Current amt from Earnings Statement) |  |  | 0
State Optional LIfe - employee (Current amt from Earnings Statement) |  |  | 0
[NAME] plan Flat Rate(Current amt from Earnings Statement)
403b plan Percentage enter percentage in column B
457 plan (Current amt from Earnings Statement)
SURS buy back (Current amt from Earnings Statement) |  |  | 0
Parking  (Current amt from Earnings Statement) |  |  | 0
Transit Benefit Deduction (Current amt from Earnings Statement)
Dependent Care Assistance (Current amt from Earnings Statement)
Medical Care Assistance (Current amt from Earnings Statement)
Total Pre-Tax Deductions
AFTER TAX DEDUCTIONS:
Prudential LTD (Current amt from Earnings Statement) |  |  | 0
U of I Life(Current amt from Earnings Statement)
Spouse Life and Dependent Life (Current amt from Earnings Statement) |  |  | 0
Total Charities (Add all Charities (Current amt from Earnings Statement) |  |  | 0
Ad&D (Current amt from Earnings Statement) |  |  | 0
Child Support/Alimony (Current amt from Earnings Statement)
Garnishments (Current amt from Earnings Statement)
Other Involuntary Deductions (Current amt from Earnings Statement)
Other Miscellaneous Deductions (Current amt from Earnings Statement)
[NAME] [NAME] Rate(Current amt from Earnings Statement)
[NAME] 403b plan Percentage enter percentage in column B
Union Dues (Current amt from Earnings Statement)
Total After Tax Deductions
 |  | Enter # of Allowances
TAXABLE GROSS
[NAME] | MARRIED | 0
 | tax amount
TAX AMOUNT FILING MARRIED
Tax on Taxable Benefits (tax at supplemental rates)
ADDITIONAL WITHHOLDING or FILING EXEMPT |  |  | 0
TOTAL FEDERAL TAX WITHHOLDING
TAXABLE GROSS
[NAME] | SINGLE | 0
TAX AMOUNT FILING SINGLE | tax amount
Tax on Taxable Benefits (tax at supplemental rates)
ADDITIONAL WITHHOLDING or FILING EXEMPT |  |  | 0
TOTAL FEDERAL TAX WITHHOLDING
ILLINOIS
TAXABLE GROSS
STATE W4 ALLOWANCES |  | 0
Tax on Taxable Benefits (tax at supplemental rates) |  |  | 0
ADDITIONAL WITHHOLDING or FILING EXEMPT |  |  | 0
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