Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Use the following to answer questions 21 - 25

The Company's cash ledger reports the following for the month ending October 31, 20XE.

Deposits Checks

Date Amount No. Date Amount

3-Oct $45,000 1151 4-Oct $15,000

10-Oct 32,000 1152 6-Oct 11,000

17-Oct 49,000 1153 15-Oct 78,000

24-Oct 41,000 1154 16-Oct 12,000

Cash receipts 10/26 -10/27 22,000 1155 20-Oct 6,800

$189,000 1156 22-Oct 9,200

1157 29-Oct 29,000

Balance on October $65,200 $161,000

Receipts 189,000

Disbursements 161,000

Balance on October 31$93,200

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 $110,760

b)Cash receipts of $22,000 from 10/26-10/27 are outstanding.

c)Checks 1156 and 1157 are outstanding.

d)The deposit on 10/24 includes a customer's check for $1,500 that did not clear the bank (NSF check).

e)Check 1154 was written for $11,200 for a desk purchased in October. The bank properly recorded the check forthis amount.

f)An automatic withdrawal for November rent was made on October 29 for $3,000.

g)The company's checking account earns interest based on the average daily balance. The amount of interest earned for October is $20.

h)Last year, one of the company's customers requested their A/R be converted to a Note Receivable (they owed $5,000 to the company). On October 29th, the customer paid $5,100 ($5,000 note amount plus $100 interest) directly to the bank in payment for the amount they owed the company.

i)The bank charged the following service fees: $50 for NSF check and $10 account maintenance fee.

Display a bank reconciliation for October 31, 20XE to assist answering the questions following:

21. $___________Of the total checks written during the month, what amount should be deducted from the bank balance during reconciling the bank account?

22. $___________Of the cash receipts, what amount should be added to the bank balance during reconciling the bank account?

23. When performing the bank reconciliation, how should the company treat check 1154?

A. add $800 to the company cash account

B. subtract $800 from company cash account

C. add $800 to bank statement balance

D. subtract $800 from bank statement balance

24. $___________The total amount needed to reconcile the company cash account was:

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

Accountancy And The Changing Landscape Of Integrated Reporting

Authors: Ioana Dragu

1st Edition

1522536221, 9781522536222

More Books

Students also viewed these Accounting questions

Question

6. Explain what causes unsafe acts.

Answered: 1 week ago