Music-Is Us, Inc., is a supplier of musical instruments for professional and amateur musicians. The company's accountants make adjusting entries monthly, and they make all closing entries annually. The company is growing rapidly and prides itself on having no long-term liabilities. The company has provided the following trial balance dated December 31, 2021 MUSIC-IS-US, INC. TRIAL BALANCE DECEMBER 31, 2021 Cash at bank 46,000 Marketable securities 33,000 Accounts receivable 126,000 Allowance for doubtful accounts $ 5,380 Merchandise inventory 259,000 Office supplies 1,500 Prepaid insurance 7,040 Building and fixtures 1,791,000 Accumulated depreciation 797,000 Land 72,800 Accounts payable 66,000 Unearned customer deposits 7,800 Income taxes payable 70,000 Capital stock 939,800 Retained earnings 239,200 Unrealized holding gain on investments 5,100 Sales 1,690,980 Cost of goods sold 952,000 Bank service charges 240 Uncollectible accounts experise 8,700 Salary and wages expense 387,000 300 Office supplies expense Insurance expense 5,400 Utilities expense 3,400 Prepare a bank reconciliation to update the accounting records of Music is Us as of December 31, 2021. MUSIC-IS-US, INC. Bank Reconciliation December 31, 2021 Adjusted cash balance Adjusted cash balance 1. The most recent bank statement reports a balance of $48,770. Included with the bank statement was a $2.100 check from Iggy Smarts, a professional musician, charged back to Music-Is-Us as NSF. The bank's monthly service charge was $30. Three checks written by Music-Is-Us to suppliers of merchandise inventory had not yet cleared the bank for payment as of the statement date. These checks included: no. 508. $3.700: no. 511, $9,200; and no. 521. $8,400. Deposits of $16.400 reached the bank too late for inclusion in the current bank statement. The company prepares a bank reconciliation at the end of each month. 2. Music-Is-Us has a portfolio of marketable securities that originally cost $27.000. As of December 31. the market value of these securities was $35,100. All short-term investments are classified as "available for sale. 3. During December, $5,900 of accounts receivable were written off as uncollectible. A recent aging of the company's accounts receivable led management to conclude that an allowance for doubtful accounts of $8,300 is needed at December 31, 2021. 4. The company uses a perpetual Inventory system. A year-end physical count revealed that several guitars reported in the inventory records were missing. The cost of the missing units amounted to $1,400. This amount is not considered significant relative to the total cost of inventory on hand. 5. At December 31, approximately $900 in office supplies remained on hand. 6. The company pays for its insurance policies 12 months in advance. Its most recent payment was made on November 1, 2021. The cost of this policy was slightly higher than the cost of coverage for the previous 12 months 7. Depreciation expense related to the company's building and fixtures is $4,000 for the month ending December 31, 2021. 8. Although Music-Is-Us carries an extensive inventory, it is not uncommon for experienced musicians to order custom guitars made to their exact specifications. Manufacturers do not allow any sales retums of custom-made guitars. The entire sales amount is collected at the time a custom order is placed, and is credited to an account entitled "Unearned Customer Deposits." As of December 31, $4,600 of these deposits remained unfilled because the special-order guitars have not been received from the manufacturer. The cost of goods sold and the reduction in inventory associated with all custom orders is recorded when the custom merchandise is delivered to customers. At that time, the adjusting entry requires only a decrease to unearned customer deposits and an increase in sales. 9. Accrued income taxes payable for the entire year ending December 31, 2021, total $81.000. No income tax payments are due until early in 2022