Hi, I need help with an accounting project. I know it looks like a lot but really this is information about it so you have a good idea on how to do it.

Read pages 7-1 thru 7-6. All the information contained on these pages is informational. It is important to understand the nuances of the company. On page 7-7, you will find the information for the October 9th payroll (Narrative of Payroll Transactions). This payroll carries over to Page 7-8. Go to page 7-8. There you will see the "Time Clerk's Report" for the 2 weeks that make up the payroll for October 9. You will use these time sheets (similar going forward) for the remaining payrolls. Not ALL the employees are going to be on the time sheets. Many of the employees are paid a "salary" so they will NOT show up on the time sheets but will show up on the Payroll Register. They will have their hours listed on the Payroll Register as (8 8 8 8 8) by their names. There are 3 hourly employees that are paid based entirely on the # of hours times their hourly rate (you are one of those employees named "student"). Like I said, all others are paid a set salary for the 2 week period so their salary will not change from period to period (unless they don't show up to work). From Page 7-9 thru 7-10, the book explains the journal entries made for the October 9 payroll. This includes both the Payroll journal and the Employer's Payroll Tax journal like we did in Chapter 6. You will also need to POST the journal entries to the General Ledger accounts. In your spreadsheet, if you click on the Payroll Register tab, you will see the hours and the payroll information entered in the Payroll Register (you use the register to create your journal entries). If you click on the Employee Earnings Record tab, you will see the information from October 9 payroll entered in EACH employees record.

The October 9 payroll is completed for you in the Excel file. Use it to help you do the October 23 payroll. You can track the Payroll Register entries, the posting of the Payroll Register to the Employee Earnings Record, the Journal Entries and the posting of the Journal Entries to the General Ledger accounts. You will basically repeat this procedure for the next payrolls using different numbers (that you calculate).

At the top of page 7-11, the date changes to October 15 (from October 9). You do not have to do anything with this entry. Then the date changes to October 20

This is where you begin...OCTOBER 20, 2014 (transaction No. 2)

The first thing you do is record the payment of the SIT (State Income Tax) to the state of Pennsylvania. The entry will be your FIRST actual entry into your General Journal and your FIRST posting to the General Ledger accounts. You will also fill out the form on Page 7-50 (Transaction No. 2). The book explains everything you need to do here.

NEXT...you get to do your first FULL payroll - October 23 (P 7-11 thru P 7-12).

The step by step process is as follows:

1. Record the time in the Payroll Register. There are many formulas that automatically calculate OASDI, HI, SIT, CIT, etc. You WILL have to calculate the Federal Income Tax (FIT) for each employee. You will use the Bracket Method for this (Biweekly). Some employees will have the same amount withheld so you can copy from the 10/9 payroll. BUT be careful, some employee wages change due to OT. Going forward, employees will change their # of allowances, marital status, etc. You will need to work at determining the proper FIT withholding. Other items you will need to calculate are the FUTATaxable Wagesand SUTATaxable Wages. You will need to check the YTD wages for each employee. Once they reach the cap, their wages are not taxable. If they have not reached the limit, then you need to determine how much of the wages paid that period are taxable for FUTA, SUTA.

2. Post the Payroll Register information to each Employee Earnings Record. The October 23rd payroll will have Group Health Insurance withheld from the employees paycheck. Use the October 9 payroll as a guide for the other items. To calculate the amount of Group Insurance to withhold, you will go to the Employee Earnings Records (7-43). There you will see the Group Insurance box. For Bonno, it shows $55,000 and $0.30/M. You basically take $55,000 / $1,000 x $.30 = $16.50. Bonno will have $16.50 withheld from the October 23 payroll. Ferguson would have $26.40 withheld for Group Insurance.

3. Prepare the journal entry to record the payroll. Don't forget about transferring money from the cash account to the payroll cash account. Don't forget about the Employer's Payroll Tax journal entry that captures the matching portion of FICA and the FUTA/SUTA taxes.

4. Post the journal entry to the general ledger accounts.

After the payroll is completed and all posting are done, save the Excel spreadsheet as Oct 23_(your initials). Then submit the Excel file to me via the appropriate link. You will complete a couple payrolls per week so do NOT get behind.

NOTE: You MUST change the "student" name on the payroll register to YOUR NAME! If you do not change the name, I will NOT accept the payroll. I will grade it as a zero and make you resubmit the payroll with the change which will be subject to the 10% late penalty per day.

After October 23 is completed, you will then proceed to the NEXT TRANSACTION in the book which is November 4. Go through each transaction until you get to the next payroll (November 6 payroll). Complete the November 6 payroll. Save that file as November 6_(your name) and submit it using the appropriate drop box.

There are a couple other items that the book asks you to do. You will be asked to fill out forms. Fill out the forms in your book. You will not need to turn them in. It is good practice to do a couple forms so you see how they are done. If you have questions, I'll help you through them.

This will be a challenge at first but will get progressively easier. If you run into a "special" payroll (we have to fire someone and someone actually dies during this project), just complete it and wait to send it with your next scheduled payroll.

2015 State of Nebraska Payroll Project The following data for the Bugeaters Corporation relate to the payroll for the week ended December 31, 2014. Federal Income Tax and State Income Tax will be affected by the SIMPLE contribution. The Employer portion of SUTA is 4.5% with a $9,000 cap. OASDI and HI are withheld at their respective rates of 6.2% and 1.45%. The OASDI wage cap is $117,000. There is no wage cap for HI. Federal State Weekly Employee Hours Status Rate Income Income Simple Group YTD Salary Tax Tax IRA Insurance Wages Rozier 48 M6 $22 TBD TBD 4.0% $12.00 $39,490 Green 42 S0 $19 TBD TBD 2.5% $10.50 $52,450 Hipp 44 M2 $23 TBD TBD 3.5% $12.50 $45,680 Craig 36 S2 $16 TBD TBD NA $9.00 $ 3,280 Redwine 45 S0 $20 TBD TBD 3.0% $11.00 $53,200 Johnson M3 $2,800 TBD TBD 5.0% $18.50 $115,800 Burkhead 35 M1 $13 TBD TBD NA $8.25 $ 5,200 Phillips S1 $3,450 TBD TBD 6.0% $22.50 $179,400 Jones 41 M4 $18 TBD TBD NA $10.50 $ 8,300 On the Payroll Register provided, calculate the last payroll for the year. You will need to calculate the Taxable Wages for each person based on the information provided. You will use the Wage Bracket method for FIT and SIT (NE) withholding for each employee when appropriate. If the wages are unavailable using the Wage Bracket method, you will use the Percentage Method to calculate FIT and SIT withholding for each employee. You will also be required to prepare the following journal entries: 1. Record the payroll entry from the payroll register and post to the ledger accounts. 2. Record the employer payroll tax entry and post to the ledger accounts. 3. Record the 941 payment for FIT and FICA taxes to the IRS and post to the ledger accounts. 4. Record the 941N payment to the NDOR for SIT and post to the ledger accounts. NOTE: Date your journal entries for the tax payments January 15, 2015. CONTINUED ON THE NEXT PAGE 5. Prepare the 941 and the 941N for the 4th quarter. The following information will be used for the appropriate forms. Federal Income Taxes for OCT = $8,729.00 State Income Taxes for OCT = $2,876.00 Federal Income Taxes for NOV = $6,983.00 State Income Taxes for NOV = $2,301.00 Federal Income Taxes for DEC = $5,238.00 State Income Taxes for DEC = $1,727.00 NOTE: The December tax totals do NOT include the current weekly payroll. 6. Prepare the W-2 for each employee. Payroll Project - Check Figures - 2015 TAXABLE EARNINGS SIT SUTA CIT NET FUTA 9-Oct DATE 15,460.17 REG OT - 15,460.77 TOTAL OASDI 958.57 224.19 HI 1,142.00 FIT 474.67 10.85 606.67 - 16.00 - 12,027.82 3,818.00 4,778.00 23-Oct 15,460.77 321.92 15,782.69 978.53 228.86 1,173.00 484.55 11.07 619.29 181.20 16.00 - 12,090.19 692.00 4,778.00 6-Nov 15,415.54 - 15,415.54 955.77 223.54 1,265.00 473.28 10.82 604.90 - 16.00 - 11,866.23 - 1,778.00 13-Nov 2,079.32 - 2,079.32 128.92 30.15 336.00 63.84 1.46 81.59 14.40 - - 1,422.96 - - 20-Nov 13,925.29 - 13,925.29 863.38 201.94 852.00 427.53 9.77 546.42 166.80 16.00 1,650.00 9,191.45 - 176.00 4-Dec 15,365.69 363.40 15,729.09 975.21 228.09 1,045.00 482.91 11.04 617.20 - 16.00 1,650.00 10,703.64 14-Dec 1,134.00 - 2,394.00 148.43 34.71 - 1.68 - 14.70 - 18-Dec 90,543.69 612.60 91,156.29 4,750.30 1,321.78 182.10 18.00 27,622.62 2,798.52 63.83 GROUP 3,576.96 UNION SIMPLE 4,950.00 2,194.48 45,872.18 1,080.00 2,460.00 SUTA 1,080.00 2,460.00 Page 41 JOURNAL DATE 20-- Oct. DESCRIPTION 9 Payroll Cash Cash POST. REF. DEBIT 12 11 12,027.82 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 2,307.69 4,651.08 3,600.00 4,902.00 9 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20.1 20.2 21 22 CREDIT 1,381.42 12,027.82 958.57 224.19 1,142.00 474.67 10.85 606.67 16.00 12,027.82 958.57 224.18 22.91 175.76 Page 42 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 43 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 44 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT Page 45 JOURNAL DATE 20-- DESCRIPTION CREDIT POST. REF. DEBIT CREDIT Page 46 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT Page 47 JOURNAL DATE 20-- DESCRIPTION CREDIT POST. REF. DEBIT CREDIT Page 48 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT Page 49 JOURNAL DATE 20-- DESCRIPTION CREDIT POST. REF. DEBIT CREDIT Page 50 JOURNAL DATE DESCRIPTION POST. REF. DEBIT CREDIT 20-- Total debits and credits (calculated automatically): 293,468.75 293,468.75 Your debits and credits should be equal after each journal entry is complete Journal Checkpoints October 31, 20-November 30, 20-- December 31, 20-January 31, 20-- GENERAL LEDGER ACCOUNT: DATE 20-- Oct. 1 Balance 9 DEBIT CREDIT POST. REF. BALANCE DEBIT 12,027.82 CREDIT 12,027.82 FICA TAXES PAYABLE - OASDI 9 9 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- DEBIT CREDIT 12,027.82 0.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- J41 J41 BALANCE DEBIT CREDIT 958.57 958.57 DEBIT CREDIT 958.57 1,917.14 Credit Balance Debit Balance Credit Balance Checkpoints ACCOUNT NO. 20.1 POST. REF. Debit Balance Checkpoints ACCOUNT NO. 12 J41 J41 ITEM DEBIT 199,846.33 12,027.82 187,818.51 a 9 9 DATE Oct. BALANCE J41 ITEM ACCOUNT: 20-- POST. REF. PAYROLL CASH DATE 20-- ACCOUNT NO. 11 ITEM ACCOUNT: Oct. Checkpoints CASH Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Credit Balance ACCOUNT: FICA TAXES PAYABLE - HI DATE 20-- Oct. ITEM 9 9 ACCOUNT: 20-- Oct. Oct. ITEM 1 Balance 9 CREDIT 9 CREDIT 224.19 448.37 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- POST. REF. BALANCE DEBIT a CREDIT DEBIT CREDIT 392.94 415.85 22.91 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- J41 BALANCE DEBIT CREDIT 175.76 DEBIT Credit Balance CREDIT 175.76 Debit Balance Credit Balance Checkpoints ACCOUNT NO. 22 POST. REF. Debit Balance Checkpoints ACCOUNT NO. 21 J41 ITEM DEBIT 224.19 224.18 SUTA TAXES PAYABLE - EMPLOYER DATE 20-- BALANCE DEBIT FUTA TAXES PAYABLE ACCOUNT: Oct. POST. REF. J41 J41 DATE Checkpoints ACCOUNT NO. 20.2 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Credit Balance ACCOUNT: EMPLOYEES FIT PAYABLE DATE 20-- Oct. ITEM 9 ACCOUNT: 20-- Oct. 9 9 POST. REF. 9 CREDIT 1,142.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- CREDIT DEBIT 474.67 CREDIT 474.67 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- BALANCE DEBIT CREDIT DEBIT CREDIT 10.85 10.85 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- J41 BALANCE DEBIT CREDIT 606.67 DEBIT CREDIT 606.67 Debit Balance Credit Balance Debit Balance Credit Balance Checkpoints ACCOUNT NO. 26 POST. REF. Credit Balance Checkpoints ACCOUNT NO. 25.1 POST. REF. Debit Balance Checkpoints BALANCE DEBIT J41 ITEM DEBIT ACCOUNT NO. 25 EMPLOYEES CIT PAYABLE DATE 20-- CREDIT 1,142.00 J41 ITEM ACCOUNT: Oct. DEBIT EMPLOYEES SUTA PAYABLE DATE Oct. BALANCE J41 ITEM ACCOUNT: 20-- POST. REF. EMPLOYEES SIT PAYABLE DATE Checkpoints ACCOUNT NO. 24 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Credit Balance ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED DATE ITEM POST. REF. Checkpoints ACCOUNT NO. 27 BALANCE DEBIT CREDIT DEBIT CREDIT 20-- ACCOUNT: UNION DUES PAYABLE DATE 20-- Oct. ACCOUNT: DATE ITEM 9 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 16.00 SIMPLE CONTRIBUTIONS PAYABLE 16.00 BALANCE DEBIT CREDIT DEBIT CREDIT 20-- ACCOUNT: Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- ADMINISTRATIVE SALARIES ACCOUNT NO. 51 POST. BALANCE Debit Balance Credit Balance Checkpoints ACCOUNT NO. 29 POST. REF. Credit Balance Checkpoints ACCOUNT NO. 28 J41 ITEM Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Credit Balance Checkpoints Debit Balance Credit Balance DATE 20-- Oct. ACCOUNT: ITEM 1 Balance 9 Oct. ACCOUNT: 20-- ACCOUNT: 1 Balance 9 Oct. POST. REF. J41 1 Balance 9 BALANCE DEBIT CREDIT DEBIT CREDIT 28,350.00 33,001.08 4,651.08 POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 28,525.00 32,125.00 a 3,600.00 PLANT WAGES 1 Balance 9 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Checkpoints Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- BALANCE DEBIT a J41 4,902.00 CREDIT DEBIT 42,657.30 47,559.30 CREDIT Credit Balance Debit Balance Credit Balance Checkpoints ACCOUNT NO. 54 POST. REF. Debit Balance Checkpoints ACCOUNT NO. 53 J41 ITEM CREDIT ACCOUNT NO. 52 a ITEM DEBIT 42,692.27 44,999.96 2,307.69 SALES SALARIES DATE 20-- CREDIT a J41 ITEM DATE Oct. DEBIT OFFICE SALARIES DATE 20-- REF. Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Credit Balance ACCOUNT: PAYROLL TAXES DATE 20-- Oct. ITEM 1 Balance 9 Checkpoints ACCOUNT NO. 56 POST. REF. BALANCE DEBIT a J41 1,381.42 CREDIT DEBIT 14,068.41 15,449.83 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance Credit Balance Payday, October 9, 20-- Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record GLO-BRITE PAINT COMPANY Regular Earnings Rate Per S M T W T F S S M T W T F S Hrs. Hour Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. OASDI HI FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant For Period Ending October 3, 20-- M M S M M S M M S S 4 5 2 4 3 1 4 2 1 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17.65 80 80 80 80 80 80 18.00 80 72 14.00 80 1,412.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 1,412.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 87.54 139.50 75.64 83.70 143.08 74.40 89.28 127.10 62.50 75.83 20.47 32.63 17.69 19.58 33.46 17.40 20.88 29.73 14.62 17.73 48.00 140.00 108.00 42.00 194.00 128.00 52.00 178.00 98.00 154.00 43.35 69.08 37.45 41.45 70.85 36.84 44.21 62.94 30.95 37.55 0.99 1.58 0.85 0.95 1.62 0.84 1.01 1.44 0.71 0.86 55.41 88.29 47.87 52.97 90.55 47.09 56.51 80.44 39.55 47.99 15,460.77 15,460.77 958.57 224.19 1,142.00 474.67 10.85 606.67 0 17.65 0 0 0 0 0 0 18.00 0 0 14.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 682 683 684 685 686 687 688 689 690 691 0 17.65 0 0 0 0 0 0 18.00 0 0 14.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 692 693 694 695 696 697 698 699 700 701 0.00 0.00 #VALUE! #VALUE! #VALUE! 702 0 17.65 0 0 0 0 0 0 18.00 0 0 14.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 703 704 705 706 707 708 709 710 711 0 17.65 0 0 0 0 0 0 18.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 712 713 714 715 716 717 718 719 TOTALS 8.00 672 673 674 675 676 677 678 679 680 681 8.00 0.00 16.00 0.00 Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Payday, November 6, 20-- For Period Ending October 31, 20-- Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Payday, November 13, 20-- For Period Ending November 14, 20-- Williams, R. TOTALS Payday, November 20, 20-- For Period Ending November 14, 20-- Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) 1,148.24 1,778.92 932.50 1,109.35 1,774.13 895.43 1,168.11 1,570.35 761.67 889.12 1,412.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 1,412.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 12,027.82 15,460.77 15,460.77 Payday, October 23, 20-- For Period Ending October 17, 20-- TOTALS Payday, December 4, 20-- For Period Ending November 28, 20-- Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. Amount Taxable Earnings 1,412.00 2,250.00 700.00 1,350.00 1,220.00 1,350.00 1,220.00 1,350.00 2,307.69 760.00 1,200.00 1,200.00 1,440.00 2,050.00 1,008.00 1,008.00 3,818.00 4,778.00 1,008.00 1,223.08 2,307.69 4,651.08 3,600.00 4,902.00 (Student) Woods, B. 0 14.00 0 0.00 0.00 0.00 0.00 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 720 721 0.00 0.00 #VALUE! #VALUE! #VALUE! 722 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 723 724 725 726 727 728 729 730 731 732 TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-- Russell, V. TOTALS Payday, December 18, 20-- For Period Ending December 12, 20-- Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS 0 17.65 0 0 0 0 0 18.00 0 0 14.00 0 0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid DEPARTMENT OCCUPATION WORKS IN (STATE) Plant Mixer Operator PA SEX M F x S.S. ACCOUNT NO. 000-00-3481 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST BONNO Anthony $ $ $ $ SALARY UNIION DUES OTHER WEEKLY RATE HOURLY RATE $55,000 --$.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS OVERTIME R CUMULATIVE PAYDAY RATE AMOUNT 2 80 10/9 10/23 3 11/6 4 11/20 5 12/4 6 12/18 RATE 10,293.40 1,412.00 YEAR-TO-DATE 1 HRS. 17.65 17.65 17.65 17.65 17.65 17.65 AMOUNT 11,322.00 12,734.00 17.65 26.48 MARITAL ALLOW. STATUS 4 M NET PAID FICA OASDI 1,028.60 0.00 0.00 0.00 0.00 0.00 0.00 Victor W/H DEDUCTIONS EARNINGS HRS. MIDDLE OTHER HI 701.96 87.54 164.17 20.47 FIT 810.00 48.00 SIT SUTA 347.59 43.35 CIT 7.93 0.99 SIMPLE 444.28 55.41 CK. DEDUCTIONS NO. AMOUNT 216.80 8.00 672 682 692 703 712 723 8,629.27 1,148.24 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 NAME - LAST FIRST HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OTHER OVERTIME EARNINGS WEEKLY RATE CUMULATIVE PAYDAY RATE AMOUNT RATE AMOUNT W/H STATUS 5 M NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 23,125.00 1,433.75 335.31 2,291.00 709.94 16.19 25,375.00 139.50 32.63 140.00 69.08 1.58 SIMPLE 907.43 2,250.00 80 10/9 MARITAL ALLOW. 23,125.00 YEAR-TO-DATE 1 HRS. Claude DEDUCTIONS EARNINGS HRS. $ SALARY $88,000 -- $.30/M 20___ James $ 58,500 /yr. $ 1,125.00 $ 28.13 OVERTIME R . FERGUSON MIDDLE CK. DEDUCTIONS NO. 88.29 AMOUNT 132.30 17,299.08 673 2 10/23 683 3 11/6 693 4 11/20 704 5 12/4 713 6 12/18 1,778.92 724 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Executive Secretary x PA 000-00-4567 HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS OTHER AMOUNT 2 AMOUNT STATUS 2 S NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 6,300.00 390.60 91.35 639.00 193.41 4.41 7,520.00 75.64 17.69 108.00 37.45 0.85 SIMPLE CK. DEDUCTIONS NO. 247.21 1,220.00 80 10/9 RATE 22.88 MARITAL ALLOW. 6,300.00 YEAR-TO-DATE 1 HRS. $ WEEKLY RATE Louise W/H DEDUCTIONS EARNINGS RATE Catherine 2,643.33 /mo. 610.00 15.25 CUMULATIVE PAYDAY HRS. FORD SALARY $48,000--$.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION 47.87 AMOUNT 37.80 4,696.22 674 10/23 932.50 684 3 11/6 694 4 11/20 705 5 12/4 714 6 12/18 725 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Sales Representative x PA 000-00-9352 HOURLY RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY OTHER WEEKLY RATE CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT Wilson W/H 80 STATUS 4 M NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 5,400.00 YEAR-TO-DATE MARITAL ALLOW. DEDUCTIONS EARNINGS HRS. $ SALARY UNIION DUES $53,000 -- $.30/M 20___ Dewey $ 2,925.00 /mo. $ 675.00 $ 16.88 OVERTIME R OTHER DEDUCTIONS INFORMATION GROUP INSURANCE MANN 5,400.00 334.80 78.30 332.00 165.78 3.78 211.90 1,350.00 6,750.00 83.70 19.58 42.00 41.45 0.95 SIMPLE 52.97 CK. DEDUCTIONS NO. 31.50 4,241.94 675 1 10/9 2 10/23 685 3 11/6 695 4 11/20 706 5 12/4 715 6 12/18 726 R. TOT. R. TOT. Checkpoint Checkpoint AMOUNT 1,109.35 DEPARTMENT OCCUPATION WORKS IN (STATE) Administrative President PA SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F x 000-00-1534 HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS OTHER WEEKLY RATE CUMULATIVE PAYDAY RATE AMOUNT AMOUNT MARITAL ALLOW. STATUS 3 M NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 42,692.27 2,646.92 619.04 6,116.00 1,310.65 29.88 44,999.96 143.08 33.46 194.00 70.85 1.62 SIMPLE 1,675.24 2,307.69 80 10/9 RATE W/H 42,692.27 YEAR-TO-DATE 1 HRS. Tyler DEDUCTIONS EARNINGS HRS. $ SALARY $90,000 -- $.30/M 20___ Joseph $ 60,000 /yr. $ 1,153.85 $ 28.85 OVERTIME R OTHER DEDUCTIONS INFORMATION O'NEILL CK. DEDUCTIONS NO. 90.55 AMOUNT 202.50 30,092.04 676 2 10/23 686 3 11/6 696 4 11/20 707 5 12/4 716 6 12/18 1,774.13 727 R. TOT. R. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Time Clerk x PA 000-00-6337 HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS OTHER AMOUNT HRS. RATE $ 22.50 WEEKLY RATE AMOUNT Aloise W/H ALLOW. S NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 6,240.00 386.88 90.48 642.00 191.56 4.37 7,440.00 74.40 17.40 128.00 36.84 0.84 SIMPLE CK. DEDUCTIONS NO. 244.86 1,200.00 80 STATUS 1 6,240.00 YEAR-TO-DATE MARITAL DEDUCTIONS EARNINGS RATE Virginia 3,600 /mo. 600.00 15.00 CUMULATIVE PAYDAY HRS. RUSSELL SALARY $47,000 -- $.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION 47.09 AMOUNT 31.50 4,648.35 677 1 10/9 2 10/23 687 3 11/6 697 4 11/20 708 5 12/4 717 6 12/14 895.43 722 R. TOT. R. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE RYAN Norman Allen M F Plant Electrician x PA 000-00-1223 HOURLY RATE 20___ OTHER OVERTIME EARNINGS AMOUNT HRS. RATE AMOUNT W/H 80 M NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 1,397.80 14,685.30 910.49 212.94 1,070.00 450.84 10.28 0.00 16,125.30 89.28 20.88 52.00 44.21 1.01 SIMPLE 576.25 1,440.00 18.00 STATUS 4 13,287.50 YEAR-TO-DATE MARITAL ALLOW. DEDUCTIONS EARNINGS RATE 27.00 CUMULATIVE PAYDAY HRS. $ WEEKLY RATE $8 each pay REGULAR EARNINGS 18.00 SALARY UNIION DUES $56,000 -- $.30/M $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION GROUP INSURANCE CK. DEDUCTIONS NO. 56.51 AMOUNT 235.70 11,218.80 8.00 678 1 10/9 2 10/23 0.00 688 3 11/6 0.00 1,168.11 698 4 11/20 0.00 709 5 12/4 0.00 718 6 12/18 0.00 728 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE 000-00-8832 SOKOWSKI Thomas James M F Plant Supervisor x PA HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS PAYDAY OTHER WEEKLY RATE CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT W/H ALLOW. 80 M NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 16,650.00 YEAR-TO-DATE STATUS 2 1,025.00 25.63 MARITAL DEDUCTIONS EARNINGS HRS. $ SALARY $80,000 -- $.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION 16,650.00 1,032.30 241.43 2,002.00 511.16 11.66 653.35 2,050.00 18,700.00 127.10 29.73 178.00 62.94 1.44 80.44 SIMPLE CK. DEDUCTIONS NO. 94.50 AMOUNT 12,103.60 679 1 10/9 2 10/23 689 3 11/6 699 4 11/20 710 5 12/4 719 6 12/18 729 1,570.35 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Accounting Trainee PA HOURLY RATE REGULAR EARNINGS OVERTIME EARNINGS OTHER AMOUNT HRS. RATE 21.00 AMOUNT W/H 14.00 S NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT 5,550.00 72 STATUS 1 5,550.00 344.10 80.48 409.00 170.38 3.89 6,558.00 62.50 14.62 98.00 30.95 0.71 SIMPLE CK. DEDUCTIONS NO. 217.78 1,008.00 YEAR-TO-DATE MARITAL ALLOW. DEDUCTIONS EARNINGS RATE $ WEEKLY RATE CUMULATIVE PAYDAY HRS. 14.00 SALARY UNIION DUES $39,000 -- $.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION GROUP INSURANCE 39.55 AMOUNT 32.40 4,291.97 680 1 10/9 2 10/23 0.00 690 3 11/6 0.00 761.67 700 4 11/20 0.00 711 5 12/4 0.00 720 6 12/18 0.00 730 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE 000-00-6741 WILLIAMS Ruth Virginia M F Office Programmer x PA HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS OTHER WEEKLY RATE CUMULATIVE PAYDAY RATE AMOUNT HRS. RATE AMOUNT 2,650 /mo. 611.54 15.29 W/H ALLOW. FICA OASDI OTHER HI FIT SIT SUTA CIT 10,260.00 636.12 148.77 1,606.00 314.98 7.18 11,483.08 75.83 17.73 154.00 37.55 0.86 SIMPLE CK. DEDUCTIONS NO. 402.60 1,223.08 80 S NET PAID 10,260.00 YEAR-TO-DATE STATUS 0 22.94 MARITAL DEDUCTIONS EARNINGS HRS. $ SALARY $48,000 -- $.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION 47.99 AMOUNT 59.40 7,084.95 681 1 10/9 2 10/23 3 11/6 701 4 11/13 889.12 691 702 5 6 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE WOODS Beth Anne M F Office Programmer x PA 000-00-1587 HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS OTHER WEEKLY RATE CUMULATIVE PAYDAY RATE AMOUNT HRS. RATE AMOUNT 2,600 /mo. 600.00 15.00 W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS EARNINGS HRS. $ SALARY $47,000--$.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 12/4 6 12/18 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Field Sales Representative x PA 000-00-6057 YOUNG Paul HOURLY RATE GROUP INSURANCE UNIION DUES OTHER REGULAR EARNINGS OVERTIME EARNINGS PAYDAY WEEKLY RATE YEAR-TO-DATE 1 2 3 CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT 2,730 /mo. 630.00 15.75 W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS EARNINGS HRS. Winston $ SALARY $49,000--$.30/M 20___ $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT 4 5 6 12/18 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Time Clerk x PA 000-00-1502 HOURLY RATE GROUP INSURANCE UNIION DUES REGULAR EARNINGS OVERTIME EARNINGS OTHER WEEKLY RATE CUMULATIVE PAYDAY RATE AMOUNT HRS. RATE AMOUNT Lloyd W/H ALLOW. STATUS 1 22.50 MARITAL M DEDUCTIONS EARNINGS HRS. $ SALARY $47,000--$.30/M 20___ Richard $ 2,600 /mo. $ 600.00 $ 15.00 OVERTIME R OTHER DEDUCTIONS INFORMATION ZIMMERMAN NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F HOURLY RATE GROUP INSURANCE 20___ REGULAR EARNINGS PAYDAY YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. OTHER RATE AMOUNT HRS. RATE AMOUNT WEEKLY RATE CUMULATIVE W/H MARITAL ALLOW. STATUS DEDUCTIONS EARNINGS HRS. $ SALARY UNIION DUES OVERTIME EARNINGS $ $ $ OVERTIME R OTHER DEDUCTIONS INFORMATION NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT a 22222 b Employee's Social Security Number XXX-XX-XXXX Void [ ] Employer's Identification Number (EIN) For Official Use Only OMB NO. 1 545-0008 1 Wages, tips, other compensation 2 Federal Income Tax Withheld 3 Social Security Wages 4 Scoial Security Tax Withheld 5 Medicare Wages and tips 6 Medicare Tax Withheld 7 8 Allocated Tips 47-1234567 c Employer's name, address, and ZIP code Bugeater's Corporation 5 Championship Drive Social Security Tips Lincoln, NE 68000 d Control Number 9 Advance EIC Payment e Employee's 1st name, initial Employee's address and ZIP code 11 Nonqualified Plans 13 Statutory Employee Retirment Plan 12a Third Party Sick Pay See Instructions for Box 12 Code f Last Name 10 Dependent Care Benefits |$ 12b Code |$ 12c 14 Other Code |$ 12d Code 15 State NE Employer's State ID Number 12345 16 State wages, tips 17 State Income Tax 18 Local wages & tips |$ 19 Local Income Tax