Proof of Cash-Sherman School District You are currently performing an audit of the Sherman School District and the Engagement Partner assigned you the task of performing the October 2020 Proof of Cash You have obtained the following information: o Balance per Bank, September 30 = $6,915 o Balance per Bank, October 31 = $8,276 o Outstanding checks at September 30 - $1,811 o Outstanding checks at October 31 = $2,615 o Cash Deposits for October Bank = $28,792 o Cash Deposits for October Book = $? (You have to calculate) o Deposit in Transit, September = $5,621 o Deposit in Transit, October = $996 o Checks & Charges, per Bank = $27,431 Checks & Charges, per book = $? (You have to calculate) o Interest on bank loan for the month of October, charged by the bank in October but not entered on Books until November, $596. Sherman School District is paying the interest to the bank. o Proceeds of a note of Jones Company was collected by the bank on October 26th, but not entered on the books until November, $3,296. This was an increase in cash. o On October 24th, a $1,144 check of Billings Company was charged to the Sherman School District's account in error (Bank pulled $1,144 from Sherman's account in error) - Bank notified and corrected error in November o NSF checks are not recorded on the books unless they permanently fail to clear the bank. The bank treats them as disbursements when dishonored and deposits when they are redeposited. Checks totaling $1,335 were dishonored in October; $600 were re-deposited and cleared on October and $735 were re-deposited and cleared in November. REQUIRED: Prepare the four-column proof of cash on the next page Sherman School District - Proof of Cash - October 31, 200X October Activity Balance 9/30/0x Deposits Balance per Bank Statement 69151 28,702 Deposit In Transit At 9/30/0x 5621 #5 (5621\#6 994 #8 Checks & Charges Balance 10/31/0x 274431 18,274 #7 #9 994 At 10/31/0x Outstanding Checks At 9/30/0x At 10/31/0x Interest on Bank Loan (1810 #11 #12 #13 #14 #15 #16 Proceeds from Jones Note #17 # 18 Check error #19 #20 NSF Check Activity #21 #22 #23 Balance per Book #24 #25 #26 #27 Question = Number