AutoSave 1 2 File Home Insert Draw Page Layout Paste AX94 3 Cut Clipboard Copy Format...

Transcribed Image Text:

AutoSave 1 2 File Home Insert Draw Page Layout Paste AX94 3 Cut Clipboard Copy Format Painter v Off A 4 80 67 68 TOTALS N/AME 106 107 108 109 110 1.11 112 113 EX fx 89 Ferguson, J. 90 Ford, C. 91 Mann, K 92 O'Neill, J. S 93 Ryan, J. 94 Sokowski, T. Arial 95 (Student) 96 Woods, B. 97 Young, P. 98 99 100 101 102 103 QTR 104 YEAR 105 BIU TOTALS Filing Status W/H Allow. D = Project Template Short F23 Part 1 Last Modified: Sat at 2:49 PM 69 Payday, December 4, 20-- For Period Ending November 28, 20-- 70 Bonno, A. MFJ N/A 8 8 8 MFJ N/A 8 S N/A MFJ N/A MFJ N/A S N/A MFJ N/A S N/A N/A N/A S S B C D E F G H I J K L M N O PQ R S T PAYROLL REGISTER No. Font S MFJ N/A S S MFJ N/A MFJ N/A S N/A SHIT S N/A N/A N/A 71 Ferguson, J. 72 Ford, C. 73 Mann, K 74 O'Neill, J. 75 Russell, S. 76 Ryan, J. 77 Sokowski, T. 78 (Student) 79 Woods, B. 80 81 82 TOTALS 83 Payday, December 14, 20-- For Period Ending December 12, 20- 88888 84 Russell, S. S N/A 8 8 8 85 86 Rate Per SMTWTFSSMTWTFS Hrs. Hour 8 8 8 8 - 8 H 20 8 MFJ N/A 48 MFJ N/A N/A 98x + 088 8 Formulas Data Review View Help A stato ++ 8 8 888 8 10 8 8 888 O LL 8 8 8 8 ++ 8 8 H 8 8 + o 84 HH 9 8 8 8 TOTALS 87 Payday, December 18, 20-- For Period Ending December 12, 20-- 88 Bonno, A. 8 8 8 8 H Time Record 8 HE 8 8 8 8 FE 8888888 8 8 8 4 H 8 7 H+ H 8 8 8 888888 8 8 9 9 8 HHHS 8 8 88 8 8 + 8 8 9 88 8 8 H ++ 488 HH 8 8 88 8 8 8 8 8 H 8 H8 8 H 8 8 8 8 H 8 8 8 8 H 8 9 10 8 H 8 8 8 H 8 8 8 8 H + 7888 o 9m 4 8 H ww 88 H 8 4 8 8 8 H 8 H 8 8 8 8 10 8 8H8 8 H 4 8 H 8 2 888888 L H 8 8 8 8 8 8 8 8 H 88 8 8 89 8 8 8888 8 8 8 8 8 00 00 + 8 8 Alignment 8888 ab Wrap Text U 152 Regular Earnings 80 17.60 80 80 80 80 80 76 18.00 80 72 15.00 72 15.00 Merge & Center 80 17.60 80 80 80 80 80 18.00 80 V 71 15.00 80 15,00 80 15.75 13,994.09 Rate Per Amount Hrs. Hour 1,408.00 2,250.00 1,280.00 W X 1,350.00 2,307.69 1,260.00 1,368.00 2,050.00 1,080.00 1,080.00 15,433.69 2,394.00 2,394.00 Ov 1,408.00 2,250.00 1,280.00 1,350.00 97,307.69 1,440,00 2,050.00 1,065,00 1,200.00 1,260,00 110,610.69 General $ % 9 Earnings 3 27.00 Y 12 35.20 Number 8 35.20 281.60 7 27.00 Amount 81.00 362.60 422.40 189.00 611.40 Z Total Earnings 13,994.09 AC AA AB GLO-BRITE PAINT COMPANY 15,796.29 2,394.00 2,394.00 143.08 33.46 1,689.60 104.76 24.50 2,250.00 139.50 32.63 1,280.00 79.36 18.56 1,350.00 83.70 19.58 2,307.69 1,260.00 1,449.00 2,050.00 1,080.00 1,080.00 78.12 18.27 89.84 21.01 127.10 29.73 66.96 15.66 66.96 15.66 1,830.40 2,250.00 1,280.00 1,350.00 97,307,69 1,629.00 2,050.00 Normal Conditional Format as Check Cell Formatting Table 1,065.00 1,200.00 1,260.00 OASDI 867.64 202.93 979.38 148.43 HI 148.43 113.48 139.50 229.06 34.71 34.71 26.54 32.63 18.56 79.36 83.70 19.58 FIT 68.00 76.00 86.00 10.00 60.00 84.00 24.00 179.00 62.00 62.00 711.00 0.00 576.00 429.64 85.00 76.00 86.00 10.00 Search 42.00 179.00 AD 60.00 76.00 84.00 SIT 51.87 69.08 39.30 41.45 70.85 38.68 44.48 62.94 Deductions 33.16 33.16 484.97 0.00 5,751.68 1,410.96 20,900.00 2,987.35 23.62 101.00 29.73 127.10 66.03 15.44 74.40 17.40 78.12 18.27 56.19 69.08 39.30 41.45 50.01 62.94 32.70 36.84 38.68 Bad 111,222.09 6,614.37 1,612.73 21,598.00 3,414.54 192,348.47 11,644.24 2,789.13 25,581.00 5,831.75 334,573.04 20,462.16 4,851.40 41,498.00 10,198.04 Explanatory... AE SUTA 8.39 1.01 1.35 0.77 0.81 1.38 0.76 0.87 1.23 0.65 0.65 9.48 1.44 1.44 1.10 1.35 0.77 0.81 58.38 0.98 1.23 0.64 0.72 0.76 66.74 Styles AF Good Input CIT 64.88 86.40 49.15 51.84 88.61 48.38 55.64 78.72 41.47 41.47 537.36 167.70 606.56 0.00 AG 51.84 3,736.42 40.89 46.08 48.38 0.00 Group Union Ins. 14.70 70.28 16.50 86.40 49.15 14.70 26.40 15.00 15.90 27.00 62.55 16.80 78.72 24.00 12.60 14.10 14.70 Neutral Linked Cell 4,270.71 183.00 115.37 7,293.94 561.90 200.71 12,755.08 1,492.30 AH 16.00 1,650.00 8.00 Ck. Dues SIMPLE No. 8.00 Al 0.00 16.00 1,650.00 9.00 9.00 Calculation 0.00 Note AJ 18.00 2,950.00 98.00 6,250.00 242.00 6,250.00 AK 722 Net Paid Amount AL Insert Delete Format OASDI 2,194.72 2,194.72 712 500.00 713 1,366.58 1,689.60 1,689.60 1,345.04 2,250.00 2,250.00 714 1,006.86 1,280.00 1,280.00 250.00 715 892.62 1,350.00 1,350.00 700.00 716 1,210.31 2,307.69 2,307.69 717 1,260.00 200.00 718 719 720 721 1,449.00 991.79 1,260.00 1,449.00 1,005.16 2,050.00 2,050.00 1,571.28 860.10 1,080.00 1,080.00 860.10 1,080.00 1,080.00 Cells AM 9,538.43 13,994.09 13,994.09 HI 2,394.00 Taxable Earnings 11,109.84 15,796.29 15,796.29 2,394.00 2,394.00 2,394.00 1,830.40 723 1,830.40 1,452.31 500.00 724 2,250.00 2,250.00 1,318.64 725 991.86 1,280.00 1,280.00 876.72 250.00 726 1,350.00 1,350.00 2,000.00 727 60,435.90 97,307.69 97,307.69 200.00 728 729 730 731 732 AN Autosum FUTA 0.00 1,080.00 Fill Clear 0.00 AO SUTA 130.00 1,080.00 1,080.00 Editing 1,860.00 V 1,210.00 0.00 1,123.04 1,629.00 1,629.00 2,050.00 2,050.00 1,547.28 1,065.00 1,065.00 836.70 934.46 1,200.00 1,200.00 1,200.00 1,200.00 1,260.00 1,260.00 977,09 1,260.00 1,260.00 AT O 27 Sort & Find & Filter Select AP Admin. Add-ins 1,210.31 Add-ins AQ Office Labor Cost Distribution 1,006.86 991.79 860.10 860.10 2.307.69 3,470.00 3,600.00 4,616.40 2,194.72 Analyze Data 0.00 2,194.72 AR 991.86 336.70 934.46 Sales 1,345.04 892.62 1,210.31 3.718.85 2,237.66 3,943.02 0.00 1,318.64 AS A 876.72 Plant 977.09 1,366.58 1,005.16 1,571.28 0.00 1,452.31 1,123.04 1,547.28 70,494.00 111,222.09 111,222.09 0.00 2,763.02 3,172.45 4.122.63 2,480.00 2,460.00 8,050.00 20,050.00 10,441.07 28,349.92 19,810.11 27,697.65 132,183.14 192,348.47 192,348.47 #REF! #REF! #REF! #REFI 236,623.35 334,573.04 334,573.04 73,540.00 103,540.00 AU Checkpoints Total earnings Net paid Connie Morin Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints-Annual Total earnings Qtr's taxable OASDI earnings Total earnings for FIT Total earnings for SIT/CIT Total earnings for FUTA AV 15,796.29 11,109.84 2,394.00 2,194.72 111,222.09 70,494.00 334,573.04 73,540.00 Comments AW AutoSave 1 2 File Home Insert Draw Page Layout Paste AX94 3 Cut Clipboard Copy Format Painter v Off A 4 80 67 68 TOTALS N/AME 106 107 108 109 110 1.11 112 113 EX fx 89 Ferguson, J. 90 Ford, C. 91 Mann, K 92 O'Neill, J. S 93 Ryan, J. 94 Sokowski, T. Arial 95 (Student) 96 Woods, B. 97 Young, P. 98 99 100 101 102 103 QTR 104 YEAR 105 BIU TOTALS Filing Status W/H Allow. D = Project Template Short F23 Part 1 Last Modified: Sat at 2:49 PM 69 Payday, December 4, 20-- For Period Ending November 28, 20-- 70 Bonno, A. MFJ N/A 8 8 8 MFJ N/A 8 S N/A MFJ N/A MFJ N/A S N/A MFJ N/A S N/A N/A N/A S S B C D E F G H I J K L M N O PQ R S T PAYROLL REGISTER No. Font S MFJ N/A S S MFJ N/A MFJ N/A S N/A SHIT S N/A N/A N/A 71 Ferguson, J. 72 Ford, C. 73 Mann, K 74 O'Neill, J. 75 Russell, S. 76 Ryan, J. 77 Sokowski, T. 78 (Student) 79 Woods, B. 80 81 82 TOTALS 83 Payday, December 14, 20-- For Period Ending December 12, 20- 88888 84 Russell, S. S N/A 8 8 8 85 86 Rate Per SMTWTFSSMTWTFS Hrs. Hour 8 8 8 8 - 8 H 20 8 MFJ N/A 48 MFJ N/A N/A 98x + 088 8 Formulas Data Review View Help A stato ++ 8 8 888 8 10 8 8 888 O LL 8 8 8 8 ++ 8 8 H 8 8 + o 84 HH 9 8 8 8 TOTALS 87 Payday, December 18, 20-- For Period Ending December 12, 20-- 88 Bonno, A. 8 8 8 8 H Time Record 8 HE 8 8 8 8 FE 8888888 8 8 8 4 H 8 7 H+ H 8 8 8 888888 8 8 9 9 8 HHHS 8 8 88 8 8 + 8 8 9 88 8 8 H ++ 488 HH 8 8 88 8 8 8 8 8 H 8 H8 8 H 8 8 8 8 H 8 8 8 8 H 8 9 10 8 H 8 8 8 H 8 8 8 8 H + 7888 o 9m 4 8 H ww 88 H 8 4 8 8 8 H 8 H 8 8 8 8 10 8 8H8 8 H 4 8 H 8 2 888888 L H 8 8 8 8 8 8 8 8 H 88 8 8 89 8 8 8888 8 8 8 8 8 00 00 + 8 8 Alignment 8888 ab Wrap Text U 152 Regular Earnings 80 17.60 80 80 80 80 80 76 18.00 80 72 15.00 72 15.00 Merge & Center 80 17.60 80 80 80 80 80 18.00 80 V 71 15.00 80 15,00 80 15.75 13,994.09 Rate Per Amount Hrs. Hour 1,408.00 2,250.00 1,280.00 W X 1,350.00 2,307.69 1,260.00 1,368.00 2,050.00 1,080.00 1,080.00 15,433.69 2,394.00 2,394.00 Ov 1,408.00 2,250.00 1,280.00 1,350.00 97,307.69 1,440,00 2,050.00 1,065,00 1,200.00 1,260,00 110,610.69 General $ % 9 Earnings 3 27.00 Y 12 35.20 Number 8 35.20 281.60 7 27.00 Amount 81.00 362.60 422.40 189.00 611.40 Z Total Earnings 13,994.09 AC AA AB GLO-BRITE PAINT COMPANY 15,796.29 2,394.00 2,394.00 143.08 33.46 1,689.60 104.76 24.50 2,250.00 139.50 32.63 1,280.00 79.36 18.56 1,350.00 83.70 19.58 2,307.69 1,260.00 1,449.00 2,050.00 1,080.00 1,080.00 78.12 18.27 89.84 21.01 127.10 29.73 66.96 15.66 66.96 15.66 1,830.40 2,250.00 1,280.00 1,350.00 97,307,69 1,629.00 2,050.00 Normal Conditional Format as Check Cell Formatting Table 1,065.00 1,200.00 1,260.00 OASDI 867.64 202.93 979.38 148.43 HI 148.43 113.48 139.50 229.06 34.71 34.71 26.54 32.63 18.56 79.36 83.70 19.58 FIT 68.00 76.00 86.00 10.00 60.00 84.00 24.00 179.00 62.00 62.00 711.00 0.00 576.00 429.64 85.00 76.00 86.00 10.00 Search 42.00 179.00 AD 60.00 76.00 84.00 SIT 51.87 69.08 39.30 41.45 70.85 38.68 44.48 62.94 Deductions 33.16 33.16 484.97 0.00 5,751.68 1,410.96 20,900.00 2,987.35 23.62 101.00 29.73 127.10 66.03 15.44 74.40 17.40 78.12 18.27 56.19 69.08 39.30 41.45 50.01 62.94 32.70 36.84 38.68 Bad 111,222.09 6,614.37 1,612.73 21,598.00 3,414.54 192,348.47 11,644.24 2,789.13 25,581.00 5,831.75 334,573.04 20,462.16 4,851.40 41,498.00 10,198.04 Explanatory... AE SUTA 8.39 1.01 1.35 0.77 0.81 1.38 0.76 0.87 1.23 0.65 0.65 9.48 1.44 1.44 1.10 1.35 0.77 0.81 58.38 0.98 1.23 0.64 0.72 0.76 66.74 Styles AF Good Input CIT 64.88 86.40 49.15 51.84 88.61 48.38 55.64 78.72 41.47 41.47 537.36 167.70 606.56 0.00 AG 51.84 3,736.42 40.89 46.08 48.38 0.00 Group Union Ins. 14.70 70.28 16.50 86.40 49.15 14.70 26.40 15.00 15.90 27.00 62.55 16.80 78.72 24.00 12.60 14.10 14.70 Neutral Linked Cell 4,270.71 183.00 115.37 7,293.94 561.90 200.71 12,755.08 1,492.30 AH 16.00 1,650.00 8.00 Ck. Dues SIMPLE No. 8.00 Al 0.00 16.00 1,650.00 9.00 9.00 Calculation 0.00 Note AJ 18.00 2,950.00 98.00 6,250.00 242.00 6,250.00 AK 722 Net Paid Amount AL Insert Delete Format OASDI 2,194.72 2,194.72 712 500.00 713 1,366.58 1,689.60 1,689.60 1,345.04 2,250.00 2,250.00 714 1,006.86 1,280.00 1,280.00 250.00 715 892.62 1,350.00 1,350.00 700.00 716 1,210.31 2,307.69 2,307.69 717 1,260.00 200.00 718 719 720 721 1,449.00 991.79 1,260.00 1,449.00 1,005.16 2,050.00 2,050.00 1,571.28 860.10 1,080.00 1,080.00 860.10 1,080.00 1,080.00 Cells AM 9,538.43 13,994.09 13,994.09 HI 2,394.00 Taxable Earnings 11,109.84 15,796.29 15,796.29 2,394.00 2,394.00 2,394.00 1,830.40 723 1,830.40 1,452.31 500.00 724 2,250.00 2,250.00 1,318.64 725 991.86 1,280.00 1,280.00 876.72 250.00 726 1,350.00 1,350.00 2,000.00 727 60,435.90 97,307.69 97,307.69 200.00 728 729 730 731 732 AN Autosum FUTA 0.00 1,080.00 Fill Clear 0.00 AO SUTA 130.00 1,080.00 1,080.00 Editing 1,860.00 V 1,210.00 0.00 1,123.04 1,629.00 1,629.00 2,050.00 2,050.00 1,547.28 1,065.00 1,065.00 836.70 934.46 1,200.00 1,200.00 1,200.00 1,200.00 1,260.00 1,260.00 977,09 1,260.00 1,260.00 AT O 27 Sort & Find & Filter Select AP Admin. Add-ins 1,210.31 Add-ins AQ Office Labor Cost Distribution 1,006.86 991.79 860.10 860.10 2.307.69 3,470.00 3,600.00 4,616.40 2,194.72 Analyze Data 0.00 2,194.72 AR 991.86 336.70 934.46 Sales 1,345.04 892.62 1,210.31 3.718.85 2,237.66 3,943.02 0.00 1,318.64 AS A 876.72 Plant 977.09 1,366.58 1,005.16 1,571.28 0.00 1,452.31 1,123.04 1,547.28 70,494.00 111,222.09 111,222.09 0.00 2,763.02 3,172.45 4.122.63 2,480.00 2,460.00 8,050.00 20,050.00 10,441.07 28,349.92 19,810.11 27,697.65 132,183.14 192,348.47 192,348.47 #REF! #REF! #REF! #REFI 236,623.35 334,573.04 334,573.04 73,540.00 103,540.00 AU Checkpoints Total earnings Net paid Connie Morin Checkpoints Total earnings Net paid Checkpoints Total earnings Net paid Checkpoints-Annual Total earnings Qtr's taxable OASDI earnings Total earnings for FIT Total earnings for SIT/CIT Total earnings for FUTA AV 15,796.29 11,109.84 2,394.00 2,194.72 111,222.09 70,494.00 334,573.04 73,540.00 Comments AW