Question
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
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