Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after bankang hours. The data required to reconcile the bank state 31, 20Y0, 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 payments on account. CASH ACCOUNT: Balance as of July 1 CASH RECEIPTS FOR MONTH OF JULY $9,580.006,467.42 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in July: CHECKS WRITIEN: Number and amount of each check issued in July: MEMBER FDIC AMERICAN NATIONAL BANK OF DETROIT DETROIT, MI 482012500 (313) 933-8547 ACCOUNT NUMBER FROM 7/01/20Y0 BALANCE 9 DEPOSITS 20 WITHDRAWALS SUNSHINE INTERIORS 4 OTHER DEBITS AND CREDITS NEW BALANCE PAGE 1 TO 7/31/20 Yo 9,424,70 6,106.35 7,656.74 3,749.00CR 11,623.31 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & CHECK & AND OTH & R DEBIIS & & DEPOSIIS & DATE & BALANCE \\ \hline No. 580 & 310.10 & No, 612 & 92.50 & & 780.80 & 07/01 & 9,802.90 \\ \hline No. 602 & 85.50 & No. 614 & 243.50 & & 569.50 & 07/03 & 10,043,40 \\ \hline No. 615 & 350.10 & No. 616 & 279.90 & & 701.80 & 07/06 & 10,115.20 \\ \hline No. 617 & 395.50 & No. 618 & 435.40 & & 819.24 & 07/11 & 10,103.54 \\ \hline No. 619 & 320.10 & No. 620 & 238.87 & & 580.70 & 07/13 & 10,125.27 \\ \hline No. 621 & 309.50 & No. 624 & 707.01 & & MS 4,000.00 & 07/14 & 13,108.76 \\ \hline No. 625 & 158.63 & No. 626 & 55/203 & & MS 160.00 & 07/14 & 12,560.10 \\ \hline No. 627 & 318.73 & No. 629 & 329.90 & & 600.10 & 07/17 & 12,511.57 \\ \hline No. 630 & 882.80 & No, 631 & 1,081.56 & NSF 375.00 & & 07/20 & 10,172.21 \\ \hline No. 632 & 325.40 & No. 634 & 241.71 & & 701.26 & 07/21 & 10,306.36 \\ \hline & & & & & 751.45 & 07/24 & 11,057.81 \\ \hline \end{tabular} BANK RECONCILIATION FOR PRECEDING MONTH: ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEOIATHY. Required: 1. Prepare a bank reconcliation as of July 31, 20Y0, If eirors in recording deposits or checks are discovered, assurne that the erron were mode by the company Ansume that all deposits are froen cash sales. All check are wruten to satisfy accounts payable. When required, enker amounts in dollars and cents. rotar amount of checks issued in July BANK RECONCILIATION FOR PRECEDING MONTH