do it in Excel file .plz
You should do this homework in an Excel file so you can use the formula functions. I would recommend using multiple tabs/sheets to make it easier for your input. a.) Journalize and post the July transactions. Use page Jl for the journal. For the ledger, you can use T-accounts or standard account form (your choice) b.) Prepare a trial balance at July 31. c.) Journalize and post adjusting entries using the information below (a-e). Use page J2 for journal. a. Unbilled and uncollected revenue for services performed at July 31 were $2,700. b. Depreciation on equipment for the month was $500 c. One-twelfth of the insurance expired d. An inventory count shows $600 of cleaning supplies on hand at July 31. e. Accrued but unpaid employee salaries were $1,000. d.) Prepare adjusted trial balance at July 31. e.) Prepare the income statement and owner's equity statement for July and a classified balance sheet at July 31. f.) Journalize and post closing entries and complete the closing process. Use page J3 for the journal. g.) Prepare a post-closing trial balance at July 31. Complete all steps in accounting cycle. (LO 1, 2, 4) P4-5A Anya Clark opened Anya's Cleaning Service on July 1, 2017. During July, the following transactions were completed. July GLS 1 1 3 5 12 18 Anya invested $20,000 cash in the business. Purchased used truck for $12,000, paying $4,000 cash and the balance on account. Purchased cleaning supplies for $2.100 on account. Paid $1,800 cash on a 1-year insurance policy effective July 1. Billed customers $4,500 for cleaning services. Paid $1.500 cash on amount owed on truck and $1,400 on amount owed on cleaning supplies. Paid $2,800 cash for employee salaries. Collected $3,400 cash from customers billed on July 12. Billed customers $6,000 for cleaning services. Paid $350 for the monthly gasoline bill for the truck. Withdraw $5,600 cash for personal use. 20 21 25 31 31 (b) Trial balance 537,700 (c) Adjusted trial balance 541,900 The chart of accounts for Anya's Cleaning Service contains the following accounts: No. 101 Cash, No. 112 Accounts Receivable, No. 126 Supplies, No. 130 Prepaid Insurance, No. 157 Equipment, No. 158 Accumulated Depreciation Equipment, No. 201 Accounts Pay- able, No. 212 Salaries and Wages Payable, No. 301 Owner's Capital, No. 306 Owner's Drawings, No. 350 Income Summary, No. 400 Service Revenue, No. 631 Supplies Expense, No. 633 Gasoline Expense, No. 711 Depreciation Expense, No. 722 Insurance Expense, and No. 726 Salaries and Wages Expense. Instructions (a) Journalize and post the July transactions. Use page Jl for the journal and the three- column form of account. (b) Prepare a trial balance at July 31 on a worksheet. (c) Enter the following adjustments on the worksheet and complete the worksheet. (1) Unbilled and uncollected revenue for services performed at July 31 were $2,700. (2) Depreciation on equipment for the month was $500 (3) One-twelfth of the insurance expired. (4) An inventory count shows $600 of cleaning supplies on hand at July 31. (5) Accrued but unpaid employee salaries were $1,000 (d) Prepare the income statement and owner's equity statement for July and a classified balance sheet at July 31. (e) Journalize and post adjusting entries. Use page J2 for the journal. (1) Journalive and post closing entries and complete the closing process. Use pageJ3 for the journal. (9) Prepare a post-closing trial balance at July 31. comployee salarning supplies (d) Net income 56,900 Total assets 529,500 hole the income (g) Post-closing trial balance 530,000
