Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed two cheques outstanding at that time, #5888 for $6,270

Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed two cheques outstanding at that time, #5888 for $6,270 and #5893 for $1,498.00. The following information was available for the September 30, 2020, reconciliation: From the September 30, 2020, bank statement:

Balance of previous statement on Aug. 31/20 10,763.00
6 deposits and other credits totalling 22,759.00
9 cheques and other debits totalling 26,670.00
Current balance as of Sept. 30/20 6,852.00

Chequing Account Transactions
Date Amount Transaction Description Date Amount Transaction Description
Sept. 05 5,690.00 + Deposit Sept. 25 4,264.00 + Deposit
12 2,583.00 + Deposit 30 48.00 + Interest
17 933.45 NSF cheque 30 3,506.00 + Credit memo
21 6,489.00 + Deposit
Date Cheque No. Amount Date Cheque No. Amount
Sept. 03 5904 9,340.55 Sept. 22 5888 6,270.00
07 5901 1,453.00 24 5909 2,289.00
08 5905 362.00 28 5907 3,556.00
10 5903 1,412.00 29 5902 1,054.00

From Pelzer Companys accounting records:

Cash Acct. No. 101
Date Explanation PR Debit Credit Balance
2020
Aug. 31 Balance 3,174.00
Sept. 30 CR12 21,388.00 24,562.00
30 CD23 15,748.55 8,813.45

Deposits Made
Sept. 5 $ 5,690.00
12 2,583.00
21 6,489.00
25 4,264.00
30 2,362.00
Total Sept. Cash Receipts $ 21,388.00

Cheques Written
No. 5901 $ 1,453.00
5902 1,054.00
5903 1,412.00
5904 3,940.55
5905 362.00
5906 766.00
5907 3,556.00
5908 916.00
5909 2,289.00
Total Sept. Cash Disbursements $ 15,748.55

  • Cheque #5904 was correctly written for $9,340.55 to pay for computer equipment; however, the bookkeeper misread the amount and entered it in the accounting records with a debit to Computer Equipment and a credit to Cash as though it were for $3,940.55. The NSF cheque was originally received from a customer, Lisa Willis, in payment of her account. Its return was not recorded when the bank first notified the company.
  • The credit memo resulted from an electronic fund transfer of $3,556 for a customer payment. The bank had deducted a $50.00 bank service charge. The collection has not been recorded.

Required: 1. Prepare a September 30 bank reconciliation for the company. (Round your answers to 2 decimal places.)

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

More Books

Students also viewed these Accounting questions

Question

Describe how projective tests are used.

Answered: 1 week ago

Question

2. Describe why we form relationships

Answered: 1 week ago

Question

5. Outline the predictable stages of most relationships

Answered: 1 week ago