Answered step by step
Verified Expert Solution
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
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