Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help I would appreciate with explanation... Problem 4-3A (Algo) Prepare the bank reconciliation and record cash adjustments (LO4-5) The cash records and bank statement

please help I would appreciate with explanation...

Problem 4-3A (Algo) Prepare the bank reconciliation and record cash adjustments (LO4-5)

The cash records and bank statement for the month of May for Copperfield Entertainment are shown below.

COPPERFIELD ENTERTAINMENT
Cash Account Records
May 1, 2024, to May 31, 2024
Cash Balance May 1, 2024 + Cash Receipts Cash Disbursements = Cash Balance May 31, 2024
$5,470 $11,090 $11,080 $5,480
Cash Receipts Cash Disbursements
Date Description Amount Date Description Memo Amount
5/3 Sales $1,270 5/7 DC Legal fees $1,110
5/10 Sales 1,700 5/12 DC Property tax 1,480
5/17 Sales 2,330 5/15 DC Salaries 3,410
5/24 Sales 2,800 5/22 DC Advertising 1,310
5/31 Sales 2,990 5/30 CHK number 471 Supplies 360
5/31 CHK number 472 Salaries 3,410
$11,090 $11,080
P.O. Box 162647 Bowlegs, OK 74830 (405) 369-CASH Midwest Bank Looking Out For You Member FDIC
Account Holder: Copperfield Entertainment 124 Saddle Blvd, Bowlegs, OK 74830 Account Number: 7772854360
Statement Date: May 31, 2024
Account Summary
Beginning Balance May 1, 2024 Deposits and Credits Withdrawals and Debits Ending Balance May 31, 2024
Number Total Number Total
$6,070 7 $9,252 9 $8,561 $6,761
Account Details
Deposits and Credits Withdrawals and Debits Daily Balance
Date Amount Description Date Number Amount Description Date Amount
5/4 $1,270 DEP 5/1 469 $360 CHK 5/1 $5,710
5/11 1,700 DEP 5/2 470 240 CHK 5/2 5,470
5/18 2,330 DEP 5/7 1,110 DC 5/4 6,740
5/20 1,100 NOTE 5/11 210 NSF 5/9 5,630
5/20 41 INT 5/12 1,480 DC 5/11 7,120
5/25 2,800 DEP 5/15 3,410 DC 5/12 5,640
5/31 11 INT 5/20 410 EFT 5/18 4,560
5/22 1,310 DC 5/20 5,291
5/31 31 SF 5/25 6,781
$9,252 $8,561 5/31 $6,761

Description DEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer DC Debit card

Additional information:

The difference in the beginning balances in the companys records and the bank statement relates to checks number 469 and number 470, which are outstanding as of April 30, 2024 (prior month).

The bank made the EFT on May 20 in error. The bank accidentally charged Copperfield for payment that should have been made on another account.

Required: 1. Prepare a bank reconciliation for Copperfield's checking account on May 31, 2024. 2. Record the necessary cash adjustments.

required 1: Prepare a bank reconciliation for Copperfield's checking account on May 31, 2024. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconciliation.)

required 2 :

Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Total entries to the same account together when entering in the journal entry carousel.)

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_2

Step: 3

blur-text-image_3

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

Financial and managerial accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

1st edition

111800423X, 9781118233443, 1118016114, 9781118004234, 1118233441, 978-1118016114

More Books

Students also viewed these Accounting questions

Question

Why are large corporations often said to be publicly owned?

Answered: 1 week ago