Data for ANNA, INC. are shown as follows: July 31 Aug 31 Cash account balance 20,640 48,540 Bank statement balance 107,060 137,820 8,200 12,880 27,700 30,100 Deposit in transit Outstanding checks Bank service charges for the month 720 600 NSF Checks returned by bank 4,300 8,240 Bank collections 72,240 80,900 Additional information: 1. Deposits and credit meros per bank statement, P249,100 2. Canceled checks and debit memos per bank statement. P218.340 3. Cash receipts per book, P172.880 4. Checks written per book, P211,900 REQUIRED (Excel of photo of computation) 1. PROOF OF CASH STATEMENT 2. Adjusting entries