An asterisk (*) will appear to the right of an incorrect entry.
Account Debit Credit
2016
Oct. 1
12
31
31
31
0%
JOURNAL
Date
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Problem 8-2A
Name:
Section:
Account Debit Credit
2016
Oct. 1 Petty Cash 750
Cash 750
31 Store Supplies 390
Delivery Expense 90
Office Supplies 56
31 Cash 18,780
Cash Short and Over 40
Sales 18,820
ON
Date
JOURNAL
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Scoring:
Problem 8-2A
Name:
Solution
Section:
An asterisk (*) will appear to the right of an incorrect entry.
Account Debit Credit
2016
June 1
12
30
30
30
0%
JOURNAL
Date
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Problem 8-2B
Name:
Section:
Account Debit Credit
2016
June 1 Petty Cash 1,000
Cash 1,000
30 Store Supplies 375
Merchandise Inventory 215
Office Supplies 208
Miscellaneous Administrative Expense 134
Date
JOURNAL
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
ON
Scoring:
Problem 8-2B
Name:
Solution
Section:
An asterisk (*) will appear to the left of an incorrect entry.
1.
Cash balance according to bank statement
Add:
Subtotal
Deduct:
Adjusted balance
Cash balance according to company’s records
Add:
Subtotal
Deduct:
Adjusted balance
2.
3.
Amount to be reported on November 30, 2016, balance sheet
0%
[Key code here]
Instructions
Score:
Key Code:
November 30, 2016
CAPSTONE MEDICAL CO.
Bank Reconciliation
Problem 8-3A
Name:
Section:
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
1.
Cash balance according to bank statement 128,660$
Add: Deposit of November 30, not recorded by bank 18,550$
Cash balance according to company’s records 89,620$
2.
Cash 26,750
Notes Receivable 25,000
Interest Revenue 1,750
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
November 30, 2016
CAPSTONE MEDICAL CO.
Bank Reconciliation
Problem 8-3A
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the left of an incorrect entry.
An asterisk (*) will appear to the right of an incorrect entry.
1.
Cash balance according to bank statement
Add:
Subtotal
Deduct:
Adjusted balance
Cash balance according to company‘s records
Add:
Subtotal
Deduct:
Adjusted balance
2.
3.
Amount to be reported on July 31, 2016, balance sheet
0%
[Key code here]
Instructions
Score:
Key Code:
July 31, 2016
STONE SYSTEMS
Bank Reconciliation
Problem 8-3B
Name:
Section:
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
1.
Cash balance according to bank statement 33,650$
Add: Deposit of July 31, not recorded by bank 9,150
Subtotal 42,800$
Cash balance according to company‘s records 17,750$
2.
3.
Cash 6,635
Notes Receivable 5,750
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
July 31, 2016
STONE SYSTEMS
Bank Reconciliation
Problem 8-3B
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
An asterisk (*) will appear to the right of an incorrect entry.
1.
Balance per bank statement
Add:
Subtotal
Deduct:
Adjusted balance
Balance per company‘s records
Add:
Subtotal
Deduct:
Adjusted balance
2.
3.
Amount to be reported as cash on May 31, 2016, balance sheet
0%
[Key code here]
Instructions
Score:
Key Code:
May 31, 2016
BRENTWOOD BIKE CO.
Bank Reconciliation
Problem 8-4A
Name:
Section:
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
1.
Balance per bank statement 43,525$
Add: Deposit of May 31, not recorded by bank 1,850$
Balance per company‘s records 35,670$
Add: Proceeds of note collected by bank, including $250 interest 5,250
2.
3.
Cash 5,250
Notes Receivable 5,000
Interest Revenue 250
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
May 31, 2016
BRENTWOOD BIKE CO.
Bank Reconciliation
Problem 8-4A
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
An asterisk (*) will appear to the right of an incorrect entry.
1.
Balance per bank statement
Add:
Subtotal
Deduct:
Adjusted balance
Balance per company‘s records
Add:
Subtotal
Deduct:
Adjusted balance
2.
3.
Amount to be reported as cash on Nov. 30, 2016, balance sheet
0%
[Key code here]
Instructions
Score:
Key Code:
November 30, 2016
COLLEGIATE SPORTS CO.
Bank Reconciliation
Problem 8-4B
Name:
Section:
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
1.
Balance per bank statement 112,675$
Add: Deposit of November 30, not recorded by bank 12,200
Subtotal 124,875$
Balance per company‘s records 66,935$
Add: Proceeds of note collected by bank, including $385 interest 7,385$
2.
3.
Cash 14,225
Notes Receivable 7,000
Accounts Payable – Ramirez Co. 6,840
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
November 30, 2016
COLLEGIATE SPORTS CO.
Bank Reconciliation
Problem 8-4B
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Cash balance according to bank statement
Add:
Subtotal
Deduct outstanding checks:
Adjusted balance
Cash balance according to company‘s records
Add:
Subtotal
Deduct:
Adjusted balance
2.
3.
Amount to be reported as cash on the June 30 balance sheet
4.
Problem 8-5A
Name:
Section:
(Key essay answer here)
June 30, 2016
BEELER FURNITURE COMPANY
Bank Reconciliation
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Instructions
Score:
Key Code:
1.
Cash balance according to bank statement 13,624.71$
Add: Deposit of June 30, not recorded by bank 1,117.74
Subtotal 14,742.45$
Deduct outstanding checks:
No. 738 251.40$
No. 756 113.95
Cash balance according to company‘s records 10,145.50$
Add: Proceeds of note collected by bank, including interest 3,710.00$
Error in recording check 90.00 3,800.00
Subtotal 13,945.50$
Deduct: Check returned due to insufficient funds 550.00$
Error in recording June 10 deposit 100.00
2.
Cash 3,800.00
Notes Receivable 3,500.00
Accounts Receivable 550.00
Sales 104.50
4.
Problem 8-5A
Name:
Solution
Section:
The error of $540 ($930 – $390) in the canceled check should be added to the “balance according to bank
June 30, 2016
BEELER FURNITURE COMPANY
Bank Reconciliation
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Cash balance according to bank statement
Add:
Subtotal
Deduct outstanding checks:
Adjusted balance
Cash balance according to company‘s records
Add:
Subtotal
Deduct:
Adjusted balance
2.
3.
Amount to be reported as cash on July 31 balance sheet
4.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Instructions
Score:
Key Code:
(Key essay answer here)
July 31, 2016
SUNSHINE INTERIORS
Bank Reconciliation
Problem 8-5B
Name:
Section:
1.
Cash balance according to bank statement 11,601.41$
Add: Deposit of July 31, not recorded by bank 1,177.87
Subtotal 12,779.28$
Deduct outstanding checks:
Cash balance according to company‘s records 7,664.00$
Add: Proceeds of note collected by bank, including interest 4,160.00$
Error in recording Check No. 627 63.00
2.
Cash 4,241.00
Notes Receivable 4,000.00
4.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
The error of $1,620 ($1,800 – $180) in the canceled check should be added to the “balance according to bank
July 31, 2016
SUNSHINE INTERIORS
Bank Reconciliation
Problem 8-5B
Name:
Solution
Section: