I need to create a general journal and spreadsheet!

Basket Corner UNADJUSTED TRIAL BALANCE December 31, 20-- ACCOUNT TITLE DEBIT CREDIT 1 Cash 24,000.00 2 Accounts Receivable 16,800.00 3 Merchandise Inventory 90,000.00 4 Estimated Returns Inventory 3,840.00 5 Supplies 9,600.00 6 Prepaid Insurance 6,480.00 7 Land 156,000.00 300,000.00 8 Building 9 Accumulated Depreciation-Building 10 Store Equipment 120,000.00 120,000.00 11 Accumulated Depreciation-Store Equipment 48,000.00 Instructions 12 Accounts Payable 11.520.00 4,200.00 15 Customer Refunds Payable 14 Wages Payable 15 Sales Tax Payable 7,080.00 10,680.00 16 Unearned Rent Revenue 341.172.00 17 L Palermo, Capital 18 L Palermo, Drawing 19 Income Summary 31,200.00 20 Sales 630.168.00 21 Sales Returns and Allowances 17,400.00 12 Rent Revenue 23 Purchases 150,000.00 24 Purchases Returns and Allowances 1,680.00 75 Purchases Discounts 2.160.00 26 Freight-in 2,520.00 150,000.00 15,600.00 27 Wages Expense 28 Advertising Expense 29 Supplies Expense 30 Phone Expense 1.620.00 31 Utilities Expense 9,600.00 32 Insurance Expense 33 Depreciation Expense-Building 34 Depreciation Expense-Store Equipment 35 Rent Expense 72,000.00 36 Totals 1,176,660.00 1,176,660.00 Instructions Year-end adjustment information is provided below (a, b) D A physical count shows that merchandise inventory costing $102,000 as on hand as of December 31, 20- (c. d, e) Palermo estimates that customers will be granted 56,840 in refunds or mis year's sales next year and the merchandise expected to be returned will have a cost of 55,160 Supplies remaining at the end of the year, $3,960 (a) Unexpired insurance on December 31,54,560, th) Depreciation expense on the building for 20- $15,000 0 Depreciation expense on the store equipment for 20- 55,000 0) Unearned rent revenue as of December 31, 85,400 Wages earned but not paid as of December 31, 54,200 Required: 1 Complete the Adjustments columns 2 Complete the spreadsheet 3. Enter the adjustments in a general jouma! GENERAL JOURNAL Score: 110/276 DATE ACCOUNT TITLE POST. REF. DEBIT CREDIT 1 2 3 90,000.00 4 Adjusting Entries Income Summary Merchandise Inventory Merchandise Inventory Income Summary Supplies Expense Supplies Insurance Expense > 5 5 1 9 10 11 13 14 Prepaid Insurance Depreciation Expense Building Accumulated Depreciation Building Depreciation Expense-Building Accumulated Depreciation Store Equipment Unearned Rent Revenue Rent Expense Wages Expense Wages Payable Freight-In Land 15 16 17 18 19 20 Rent Expense ddd 21 22 Utilities Expense Advertising Expense Corner ST325 End of Period Spreadsheet For the Year End December 31, 20 TRIAL BALANCE TRIAL BALANCE ADRUSTMENTS ADJUSTMENTS ACCOUNT TITLE AIUSTED TRIAL BALANCE DERIT ADRUSTED TRIAL BALANCE EDIT CREDIT DEBIT CREDIT 24,000.00 16.000 Ch Accomowable Merchandise Inventory Estimated Returns intory Supplies Prepaid Insurance DEBIT 24,000.00 16.800,00 10.000.00 3.840.00 9.600.00 6480,00 0.000.00 40.00 156.000.00 156,000.00 300,000.00 Building Accumulated Depreciation Building 300,000.00 120,000.00 LOGO 11.520.00 400.00 Steel Accounts Payable Cantorefund Pulle Waste Sales Tax Puy de named fint Roma LPm Capital 20 L.Paleme Dwi Alcome Suary TODO 10.480.00 141.172.00 31,200.00 650.168.00 2 Sales 1740000 Sites Beans and Allowances * Rever Purchases Purchases fans and Allowances 150,000.00 1690.00 Spreadsheet ww 2.16000 2.500 10.000.00 15.00 160.00 00.00 1 Wapers Adlwyti Supplies Phone Experts Units Expense Insurance Depreciation Expense-Building Depreciation ExperStore Equipment Rent Experts 72.000.00 $1.176.60.00 $1.176.60.00 Net Income