An asterisk (*) will appear to the right of an incorrect entry.
Account Debit Credit
20Y1
July 1
12
31
31
31
Problem 7-2A
Name:
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
JOURNAL
Date
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
# Incorrect N-box and B-box entries COUNTIF(B15:G24,”~*”)
0
# N-box Incorrects due to blanks COUNTIF(B15:AT24,” “)
0
# N-box +B-box corrects COUNTIF(B15:AT24,” “)
0
Total SUM(AD13:AD15)
0
Percentage =(AD16-AD13-AD14)/AD16
#DIV/0!
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, ” “
If number-entry or blank-entry box is incorrect, returns “*”
If number-entry or blank-entry box is correct, returns single space, ” “
Account Debit Credit
20Y1
July ### Petty Cash 1,100 Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can’t enter a space in a box and have it counted as correct.
Cash 1,100 Conditional formatting might be used but wasn’t here, to hide some of the error check return symbols. If A1 = “~*”, then font = red, if something else, then font = background color.
### Cash 8,220
Sales 8,192
Cash Short and Over 28
### Store Supplies 580
Delivery Expense 225
Office Supplies 140
Miscellaneous Administrative Expense 88
Cash Short and Over 20
Cash 1,053
### Cash 10,232
Cash Short and Over 9
Sales 10,241
### Cash 150
Petty Cash 150
Scoring:
ON
Problem 7-2A
Name:
Solution
Section:
JOURNAL
Date
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 right of an incorrect entry.
Account Debit Credit
20Y3
June 1
12
30
30
30
Problem 7-2B
Name:
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
JOURNAL
Date
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
# Incorrect N-box and B-box entries COUNTIF(B15:G24,”~*”)
0
# N-box Incorrects due to blanks COUNTIF(B15:AT24,” “)
0
# N-box +B-box corrects COUNTIF(B15:AT24,” “)
0
Total SUM(AD13:AD15)
0
Percentage =(AD16-AD13-AD14)/AD16
#DIV/0!
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, ” “
If number-entry or blank-entry box is incorrect, returns “*”
If number-entry or blank-entry box is correct, returns single space, ” “
Account Debit Credit
20Y3
June ### Petty Cash 1,000 Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can’t enter a space in a box and have it counted as correct.
Cash 1,000 Conditional formatting might be used but wasn’t here, to hide some of the error check return symbols. If A1 = “~*”, then font = red, if something else, then font = background color.
### Cash 9,506
Sales 9,440
Cash Short and Over 66
### Store Supplies 375
Inventory 215
Office Supplies 208
Miscellaneous Administrative Expense 134
Cash Short and Over 22
Cash 954
### Cash 13,350
Cash Short and Over 40
Sales 13,390
### Petty Cash 200
Cash 200
Scoring:
ON
Problem 7-2B
Name:
Solution
Section:
JOURNAL
Date
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:
Total additions
Deduct:
Adjusted balance
Cash balance according to company’s records
Add:
Deduct:
Total deductions
Adjusted balance
2.
30
3.
Amount to be reported on June 30, 20Y1, balance sheet
Answers are entered in the cells with gray backgrounds.
Problem 7-3A
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Pala Medical Co.
Bank Reconciliation
June 30, 20Y1
June 30
1.
Cash balance according to bank statement 195,688$
Add: Deposit in transit on June 30 12,300$
Bank error in charging check as $915 instead of $195 720
Total additions 13,020
Deduct: Outstanding checks (19,427)
Adjusted balance 189,281$
Cash balance according to company’s records 166,436$
Add: Note collected by bank, including $1,500 interest 26,500
Deduct: Error in recording check 3,600$
Bank service charges 55
Total deductions (3,655)
Adjusted balance 189,281$
2.
Cash 26,500
Notes Receivable 25,000
Interest Revenue 1,500
30 Accounts Payable – Skyline Supply Co. 3,600
Miscellaneous Expense 55
Cash 3,655
Scoring:
ON
Problem 7-3A
Name:
Solution
Section:
Pala Medical Co.
Bank Reconciliation
June 30, 20Y1
June 30
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 left of an incorrect entry.
An asterisk (*) will appear to the left of an incorrect entry.
1.
Cash balance according to bank statement
Add:
Deduct:
Total deductions
Adjusted balance
Cash balance according to company’s records
Add:
Total additions
Deduct:
Adjusted balance
2.
31
3.
Amount to be reported on July 31, 20Y5, balance sheet
Answers are entered in the cells with gray backgrounds.
Problem 7-3B
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Stone Systems
Bank Reconciliation
July 31, 20Y5
July 31
1.
Cash balance according to bank statement 33,650$
Add: Deposit in transit on July 31 9,150
Deduct: Outstanding checks 17,865$
Bank error in charging check as $1,180 instead of $1,810 630
Total deductions (18,495)
Adjusted balance 24,305$
Cash balance according to company’s records 17,750$
Add: Note collected by bank, including $345 interest 6,095$
Error in recording check 540
Total additions 6,635
Deduct: Bank service charges (80)
Adjusted balance 24,305$
2.
Cash 6,635
Notes Receivable 5,750
Accounts Payable – Holland Co. 540
Interest Revenue 345
31 Miscellaneous Expense 80
Cash 80
3.
Scoring:
ON
Problem 7-3B
Name:
Solution
Section:
Stone Systems
Bank Reconciliation
July 31, 20Y5
July 31
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 left of an incorrect entry.
An asterisk (*) will appear to the left of an incorrect entry.
1.
Cash balance according to bank statement
Add:
Total additions
Deduct:
Adjusted balance
Cash balance according to company’s records
Add:
Deduct:
Total deductions
Adjusted balance
2.
31
3.
Amount to be reported on October 31, 20Y9, balance sheet
Problem 7-4A
Name:
Section:
Oct. 31
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Coastal Bike Co.
Bank Reconciliation
October 31, 20Y9
20Y9
1.
Cash balance according to bank statement 8,980$
Add: Deposit in transit on October 31 1,050$
Bank error in charging check as $730 instead of $370 360
Total additions 1,410
Deduct: Outstanding checks (5,560)
Adjusted balance 4,830$
Cash balance according to company’s records 3,795$
Add: Note collected by bank, including $120 interest 2,120
Deduct: Check returned because of insufficient funds 880$
Error in recording check 180
Bank service charges 25
Total deductions (1,085)
Adjusted balance 4,830$
2.
Cash 2,120
Notes Receivable 2,000
Interest Revenue 120
31 Accounts Receivable – Bay View Condos 880
Accounts Payable – Rack Pro Co. 180
3.
An asterisk (*) will appear to the left of an incorrect entry.
Problem 7-4A
Name:
Solution
Section:
Scoring:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Coastal Bike Co.
Bank Reconciliation
October 31, 20Y9
20Y9
Oct. 31
An asterisk (*) will appear to the left of an incorrect entry.
1.
Cash balance according to bank statement
Add:
Deduct:
Total deductions
Adjusted balance
Cash balance according to company’s records
Add:
Total additions
Deduct:
Total deductions
Adjusted balance
2.
30
3.
Amount to be reported on November 30, 20Y9, balance sheet
Answers are entered in the cells with gray backgrounds.
Problem 7-4B
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Collegiate Sports Co.
Bank Reconciliation
November 30, 20Y9
Nov. 30
1.
Cash balance according to bank statement 112,675$
Add: Deposit in transit on November 30 12,200
Deduct: Outstanding checks 41,840$
Bank error in charging check as $7,250 instead of $2,750 4,500
Total deductions (46,340)
Adjusted balance 78,535$
Cash balance according to company’s records 66,935$
Add: Note collected by bank, including $385 interest 7,385$
Error in recording check as $7,600 instead of $760 6,840
Total additions 14,225
Deduct: Check returned because of insufficient funds 2,500$
Bank service charges 125
Total deductions (2,625)
Adjusted balance 78,535$
2.
Cash 14,225
Notes Receivable 7,000
Accounts Payable – Ramirez Co. 6,840
Interest Revenue 385
3.
Scoring:
ON
Problem 7-4B
Name:
Solution
Section:
Collegiate Sports Co.
Bank Reconciliation
November 30, 20Y9
Nov. 30
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 left 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:
Deduct: Outstanding checks:
Total deductions
Adjusted balance
Cash balance according to company’s records
Add:
Total additions
Deduct:
Total adjustments
Adjusted balance
2.
30
3.
Amount to be reported as cash on the June 30 balance sheet
4.
Problem 7-5A
Name:
Section:
(Key essay answer here)
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Beeler Furniture Company
Bank Reconciliation
June 30, 20Y2
June 30
1.
Cash balance according to bank statement 13,624.71$
Add: Deposit in transit on June 30 1,117.74
Deduct: Outstanding checks:
No. 738 251.40
No. 756 113.95
No. 758 259.60
No. 759 901.50
Total deductions (1,526.45)
Adjusted balance 13,216.00$
Cash balance according to company’s records 10,145.50$
30 Accounts Receivable 550.00
Sales 104.50
Miscellaneous Expense 75.00
Cash 729.50
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Problem 7-5A
Name:
Solution
Section:
Scoring:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Beeler Furniture Company
Bank Reconciliation
June 30, 20Y2
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:
Deduct: Outstanding checks:
Total deductions
Adjusted balance
Cash balance according to company’s records
Add:
Total additions
Deduct:
Total deductions
Adjusted balance
2.
31
3.
Amount to be reported as cash on the July 31 balance sheet
4.
Problem 7-5B
Name:
Section:
(Key essay answer here)
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Sunshine Interiors
Bank Reconciliation
July 31, 20Y0
July 31
1.
Cash balance according to bank statement 11,601.41$
Add: Deposit in transit on July 31 1,177.87
Deduct: Outstanding checks:
No. 613 137.50$
No. 628 837.70
No. 633 310.08
Total deductions (1,285.28)
Adjusted balance 11,494.00$
Cash balance according to company’s records 7,664.00$
Add: Note collected by bank, including $160 interest 4,160.00$
31 Accounts Receivable 375.00
Miscellaneous Expense 36.00
Cash 411.00
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Problem 7-5B
Name:
Solution
Section:
Scoring:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Sunshine Interiors
Bank Reconciliation
July 31, 20Y0