On December 1, 2022, Windsor, Inc. had the following account balances. Cash Notes Receivable Accounts Receivable Inventory Prepaid Insurance Equipment Debit $18,500 2,300 7.400 16,400 1,700 27,700 $74,000 Accumulated Depreciation-Equipment Accounts Payable Common Stock Retained Earnings Credit $2.900 6,100 52,100 12.900 $74,000 During December, the company completed the following transactions, Dec. 7 12 17 19 22 Received $3,700 cash from customers in payment of account (no discount allowed). Purchased merchandise on account from Vance Co. $11.900, terms 1/10,n/30. Sold merchandise on account $15,900, terms 2/10, 1/30. The cost of the merchandise sold was $9,000. Paid salaries $2,100. Paid Vance Co. in full, less discount. Received collections in full, less discounts, from customers billed on December 17 Received $2,600 cash from customers in payment of account (no discount allowed). 26 31 The statement from Jackson County Bank on December 31 showed a balance of $26,651. A comparison of the bank statement with the Cash account revealed the following facts. The bank collected a note receivable of $2,300 for Windsor, Inc. 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 3. Checks outstanding on December 31 totaled $1,100. On December 31, the bank statement showed an NSF charge of $650 for a check received by the company from L. Bryan, a customer, on account. 1. 2. 4. Prepare a bank reconciliation as of December 31 based on the available information. (Hint: The cash balance per books is $26,501. This can be proven by finding the balance in the Cash account from parts (a) and (b)) (List items that increase cash balance first. Reconcile cash balance per bank first.) Windsor, Inc. Bank Reconciliation