978-0078025587 Chapter 8 Excel

subject Type Homework Help
subject Pages 7
subject Words 771
subject Authors Barbara Chiappetta, John Wild, Ken Shaw

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
27,233$ 27,497$
11,514 7,955
38,747 35,452
1,482$ NSF check 805$
382 Service charge 25
2,281 4,145 Error (Check no. 3056) 20 850
34,602$ «- Correct! Adjusted book balance 34,602$ «- Correct!
Date Account Title Debit Credit
Jul 31 7,955
45
8,000 «- Correct!
31 805
805 «- Correct!
31 25
25 «- Correct!
31 20
20 «- Correct!
To charge account for NSF check plus fees.
McGraw-Hill/Irwin
Instructor
Problem 08-04A
To record note collection less fees.
General Journal
BRANCH COMPANY
Cash
Bank Reconciliation
Collection Expense
Miscellaneous Expenses
BRANCH COMPANY
Adjusted bank balance
Accts. Rec.- E. Shaw
3065
3069
Deduct:
July 31, 2013
Bank statement balance
Add:
Deposit of July 31
Total
Notes Receivable
Book balance
Add:
Proceeds of note less collection charge
Deduct:
Outstanding Checks:
3031
Cash
Cash
Rent Expense
Cash
To record bank service fee.
To correct an entry error.
bank statement cash balance and (ii) the adjusted cash account
For each of the following errors, explain the effect on (i) the adjusted
page-pf2
Student Name:
Class:
McGraw-Hill/Irwin
Instructor
Problem 08-04A
a. (i) The final balance that results from adjusting the bank statement
balance will not be affected by the error; and
(ii) The final balance that results from adjusting the book balance of cash will
statement cash balance on reconciliation.
b. Collection of $8,000 note less $45 collection fee is added to bank
as $27,947.
a. Unadjusted cash account balance of $27,497 is listed on reconciliation
book balance.
be overstated by $450 ($27,947-$27,497), and the bank reconciliation
will not balance.
b. (i) The final balance that results from adjusting the bank statement
balance will be overstated by $7,955; and
(ii) The final balance that results from adjusting the book balance will be
understated by$7,955.
page-pf4
Student Name:
Class:
18,453.25$ 17,404.20$
1,682.75 12.50$
20,136.00 1,485.00 1,497.50
18,901.70
494.25$ 600.25
982.30 30.00
388.00 1,864.55 630.25
18,271.45$ «- Correct! 18,271.45$ «- Correct!
Date Account Title Debit Credit
Sep 30 12.50
12.50 «- Correct!
30 1,485.00
15.00
1,500.00 «- Correct!
30 600.25
600.25 «- Correct!
30 30.00
30.00 «- Correct!
McGraw-Hill/Irwin
Instructor
Problem 08-05A
To correct an entry error.
To charge account for NSF check plus fee.
To record note collection less fee.
Bank statement balance
Add:
To record interest earned.
September 30, 2013
Bank Reconciliation
CHAVEZ COMPANY
General Journal
CHAVEZ COMPANY
Deposit of September 30
Total
The bank statement reveals that some of the prenumbered checks in the sequence are missing.
Describe three situations that could explain this.
There are several possible reasons why some prenumbered checks are missing from
the sequence of canceled checks returned with a bank statement. Reasons include:
(1) Some of the checks in the numbered sequence may have cleared the bank in a
previous period and were returned with the bank statement in that previous period.
(2) Some of the checks in the numbered sequence may remain outstanding. If so, they
will be returned with the bank statement in a later period when they clear the bank.
Adjusted bank balance
Book balance of cash
Add:
Interest earned
Proceeds of note less coll. fee
Deduct:
NSF check
Error on check no. 5904
Total
Adjusted book balance
Deduct:
Checks No. 5893
5906
5908
Computer Equipment
Cash
Collection Expense
Notes Receivable
Accts. Rec.-S. Nilson
Cash
Interest Earned
Cash
Cash
page-pf5
Student Name:
Class:
McGraw-Hill/Irwin
Instructor
Problem 08-05A
check to the wrong account. When the bank detects the error, it will return the check
separately with a note of explanation to the depositor.
numbered sequence, perhaps because of making an error in writing the checks.
(4) Occasionally, a check will reach the bank but the bank will incorrectly charge the
(3) The issuer of the checks may have voided one or more of the checks in the

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.