pdat

Correction ***

The total debits on the adjusted trail balance is $482,020 and the total liabilitieson the balance sheet should be $88,270.

Please show on excel.

Smith Company manufactures and sells widgets to the baggers industry. The unadjusted trial balance as of December 31, 2017, is shown below. The company operates under a calendar fiscal year and uses the perpetual inventory system Account Debits Credits $ 17,920.00 Cash Accounts receivable Supplies Prepaid rent Prepaid insurance Inventory Equipment Accumulated depreciation Accounts payable Wages payable Interest payable Note payable Common stock Retained earnings Sales revenue Cost of goods sold Interest expense Wage expense Rent expense Insurance expense Supplies expense Utility expense Bank charges Depreciation expense 42,350.00 107,500.00 90,000.00 $ 27,000.00 37,518.00 4,280.00 5,000.00 84,000.00 42,500.00 231,250.00 42,990.00 31,250.00 24,000.00 6,700.00 4,650.00 4,188.00 Totals $471.548,00$471.548.00 Smith Company accountants have not completed the bank reconciliation for the year ended December 31, 2017. As of that date, the statement from Bank of the South showed a balance of $19,867.00. Additional information regarding bank account activity includes the following: 1) Outstanding checks were $3,125.00; 2) Deposit recorded on the books as of December 31 2017 of $375.00 did not clear the bank records until January 2, 2018; 3) One check in payment of insurance was correctly recorded by the bank in the amount of $517.00, but was recorded by Smith Company, and charged to Insurance Expense properly, as $571.00; 4) The bank recorded a withdrawal, previously