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 7-2A
Name:
Section:
Account Debit Credit
2016
Oct. 1 Petty Cash 750
Cash 750
31 Store Supplies 390
Delivery Expense 90
Office Supplies 56
Miscellaneous Administrative Expense 42
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 7-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
Problem 7-2B
Name:
Section:
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:
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
Cash Short and Over 22
Cash 954
ON
Scoring:
Problem 7-2B
Name:
Solution
Section:
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.
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 7-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$
Bank error in charging check as $940 instead of $490 450 19,000
Deduct: Error in recording check 1,350$
Bank service charges 60 1,410
Adjusted balance 114,960$
2.
Cash 26,750
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
November 30, 2016
CAPSTONE MEDICAL CO.
Bank Reconciliation
Problem 7-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 7-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$
2.
3.
Cash 6,635
Notes Receivable 5,750
Accounts Payable – Holland Co. 540
Interest Revenue 345
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
July 31, 2016
STONE SYSTEMS
Bank Reconciliation
Problem 7-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 7-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
Subtotal 40,920$
Deduct: Check returned due to insufficient funds 1,325$
2.
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 7-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 7-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$
2.
Cash 14,225
Notes Receivable 7,000
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
November 30, 2016
COLLEGIATE SPORTS CO.
Bank Reconciliation
Problem 7-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.
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Instructions
Score:
Key Code:
Problem 7-5A
Name:
Section:
(Key essay answer here)
June 30, 2016
BEELER FURNITURE COMPANY
Bank Reconciliation
Answers are entered in the cells with gray backgrounds.
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$
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$
2.
Cash 3,800.00
Notes Receivable 3,500.00
Interest Revenue 210.00
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:
Problem 7-5A
Name:
Solution
Section:
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.
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.
0%
[Key code here]
Instructions
Score:
Key Code:
Problem 7-5B
Name:
Section:
(Key essay answer here)
July 31, 2016
SUNSHINE INTERIORS
Bank Reconciliation
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 11,601.41$
Add: Deposit of July 31, not recorded by bank 1,177.87
Subtotal 12,779.28$
Cash balance according to company‘s records 7,664.00$
Add: Proceeds of note collected by bank, including interest 4,160.00$
2.
Cash 4,241.00
Notes Receivable 4,000.00
Interest Revenue 160.00
3.
Amount to be reported as cash on July 31 balance sheet 11,494.00$
Instructions
Answers are entered in the cells with gray backgrounds.
Scoring:
Problem 7-5B
Name:
Solution
Section:
ON
July 31, 2016
SUNSHINE INTERIORS
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.