I need help with worksheet
January DATE TRANSACTIONS Jan. 2 Purchased supplies for $14,000; issued Check 1015 2 Purchased a one-year insurance policy for $16,800 7 sold services for $30,000 in cash and $20,000 on credit during the first week of January 12 Collected a total of $8,000 on account from credit customers during the first week of January 12 Issued Check 1017 for $7,200 to pay for special promotional advertising to new businesses on the local radio station during the month 13 Collected a total of $9,000 on account from credit customers during the second week of January. 14 Returned supplies that were damaged for a cash refund of $1,500. 15 Sold services for $41, 400 in cash and $4,600 on credit during the second week of January. 20 Purchased supplies for $10,000 from white's, Inc. received Invoice 2384 payable in 30 days. 20 Sold services for $25,000 in cash and $7,000 on credit during the third week of January, 20 collected a total of $11,200 on account from credit customers during the third week of January. 21 Issued Check 1018 for $14, 130 to pay for maintenance work on the office equipment. 22 Issued Check 1019 for $7,200 to pay for special promotional advertising to new businesses in the local newspaper 23 Received the monthly telephone bill for $2,650 and paid it with Check 1020 26 Collected a total of $3,200 on account from credit customers during the fourth week of January 27 Issued Check 1021 for $6,000 to Office Plus as payment on account for Invoice 2223. 28 Sent Check 1822 for $5, 350 in payment of the monthly bill for utilities. 29 Sold services for $38, 080 in cash and $5,500 on credit during the fourth week of January. 31 Issued Checks 1023-1027 for $65, 600 to pay the monthly salaries of the regular employees and three part-time workers. 31 Issued Check 1028 for $24,000 for personal use. 31 Issued Check 1029 for $8,360 to pay for maintenance services for the month. 31 Purchased additional equipment for $30,000 from Contemporary Equipment Company, issued Check 1030 for $20,000 and bought the rest on credit. The equipment has a five-year life and no salvage value. 31 Sold services for $15,200 in cash and $3,240 on credit on January 31. ADJUSTMENTS 31 compute and record the adjustment for supplies used during the month. An inventory taken on January 31 showed supplies of $9, 400 on hand. 31 Compute and record the adjustment for expired insurance for the month 31 Record the adjustment for one month of expired rent of $4,000. 31 Record the adjustment for depreciation of $183 on the old equipment for the month. The first adjustment for depreciation for the new equipment will be recorded in February. Ranuirer. Checker Analyze: Answer the questions on the Analyse tab to compare the January 31 balance sheet you prepared with the December 31 balance sheet shown in E Complete this question by entering your answers in the tabs below. Ime Requirement General Ang General Joma and Closing Ledger Warnish Statement for a short storing Any Prepare the trial balance section of the worksheet. Then prepare the Adjustments section using the adjusting transactions. Now complete the worksheet ELIS CONSULTING SERVICES Worksheet Munth Ended January 31, 203 Trial Galance Account Name Autants Asted Balance Income Batement Debe Credit Debit Credit Debit Credit Det Cred Cash Accounts receivable Supplies - Prepaid inuice Prepaid rent Enument Accumulated depreciation Equipment Accounts payable Trayton El Capit The Twin Trial Account Name Debit Cash Accounts receivable Supplies Prepaid insurance Prepaid rent Equipment Accumulated depreciation-Equipment Accounts payable Trayton Eli, Capital Trayton Eli, Drawing Income summary Fees income Salaries expense Utilities expense Supplies expense Insurance expense Rent expense Depreciation expense-Equipment Advertising expense Telephone expense Maintenance expense Sub-totals Totale me Tawance Debt Credit Adjustments Debit Cred Asted Hace Crete De Credit Driin pment