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
Get step-by-step solutions from verified subject matter experts
