Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the following to answer questions 21 - 25 TLC Company's cash ledger reports the following for the month ending October 31, 20XE. Checks Deposits
Use the following to answer questions 21 - 25 TLC Company's cash ledger reports the following for the month ending October 31, 20XE. Checks Deposits Date 3-Oct 10-Oct 17-Oct 24-Oct Cash receipts 10/26 10/31 Amount $12,500 1151 4-Oct $2,410 18,300 35,600 22,100 21,300 $109,800 1156 22-Oct 14,200 No. Date Amount 1152 6-Oct 10,040 1153 15-Oct 27,400 1154 16-Oct 6,420 1155 20-Oct 4,600 1157 29-Oct 27,500 Balance on October 1 $6,277 Receipts Disbursements Balance on October 31 $92,570 109,800 92,570 $23,507 Information from October's bank statement and company records reveals the following additional information: a. The ending cash balance shown on the bank statement is $47,820. b. Cash receipts of $21,300 from 10/26-10/31 are outstanding. c. Checks 1156 and 1157 are outstanding. d. The deposit on 1O/24 includes a customer's check for $360 that did not clear the bank (NSF check) e. Check 1154 was written for $4,620 for equipment purchased in October. The bank properly recorded the check for this amount. f. An automatic withdrawal for October rent was made on October 4 for $1,750 g. TLC's checking account earns interest based on the average daily balance. The amount of interest earned for October is $10 h. Last year, one of TLC's customers requested their A/R be converted to a Note Receivable (they owed $4,000 to TLC). On October 29th, the customer paid $4,240 ($4,000 note amount plus $240 interest) directly to the bank in payment for the amount they owed TLC i. The bank charged the following service fees: $25 for NSF check, $1 for automatic withdrawal for rent payment, and $1 for collection of the loan amount from the customer. Prepare a bank reconciliation for October 31, 20XE to assist answering the questions following
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started