Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answer 21-25 please Use the following to answer questions 21-25 TIM Company's cash ledger reports the following for the month ending October 31, 20XE. Deposits

answer 21-25 please
image text in transcribed
Use the following to answer questions 21-25 TIM Company's cash ledger reports the following for the month ending October 31, 20XE. Deposits Checks Date Amount Date No 3-Oct 4-Oct 10-Oct 6-Oct Amount $17.500 33,250 39,500 22,400 29,500 $142,150 1151 1152 1153 1154 17-Oct 15-Oct 16-Oct 24-Oct Cash receipts 10/26 10/31 $12,000 8,500 42,900 9,800 17,700 14,900 27,250 $133,050 20-Oct 1155 1156 22-Oct 29-Oct 1157 Balance on October 1 Receipts Disbursements Balance on October 31 $23,800 142,150 133,050 $32,900 Information from October's bank statement and company records reveals the following additional information The ending cash balance shown on the bank statement is $46.793. Cash receipts of $29,500 from 10/26-10/31 are outstanding Checks 1156 and 1157 are outstanding The deposit on 10/24 includes a customer's check for $400 that did not clear the bank (NSF check Check 1154 was actually written for $9,080 for equipment purchased in October. The bank properly recorded the check for this amount An automatic withdrawal for October rent was made on October 4 for $2.400 The company's checking account earns interest based on the average daily balance. The amount of interest earned for October is $S Last year, one of the company's customers requested their A/R be converted to a Not Receivable (they owed $3,200 to the company on October 29th, the customer paid $3,350 53.200 note amount plus $150 interest directly to the bank in payment for the amount they owed the company The bank charged the following service fees: $25 for NSF check, S1 for automatic withdrawal for rent payment and 51 for collection of the loan amount from the customer Prepare a bank reconciliation for October 31, 20XE to assist answering the questions following: 21. S of the total checks written during the month, what amount should be deducted from the bank balance during reconciling the bank account? 225 account? Of the cash receipts, what amount should be added to the bank balance during reconciling the bank 23 When performing the bank reconciliation, how should the company treat check 1154?add 5720 to the company cash account, subtract 5720 from company cash account, add 5720 to bank statement balance, subtract 5720 from bank statement balance) 24. $ The total amount of subtractions from the company cash account during the reconciliation (DO NOT INCLUDE THE ADDITIONS. also do not make the answer negative 25 What is the company's cash balance after the reconciliation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M.Dater, George Foster, Madhav

13th Edition

8120335643, 136126634, 978-0136126638

Students also viewed these Accounting questions