Question: I believe I know how to do steps 1-5 but I need help with steps 6-11. The Case: George Sullivan opened Sullys Landscaping, Inc. on
I believe I know how to do steps 1-5 but I need help with steps 6-11.
The Case: George Sullivan opened Sullys Landscaping, Inc. on July 1, 2022. During July, the following transactions were completed.
July 1 Issued 12,000 shares of common stock for $12,000 cash.
1 Purchased used truck for $8,000, paying $2,000 cash and the balance on account.
3 Purchased landscaping supplies for $900 on account.
5 Paid $1,800 cash on a 1year insurance policy effective July 1.
12 Billed customers $3,700 for landscaping services performed.
18 Paid $1,000 cash on amount owed on truck and $500 on amount owed on landscaping supplies.
20 Paid $2,000 cash for employee salaries.
21 Collected $1,600 cash from customers billed on July 12.
25 Billed customers $2,500 for landscaping services performed.
31 Paid $290 for maintenance of the truck during month.
31 Declared and paid $600 cash dividend.
The chart of accounts for Sullys Landscaping, Inc. contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated DepreciationEquipment, Accounts Payable, Salaries and Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Maintenance and Repairs Expense, Supplies Expense, Depreciation Expense, Insurance Expense, and Salaries and Wages Expense. Instructions: Use the enclosed Excel template to complete the July monthly accounting cycle for Sullys Landscaping. The lines and t-accounts provided in the template are not an indication of how many you will need. Add or delete as necessary.
Step 1 - Journalize the July transactions (Excel Tab 1)
Step 2 - Post to the general ledger accounts (T-Accounts) and determine unadjusted ending balances for each account (Excel Tab 2)
Step 3 - Prepare an unadjusted trial balance at July 31. (Excel Tab 3)
Step 4 - Journalize the following adjustments. (Excel Tab 4) (1) Services performed but unbilled and uncollected at July 31 were $1,700. (2) Depreciation on equipment for the month was $180. (3) Onetwelfth of the insurance expired. (4) A count shows $320 of landscaping supplies on hand at July 31. (5) Accrued but unpaid employee salaries were $400.
Step 5 - Enter the unadjusted balances from the unadjusted trial balance (Excel Tab 3) as beginning balances in the Updated GL (Excel Tab 5).
Step 6 - Post adjusting entries to the updated general ledger and determine the ending adjusted balances for each account. (Excel Tab 5)
Step 7 - Prepare an adjusted trial balance (Excel Tab 6) from the Updated GL.
Step 8 - Prepare the income statement and a statement of stockholders equity for the month of July and a classified balance sheet as of July 31 (Excel Tab 7)
Step 9 - Journalize the closing entries (Excel Tab 8)
Step 10 - Post closing entries from Step 9 to the Updated GL (Excel Tab 5) and recompute ending balances.
Step 11 - Prepare a postclosing trial balance as of July 31 (Excel Tab 9)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
