Use mail merge to make labels for your all or part of your mailing list. Microsoft Word has label layouts for many address label and shipping label sizes. How to Create Labels in Microsoft Word. This wikiHow teaches you how to set up and print a template for a single label or multiple labels in Microsoft Word. Obtain. Creating a Payroll Spreadsheet Chron. If you choose to calculate payroll manually, ensure the calculations are correct. JupiterimagesPhotos. Getty Images. To your employees, payday is always an important day. Providing pay and salaries on time is essential to maintain the morale and performance of your staff. Creating A Spreadsheet In Microsoft Word' title='Creating A Spreadsheet In Microsoft Word' />It is equally important that you calculate pay and taxes for your employees accurately. Few things upset employees more than when employers make errors on their paychecks. Many small businesses use an outside accountant or bookkeeper to process payroll for them, but doing this can substantially reduce your bottom line if you have many employees. Even if you only have a few staff members, though, you can still save money by calculating and processing your own payroll. Armed with basic payroll information, you can use a spreadsheet application such as Microsoft Excel to create your own payroll worksheets and calculate how much you should pay your employees as well as how much youre required to submit to the government for withholding and taxes. Why Use a Spreadsheet. You could use a word processor or text editor application to create payroll documents, but you would still have to use an adding machine or calculator to tally up the totals. Spreadsheets are ideal for payroll because they allow you to format text and labels much as you would in a word processor while also providing easy to use formulas and calculations that make quick work of figuring how much you owe your employees and the government. Properly calculating payroll involves more than just addition and subtraction, and spreadsheet applications like Excel make it relatively easy to tally gross pay, net pay and taxes owed. Fundamental Elements of a Payroll Spreadsheet. A spreadsheet is a table of values arranged in rows and columns. Each value can have a predefined relationship to the other values. If you change one value, therefore. Games Crazy Taxi 2. Creating A Spreadsheet In Microsoft Word' title='Creating A Spreadsheet In Microsoft Word' />The elements needed in a payroll spreadsheet are not complicated and implementing them is relatively straightforward. Of course, the spreadsheet should contain fields for each employees name and Social Security number, but you may also want to include fields for department, employee ID or other company specific data. Depending on whether you pay your employees fixed salaries or hourly rates, your spreadsheet will need a single Gross Pay field or two fields to calculate earning based on hourly rates multiplied by the number of hours worked. To calculate earnings after taxes, youll need fields for Federal Withholding, Medicare and Social Security Insurance deductions. If your state has an income tax or other withholding taxes, your spreadsheet must include fields for those deductions as well. All values in the spreadsheet should consist of two cells one for the label describing the value and the other for the actual value or amount. For instance, to display Gross Pay in the spreadsheet, you would use two cells located side by side or in two adjacent columns. Calculations and Entering Data. You can use a spreadsheet to calculate many of the amount values needed for payroll rather easily. For instance, to calculate the total gross pay for an hourly employee, you simply need to create three fields in the spreadsheet one for Number of Hours Worked, one for Hourly Rate of Pay and one for Gross Pay. To calculate the value for the Gross Pay field, simply enter the formula in the field using the A2B2 formula, where A2 and B2 are the cells used for the Number of Hours Worked and Hourly Rate of Pay value fields. Likewise, you can use the SUM feature on the spreadsheet toolbar to create totals for amounts in a single column. If you need to enter a deduction value, such as a Medicare or Withholding Tax deduction, enter those amounts preceded by a negative symbol. For example, if the employees Federal Withholding Tax amount is 1. Withholding Tax label field. What Payroll Spreadsheets Cant Calculate. Spreadsheets can help you calculate most of the amount values needed for payroll, but you must enter some figures manually. Federal Withholding Tax is a good example of an amount that a spreadsheet cannot calculate automatically or dynamically from other values. Because employees claim different filing statuses, numbers of dependents and so on, you must enter the deduction amount for tax withholding manually. Patch No Cd Football Manager 2006. To determine the amount to withhold for an employee, refer to IRS Publication 1. Circular E, a free download on the IRS. This publication can also help you calculate Federal Unemployment, Medicare and Social Security Insurance amounts as well. Using a Template. Creating your own payroll spreadsheet is not difficult, but there is really no reason to create one at all in most cases unless you just want the practical experience of creating one from scratch. If you search the Internet, you can find hundreds of ready made payroll templates that you can customize and use in popular spreadsheet programs. Payroll templates are easy to download and customize by changing labels or adding fields as needed. If you use Microsoft Excel, you can download many payroll templates directly from the Microsoft Office website. If you use another spreadsheet program, just run a search on your favorite search engine to find templates for that application. After you download a template, you can use it to create normal spreadsheet files from it. That way, you only need make needed changes to the template once. After that, all spreadsheets created from the template incorporate the customizations needed for your business. About the Author. Jeff Grundy has been writing computer related articles and tutorials since 1. How To Program Scalextric Digital'>How To Program Scalextric Digital. Since that time, Grundy has written many guides to using various applications that are published on numerous how to and tutorial sites. Born and raised in South Georgia, Grundy holds a Master of Science degree in mathematics from the Georgia Institute of Technology. Photo Credits. JupiterimagesPhotos.