Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed...

Transcribed Image Text:

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,160 and #5893 for $1,473.00. The following information was available for the September 30, 2023, reconciliation: From the September 30, 2023, bank statement: Balance of previous statement on Aug. 31/20 6 deposits and other credits totalling: 9 cheques and other debits totalling Current balance as of Sept. 30/20 Chequing Account Transactions Transaction 10,584.00 21,240.00 25,085.00 6,739.00 Date Amount Description Date Sept. 05 5,546.00 + Deposit Sept. 25- Amount 3,845.00 12 2,470.00 +Deposit 30 17 311.45 21 Date 5,932.00 Cheque No. Sept. 03 5904 07 5901 NSF cheque Deposit Amount 9,340.55. 1,450.00 30 43.00 3,496.00 Date Cheque No. Sept. 22 08 5985 327.00 28 10 5903 1,274.00 2222 5888 24 5909 5907 29 5902 Transaction Description + Deposit + Interest + Credit memo Amount 6,160.00 2,064.00 3,208.00 950.00 From Pelzer Company's accounting records: Cash Date 2023 Explanation PR Debit Credit Acct. No. 101 Balance Aug. 31 Balance 2,859.00 Sept. 30 30 CR12 19,266.00 CD23 22,125.00 14,731.55 7,393.45 Deposits Made Sept. 5 $ 5,546.00 12 2,470.00 21 5,932.00 25 3,845.00 30 1,473.00 Total Sept. Cash Receipts Cheques Written No. 5901 5902 5903 5904 5905 5906 5907 5908 $19,266.00 $ 1,450.00 950.00 1,274.00 3,940.55 327.00 692.00 3,208.00 826.00 2,064.00 5909 Total Sept. Cash Disbursements $14,731.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.546 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.) PELZER COMPANY Bank Reconciliation September 30, 2023 Bank Statement Bank statement balance Add: Deduct: S 0.00 Company's Books Book balance of cash Add: Deduct $ 0.00 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.) View transaction list Journal entry worksheet < 2 3 Record interest earned. Note: Enter debits before credits Date Sep 30 General Journal Debit Credit 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.) View transaction list Journal entry worksheet < 1 2 3 4 Record EFT less bank service charge. Note: Enter debits before credits. Date Sep 30 General Journal Debit Credit 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.) View transaction list Journal entry worksheet 2 3 4 Record NSF cheque. Note: Enter debits before credits. Date Sep 30 General Journal Debit Credit 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.) View transaction list Journal entry worksheet < 1 2 3 4 Record to correct error in Cheque #5904. Note: Enter debits before credits. Date Sep 30 General Journal Debit Credit 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,160 and #5893 for $1,473.00. The following information was available for the September 30, 2023, reconciliation: From the September 30, 2023, bank statement: Balance of previous statement on Aug. 31/20 6 deposits and other credits totalling: 9 cheques and other debits totalling Current balance as of Sept. 30/20 Chequing Account Transactions Transaction 10,584.00 21,240.00 25,085.00 6,739.00 Date Amount Description Date Sept. 05 5,546.00 + Deposit Sept. 25- Amount 3,845.00 12 2,470.00 +Deposit 30 17 311.45 21 Date 5,932.00 Cheque No. Sept. 03 5904 07 5901 NSF cheque Deposit Amount 9,340.55. 1,450.00 30 43.00 3,496.00 Date Cheque No. Sept. 22 08 5985 327.00 28 10 5903 1,274.00 2222 5888 24 5909 5907 29 5902 Transaction Description + Deposit + Interest + Credit memo Amount 6,160.00 2,064.00 3,208.00 950.00 From Pelzer Company's accounting records: Cash Date 2023 Explanation PR Debit Credit Acct. No. 101 Balance Aug. 31 Balance 2,859.00 Sept. 30 30 CR12 19,266.00 CD23 22,125.00 14,731.55 7,393.45 Deposits Made Sept. 5 $ 5,546.00 12 2,470.00 21 5,932.00 25 3,845.00 30 1,473.00 Total Sept. Cash Receipts Cheques Written No. 5901 5902 5903 5904 5905 5906 5907 5908 $19,266.00 $ 1,450.00 950.00 1,274.00 3,940.55 327.00 692.00 3,208.00 826.00 2,064.00 5909 Total Sept. Cash Disbursements $14,731.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.546 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.) PELZER COMPANY Bank Reconciliation September 30, 2023 Bank Statement Bank statement balance Add: Deduct: S 0.00 Company's Books Book balance of cash Add: Deduct $ 0.00 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.) View transaction list Journal entry worksheet < 2 3 Record interest earned. Note: Enter debits before credits Date Sep 30 General Journal Debit Credit 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.) View transaction list Journal entry worksheet < 1 2 3 4 Record EFT less bank service charge. Note: Enter debits before credits. Date Sep 30 General Journal Debit Credit 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.) View transaction list Journal entry worksheet 2 3 4 Record NSF cheque. Note: Enter debits before credits. Date Sep 30 General Journal Debit Credit 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.) View transaction list Journal entry worksheet < 1 2 3 4 Record to correct error in Cheque #5904. Note: Enter debits before credits. Date Sep 30 General Journal Debit Credit