Answered step by step
Verified Expert Solution
Question
1 Approved Answer
P5-4 Bank reconciliation and entries Rancho Foods deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required
P5-4 Bank reconciliation and entries Rancho Foods deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of May 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account.
Here's the template: I need the help with section 2
I need the help with section 2
CASH ACCOUNT: Balance as of May 1 9,578.00 $5,255.89 CASH RECEIPTS FOR MONTH OF MAY DUPLICATE DEPOSIT TICKETS: Date adamount of each deposit in May: Date Amount Amount $580.70 600.10 701.26 May 23 $569.50 701.80 189.24 601.50 580.34 31 CHECKS WRITTEN Number and amount of each check issued in May Check No. Amount $309.50 Void Void 707.01 185.63 550.03 ec Amount ec Amount $243.50 329.90 882.80 1,081.56 62.40 310.08 503.30 279.90 395.50 435.40 238.87 Total amount of checks issued in May 8,342.01 PAGE 1 MEMBER FDIC ACCOUNT NUMBER FROM 5/01/2OY8 TO 5/31/20Y8 BALANCE AMERICAN NATIONAL BANK OF DETROIT DETROIT MI 48201-2500 (313)933-8547 9,422.80 6,086.35 20 WITHDRAWALS Rancho Foods 4 OTHER DEBITS AND CREDITS 3,650.00CR NEW BA LANCE 11,697.04 -CHECKS AND OTHER DEBITS---- DEPOSITS -DATE -BALANCE- No.612 No.580 310.10 No.602 85.50 No.614 243.5O No.615 350.10 No.616 279.90 No. 617 395.50 No.618 435.40 No 619 320.10 No.620 238.87 No 621 309.50 No.624 707.01 No 625 158.63 No.626 550.03 No 627 318.73 No.629 329.90 Na 630 882.80 No. 631 1,081.56 NSF 450.00 No 632 62.40 Na 633 310.08 9,801.00 10,041.50 10,113.30 10,101.64 10,123.37 13,108.86 12,558.20 12,509.67 10,095.31 10,424.09 11,155.54 11,757.04 11,697.04 92.50 780.80 569.50 05/03 05/06 819.24 580.70 MS 4,000.00 MS 160.00 600.10 05/13 05/20 701.26 05/24 05/28 05/31 601.50 SC 60.00 OD-OVERDRAFT PS- PAYMENT STOPPED 8C SERVICE CHARGE C ERROR CORRECTION NSFNOT SUFFICIENT FUNDS THE RECONCILEMENT OF THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELYStep 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