Score:
Key Code:
An asterisk (*) will appear to the left of an incorrect entry.
For ledger account amounts, only the normal balance column will be graded.
Essay answers will not be graded.
1.
Page 1
Inv. Post.
No. Account Debited Ref.
July 21 1
22 2
24 3
27 4
30 5
30 6
31 7
31
Page 1
Post.
Ref. Debit Credit
July 28
D. Chase
Post.
Item Ref. Debit Credit Balance
July 30 ……………………………
J. Dunlop
Post.
Item Ref. Debit Credit Balance
July 21 ……………………………
F. Mintz
Post.
Item Ref. Debit Credit Balance
July 27 ……………………………
Problem 5-1A
Name:
Section:
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
REVENUE JOURNAL
Date
Fees Earned Cr.
2016
Cells with non-gray backgrounds are protected and cannot be edited.
Accts. Rec. Dr.
Date
JOURNAL
Date
Description
2016
Date
2016
ACCOUNTS RECEIVABLE LEDGER
Date
2016
2016
T. Quinn
Post.
Item Ref. Debit Credit Balance
July 24 ……………………………
31 ……………………………
K. Tisdale
Post.
Item Ref. Debit Credit Balance
July 22 ……………………………
30 ……………………………
2.
Accounts Receivable 12
Post.
Item Ref. Debit Credit Debit Credit
July 31 ……………………………
Supplies 13
Post.
Item Ref. Debit Credit Debit Credit
July 25 ……………………………
Fees Earned
41
Post.
Item Ref. Debit Credit Debit Credit
July 25 ……………………………
31 ……………………………
3.
a.
b.
4.
Date
Date
2016
2016
Balance
Date
2016
Balance
Date
GENERAL LEDGER
2016
Date
2016
Balance
Scoring:
An asterisk (*) will appear to the left of an incorrect entry.
For ledger account amounts, only the normal balance column will be graded.
Essay answers will not be graded.
Page 1
Inv. Post.
No. Account Debited Ref.
July 21 1 J. Dunlop √
22 2 K. Tisdale √
24 3 T. Quinn √
Page 1
Post.
Ref. Debit Credit
July 25 13 300
D. Chase
Post.
Item Ref. Debit Credit Balance
July 30 …………………………… R1 170 170
J. Dunlop
Post.
2016
Item Ref. Debit Credit Balance
F. Mintz
Post.
Item Ref. Debit Credit Balance
July 27 …………………………… R1 225 225
ON
Problem 5-1A
Name:
Solution
Section:
Instructions
Date
85
2016
115
REVENUE JOURNAL
Accts. Rec. Dr.
350
Fees Earned Cr.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
JOURNAL
2016
Date
Description
Supplies
Date
2016
ACCOUNTS RECEIVABLE LEDGER
Date
Date
2016
120
225
170
105
T. Quinn
Post.
Item Ref. Debit Credit Balance
K. Tisdale
Post.
Item Ref. Debit Credit Balance
July 22 …………………………… R1 350 350
2.
Accounts Receivable 12
Post.
2016
Item Ref. Debit Credit Debit Credit
Supplies 13
Post.
Item Ref. Debit Credit Debit Credit
July 25 …………………………… J1 300 300
Fees Earned
41
Post.
3.
Item Ref. Debit Credit Debit Credit
July 25 …………………………… J1 300 300
4.
Date
Date
2016
GENERAL LEDGER
Balance
Date
Date
2016
The computerized system is much more efficient. Each sales transaction would be entered into an electronic invoice
form. The postings to the accounts receivable subsidiary and general ledgers would be automatic. Also, all sums and
Balance
Date
2016
Balance
2016
Score:
Key Code:
An asterisk (*) will appear to the left of an incorrect entry.
For ledger account amounts, only the normal balance column will be graded.
Essay answers will not be graded.
1.
Page 1
Inv. Post.
No. Account Debited Ref.
Jan. 18 1
20 2
24 3
27 4
28 5
30 6
31 7
31
Page 1
Post.
Ref. Debit Credit
Jan. 28
Amber Waves Co.
Post.
Item Ref. Debit Credit Balance
Jan. 28 ……………………………
Carson Co.
Post.
Item Ref. Debit Credit Balance
Jan. 27 ……………………………
Hopkins Co.
Post.
Item Ref. Debit Credit Balance
Jan. 24 ……………………………
31 ……………………………
Date
2016
ACCOUNTS RECEIVABLE LEDGER
Date
2016
2016
Date
JOURNAL
Date
Description
2016
Accts. Rec. Dr.
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
REVENUE JOURNAL
Date
Fees Earned Cr.
2016
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 5-1B
Name:
Section:
Murphy Co.
Post.
Item Ref. Debit Credit Balance
Jan. 18 ……………………………
Qwik-Mart Co.
Post.
Item Ref. Debit Credit Balance
Jan. 20 ……………………………
30 ……………………………
2.
Accounts Receivable 12
Post.
Item Ref. Debit Credit Debit Credit
Jan. 31 ……………………………
Supplies 14
Post.
Item Ref. Debit Credit Debit Credit
Jan. 28 ……………………………
Fees Earned
41
Post.
Item Ref. Debit Credit Debit Credit
Jan. 28 ……………………………
31 ……………………………
3.
a.
b.
4.
GENERAL LEDGER
2016
Date
2016
Balance
Date
Date
2016
2016
Balance
Date
2016
Balance
Date
Score:
Key Code:
An asterisk (*) will appear to the left of an incorrect entry.
For ledger accounts amounts, only the normal balance column will be graded.
Essay answers will not be graded.
Page 1
Inv. Post.
No. Account Debited Ref.
Jan. 18 1 Murphy Co. √
20 2 Qwik-Mart Co. √
24 3 Hopkins Co. √
Page 1
Post.
Ref. Debit Credit
Jan. 28 14 100
Amber Waves Co.
Post.
Item Ref. Debit Credit Balance
Jan. 28 …………………………… R1 120 120
Carson Co.
Post.
2016
Item Ref. Debit Credit Balance
Hopkins Co.
Post.
Item Ref. Debit Credit Balance
Jan. 24 …………………………… R1 750 750
Date
2016
2016
Date
Date
JOURNAL
ACCOUNTS RECEIVABLE LEDGER
2016
Supplies
Accts. Rec. Dr.
340
Fees Earned Cr.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Date
Description
Instructions
Date
750
2016
490
REVENUE JOURNAL
ON
Problem 5-1B
Name:
Solution
Section:
295
200
680
120
Murphy Co.
Post.
Item Ref. Debit Credit Balance
Jan. 18 …………………………… R1 490 490
Qwik-Mart Co.
Post.
Item Ref. Debit Credit Balance
2.
Accounts Receivable 12
Post.
Item Ref. Debit Credit Debit Credit
Jan. 31 …………………………… R1 2,875 2,875
Supplies 14
Post.
Item Ref. Debit Credit Debit Credit
Fees Earned
41
Post.
3.
Item Ref. Debit Credit Debit Credit
Jan. 28 …………………………… J1 100 100
4.
2016
Date
2016
GENERAL LEDGER
Balance
The computerized system is much more efficient. Each sales transaction would be entered into an electronic invoice
form. The postings to the accounts receivable subsidiary and general ledgers would be automatic. Also, all sums and
Balance
Date
2016
Balance
Date
2016
Date
Date
2016
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry. For correct grading, enter a zero
or select N/A in cells you would otherwise leave blank. Essay answers will not be graded.
3. and 4.
Page 30
Post. Field Supplies Office Supplies Post.
Account Credited Ref. Debit Debit Other Accounts Debit Ref. Amount
Oct.
31 Totals
1. and 4.
Field Supplies
14
Post.
Item Ref. Debit Credit Debit Credit
Oct. 1 Balance √5,920
……………………………
Office Supplies
15
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
Oct. 1 Balance √750
……………………………
Office Equipment 18
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
Oct. 1 Balance √12,300
……………………………
Accounts Payable 21
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
Oct. 1 Balance √1,170
……………………………
2. and 3.
Executive Office Supply co.
Post.
Item Ref. Debit Credit Balance
Oct. 1 Balance √390
……………………………
……………………………
Meade Co.
Post.
Item Ref. Debit Credit Balance
Oct. 1 Balance √780
……………………………
Omni Co.
Post.
Item Ref. Debit Credit Balance
Oct. ……………………………
GENERAL LEDGER
Balance
Date
2016
Date
2016
ACCOUNTS PAYABLE SUBSIDIARY LEDGER
Date
2016
Date
2016
Problem 5-3A
Name:
Section:
2016
Cells with non-gray backgrounds are protected and cannot be edited.
PURCHASES JOURNAL
Accts. Payable
Credit
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Date
……………………………
……………………………
Peach Computers Co.
Post.
Item Ref. Debit Credit Balance
Oct. ……………………………
Yamura Co.
Post.
Item Ref. Debit Credit Balance
Oct. ……………………………
……………………………
5.
a. Sum of creditor balances at October 31
b. Balance of accounts payable controlling account at October 31
6.
Date
2016
Date
2016
Scoring:
An asterisk (*) will appear to the right of an incorrect entry. For correct grading enter a zero
in cells you would otherwise leave blank. Essay answers will not be graded.
3. and 4.
Page 30
Post. Field Supplies Office Supplies Post.
Account Credited Ref. Debit Debit Other Accounts Debit Ref. Amount
Oct. 2 Meade Co. √– 400 N/A – –
5 Peach Computers Co. √– – Office Equipment 18 3,980
9 Executive Office Supply Co. √– 320 N/A – –
13 Yamura Co. √1,420 – N/A – –
1. and 4.
Field Supplies
14
Post.
Item Ref. Debit Credit Debit Credit
Oct. 1 Balance √5,920
31 …………………………… P30 11,930 – 17,850 –
Office Supplies
Oct. 1 Balance √750
15
Post. Balance
Date Item Ref. Debit Credit Debit Credit
Oct. 1 Balance √1,170
Office Equipment 18
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
Oct. 1 Balance √12,300
5 …………………………… P30 3,980 – 16,280 –
Accounts Payable 21
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2. and 3.
Executive Office Supply co.
Post.
Item Ref. Debit Credit Balance
Oct. 1 Balance √390
9 …………………………… P30 – 320 710
Meade Co.
Post.
Item Ref. Debit Credit Balance
Oct. 1 Balance √780
2 …………………………… P30 – 400 1,180
Omni Co.
Post.
Item Ref. Debit Credit Balance
Date
GENERAL LEDGER
Balance
Date
2016
ACCOUNTS PAYABLE SUBSIDIARY LEDGER
Date
Cells with non-gray backgrounds are protected and cannot be edited.
1,420
2016
400
3,980
PURCHASES JOURNAL
Problem 5-3A
Name:
Solution
Section:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
2016
Date
2016
Date
Accts. Payable
Credit
320
1,800
2,940
1,890
3,880
310
Peach Computers Co.
Post.
Item Ref. Debit Credit Balance
Oct. 5 …………………………… P30 – 3,980 3,980
Yamura Co.
Post.
Item Ref. Debit Credit Balance
5.
a. Sum of creditor balances at October 31
6.
18,110$
Date
2016
Date
18,110$
2016
2016
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry. For correct grading enter a zero
in cells you would otherwise leave blank. Essay answers will not be graded.
3. and 4.
Page 30
Post. Field Supplies Office Supplies Post.
Account Credited Ref. Debit Debit Other Accounts Debit Ref. Amount
May
31 Totals
1. and 4.
Field Supplies
14
Post.
Item Ref. Debit Credit Debit Credit
May 1 Balance √6,200
……………………………
Office Supplies
15
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
May 1 Balance √1,490
……………………………
Office Equipment 18
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
May 1 Balance √19,400
……………………………
Accounts Payable 21
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
May 1 Balance √5,145
……………………………
2. and 3.
Accu-Vision Supply Co.
Post.
Item Ref. Debit Credit Balance
May 1 Balance √3,900
……………………………
J-Mart Co.
Post.
Item Ref. Debit Credit Balance
May 1 Balance √730
……………………………
……………………………
Lassiter Co.
Post.
Item Ref. Debit Credit Balance
GENERAL LEDGER
Balance
Date
2016
Date
ACCOUNTS PAYABLE SUBSIDIARY LEDGER
Date
2016
Date
2016
Problem 5-3B
Name:
Section:
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Date
2016
Cells with non-gray backgrounds are protected and cannot be edited.
PURCHASES JOURNAL
Accts. Payable
Credit
May 1 Balance √515
……………………………
Tri Cities Supplies
Post.
Item Ref. Debit Credit Balance
May ……………………………
……………………………
……………………………
Wendell Co.
Post.
Item Ref. Debit Credit Balance
May ……………………………
……………………………
5.
a. Sum of creditor balances at May 31
b. Balance of accounts payable controlling account at May 31
6.
2016
Date
2016
Date
2016
Scoring:
An asterisk (*) will appear to the right of an incorrect entry. For correct grading enter a zero
in cells you would otherwise leave blank. Essay answers will not be graded.
3. and 4.
Page 30
Post. Field Supplies Office Supplies Post.
Account Credited Ref. Debit Debit Other Accounts Debit Ref. Amount
May 1 Wendell Co. √3,240 – N/A – –
3 Lassiter Co. √– 340 N/A – –
1. and 4.
Field Supplies
14
Post.
Item Ref. Debit Credit Debit Credit
May 1 Balance √6,200
31 …………………………… P30 16,900 – 23,100 –
Office Supplies
15
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
May 1 Balance √1,490
Office Equipment 18
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
Accounts Payable 21
Post. Balance
Date Item Ref. Debit Credit Debit Credit
2016
May 1 Balance √5,145
2. and 3.
Accu-Vision Supply Co.
Post.
Item Ref. Debit Credit Balance
May 1 Balance √3,900
19 …………………………… P30 – 8,150 12,050
J-Mart Co.
Post.
Item Ref. Debit Credit Balance
May 1 Balance √730
15 …………………………… P30 – 500 1,230
Lassiter Co.
Post.
Item Ref. Debit Credit Balance
ACCOUNTS PAYABLE SUBSIDIARY LEDGER
Date
Date
2016
3,240
340
GENERAL LEDGER
Balance
Date
2016
Problem 5-3B
Name:
Solution
Section:
Accts. Payable
Credit
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Date
PURCHASES JOURNAL
ON
Instructions
2016
Date
2016
3,040
8,150
2,450
265
4,500
3,670
500