Payroll Project Chapter 7

Anonymous
timer Asked: Jun 2nd, 2018
account_balance_wallet $90

Question description

I need help with my payroll project. Chapter 7 from Payroll Accounting 2018 by Bieg and Toland. I have attached the excel files. Thank you.

Tutor Answer

Manal25
School: Carnegie Mellon University

I did it I did it :)Please find the full project attached. If you have any questions please do not hesitate to ask; if all is clear please review and rate my services.All the best

Excel Instructions
CAUTION: Read Appendix B for specific instructions relating to these templates.
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
2. A formula begins with an equals sign (=) and can consist of any of the following elements:
Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division).
Cell references, including cell addresses such as B52, as well as named cells and ranges
Values and text
Worksheet functions (such as SUM)
3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells.
To enter a formula manually, follow these steps:
Move the cell pointer to the cell that you want to hold the formula.
Type an equals sign (=) to signal the fact that the cell contains a formula.
Type the formula, then press Enter.
4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example,
17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function.
5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time.
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name.
To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar.
It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx
To save under a different name, follow these steps:
Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx)
Select the folder in which to store the workbook.
Enter the new filename in the File name box.
Click Save.

Page 41

JOURNAL
DATE
20--

Oct.

DESCRIPTION

9 Payroll Cash
Cash

POST.
REF.

DEBIT

12
11

12,052.01

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,898.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

1,381.11

CREDIT

12,052.01

958.33
224.14
1,118.00
474.55
10.85
602.89
16.00
12,052.01

958.32
224.12
22.91
175.76

20 Employees SIT Payable
Cash

25
11

474.55

23 Payroll Cash
Cash

12
11

12,115.19

474.55

12,115.19

Page 42

JOURNAL
DATE
20--

Oct.

Nov.

DESCRIPTION

POST.
REF.

DEBIT

23 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
Group Insurance Premiums Collected
Union Dues Payable
Payroll Cash

51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
12

2,307.69
4,651.08
3,600.00
5,219.60

23 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20.1
20.2
21
22

1,386.96

CREDIT

978.26
228.80
1,148.00
484.42
11.07
615.43
181.20
16.00
12,115.19

978.26
228.79
4.15
175.76

4 Employees SIT Payable
Cash

25
11

484.42

6 Union Dues Payable
Cash

28
11

32.00

484.42

32.00

Page 43

JOURNAL
DATE
20--

Nov.

DESCRIPTION

6 Payroll Cash
Cash

POST.
REF.

DEBIT

12
11

11,893.42

6 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,605.85
3,600.00
4,898.00

6 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
SUTA Taxes Payable - Employer

56
20.1
20.2
22

1,343.71

12
11

1,428.45

13 Payroll Cash
Cash

CREDIT

11,893.42

955.53
223.49
1,238.00
473.16
10.82
601.12
16.00
11,893.42

955.52
223.47
164.72

1,428.45

Page 44

JOURNAL
DATE
20--

Nov.

DESCRIPTION

POST.
REF.

DEBIT

13 Office Salaries
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Payroll Cash

52
20.1
20.2
24
25
25.1
26
27
12

2,079.32

13 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI

56
20.1
20.2

159.07

16 FICA Taxes Payabe-OASDI
FICA Taxes Payable-HI
Employee FIT Payable
Cash

20.1
20.2
24
11

3,873.17
905.85
2,266.00

16 Employee CIT Payable
Cash

26
11

1,218.32

18 Employees SIT Payable
Cash

25
11

537.00

20 Payroll Cash
Cash

12
11

9,216.00

51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
29
12

2,307.69
3,398.00
3,600.00
4,616.40

20 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
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash

CREDIT

128.92
30.15
331.00
63.84
1.46
81.10
14.40
1,428.45

128.92
30.15

7,045.02

1,218.32

537.00

9,216.00

863.18
201.89
828.00
427.43
9.77
543.02
166.80
16.00
1,650.00
9,216.00

Page 45

JOURNAL
DATE
20--

Nov.

Dec.

DESCRIPTION

20 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
SUTA Taxes Payable - Employer

POST.
REF.

56
20.1
20.2
22

DEBIT

1,113.15
863.17
201.87
48.11

3 Employees SIT Payable
Cash

25
11

427.43

4 Payroll Cash
Cash

12
11

10,730.23

51
52
53
54
20.1
20.2
24
25
25.1
26
28
29
12

2,307.69
4,628.00
3,600.00
5,188.60

4 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
SIMPLE Contributions Payable
Payroll Cash

CREDIT

427.43

10,730.23

974.92
228.02
1,018.00
482.76
11.03
613.33
16.00
1,650.00
10,730.23

Page 46

JOURNAL
DATE
20--

Dec.

DESCRIPTION

4 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer
9 Union Dues Payable
Cash

POST.
REF.

56
20.1
20.2
21
22

DEBIT

1,255.30
974.91
228.00
6.48
45.91

28
11

32.00

12
11

2,194.48

14 Office Salaries
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees SUTA Payable
Group Insurance Premiums Collected
Payroll Cash

52
20.1
20.2
25.1
27
12

2,394.00

14 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI

56
20.1
20.2

183.14

15 FICA Taxes Payabe-OASDI
FICA Taxes Payable-HI
Employee FIT Payable
Cash

20.1
20.2
24
11

3,895.24
911.02
2,397.00

15 Employee CIT Payable
Cash

26
11

1,225.24

18 Employees SIT Payable
Cash

25
11

482.76

18 Group Insurance Premiums Collected
Cash

27
11

14.70

18 Payroll Cash
Cash

12
11

45,348.73

14 Payroll Cash
Cash

CREDIT

32.00

2,194.48

148.43
34.71
1.68
14.70
2,194.48

148.43
34.71

7,203.26

1,225.24

482.76

14.70

45,348.73

Page 47

JOURNAL
DATE
20--

Dec.

DESCRIPTION

POST.
REF.

DEBIT

18 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
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash

51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
29
12

77,307.69
3,474.00
4,860.00
5,509.40

18 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20.1
20.2
21
22

6,809.33

CREDIT

5,382.37
1,321.70
27,530.73
2,798.36
63.83
3,555.27
182.10
18.00
4,950.00
45,348.73

5,382.39
1,321.69
14.76
90.49

Page 48

JOURNAL
DATE
20--

Jan.

DESCRIPTION

6 Employees SIT Payable
Cash
8 Union Dues Payable
Cash
15 FICA Taxes Payabe-OASDI
FICA Taxes Payable-HI
Employee FIT Payable
Cash
15 Employee CIT Payable
Cash

Feb.

POST.
REF.

DEBIT

CREDIT

2,798.36
2,798.36
34.00
34.00
13,011.45
3,168.83
28,548.73
44,729.01
4,168.60
4,168.60

1 FUTA Taxes Payable
Cash

441.24

1 SUTA Taxes Payable - Employer
Employees SUTA Taxes Payable
Cash

700.75
120.51

441.24

821.26

Page 49

JOURNAL
DATE
20--

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Page 50

JOURNAL
DATE
20--

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Total debits and credits (calculated automatically):
362,696.92 362,696.92
Your debits and credits should be equal after each journal entry is complete

Cumulative Journal Checkpoint Through Month Ending
58,644.96
124,528.47

October 31, 20-November 30, 20--

December 31, 20-January 31, 20--

309,704.45
361,434.42

GENERAL LEDGER

Checkpoints
ACCOUNT:

ACCOUNT NO. 11

CASH

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.

Dec.

1 Balance
9
20
23
4
6
6
13
16
16
16
20
3
4
9
14
15
15
18
18
18

a
J41
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
J45
J46
J46
J46
J46
J46
J46
J46

12,052.01
474.55
12,115.19
484.42
32.00
11,893.42
1,428.45
7,045.02
1,218.32
537.00
9,216.00
427.43
10,730.23
32.00
2,194.48
7,203.26
1,225.24
482.76
14.70
45,348.73

199,846.33
187,794.32
187,319.77
175,204.58
174,720.16
174,688.16
162,794.74
161,366.29
154,321.27
153,102.95
152,565.95
143,349.95
142,922.52
132,192.29
132,16...

flag Report DMCA
Review

Anonymous
Excellent job

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors