# Payroll Project Chapter 7

Anonymous
timer Asked: May 12th, 2018
account_balance_wallet \$30

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.

Missmourine
School: Duke University

Attached.

Excel Instructions using Excel 2010:
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 answe
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. Fo
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
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive versio
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_Nam
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.

opy of your file. You can save your work at any time.
ork by saving each successive version under a different name.

Page 41

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/10/2018

9 Payroll Cash
Cash

12
11

12,044.51

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

12,044.51

594.83
224.14
1.124.14
474.55
10.85
604.39
16.00
12,044.51

958.32
224.32
22.91
175.76

Page 42

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

20/10/2018

23 Payroll Cash

12

12,o44.51

CREDIT

Cash

11

12,044.51

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

2,307.69
4,651.08
3,600.00
4,898.00

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

56
20.1
20.2
21
22

1,281.14

608.35
210.03
1,021.00
444.68
11.59
568.96
165.90
16.00
12,044.00

898.05
210.03
51.60
121.46

Page 43

JOURNAL
DATE
20/11/2018

DESCRIPTION

Payroll Cash
6 Cash
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

POST.
REF.

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

DEBIT

CREDIT

12,044.51
12,044.51
2,307.69

3,320.79
3,600.00
4,898.00
593.48
204.89
1,146.00
433.81
11.30
555.05
16.00
12.044.51

may

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

56
20.1
20.2
21
22

2,281.14
876.09
204.89
22.20
34.07

Page 44

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/11/2018

13 Payroll Cash
Cash
Office Salaries
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable

12
11

2,079.32

52
20.1
20.2
24
25

2,079.32

2,079.32

87.33
30.15
308.00
63.84

Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Payroll Cash
13 Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI

25.1
26
27
12
56
20.1
20.2

1.66
81.68
14.40
2,079.32
159.07
128.92
30.15

Page 45

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/12/2018

20 Payroll Cash
Cash

12
11

8,265.88

51

2,307.69

8,265.88

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
20 Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

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

2,112.94
3,600.00
4,619.60

56
20.1
20.2
21
22

986.97

530.89
183.28
9.48
388.06
10.11
496.51
15.50
16.00
1,650.00
8,265.88

783.69
183.28
0.00
20.00

Page 46

JOURNAL

DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/6/2018

4 Payroll Cash
Cash
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
Payroll Taxes

12
11

9,737.33

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

2,307.69
3,330.00
3,600.00
5,193.40

56

9,737.33

606.11
209.25
1,200.00
443.03
11.54
557.83
16.00
1,650.00
9,737.33
928.49

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

20.1
20.2
21
22

603.71
209.25
64.80
50.73

Page 47

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/12/2018

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

12
11

1,425.16

52
20.1
20.2
25.1
27

1,425.16

1,425.16

59.86
20.66
1.14
8.70

Page 48

JOURNAL
DATE

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

20/01/2018

18 Payroll Cash
Cash

12
11

48,169.93

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

62,307.69
2,692.50
4,407.70
5,514.60

Payroll Taxes
FICA Taxes Payable - OASDI
FUTA Taxes Payable -HI

56
20.1
20.2

4,208.79

48,169.93

2,876.33
1,086.38
6,372.99
2,102.46
59.94
2,690.05
167.70
18.00
4,950.00
48,169.93

3,341.02
781.37

FUTA Taxes Payable
SUTA Taxes Payable - Employer

21
22

12.05
74.35

Page 49

JOURNAL
DATE
5/6/2018

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Page 50

JOURNAL
DATE
20--

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Total debits and credits (calculated automatically):

26,752.88

Your debits and credits should be equal after each journal entry is complete

Cumulative Journal Checkpoint Through Month Ending
April 31, 20-May 30, 20--

June 31, 20-July 31, 20--

26,752.88

m

GENERAL LEDGER
ACCOUNT:

ACCOUNT NO. 11

CASH

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

Nov. 30, 20--

20--

Oct.

Nov

Dec

a

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

ACCOUNT:

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

12,044.51
434.82
11,438.16
444.60
32.00
11,169.15
1,492.26
5,817.11
1,126.26
497.67
8,265.88
388.08
9,737.33
32.00
6,239.04
1,132.24
443.03
8.70
48,169.93

ACCOUNT NO. 12

PAYROLL CASH

DATE

ITEM

199,846.33
187,801.82
187,367.00
175,928.84
175,484.24
175,452.24
164,283.09
162,790.83
156,973.72
155,847.46
155,349.79
147,083.91
146,695.83
136,958.50
136,926.50
130,687.46
129,555.22
129,112.19
129,103.49
80,933.56

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

Oct.

Nov

CREDIT

Nov. 30, 20--

20--

9
9
23
23
6
6
13
13

J41
J41
J42
J42
J43
J43
J44
J44

12,044.51
12,044.51
11,348.16
11,348.16
11,169.15
11,169.15
2,079.32
2,079.32

12,044.51
0.00
11,348.16
0.00
11,169.15
0.00
2,079.32
0.00

Dec

20
20
4
4
14
14
18
18

ACCOUNT:

J45
J45
J46
J46
J47
J47
J48
J48

8,265.88
8,265.88
9,737.33
9,737.33
1,425.16
1,425.16
48,169.93
48,169.93

ACCOUNT NO. 20.1

FICA TAXES PAYABLE - OASDI

DATE

ITEM

8,265.88
0.00
9,737.33
0.00
1,425.16
0.00
48,169.93
0.00

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

Nov. 30, 20--

20--

Oct.

Nov

Dec

9
9
23
23
6
6
13
13
20
20
4
4
14
18
18

J41
J41
J42
J42
J43
J43
J44
J44
J45
J45
J46
J46
J47
J48
J48

594.83
878.09
608.35
898.05
593.48
876.09
87.33
128.92
530.89
783.69
606.11
603.71
59.86
2,876.33
3,341.02

...

flag Report DMCA
Review

Anonymous
Wow this is really good.... didn't expect it. Sweet!!!!

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