Question
Can someone please help me do this 41. Based on the information on the Bank Reconciliation sheet prepare the journal entry required to decreases cash.
Can someone please help me do this
41. | Based on the information on the "Bank Reconciliation" sheet prepare the journal entry required to decreases cash. |
Previous Balance | - | Account Number | 33999999 | |||||
Deposits/Credits | 155,632.90 | Statement Date | 6/30/202x | |||||
Checks/Debits | 79,515.00 | |||||||
Ending Balance | 76,117.90 | |||||||
76,117.90 | ||||||||
Activity in date order | ||||||||
Date | Description | Amount | Balance | |||||
Jun 01 | 1 | Deposit | 143,747.90 | 143,747.90 | ||||
Jun 07 | 4 | Paid check # 5002 | -29,000.00 | 114,747.90 | ||||
Jun 15 | 8 | Paid check # 5003 | -22,250.00 | 92,497.90 | ||||
Jun 16 | 10 | Deposit | 8,150.00 | 100,647.90 | ||||
Jun 21 | 11 | Paid check # 5005 | -14,900.00 | 85,747.90 | ||||
Jun 22 | NSF | -3,200.00 | 82,547.90 | |||||
Jun 22 | NSF service charge | -20.00 | 82,527.90 | |||||
Jun 22 | 12 | Paid check # 5006 | -6,000.00 | 76,527.90 | ||||
Jun 23 | 21 | Deposit | 3,735.00 | 80,262.90 | ||||
Jun 24 | Paid check # 306 | -1,300.00 | 78,962.90 | |||||
Jun 26 | 14 | Paid check # 5007 | -480.00 | 78,482.90 | ||||
Jun 26 | 15 | Paid check # 5008 | -700.00 | 77,782.90 | ||||
Jun 27 | 17 | Paid check # 5009 | -910.00 | 76,872.90 | ||||
Jun 27 | Elec Remit AT&T Telephone | -240.00 | 76,632.90 | |||||
Jun 27 | 19 | Paid check # 5010 | -475.00 | 76,157.90 | ||||
Jun 29 | Service Charge- Checks | -40.00 | 76,117.90 | |||||
Ending Balance | 76,117.90 | |||||||
Check # 306 is not our check | ||||||
Our policy is to charge the customer for any charges related to NSF checks | ||||||
The Deposit on Jun 16 was incorrectly recorded by the bank. | ||||||
The Deposit on Jun 23 was correctly recorded by the bank. We do not modify the original journal entry. |
This is what I have so far
41 | Jun 30 | 5130 | Bank Expense | Service Charge | 40.00 | |
41 | Jun 30 | 5140 | Telephone Expense | Service Charge | 240.00 | |
41 | Jun 30 | 1120 | Accounts Receivable | Service Charge | ||
41 | Jun 30 | 1110 | Cash | Service Charge |
|
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