Copyright 1996

User Friendly Software and Hardware, Inc.

Below are the descriptions of the files used by the UFS PAYROLL system and a short description of each.

1. Control File: The file in which default values and system setup information are entered. Technical name: stgcntrc

2. Chart of Accounts: The file for storing the general ledger account numbers. Technical name: stgchrtr

3. G/L Detail: The file in which the general ledger detail for each transaction is recorded. Technical name: stgdistd

4. Payroll Checks: This file contains payroll checks created by the system or added by the user. Technical name: pyochckx

5. Tax Table File: The file that stores data on tax amounts and percentages for the various pay periods, marital statuses, and income levels. Technical name: pyostaxr

The UFS Payroll package is designed to be completely menu-driven. In other words, you can access every function through a menu. When the operator is required to enter information, he or she is given a blank form on the screen to fill out. The screen forms, as you will see from this documentation, are largely self explanatory. Though it is necessary to learn the proper steps in which to do things, you never have to learn anything about computer languages or special commands in order to run the package. The methods of accessing and entering information are described in the Filepro 16 Users Manual.

The payroll main menu is accessed through the Accounting System main menu. To view it, type <4> at the main menu.

The following menu appears:

Enter/Update Employee Information

On the above menu, the following options appear:

This option allows you to add employees, update employee files, and review all employee information.

This option prompts the user for the type of payroll to create (Weekly, Monthly, etc.), then creates the standard checks for that type of payroll based upon the information in the employee file.

This option allows you to add, change or delete the checks created by the previous option. Hours can be entered; taxes are calculated automatically.

This option prints out an edit list of the check created by the two previous options. This edit list can be checked before the payroll checks are printed.

This option prints payroll checks.

This option prints a payroll check register.

This option post all payroll entries to the general ledger and adds check totals to quarter-to-date and year-to-date totals on the employee master file.

This option shifts all accumulated MTD information from the employee file to MTD -1 and all the MTD -1 to MTD -2.

This option removes all accumulated QTD information from the employee file.

This option removes all accumulated year-to-date information.

This allows you to setup the payroll accounts, the state disability rates, the FICA tax constant, the FICA exemption amount, and the last check date.

This option allows you to recall any prior pay check for review.

1 - Selecting this option tells the computer to print an employee list in employee number order. The list is in the short format shown in the appendix.

2 - By selecting this option at the payroll menu, the same list is printed, but in alphabetical order.

3 - This option prints a more detailed list of the information stored in the employee file. The computer asks the beginning and ending employee number for the employees you wish to print. It then prints the report shown in the appendix for each employee:

Before you can begin using the system, you must enter all the necessary information into the payroll control file; the accounts in the chart of accounts; the two tax tables; Federal and City/State and employees names and their pay rates and deductions. Account numbers must be added to the chart of accounts in the general ledger program.

Update the Payroll Control File

______________________________________________________________________

Screen 1 Enter Selection > Record: 1

D-Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

On the above screen you enter the basic account number for each pay account. If you do not use separate payment accounts you may leave these pay accounts blank and use one labor account which is added to the chart of accounts (see the UFS ACCOUNTING system manual for Chart of Accounts entry).

1.(optional) Enter the account number, sub-account number and description for each account to be used in the system.

2.(optional) Enter up to three disability rates in the decimal form (e.g. ten and a half percent would be entered as ".105, not "10.5"). The rate entered into the first disability field will be disability rate "1", the second will be rate "2" and the third rate "3".

3.(required) Enter the social security rate (e.g. 7.8% would be entered as ".078".

4.(required) Enter the F.I.C.A. exempt amount. This is the highest amount of gross wages that are taxable for FICA.

The "Last Check Posting Date" contains the date that payroll checks were last posted by the payroll system.

To enter the tax table information for State, City or Federal taxes, type <3> at the payroll main menu. The tax table screen looks like this:

TAXTABLE

F.I.T. Pay Period Codes

(D)aily (M)onthly

(W)eekly (Q)uarterly

(Bi)-weekly (H)alf-yearly

(S)emi-monthly (A)nnual

State/City Code:

Pay Period:

Marriage Status (S/M):

Over Amount:

Base Tax Amount:

Tax Percentage:

Standard Ded. Allowed: < -- Used in State Taxes Only

Personal Allowance First: < -- Used in State Taxes Only

Each Additional Allowance:

______________________________________________________________________

Screen 1 Enter Selection > Record: 1

D-Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

On the screen above, enter the basic taxable information, used by the system to calculate tax amounts. Federal/City/State taxes are all calculated with the identical formula. Gross wages are the employee's salary for the period or his hourly rate multiplied by his hours-worked. Then his total wages are determined from the gross by subtracting the product of the number of exemptions claimed and the exemption constant, minus the deductions before tax (if any) from his record in the employee file.

In determining the tax amount, the payroll system will use the employee's wages, marital status and payroll period (from the employee file) to locate the appropriate tax table. When the tax table is found the tax amount is calculated by adding the "Base Tax Amount" to the product of the "Tax Percentage" and the remaining wages.

The screen contains the following fields:

1. (Required for all non-federal taxes) State/City Code: If the tax table is for federal taxes, leave this field blank. If the table is for city or tax codes, enter the abbreviation code for that city or state (e.g., "ID" for the state of Idaho).

2. (Required) Pay Period: Using the codes on the table at the top of the screen, enter the Pay Period code which represents the frequency of payroll payments.

3. (Required) Marriage Status: Enter the tax table marital status ("S" for single, "M" for married.)

4. (Required) Over Amount: This is the lower dollar amount for the range of wages for a certain tax percentage. For example, to create a tax table entry for wages over $671 but not over $1,063, you would type "671" into this field.

5. (Optional) Base Tax Amount: If there is a base tax amount before taking a percentage, enter that dollar amount.

6. (Required) Tax Percentage: Enter the tax percentage for wages over the "Over Amount".

An example of a Tax Table Entry is shown below. This tax table record is for federal tax for a monthly pay period, for a single person with a monthly income of over $1,844 but not over $3,736.

F.I.T. Pay Period Codes

To enter employee information, type <1> at the payroll main menu. The employee screen looks like this:

_____________________________First_________Last_______________________

Employee# Name: SSN:

Department: Title: Date Hired:

Address: Birthdate:

Termination Date: City: State: Zip: Phone:

Fed Status: StateExp: Regular Rate: Sick Rate:

St. Status: Exp: Overtime Rate: Salary Rate: Hourly/Salary: Other Rate: Pay Rate: Full/Part: Vacation Rate:

Exempt State Unempl?: Holiday Rate:

State Code: Labor Account:

Extra State Tax Extra Fed. Tax FICA Y/N:

______________DEDUCTIONS____________________LEAVE_____________________

Acct Desc. Amount Limit CD TY Accrued Hrs.

Vacation: Sick: Other:

______________________________________________________________________

Screen 1 Enter Selection > Record: 1

D-Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

At this screen, enter the basic information about employees. This allows the system to calculate wages and withholding.

Enter information as shown below:

1. (Required) Enter the employee number. This number identifies the employee to the system and is used whenever selecting this employee.

2. (Required) Enter the employee's name.

3. (Required) Enter the employee's social security number next to the SSN prompt. Below enter a four digit code for their department.

4. (Required) Enter the employee's birth date and hire date in a MM/DD/YY format. There is an additional space for employee termination date.

5. (Required) Enter the employee's address and phone number. You can split the address over two lines or you can leave the second line empty.

6. (Required) Enter the number of exemptions this employee has for Federal withholding. Enter a whole number from one (1) to ten (10).

7. (Optional) Enter the employee's regular hourly rate.

8. (Optional) Enter the employee's regular salary rate.

9. (Optional) If the employee is hourly, enter the regular number of hours scheduled to work each pay period.

10. (Optional) Enter the employee overtime hourly rate.

11. (Required) Enter the employee's pay period. Use the same eight codes as used in the tax tables (D=Daily, W=Weekly, B=Bi-Weekly, S=Semi-Monthly, M=Monthly, Q=Quarterly, H=Half, Y=Yearly, A=Annually).

12. (Required) Enter the pay type. There are two types "H" for hourly and "S" for salary.

13. (Optional) If the employee has a premium pay rate, enter it here.

14. (Required) Enter an "F" if the employee if full-time; or a "P" if the employee is part-time.

15. (Optional) If the employee has a vacation rate, enter it here.

16. (Optional) If the employee has any paycheck deductions, enter the general ledger codes and the amounts of the deductions here. As the general ledger codes are entered a description of the category will appear.

17. (Optional) Enter Deduction Codes 0-6. Code 0 means do not take the deduction. 1 means the amount is a dollar amount to be subtracted from the gross before taxes are calculated. 2 means that the amount is a percentage to be multiplied by the gross pay then subtracted before taxes are calculated. 3 means that the amount is a dollar amount to be multiplied by the hours and subtracted from the gross before taxes are calculated. 4 means the amount is a dollar amount to be subtracted from the gross after taxes are calculated. 5 means that the amount is a percentage to be multiplied by the gross pay then subtracted after taxes are calculated. 6 means that the amount is a dollar amount to be multiplied by the hours and subtracted from the gross pay after taxes are calculated. Extra codes may be added to indicate areas such as deductions that are subtracted before taxes.

18. (Optional) Enter Deduction Type. This information is used by the computer when creating checks to select the type of deduction appropriate to that check run. "A" means to always take the deduction. "R" means regular deduction for deductions, which are taken regularly but not every pay period. "O" means that it is optional. You are asked if you want to take regular or optional deductions when you create checks.

19. (Optional) Enter the deductionsâ limits. This is the annual limit on any of these deductions.

20. (Optional) If you are entering an existing employee whom you have already been paying, enter an "X" next to the switch to totals screen so that you can enter your period-to-date payroll information in these fields. The program will take you to a view only screen, from which you may examine (but not update) the data.

A sample of what a screen of basic information looks like once it has been entered is shown below:

_____________________________First_________Last_______________________

Employee# 1 Name: John Jones SSN: 234-56-7890

Department: Title: Date Hired:

Address: Birthdate: 03/08/65

Termination Date: City: Blairsville State: GA Zip: 30512 Phone:

Fed Status: S Exp: 0 Regular Rate: 8.00 Sick Rate:

St. Status: S Exp: 0 Overtime Rate: Salary Rate: Hourly/Salary: H Other Rate: Pay Rate: Full/Part: F Vacation Rate:

Exempt State Unempl?: N Holiday Rate:

State Code: GA Labor Account:6000

Extra State Tax: Extra Fed. Tax: FICA Y/N:Y

______________DEDUCTIONS____________________LEAVE_____________________

Acct Desc. Amount Limit CD TY Accrued Hrs.

Vacation: Sick: Other:

______________________________________________________________________

Screen 1 Enter Selection > Record: 1

D-Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

In this sample, we see the typical entry for a single, full-time, hourly employee who normally works a 40 hour per week pay period.

When entering employees into the system who have already received wages, it is necessary to enter the amount of wages already paid to them and their withholding totals. This entry makes no adjustment to your ledger. It is assumed that these amounts were captured in some other fashion--a general journal entry, for example. This entry just starts the system with the current amount of the purposes for quarterly reporting.

When you are in the main employee screen during Employee File Maintenance (type <1> at the payroll main menu), you may type any character into the "Switch to Totals: field to go to the totals screen. If this screen has already had data entered into it by either a user or the payroll programs, you will be taken to a view-only screen which lets you examine (but not update) the data.

The screen on which you enter this startup information looks like this:

Employee Number: Name: SSN:

______________________________________________________________________

Month-2 Month-1 M.T.D. Q.T.D. Y.T.D.

Regular Pay:

Overtime Pay:

Other Pay:

Holiday Pay:

Vacation Pay:

Sick Pay:

Piece Work:

Expense:

Bonus:

Gross Wages:

Fed Tax:

FICA:

St. Disable:

State Tax:

City Tax:

Medicare Tax:

______________________________________________________________________

Screen 4 Enter Selection > Record: 1

D- Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

Fill in any payroll amounts from previous periods. Make sure Month-to-Date (MTD) data is also included in Quarter-to-Date (QTD) and Year-to-Date (YTD).

The Month-2 column is used for entering the totals for the month two months prior to the current month. This column need not be filled in if this month was in the previous quarter. The Month-1 column is used for entering the totals from the prior month. This column need not be filled in if the period month was in the previous quarter. The M.T.D.

(month-to-date) column is used for entering any accumulations for the current month. The Q.T.D. accumulations should be the total of months in the current quarter. The Y.T.D. accumulations are for the year-to-date.

In each row you enter the total that applies to the proper category of wage or deduction. These are the figures that will appear on your quarterly reports and W-2's at the end of the year.

Note: Data should not be entered into this screen once the payroll system is in daily use. If however, you need to change data on this

screen after data has already been entered, you must access it by typing the screen number on the command line while in the "View Mode" (where you type "U" to update, etc.). The numbers of the screens you may update are 2,4,6.

When you are done entering data into the totals screen, type any character into the "Total Deductions Screen" field to go to the deduction screen or into the "Return to Main Screen" field to go back to the main employee screen.

When you are in the Totals screen during Employee File Maintenance (see previous page), you may type any character into the "Total Deductions Screen" field to go to the deductions screen. If this screen has already had data entered into it by either a user or the payroll programs, you will be taken to a view-only screen, which lets you examine (but not update) the data.

The Deductions Screen looks like this:

Employee Number: XXXXX Name: XXXXXXXXXXXXXXX SSN:XXXXXXXXX

______________________________________________________________________

DEDUCTION TOTALS SCREEN

Acct Month-2 Month-1 MTD QTD YTD

Ded 1: _________ __________ _________ ________ _________

Ded 2: _________ __________ _________ ________ _________

Ded 3: _________ __________ _________ ________ _________

Ded 4: _________ __________ _________ ________ _________

Ded 5: _________ __________ _________ ________ _________

Ded 6: _________ __________ _________ ________ _________

Ded 7: _________ __________ _________ ________ _________

Ded 8: _________ __________ _________ ________ _________

Ded 9: _________ __________ _________ ________ _________

Ded 0: _________ __________ _________ ________ _________

Return to Total Screen: Return to Main Screen:

----------------------------------------------------------------------Screen 6 Enter Selection > Record: 1

D- Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

The above screen allows you to fill in the monthly, quarter to date, and year to date totals in each category of withholding. Underlines (_) indicate where you can enter information. The X's indicate where information is displayed from the previous screen.

How to use this screen:

The Month-2 column is used for entering the totals for the month two months prior to the current month. This column need not be filled in if this month was in the previous quarter. The Month-1 column is used for entering the totals from the prior month. This column need not be filled in if the period month was in the previous quarter. The M.T.D. (month-to-date) column is used for entering any accumulations for the current month. The Q.T.D. accumulations should be the total of months in the current quarter. The Y.T.D. accumulations are the year-to-date.

In each row you enter the total that applies to the proper category of wage or deduction. These are the figures that will appear on your quarterly reports and W-2's at the end of the year.

Note: Data should not be entered into this screen once the payroll system is in daily use. If however, you need to change data on this screen after data has already been entered, you must access it by typing the screen number on the command line while in the "View Mode" (where you type "U" to Update, etc.). The numbers of the screens you may update are 2,4 and 6.

When you are done entering data into the totals screen, type any character into the "Return to Totals Screen" field to go to the totals screen or into the "Return to Main Screen" field to go back to the main employee screen.

When it is time to do a payroll, select option <3> on the payroll menu. This option creates checks from the default values in the employee file.

You will be prompted with 3 questions:

1. Enter Pay Type - If you want to create a weekly payroll enter "W", for a monthly payroll enter a "M". This allows the same type codes as the payroll master file. If you need to create a payroll with employees that are paid weekly and employees that are paid monthly you just run this option 2 times, one for the weekly payroll and one for the monthly payroll.

2. Use optional deductions - If you used the deduction type code of "O" for optional then by answering this prompt with a "Y" it will deduct those deductions this payroll.

3. Use regular deductions - If you used the deduction type code of "R" for regular deductions then by answering this prompt with a "Y" it will deduct those deductions this payroll.

After these prompts the program will create a record for each active employee in the data entry file. An active employee is one without a termination date.

You can use the previous menu item to select which checks to create automatically, but you need not create any computer generated checks to create a payroll run. You can create your own checks or modify those created by the computer using the menu option for payroll data entry. When you select option <4> at the previous menu, you are taken to the Add/Update/Inquire file access menu for the paycheck file.

The normal menu allows you to use an index to select any already created check by employee number. Option number four on this menu allows you to add payroll data and create a new check. When doing this, the following screen displays:

Employee Number: Name: Salary:

INCOME

Screen 2 Enter Selection > Record: 1

D- Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

To enter data into this screen, first enter the employee code. The name appears next to the code as it is entered.

You can now enter income hours or deductions in the data entry area. This is done as follows:

1. Enter the code for the type of entry you are making. The codes are shown below. The two character code indicates what type of hours you are entering or what type of deductions.

Earnings Codes:

RE = Regular hours OV = Overtime hours

VA = Vacation hours HO = Holiday hours

EX = Expense reimbursement BO = Bonus pay

Deduction Codes:

AL = Always OP = Optional

RG = Regular M1 - M6 = Manual Deductions

2. If you enter a type that has a number (hour, piecework), enter the number of hours or pieces in the next column. If you are entering regular hours, the system defaults to the hours in the employees master file. This can be overwritten if you need to change it. If the type you enter does not take a number, this column is skipped.

3. If you enter a type that has a rate (hours, piecework), enter the rate used. For regular, overtime, etc., the system defaults to the rate in the employees file. This can be changed by the user. If the type chosen does not take a rate, it is skipped.

4. If you are using a type with a number and rate, the amount is

calculated automatically and this column is skipped. If the code does not take a rate, enter the amount.

5. The account number for all income accounts defaults to the payroll account in the employee files. You can change this number to any legitimate number on the system. For expense and discount entries you can enter any account number you wish.

6. As you enter information, the totals are calculated in the bottom part of the screen based upon the information in the employees file.

About Deductions:

The first set of deductionsâ codes can be used to automatically recall the deductions setup in the employee's file.

1. If you type "AL" in the code section, the system will recall all the "A" type deductions in the employee's file.

2. If you type "RG", the system will recall and calculate all regular deductions.

3. If you enter "OP", the system will recall and calculate all optional deductions.

For Manual entries, it is necessary to tell the computer how to calculate the deduction and when to take it off the gross pay.

1. If you enter a "MA", the system lets you manually enter or change a deduction. For manual deductions, only the number (if any) multiplied by rate calculation is made.

2. M1 means the amount is a dollar amount to be subtracted from the gross before taxes.

3. M2 means that the amount is a percentage to be multiplied by the gross pay then subtracted before taxes.

4. M3. means that the amount is a dollar amount to be multiplied by the total paycheck hours and subtracted before taxes.

5. M4 means the amount is a dollar amount to be subtracted from the gross after taxes.

6. M5 means the amount is a percentage to be multiplied by the gross pay then subtracted after taxes.

7. M6 means that the amount is a dollar amount to be multiplied by the hours and subtracted before taxes.

Employee Number: Name: Salary:

INCOME

______________________________________________________________________

Screen 2 Enter Selection > Record: 1

D- Delete, H-Hardcopy, U-Update, X-Exit, F-Print Form, B-Browse

The above sample shows a typical entry.

After you have created a payroll file automatically or manually and changed the payroll, you should print out an edit list to review the payroll on paper before printing it. The payroll edit list allows you to correct the payroll before the printing of checks. To print a payroll edit list, type <5> at the payroll menu.

See Appendix A for sample printouts.

After the payroll has been created and checked in the edit list, you can print checks. This is done by selecting <6> at the payroll menu. The computer displays the message: "enter message:" This message is optional. If you press ENTER this will be blank but if you want to print a one line message on each check stub enter it here.

At this point you should insert the checks into the printer and align them properly. When you press enter, the computer goes through the payroll checks and then asks: "period ending date:" and "check date:"

You should enter the date you want in the MM/DD/YY format.

The computer then asks: "Enter beginning check number:" This is the number on the first check to be printed.

The system then waits for you to enter the number of the first check printer.

Appendix A contains an example of the printed check.

After the paychecks have been successfully printed, you print the payroll check register. While the check register prints, this process also updates your employee history and general ledger files. To print the register, select <7> from the payroll menu.

See Appendix A for a sample check register.

This option adds the current payroll information to the MTD, QTD and YTD total in the employee master file. It also makes G/L entries for the current payroll in the G/L distribution file.

The information needed to fill in the federal quarterly report is printed in a pair of reports called up from the Payroll Report Menu by typing <A>. Both are shown in the appendix.

At the end of the year, you need to print the Federal Government's W2 form. This is done by selecting option <F> from the Payroll Report Menu. When you do so, the form shown in the appendix is printed for each employee.

On this form, pre-printed information is shown in an abbreviated form and appears in parentheses. This form changes from year to year. This was the most recent version. The system needs to be adjusted as it changes if you want to print directly to the form itself.

At the end of each month, the totals for the current month must be shifted into the previous month fields (the "month-1" fields) and the old month-1 totals moved into month-2. Then the current month amounts are cleared out. This should be done only after you have completely finished the previous month's reports, and must be done before processing any payroll for the next month.

This month-end processing is run by typing <A> at the Payroll Main Menu. The following message appears on the screen:

Press <ENTER> and the computer does the month-end closing.

To print the quarterly hours report, type <C> at the Payroll Report Menu.

Press <ENTER> and the computer runs the Quarterly Hours report. This report is in the format shown in the appendix:

At the end of each quarter, the current quarter amounts must be cleared out. This should be done only after you have completely finished the current quarter's reports, and must be done before processing any payroll for the next month. This quarter-end processing is run by typing <B> at the Payroll Main Menu. The following message appears on the screen:

Press <ENTER> and the computer does the month-end closing.

At the end of each year, the current year amount must be cleared out. This should be done only after you have completely finished the current year's reports, and must be done before processing any payroll for the next month. This year-end processing is run by typing <> at the Payroll Main Menu. The following message appears on the screen:

Press <ENTER> and the computer does the year end closing.

EMPLOYEE LIST BY NUMBER

NUMBER NAME DEPT/DIV ADDRESS

1 John Jones 110 Elm Street

Blairsville GA 30512

2 Bill McDonald 555 Georgia Avenue

Blairsville GA 30512

3 Susan Thomas 36 Appletree Court

Blairsville GA 30512

Hours Income Deductions

Totals: Reg: 120.00 .00 Befr: .00

Ovr: .00 .00 Fedx:

Vac: .00 .00 Stat:

Hol: .00 .00 City:

Sck: .00 .00 Disa:

Oth: .00 .00 FICA:

Mcar:

Aftr:

Expenses:

Gross: Net Wage:

Employers FICA Amt:

Employers Medicare:

Printed 10/03/96 PAYROLL EDIT LIST pg. 1

Employee

Type Number Rate Amount Code Hours Income Deduction

_________________________________________________________________

Salary:

3 Susan Thomas 6000 Reg: 40.00 560.00 Befr:

RE 40:00 14.00 560.00 Ovr: Fedx: 85.7

Vac: Stat: 25.5

Hol: City:

Sck: Disa: .0

Oth: FICA:

Aftr:

Total Expenses: Gross: 560.00 Net Wage:

Employers FICA Amount:

Employers Medicare:

2 Bill McDonald

RE 40.00 15.00 600.00 6000 Reg: 40.00 600.00 Befr:

Ovr: Fedx: 96.9

Vac: Stat: 27.9

Hol: City:

Sck: Disa: .0 Oth: FICA: 37.2

Mcar: 8.7

Aftr:

Total Expenses:

Gross: 600.00 Net Wage: 429.2 Employers FICA Amount: 37.2 Employers Medicare: 8.7

Date :Oct 3, 1996 Year to Date Payroll Journal Page : 1

------Earnings----- --------------Deductions-------------

REG O/T Other FWH FICA Mcare SWH Other

---------------------------------------------------------------------

John Jones 1

YTD 13520.00 .00 1768.00 838.24 196.04 577.29 .00

Bill McDonald 2

YTD 21570.00 .00 3483.00 1337.36 312.78 1071.08 .00

Susan Thomas 3

YTD 16578.00 .00 2258.00 1019.16 221.94 761.60 .00

Grand totals

YTD 51668.00 .00 .00 7509.00 3194.76 730.76 2409.97 .00

Date :Oct 3, 1996 Month to Date Payroll Journal Page : 1

--------Earnings---------Deductions-------------------------

Reg O/T Other FWH FI Mcare SWH Other

John Jones 1

MTD .00 .00

YTD 13520.00 .00 1768.00 838.24 196.04 577.29 .00

Bill McDonald 2

MTD .00 .00

YTD 21570.00 .00 3483.00 1337.36 312.78 1071.08 .00

Susan Thomas 3

MTD .00 .00

YTD 16578.00 .00 2258.00 1019.16 221.94 761.60 .00

Grand Totals

MTD .00 .00 .00 .00 .00 .00 .00 .00

YTD 51668.00 .00 .00 7509.00 3194.76 760.76 2409.97 .00

Print Date: 10/03/96 Quarterly Report Page: 1

YTD QTD QTR QTR SUTA SUTA FUTA FUTA

** Based on FUTA Limit of SUTA Limit of 8500.00

PAYROLL QUARTERLY HOURS REPORT

Date:10/03/96 Page: 1

Employee Name RegHrs OverTime VacHrs HolHrs Othe

1 John Jones 40.00 .00 .00 .00 .00

2 Bill McDonald 40.00 .00 .00 .00 .00

3 Susan Thomas 40.00 .00 .00 .00 .00

-----------------------------------------------------------------------

Total: 120.00 .00 .00 .00 .00

------------------------------------------------------------------------

Date : Oct 3, 1996 YTD Wages Report

Page : 1

YTD Gross State Wages Fed W/H FICA

----------------------------------------------------------------------- 1 John Jones 13520.00 13520.00 1768.00 838.24

13520.00 13520.00 13520.00 577.29 196.04

2 Bill McDonald 21570.00 21570.00 3483.00 1337.36

21570.00 21570.00 21570.00 1071.08 312.78

51668.00 51668.00 51668.00 2409.97 730.76

-------------------------------------------------------

EMPLOYEE DETAIL FILE

-----------------------------------------------------------------------

Employee #: 1 Name: John Jones SSN: 555-43-7653

Division: Department: Title:

Address: 110 Elm Street Date Hired:

Address: Birthdate:

City: Blairsville State: GA Zip: 30512 Date Terminated:

Phone:

Exemptions: 0 Regular Rate: 10.00 Salary Rate:

Regr. Hrs: Overtime Rate: Pay Period: W

Pay Type: H Other Rate: Marital Status:

Full/Part: F Vacation Rate: Labor Account: 6000

Disability: State Code: City Code:

DEDUCTIONS ACCRUED

Acct. Description Amount Limit CD TY YTD Hrs. Accrued Hrs. Left

Reg: 40.00 Holiday:

OT: .00 Vacation:

Other: .00 Sickness:

Month - 2 Month - 1 M.T.D. Q.T.D. Y.T.D.

Regular Pay: 13520.00

Overtime Pay:

Other Pay:

Holiday Pay:

Vacation Pay:

Sick Pay:

Gross Pay: .00 .00 13520.00

Fed Tax: 1768.00

FICA: 838.24

St. Disable:

State Tax: 577.29

City Tax:

Ded 1:

Ded 2:

Ded 3:

Ded 4:

Ded 5:

Ded 6:

Ded 7:

Ded 8:

Ded 9:

Ded 0:

Employerâs Quarterly Federal Tax Report

10/03/96

1a Number of employees 3

b EIN

2 Total wages .00

3 Total FIT withheld .00

4 Adjustment of withheld tax .00

5 Adjusted FIT withheld .00

6 Taxable social security .00

a Soc. Sec. Tax .00

b Taxable Tips

7 Taxable Medicare Wages .00

Medicare Tax .00

8 Total soc.sec. & medicare .00

9 Social security adjustment

10 Adjusted social security .00

11 Backup withholding

12 Backup adjustment

13 Adjusted backup .00

14 Total taxes .00

15 EIC payments

16 Net taxes .00

17 Quarter total deposits

Undeposited taxes due $ .00