Question
hi chegg team can you solve this question for me please. Pelzer Company reconciled its bank and book statement balances of Cash on August 31
hi chegg team can you solve this question for me please.
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,100 and #5893 for $1,458.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,476.00 | |
6 deposits and other credits totalling | 19,860.00 | |
9 cheques and other debits totalling | 24,466.00 | |
Current balance as of Sept. 30/20 | 5,870.00 | |
Chequing Account Transactions | |||||||||||
Date | Amount | Transaction Description | Date | Amount | Transaction Description | ||||||
Sept. | 05 | 5,539.00 | + Deposit | Sept. 25 | 3,326.00 | + Deposit | |||||
12 | 2,523.00 | + Deposit | 30 | 40.00 | + Interest | ||||||
17 | 325.45 | NSF cheque | 30 | 3,490.00 | + Credit memo | ||||||
21 | 5,208.00 | + Deposit |
Date | Cheque No. | Amount | Date | Cheque No. | Amount | |||||
Sept. | 03 | 5904 | 9,340.55 | Sept. 22 | 5888 | 6,100.00 | ||||
07 | 5901 | 1,447.00 | 24 | 5909 | 1,914.00 | |||||
08 | 5905 | 303.00 | 28 | 5907 | 2,974.00 | |||||
10 | 5903 | 1,181.00 | 29 | 5902 | 881.00 | |||||
From Pelzer Companys accounting records:
Cash | Acct. No. 101 | ||||||||
Date | Explanation | PR | Debit | Credit | Balance | ||||
2020 | |||||||||
Aug. | 31 | Balance | 2,652.00 | ||||||
Sept. | 30 | CR12 | 17,871.00 | 20,523.00 | |||||
30 | CD23 | 14,047.55 | 6,475.45 | ||||||
Deposits Made | |||||
Sept. | 5 | $ | 5,539.00 | ||
12 | 2,523.00 | ||||
21 | 5,208.00 | ||||
25 | 3,326.00 | ||||
30 | 1,275.00 | ||||
Total Sept. Cash Receipts | $ | 17,871.00 | |||
Cheques Written | |||||
No. | 5901 | $ | 1,447.00 | ||
5902 | 881.00 | ||||
5903 | 1,181.00 | ||||
5904 | 3,940.55 | ||||
5905 | 303.00 | ||||
5906 | 641.00 | ||||
5907 | 2,974.00 | ||||
5908 | 766.00 | ||||
5909 | 1,914.00 | ||||
Total Sept. Cash Disbursements | $ | 14,047.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,540 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.)
2. Prepare the General Journal entries needed to adjust the book balance of cash to the reconciled balance. (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