Need help preparing into an adjusted trial balance

2 3 Unadjusted Trial Balance At December 31, 2019 Credit $ Debit $ 40,400 234,800 226,000 175,000 110,000 138,200 25,300 7,500 200,000 250,000 198,450 5 5 7 Cash 3 Accounts receivable 9 Inventory 10 Equipment 11 Acc. Depreciation - equipment 12 Accounts payable 13 Unearned revenue 14 Income tax payable 15 Bank loan payable 6% 16 Common shares 17 Retained earnings 18 Dividends declared 19 Sales Revenues 20 Sales returns and allowances 21 Cost of good sold 22 Interest expense 23 Miscellaneous expense 24 Insurance expense 25 Property tax expense 26 Shipping expense 27 Income tax payable 28 Supplies expense 29 Rent expense 30 Salaries expense 31 Advertising expense 32 Utilities expense 33 34 80,000 788,350 12,500 389,600 11,000 18,300 36,000 32,800 42,000 22,500 22,300 120,000 204,000 16,800 33,800 1,717,800 1,717,800 25 f. Depreciation on the equipment is $25,000 for the year. I g. In late December the company accountant discovered that a cash payment to a supplier of $12,500 on November 28th was accounted for as follows Cash 1,250 Accounts Payable 1,250. No further entries have been made. h. The company supplied goods for $17,000 in December for which down payments from customers were received in November and recorded as unearned revenue. The Cost of Goods Sold has been correctly recorded. i. Interest for one month (December 2018) on the Bank Loan Payable should be accrued. j. It has been decided that an Allowance for Doubtful Accounts should be provided for 3% of Accounts Receivable (rounded to the nearest $100) at December 31, 2018. Focus - 6 a. The insurance expense relates to a 12-month policy purchased on April 1, 2018 and paid for in cash. b. On December 27, 2018 Shutter Bugs Ltd. purchased merchandise inventory for $13,500, terms 2/10 n/30, FOB destination. The merchandise was shipped on December 30 and was received by Shutter Bugs Ltd. on January 3, 2019. They recorded the purchase on December 27, 2018. The company uses a perpetual inventory system. C. Supplies costing $3,500 remained unused at December 31, 2018. d. During the physical inventory count a number of damaged items were found meaning that the net realizable value of inventory at year end is $206,000. e. The utilities bill for December 2018 was $4,100. Since the bill was received during the Christmas break, it will be paid and recorded in January 2019