Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

5-18 The following data were accumulated for use in reconciling thebank account

ID: 2434106 • Letter: 5

Question

5-18

The following data were accumulated for use in reconciling thebank account of Spectrum Co. for July:

a. Cash balance according to the company's records at July 31,$8,346.50.

b. Cash balance according to the bank statement July 31,$9,066.35.

c. Checks outstanding $3,175.25.

d. Deposit in transit, not recorded by bank, $2,615.40.

e. A check for $240 in payment of an account was erroneouslyrecorded in the check register at $420.

f. Bank debit memorandum for service charges, $20.00.

Prepare bank reconciliation, using the format included.

Explanation / Answer

Bankbalance 9,066.35 Add: Deposit intransit 2,615.40 11,681.75 Less: ChecksOutstanding 3,175.25 Bank balance afterreconciliation 8,506.50 BookBalance 8,346.50 Add: error inrecording 180.00 8,526.50 Less: ServiceCharge 20.00 Book Balance afterreconciliation 8,506.50

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote