Alspaugh-Instruction Manual-ENG301 (84450)-Nov2008

Alspaugh-Instruction Manual-ENG301 (84450)-Nov2008 -...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Paycheck Estimation Template A manual for employees on creating a spreadsheet to calculate your paycheck  before you get it.  Ideally created for hourly employees paid biweekly.  April Alspaugh ENG 301 (84450) November 16, 2008
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Creating a Paycheck Estimation Template Table of Contents Introduction  ........................................................................................................................................................................................ iii Getting Started       Gathering Materials. .......................................................................................................................................................................... 1  Other Sources. .................................................................................................................................................................................. 2 Formatting the Spreadsheet       Adapting the Microsoft Template. ...................................................................................................................................................... 3      Entering Personal Information. .......................................................................................................................................................... 9  Generating Formulas. ...................................................................................................................................................................... 11 Using the Template. ............................................................................................................................ 21                                                 Resources and Frequently Asked  Questions ………………………………………………………………………………………………………………………. ……………………………….22 This manual describes how to create a basic spreadsheet to be used in calculating both Gross and Net income. Formulas are given for the most common deductions employees are required to have, including State and Federal Taxes, SS, and Medicare. Optional formulas for retirement plans and medical coverage are provided. Created for single or married individuals paid hourly on a biweekly basis.
Background image of page 2
ii Introduction The purpose of this manual is to create a functioning spreadsheet template for employees who work on an hourly basis. It is designed to accommodate those making up to $6000 on a biweekly basis, in terms of tax deductions. Furthermore, the paycheck estimating template incorporates a wide range of individual’s circumstances including marital status, medical and retirement plans, life insurance, and holiday and overtime wages. The product is also unique in that it allows for tracking the entire years paychecks in two spreadsheets.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 27

Alspaugh-Instruction Manual-ENG301 (84450)-Nov2008 -...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online