The statement from Lyon County Bank on December 31 showed a balance of $24,673. A comparison of the bank statement with the Cash account revealed the following facts. 1 2 The bank collected the $2,300 note receivable for Sandhill Co. on December 15 through electronic funds transfer. The December 31 receipts were deposited in a night deposit vault on December 31. These deposits were recorded by the bank in January Checks outstanding on December 31 totaled $1.230. On December 31, the bank statement showed a NSF charge of $770 for a check received by the company from M. Lawrence, a customer, on account 3. 4. Prepare a bank reconciliation as of December 31 based on the available information.(Hint: The cash balance per books is $24.653 This can be proven by finding the balance in the Cash account from parts (a) and (b)) (List items that increase balance as per bank & books first.) Question 1 of 1 SANDHILL CO. Bank Reconciliation December 31, 2022 Cash Balance per Bank Statement : $ 24673 Add : Deposits in Transit 2460 27133 Less : Outstanding Checks . 1230 Adjusted Cash Balance per Bank $ Cash Balance per Books $ 24653 Add Electric funds transfer received 2300 25953 Less : NSF Check 770i Adjusted Cash Balance per Books $ 25133