See the following two pages for the bank and book data for Gammage, Ladjadj & Serenini Engineering, Inc. 1. Prepare a properly formatted bank reconciliation workpaper showing both the Adjusted Books and Adjusted Bank reconciliation. 2. Prepare the AJE required based upon your completed bank reconciliation. 3. Prepare a proof of cash Taccount based upon your completed bank reconciliation. The prior month's Bank Reconcilation is here: Gammage, Ladjadj & Serenini Englingeering, Inc. Bank Reconciliation August 31, 2019 Cash balance per bank 8-31-2019 Add: Depostis in transit 40,650.00 2,700.00 43,350.00 Check 6761 $ Less: Outstanding Checks Amount 6770 6771 2,000.00 1,720.10 500.00 6772 1426.80 1,150.00 6,796.90 6774 (6,796.90) Adjusted cash balance per bank 8-31-2019 36,553.10 The adjusted cash balance per bank agreed with the cash balance per books at August 31, 2019. Cash Receipts Journal: Date September 3 September 7 September 14 September 21 September 25 September 28 September 29 September 30 Cash Payment Journal: Check Date September 1 September 2 September 2 September 4 September 8 September 10 September 12 September 20 September 21 September 22 September 23 September 24 September 25 Armount Amount %2$ 1,640.70 1,300.00 6775 3,776.00 6776 4,000.00 14,000.00 2,130.00 2,600.00 3,080.00 1,040.00 1,600.10 475.50 6777 6778 6779 6780 6781 2,945.00 2,567.30 27,525.10 10,556.15 6782 14,500.67 6783 1,140.00 79,870.22 798.00 540.80 900.00 2,016.00 6784 6785 6786 6787 19,261.10 Additional Information: 1 At September 30, 2019 the unadjusted cash per books was: $97,162.22. 2 Note: There were no errors made by the bank or on the books. 3 Hint regarding the adjusting journal entries. You must record the "credit memos" and the bank fees in order to reconcile the books and get them to match the bank reconciliations. Prepare a cash Taccount analysis to check your work. The work you turn in must be handwritten. No spreadsheets. Bank of Sparta Acco Account Statement Account Number 123456789 Gammage, Ladjadj & Serenini Engineering, Inc. s00 South Market Street San Jose, CA 95110 Stmt for the Month ended: September 30, 201s Bank Balance 8-31-2019: Deposits & Credits: Checks & Debits: $ 74,227.10 Bank Balance 9-30-2019: $ 99,588.30 $ 40,650.00 $ 15,288.80 Checks: September 1 September 2 September 7 September 4 September 8 September 10 September 15 September 27 September 30 September 29 September 30 Deposits and Credits: September 1 September 4 September 8 September 16 September 22 September 26 September 29 September 30 $ 2,000.00 500.00 6761 2,700.00 3,776.00 4,000.00 14,000.00 2,945.00 2,567.30 27,525.10 6771 6772 1,426.80 1,640.70 6775 6776 1,300.00 6777 6779 6780 2,130.00 3,080.00 1,040.00 475.50 10,556.15 68,069.55 6782 6783 1,140.00 540.80 $ 15,273.80 Credit memo: Collection of note $6,150.00 Credit Memo: Interest Income earned this month $7.55 6785 Amount Deducted from account: Bank Fees $15.00 Thank you for banking at Bank of Sparta nk of Sparta lamember of the FOIC