Question: please help me check my work, super confused, what sure what to put in income statement and balance sheet on the worksheet and not sure









Services To $2,200 All Cast anu 35,240 un 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. Required: 1. General Ledger tab: Enter the account balances for January 1, 20X2 from the postclosing trial balance prepared on December 31, 20X1, which appears in Figure 6.3. 2. General Journal tab: Analyze each of the transactions listed for January and record it in the general journal. 3. General Ledger tab: Post the transactions to the general ledger accounts. 4. Worksheet tab: Prepare the Trial Balance section of the worksheet. 5. Worksheet tab: Prepare the Adjustments section of the worksheet using the adjusting transactions. 6. Worksheet tab: Complete the worksheet. 7. Income Statement tab: Prepare an income statement for the month. 8. Stmt of OE tab: Prepare a statement of owner's equity. 9. Balance Sheet tab: Prepare a balance sheet. 10. Adjusting and Closing tab: Record the adjusting entries and the closing entries in the general journal. 11. General Ledger tab: Post the adjusting entries and the closing entries to the general ledger accounts. 12. Post Closing tab: Prepare a postclosing trial balance. Check my work TE TRANSACTIONS 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 1817 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,eee 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,050 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 1022 for $5,350 in payment of the monthly bill for utilities. 29 Sold services for $38,000 in cash and $5,500 on credit during the fourth week of January. 31 Issued Checks 1923-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,300 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,20e in cash and $3,240 on credit on January 31. ces This project will give you an opportunity to apply your knowledge of accounting principles and procedures by handling all t accounting work of Ell's Consulting Services for the month of January 20X2 Assume that you are the chief accountant for Eli's Consulting Services. During January, the business will use the same types of records and procedures that you learned about in Chapters 1 through 6. The chart of accounts for Ell's Consulting Services has been expanded to include a few new accounts. Follow the instructions on the Requirements tab to complete the accounting records for the month of 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. 28 Purchased supplies for $10,eee from white's, Inc.; received Invoice 2354 payable in 30 days. 20 Sold services for $25,000 in cash and $7,000 on credit during the third week of January. 28 Collected a total of $11,200 on account from credit customers during the third week of January.. 21 Issued Check 1018 for $14,138 to pay for maintenance work on the office equipment. 22 Issued Check 1919 for $7 209 to nay for special promotional advertising to new businesses in the local newsnanar Project i Saved Check my work mode: This shows what is correct or incorrect for the work ya 1 Accumulated Depreciation- Account No. 142 Accor Equipment Date Debit Jan. 31, 20X2 5 Dints Trayton Eli, Capital Date Jan. 31, 20X2 Jan. 31, 20X2 183 Debit 24,000 Credit 183 Account No. 301 Credit Balance 128,667 60,427 (183) 0 Balance 128,667 104,667 165,094 Date Jan. 27, 20X2 Trayton E Date Jan. 31, 20X2 orrect or incorrect for the work you have completed so far. It does not indicate completion. Return to question Month Ended January 31, 20X2 Trial Balance Adjustments Debit Credit 103,220 X 13,940 X 23,500 16,800 X 4,000 X $ Debit 111,350 X 5,000 X 1,000 4,000 11,000x Credit 183 3,500 128,667 $ 41,000 24,000 183 17,500 128,667 189,940 Adjusted Trial Balance Debit Credit $ 103,220 13,940 9,400 15,400 41,000 366 17,500 128,667 24,000 189,940 hat is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question 120,007 120,00% 120,007 24,000 X 24,000 189,940 X 189,940 65,600 65,600 5,350 5,350 14,100 4,000 183 Ent 14,400 14,400 X 22,430 22,430 x 2,050 2,050 x 1,400 $ 336,290 $ $336,473 $ 132,350 $ 132,350 336,290 $ 336,473 $ en djusted Trial Balance Debit Credit 103,220 13,940 9,400 15,400 41,000 24,000 366 17,500 128,667 Income Statement Debit Credit Balance Sheet Debit Credit ELI'S CONSULTING SERVICES Balance Sheet January 31, 20X2 Assets Cash Accounts receivable Supplies Prepaid rent Equipment Less: Accumulated depreciation-Equipment Total assets Liabilities and Owner's Equity Liabilities Accounts payable Prev 41,000 183 x $ 103,220 13,940 9,400 4,000 X 40,817 $ 171,377 $ 17,500 1 of 1 Next ELI'S CONSULTING SERVICES Postclosing Trial Balance January 31, 20X2 Account Name Cash Accounts receivable Supplies Prepaid insurance Prepaid rent Equipment Accumulated depreciation Equipment Accounts payable Trayton Eli, Capital Debit 9,400
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
