Description
I need help with this payroll project from Chapter 7. This is the book: Payroll Accounting, by Beig, Toland, edition 2017.
I attached an excel template with the beginning filled out, and just need to fill out the rest.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
hi palThe project is
GENERAL LEDGER
ACCOUNT:
ACCOUNT NO. 11
CASH
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
Dec
Jan
Feb
ACCOUNT:
1 Balance
9
20
23
4
6
6
13
16
16
18
20
3
4
9
14
15
15
18
18
18
6
8
18
1
1
a
J41
J41
J41
J42
J42
J42
J42
J43
J43
J44
J44
12.027,82
474,67
12.090,19
484,55
32,00
11.866,23
1.422,96
7.095,28
1.225,96
537,12
9.191,45
427,53
10.703,64
32,00
2.194,48
7.260,35
1.232,91
482,91
14,70
45.872,18
2.798,52
18,00
4.194,16
204,53
620,96
J45
J45
J46
J46
J46
J47
J47
J47
J47
J48
J48
J48
J48
j48
ACCOUNT NO. 12
PAYROLL CASH
POST.
DATE
20--
ITEM
199846,33
187818,51
187343,84
175253,65
174769,1
174737,1
162870,87
161447,91
154352,63
153126,67
152589,55
143398,1
142970,57
132266,93
132234,93
130040,45
122780,1
121547,19
121064,28
121049,58
75177,4
72378,88
72360,88
68166,72
67962,19
67341,23
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
Oct.
Nov
Dec
9
9
23
23
6
6
13
13
20
20
4
14
14
4
18
18
ACCOUNT:
J41
J41
J41
J41
J42
J42
J43
J43
J44
J44
12.027,82
j45
J46
J46
J45
J46
10.703,64
2.194,48
12.090,19
11.866,23
1.422,96
9.191,45
45.872,18
J46
12027,82
12.027,82 0
12090,19
12.090,19 0
11866,23
11.866,23 0
1422,96
1.422,96 0
9191,45
9.191,45 0
10703,64
12898,12
2.194,48 10703,64
10.703,64 0
45872,18
45.872,18 0
ACCOUNT NO. 20.1
FICA TAXES PAYABLE - OASDI
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
9
9
23
23
6
6
13
16
J41
J41
J41
J41
j42
J42
J43
J43
958,57
958,57
978,53
978,53
955,77
955,76
128,92
3.874,20
958,57
1.917,14
2.895,67
3.874,20
4.829,97
5.785,73
5.914,65
2.040,45
Dec
Jan
20
20
13
4
4
14
14
15
18
18
15
ACCOUNT:
J44
J44
J44
J45
J45
J46
J46
J46
J47
J47
J48
863,38
863,37
128,92
975,21
975,21
148,43
148,43
3.896,12
4.750,30
4.750,30
11.747,88
ACCOUNT NO. 20.2
FICA TAXES PAYABLE - HI
POST.
DATE
ITEM
REF.
2.903,83
3.767,20
3.896,12
4.871,33
5.846,54
5.994,97
6.143,40
2.247,28
6.997,58
11.747,88
0,00
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
9
9
23
23
6
6
13
16
20
20
13
4
4
14
14
15
J41
J41
J41
J41
J42
J42
J43
J43
J44
J44
J43
J45
J45
J46
J46
J46
224,19
224,18
228,86
228,85
223,54
223,53
30,15
906,08
201,94
201,92
30,15
228,09
228,07
34,71
34,71
911,23
224,19
448,37
677,23
906,08
1.129,62
1.353,15
1.383,30
477,22
679,16
881,08
911,23
1.139,32
1.367,39
1.402,10
1.436,81
525,58
Jan
18
15
ACCOUNT:
J47
J48
2.643,55
ACCOUNT NO. 21
FUTA TAXES PAYABLE
POST.
DATE
ITEM
REF.
3.169,13
0,00
3.169,13
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Dec
Feb
1 Balance
9
23
4
18
1
ACCOUNT:
a
J41
J41
22,91
4,15
6,48
14,76
J45
J46
j47
204,53
ACCOUNT NO. 22
SUTA TAXES PAYABLE - EMPLOYER
POST.
DATE
ITEM
REF.
392,94
415,85
420,00
426,48
441,24
236,71
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
Feb
9
23
6
20
4
18
1
J41
J41
175,76
175,76
65,40
6,47
11,04
66,01
J42
J44
J45
J46
J47
500,44
175,76
351,52
416,92
423,39
434,43
500,44
0,00
ACCOUNT:
ACCOUNT NO. 24
EMPLOYEES FIT PAYABLE
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
Jan
9
23
6
13
16
20
4
15
18
8
ACCOUNT:
J41
J41
J42
J43
J43
J44
J45
J46
J47
J47
1.142,00
1.173,00
1.265,00
336,00
2.315,00
852,00
1.045,00
2.453,00
27.622,62
28.667,62
ACCOUNT NO. 25
EMPLOYEES SIT PAYABLE
POST.
DATE
ITEM
REF.
1.142,00
2.315,00
3.580,00
3.916,00
1.601,00
2.453,00
3.498,00
1.045,00
28.667,62
0,00
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
9
20
23
4
6
13
18
20
J41
J41
J41
J41
J42
J43
J43
J44
474,67
474,67
484,55
484,55
473,28
63,84
537,12
427,53
474,67
0,00
484,55
0,00
473,28
537,12
0,00
427,53
Dec
Jan
3
4
18
18
6
ACCOUNT:
J45
J45
J46
J46
J47
427,53
482,91
2.798,52
2.798,52
ACCOUNT NO. 25.1
EMPLOYEES SUTA PAYABLE
POST.
DATE
ITEM
REF.
0,00
482,91
0,00
2.798,52
0,00
482,91
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
Feb
9
20
6
13
20
4
14
18
1
ACCOUNT:
J41
J41
J42
J43
J44
10,85
11,07
10,82
1,46
9,77
11,04
1,68
63,83
J45
J46
J47
Jj47
120,52
ACCOUNT NO. 26
EMPLOYEES CIT PAYABLE
POST.
DATE
ITEM
REF.
10,85
21,92
32,74
34,20
43,97
55,01
56,69
120,52
0,00
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
9
23
6
13
J41
J41
J42
J43
606,67
619,29
604,90
81,59
606,67
1.225,96
1.830,86
1.912,45
Dec
16
20
4
15
18
ACCOUNT:
J43
J44
J45
J46
1.225,96
1.232,91
j47
3.576,96
ACCOUNT NO. 27
GROUP INSURANCE PREMIUMS COLLECTED
POST.
DATE
ITEM
REF.
686,49
1.232,91
1.850,11
617,20
4.194,16
546,42
617,20
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
NOV
Dec
ACCOUNT:
23
13
20
14
18
18
J41
J43
J44
J45
J46
181,20
14,40
166,80
14,70
14,70
J47
182,10
ACCOUNT NO. 28
UNION DUES PAYABLE
POST.
DATE
20--
ITEM
REF.
181,20
195,60
362,40
377,10
362,40
544,50
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
Oct.
Nov
Dec
Jan
9
23
6
6
20
4
9
18
8
ACCOUNT:
J41
J41
J42
J42
J44
J45
J45
J46
J47
16,00
16,00
32,00
16,00
16,00
16,00
32,00
18,00
18,00
ACCOUNT NO. 29
SIMPLE CONTRIBUTIONS PAYABLE
POST.
DATE
ITEM
REF.
16,00
32,00
0,00
16,00
32,00
48,00
16,00
34,00
16,00
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Nov
Dec
ACCOUNT:
20
4
18
j44
J45
J46
ADMINISTRATIVE SALARIES
1.650,00
1.650,00
4.950,00
1.650,00
3.300,00
8.250,00
ACCOUNT NO. 51
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
ACCOUNT:
a
1 Balance
9
23
6
20
4
18
J41
J41
J42
J44
J45
J46
42692,27
44999,96
47307,65
49615,34
51923,03
54230,72
131538,41
2.307,69
2.307,69
2.307,69
2.307,69
2.307,69
77.307,69
ACCOUNT NO. 52
OFFICE SALARIES
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20--
Oct.
Nov
Dec
1 Balance
9
23
6
13
20
4
14
18
a
J41
J41
J42
J43
J44
J45
J46
J46
4.651,08
4.651,08
4.605,85
2.079,32
3.398,00
4.628,00
2.394,00
3.474,00
28350
33001,08
37652,16
42258,01
44337,33
47735,33
52363,33
54757,33
58231,33
CREDIT
ACCOUNT:
ACCOUNT NO. 53
SALES SALARIES
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov
Dec
ACCOUNT:
1 Balance
9
23
6
20
4
18
a
J41
J41
J42
J44
J45
J46
28525
32125
35725
39325
42925
46525
51385
3.600,00
3.600,00
3.600,00
3.600,00
3.600,00
4.860,00
ACCOUNT NO. 54
PLANT WAGES
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20--
Oct.
Nov
Dec
1 Balance
9
23
6
20
4
8
a
J41
J41
J42
J44
J45
J46
4.902,00
5.223,92
4.902,00
4.619,60
5.193,40
5.514,60
42657,3
47559,3
52783,22
57685,22
62304,82
67498,22
73012,82
CREDIT
ACCOUNT:
ACCOUNT NO. 56
PAYROLL TAXES
POST.
DATE
ITEM
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20--
Oct.
Nov
Dec
1 Balance
9
23
6
13
20
4
14
18
a
J41
J41
J42
J43
J44
J45
J46
J47
1.381,42
1.387,29
1.244,69
159,07
1.071,76
1.220,80
183,14
6.152,84
14068,41
15449,83
16837,12
18081,81
18240,88
19312,64
20533,44
20716,58
26869,42
CREDIT
Checkpoints
Debit
Balance
Oct. 31, 20-- ########
Nov. 30, 20-- ########
Dec. 31, 20-- 75.177,40
Credit
Balance
0,00
0,00
0,00
Checkpoints
Oct. 31, 20-Nov. 30, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
0,00
Dec. 31, 20--
0,00
0,00
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00 3.874,20
0,00 3.896,12
0,00 11.747,88
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
906,08
911,23
3.169,13
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
420,00
420,00
441,24
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
351,52
423,39
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00 2.315,00
0,00 2.453,00
0,00 28.667,62
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
484,55
427,53
2.798,52
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
21,92
43,97
120,52
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
1.225,96
1.232,91
4.194,16
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
181,20
362,40
544,50
Checkpoints
Oct. 31, 20-Nov. 30, 20--
Debit
Credit
Balance
Balance
0,00
0,00
32,00
32,00
Dec. 31, 20--
0,00
34,00
Checkpoints
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Debit
Credit
Balance
Balance
0,00
0,00
0,00
0,00
1.650,00
8.250,00
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 47.307,65
Nov. 30, 20-- 51.923,03
Dec. 31, 20-- ########
0,00
0,00
0,00
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 37.652,16
Nov. 30, 20-- 47.735,33
Dec. 31, 20-- 58.231,33
0,00
0,00
0,00
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 35.725,00
Nov. 30, 20-- 42.925,00
Dec. 31, 20-- 51.385,00
0,00
0,00
0,00
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 52.783,22
Nov. 30, 20-- 62.304,82
Dec. 31, 20-- 73.012,82
0,00
0,00
0,00
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 16.837,12
Nov. 30, 20-- 19.312,64
Dec. 31, 20--
0,00
0,00
0,00
Page 41
JOURNAL
DESCRIPTION POST. REF.
DATE
DEBIT
CREDIT
20--
Oct.
9 Payroll Cash
Cash
12
11
12.027,82
12.027,82
9 Administrative Salaries
51
2.307,69
Office Salaries 52
4.651,08
Sales Salaries 53
3.600,00
Plant Wages 54
4.902,00
FICA Taxes Payable
20,1 - OASDI
958,57
FICA Taxes Payable
20,2 - HI
224,19
Employees FIT24
Payable
1.142,00
Employees SIT25
Payable
474,67
Employees SUTA
25,1Payable
10,85
Employees CIT26
Payable
606,67
Union Dues Payable
28
16,00
Payroll Cash 12
12.027,82
9 Pay...