Please complete this assignment into the excel template that attach with

Kristin Malone opened Kristin's Maids Cleaning Service on July 1, 2017. During July, the company completed the following transactions.July?1Stockholders invested $14,000 cash in the business in exchange for common stock.1Purchased a used truck for $10,000, paying $3,000 cash and the balance on account.3Purchased cleaning supplies for $800 on account.5Paid $1,800 on a 1-year insurance policy, effective July 1.12Billed customers $3,800 for cleaning services.18Paid $1,000 of amount owed on truck, and $400 of amount owed on cleaning supplies.20Paid $1,600 for employee salaries.21Collected $1,400 from customers billed on July 12.25Billed customers $1,500 for cleaning services.31Paid gasoline for the month on the truck, $400.31Declared and paid a $600 cash dividend.

The chart of accounts for Kristin's Maids 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 Payable, No. 212 Salaries and Wages Payable, No. 311 Common Stock, No. 320 Retained Earnings, No. 332 Dividends, 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 J1 for the journal.

(b)Prepare a trial balance at July 31 on a worksheet.

(b) Trial balance $25,700

• (c)Enter the following adjustments on the worksheet, and complete the worksheet.Unbilled fees for services performed at July 31 were $1,300.
• Depreciation on equipment for the month was $200.
• One-twelfth of the insurance expired.
• An inventory count shows $100 of cleaning supplies on hand at July 31.
• Accrued but unpaid employee salaries were $500.

(d)Prepare an income statement and a retained earnings statement for July, and a classified balance sheet at July 31, 2017.

(d) Net income $3,050

Total assets $23,350

(e)Journalize and post the adjusting entries. Use page J2 for the journal.

(f)Journalize and post the closing entries, and complete the closing process. Use page J3 for the journal.

(g)Prepare a post-closing trial balance at July 31.

(g) Post-closing trial balance $23,550

ACCT 111 Comprehensive Problem: Chapters 2 to 4 Name PART A Date 2017 July ________________________________ PART C/E (ADD ADJUSTMENTS) PART F (ADD CLOSING ENTRIES) GENERAL JOURNAL Page J1 Accounting Titles and Explanation Ref. Debit Credit Cash Date Supplies Date Equipment Date Date GENERAL JOURNAL Accounting Titles and Explanation Ref. Debit Page J2 Credit Accounts Payable Date Common Stock Date Date GENERAL JOURNAL Accounting Titles and Explanation Ref. Debit Page J3 Credit Dividends Date Service Revenue Date Gasoline Expense Date Insurance Expense Date Cash PARTS B, C/E (ADD ADJUSTMENTS), F (ADD CLOSING ENTRIES) GENERAL LEDGER No. 101 Accounts Receivable Explanation Ref. Debit Credit Balance Date Explanation Supplies Explanation Equipment Explanation Ref. Ref. Debit Debit Credit No.126 Balance Credit No.157 Balance Prepaid Insurance Date Explanation Accumulated Depreciation-Equipment Date Explanation Accounts Payable Explanation Common Stock Explanation Dividends Explanation Ref. Ref. Ref. No.201 Balance Salaries and Wages Payable Date Explanation Debit Credit Debit No.311 Credit Balance Retained Earnings Date Explanation Debit No.332 Credit Balance Income Summary Date Explanation Service Revenue Explanation Gasoline Expense Explanation Insurance Expense Explanation Ref. Ref. Ref. Debit Debit Debit Credit No.400 Balance Supplies Expense Date Explanation Credit No.633 Balance Depreciation Expense Date Explanation Credit No.722 Balance Salaries and Wages Expense Date Explanation PART B No. eivable Ref. No.112 Balance Debit Credit Debit No. 130 Credit Balance Depreciation-Equipment Ref. Debit No. 158 Balance surance Ref. Credit Wages Payable Ref. Debit Credit No. 212 Balance Credit No. 320 Balance Credit No. 350 Balance nings Ref. Debit mary Ref. Debit Expense Ref. Debit No. 631 Credit Balance Debit Credit No. 711 Balance Credit No. 726 Balance Expense Ref. Wages Expense Ref. Debit Kristen's Maids Cleaning Service Trial Balance July 31, 2017 Account Titles PART C/E Debit Credit No. Kristen's Maids Cleaning Service Adjusted Trial Balance July 31, 2017 Account Titles Kristen's Maids Cleaning Service Income Statement PART D For the Month ended July 31, 2017 Debit Credit Revenues: Expenses: aids Cleaning Service me Statement th ended July 31, 2017 Kristen's Maids Cleaning Service Retained Earnings Statement PART D For the Month ended July 31, 2017 Retained Earnings, July 1, 2007 PART D Kristen's Maids Cleaning Serv Balance Sheet July 31, 2017 Kristen's Maids Cleaning Service Balance Sheet July 31, 2017 Assets PART G Kristen's Maids Cleaning Service Post-Closing Trial Balance July 31, 2017 No. Account Titles Debit Credit ACCT 111 Comprehensive Problem: Chapters 2 to 4 Name PART A Date 1-Jul ________________________________ PART C/E (ADD ADJUSTMENTS) PART F (ADD CLOSING ENTRIES) GENERAL JOURNAL Page J1 Accounting Titles and Explanation Ref. Debit Credit Cash $14,000 Common Stock $14,000 1-Jul Equipment Cash Accounts Payable $10,000 3-Jul Supplies Accounts Payable $800 5-Jul Prepaid Insurance Cash $3,000 $7,000 $800 $1,800 $1,800 12-Jul Accounts Receivable Service Revenue $3,800 18-Jul Accounts Payable Cash $1,400 20-Jul Salaries Expense Cash $1,600 21-Jul Cash $1,400 $3,800 Supplies Date 3-Jul 31-Jul $1,400 $1,600 Accounts Receivable 25-Jul Accounts Receivable Service Revenue Cash Date Jul-17 1-Jul 5-Jul 18-Jul 20-Jul 25-Jul 31-Jul 31-Jul $1,400 $1,500 $1,500 31-Jul Gasoline Expense Cash $400 31-Jul Dividends Cash $600 $400 $600 Equipment Date 1-Jul 1-Jul GENERAL JOURNAL Date Accounting Titles and Explanation 31-Jul Accounts Receivable Service Revenue Ref. Debit $1,300 $1,300 31-Jul Depreciation Expense -Equipment Accummulated Depre-Equipment $200 31-Jul Insurance Expense Prepaid Insurance $150 31-Jul Supplies Expense Supplies $700 31-Jul Salaries and Wages Expense Salaries and Wages Payable $500 GENERAL JOURNAL Date Accounting Titles and Explanation 31-Jul Service Revenue Income Summary Accounts Payable Date 1-Jul 3-Jul 18-Jul $200 $150 $700 $500 Ref. Debit $6,600 Common Stock Date 1-Jul Page J3 Credit $6,600 31-Jul Income Summary Supplies Expense Gasoline Expense Depreciation Expense Insuranace Expense Salaries and Wages Expense $3,550 31-Jul Income Summary Retained Earnings $3,050 31-Jul Retained Earnings Page J2 Credit $700 $400 $200 $150 $2,100 $3,050 $600 Dividends Date 31-Jul Dividends $600 Service Revenue Date 12-Jul 25-Jul 31-Jul 31-Jul Gasoline Expense Date 31-Jul 31-Jul Insurance Expense Date 31-Jul 31-Jul PARTS B, C/E (ADD ADJUSTMENTS), F (ADD CLOSING ENTRIES) GENERAL LEDGER Cash Explanation Common Stock Equipment Prepaid Insurance Accounts Payable Salaries Expense Accounts Receivable Gasoline Expense Dividends Ref. Debit $$14,000 $1,400 Supplies Explanation Accounts Payable Supplies Expense Equipment Explanation Cash Accounts Payable Ref. Ref. Debit $800 Debit $3,000 $7,000 No. 101 Credit Balance $14,000 $3,000 $11,000 $1,800 $9,200 $1,400 $7,800 $1,600 $6,200 $7,600 $400 $7,200 $600 $6,600 No.126 Credit Balance $800 $700 $100 No.157 Credit Balance $3,000 $10,000 Accounts Receivable Date 12-Jul 21-Jul 25-Jul 31-Jul Prepaid Insurance Date 5-Jul 31-Jul Accumulated DepreciationDate 31-Jul Accounts Payable Explanation Equipment Supplies Cash Common Stock Explanation Cash Dividends Explanation Cash Retained Earnings Ref. Debit $1,400 Ref. Ref. No.201 Credit Balance $7,000 $7,000 $800 $7,800 $6,400 Debit No.311 Credit Balance $14,000 $14,000 Debit $600 No.332 Credit Balance $600 $600 $0 Salaries and Wages Payable Date 31-Jul Retained Earnings Date 31-Jul 31-Jul Income Summary Date 31-Jul 31-Jul 31-Jul 31-Jul 31-Jul 31-Jul 31-Jul Service Revenue Explanation Accounts Receivable Accounts Receivable Accounts Receivable Income Summary Gasoline Expense Explanation Cash Income Summary Insurance Expense Explanation Prepaid Insurance Income Summary Ref. Debit $6,600 Ref. Ref. No.400 Credit Balance $3,800 $3,800 $1,500 $5,300 $1,300 $6,600 $0 Debit $400 No.633 Credit Balance $400 $400 $0 Debit $150 No.722 Credit Balance $150 $150 $0 Supplies Expense Date 31-Jul 31-Jul Depreciation Expense Date 31-Jul 31-Jul Salaries and Wages Expens Date 31-Jul 31-Jul AL LEDGER Accounts Receivable Explanation Service Revenue Cash Service Revenue Service Revenue Prepaid Insurance Explanation Cash Insurance Expense Ref. Debit $3,800 No.112 Credit $1,500 $1,300 Balance $3,800 $2,400 $3,900 $5,200 No. 130 Debit Credit $1,800 $150 Balance $1,800 $1,650 $1,400 Ref. Accumulated Depreciation-Equipment Explanation Ref. Depreciation Expense-Equipment Debit No. 158 Credit Balance $200 $200 Salaries and Wages Payable Explanation Salaries and Wages Expense Retained Earnings Explanation Income Summary Dividends Income Summary Explanation Service Revenue Supplies Expense Gasoline Expense Depreciation Expense Insurance Expense Salaries and Wages Expense Retained Earnings Ref. Ref. Debit No. 212 Credit $500 Debit No. 320 Credit $3,050 $600 Ref. Debit $700 $400 $200 $150 $2,100 $3,050 Balance $500 Balance $2,450 No. 350 Credit $6,600 Balance $6,600 $5,900 $5,500 $5,300 $5,150.00 $3,050 $0 Supplies Expense Explanation Supplies Income Summary Depreciation Expense Explanation Accumulated Depre-Equip Income Summary Salaries and Wages Expense Explanation Cash Salaries and Wages Payable Income Summary Ref. Ref. No. 631 Debit Credit $700 $700 Debit $200 No. 711 Credit $200 Ref. Debit $1,600 $500 No. 726 Credit $2,100 Balance $700 $0 Balance $200 $0 Balance $1,600 $2,100 $0 PART B Kristen's Maids Cleaning Service Trial Balance July 31, 2017 No. Account Titles 101 Cash 112 Accounts Receivable 126 Supplies 130 Prepaid Insurance 157 Equipment 201 Accounts Payable 311 Common Stock 332 Dividends 400 Service Revenue 633 Gasoline Expense 726 Salaries and Wages Expense Total PART C/E Debit $6,600 $3,900 $800 $1,800 $10,000 Credit $6,400 $14,000 $600 $5,300 $400 $1,600 $25,700 $25,700 No. 101 112 126 130 157 158 201 212 311 332 400 631 633 711 722 726 Kristen's Maids Cleaning Service Adjusted Trial Balance July 31, 2017 Account Titles Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries and Wages Payable Common Stock Dividends Service Revenue Supplies Expense Gasoline Expense Depreciation Expense Insurance Expense Salaries and Wages Expense Total Kristen's Maids Cleaning Service Income Statement PART D For the Month ended July 31, 2017 Debit $6,600 $5,200 $100 $1,650.00 $10,000 Credit $200 $6,400 $500 $14,000 $600 $6,600 $700 $400 $200 $150 $2,100 $27,700 $27,700 Revenues: Service Revenue Expenses: Supplies Expense Gasoline Expense Depreciation Expense Insurance Expense Salaries and Wages E Total Expenses Net Income Dividends Retained Earnings aids Cleaning Service me Statement th ended July 31, 2017 Kristen's Maids Cleaning Service Retained Earnings Statement PART D For the Month ended July 31, 2017 $6,600 $700 $400 $200 $150 $2,100 $3,550 $600 ($3,550) $3,050 ($600) $2,850 Retained Earnings, July 1, 2007 Beginning Reatined Earnings Add: Net Income Less:Dividends Ending Retained Earnings PART D $0 $3,050 ($600) $2,450 Kristen's Maids Cleaning Serv Balance Sheet July 31, 2017 Assets Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation-Eq Total Assets Liabilities and Shareholders Accounts Payable Salaries and Wages Payable Total Liabilities Common Stock Reatined Earnings Total Equity Total Liabilities and Shareho Kristen's Maids Cleaning Service Balance Sheet July 31, 2017 Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation-Equipment Total Assets Liabilities and Shareholders Equity Accounts Payable Salaries and Wages Payable Total Liabilities Common Stock Reatined Earnings Total Equity Total Liabilities and Shareholders Equity PART G $6,600 $5,200 $100 $1,650 $10,000 ($200) $23,350 $6,400 $500 $6,900 $14,000 $2,450 $16,450 $23,350 No. 101 112 126 130 157 158 201 212 311 320 Kristen's Maids Cleaning Service Post-Closing Trial Balance July 31, 2017 Account Titles Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries and Wages Payable Common Stock Retained Earnings Total Debit $6,600 $5,200 $100 $1,650 $10,000 $23,550 Credit $200 $6,400 $500 $14,000 $2,450 $23,550 ACCT 111 Comprehensive Problem: Chapters 2 to 4 Name PART A Date 1-Jul ________________________________ PART C/E (ADD ADJUSTMENTS) PART F (ADD CLOSING ENTRIES) GENERAL JOURNAL Page J1 Accounting Titles and Explanation Ref. Debit Credit Cash $14,000 Common Stock $14,000 1-Jul Equipment Cash Accounts Payable $10,000 3-Jul Supplies Accounts Payable $800 5-Jul Prepaid Insurance Cash $3,000 $7,000 $800 $1,800 $1,800 12-Jul Accounts Receivable Service Revenue $3,800 18-Jul Accounts Payable Cash $1,400 20-Jul Salaries Expense Cash $1,600 21-Jul Cash $1,400 $3,800 Supplies Date 3-Jul 31-Jul $1,400 $1,600 Accounts Receivable 25-Jul Accounts Receivable Service Revenue Cash Date Jul-17 1-Jul 5-Jul 18-Jul 20-Jul 25-Jul 31-Jul 31-Jul $1,400 $1,500 $1,500 31-Jul Gasoline Expense Cash $400 31-Jul Dividends Cash $600 $400 $600 Equipment Date 1-Jul 1-Jul GENERAL JOURNAL Date Accounting Titles and Explanation 31-Jul Accounts Receivable Service Revenue Ref. Debit $1,300 $1,300 31-Jul Depreciation Expense -Equipment Accummulated Depre-Equipment $200 31-Jul Insurance Expense Prepaid Insurance $150 31-Jul Supplies Expense Supplies $700 31-Jul Salaries and Wages Expense Salaries and Wages Payable $500 GENERAL JOURNAL Date Accounting Titles and Explanation 31-Jul Service Revenue Income Summary Accounts Payable Date 1-Jul 3-Jul 18-Jul $200 $150 $700 $500 Ref. Debit $6,600 Common Stock Date 1-Jul Page J3 Credit $6,600 31-Jul Income Summary Supplies Expense Gasoline Expense Depreciation Expense Insuranace Expense Salaries and Wages Expense $3,550 31-Jul Income Summary Retained Earnings $3,050 31-Jul Retained Earnings Page J2 Credit $700 $400 $200 $150 $2,100 $3,050 $600 Dividends Date 31-Jul Dividends $600 Service Revenue Date 12-Jul 25-Jul 31-Jul 31-Jul Gasoline Expense Date 31-Jul 31-Jul Insurance Expense Date 31-Jul 31-Jul PARTS B, C/E (ADD ADJUSTMENTS), F (ADD CLOSING ENTRIES) GENERAL LEDGER Cash Explanation Common Stock Equipment Prepaid Insurance Accounts Payable Salaries Expense Accounts Receivable Gasoline Expense Dividends Ref. Debit $$14,000 $1,400 Supplies Explanation Accounts Payable Supplies Expense Equipment Explanation Cash Accounts Payable Ref. Ref. Debit $800 Debit $3,000 $7,000 No. 101 Credit Balance $14,000 $3,000 $11,000 $1,800 $9,200 $1,400 $7,800 $1,600 $6,200 $7,600 $400 $7,200 $600 $6,600 No.126 Credit Balance $800 $700 $100 No.157 Credit Balance $3,000 $10,000 Accounts Receivable Date 12-Jul 21-Jul 25-Jul 31-Jul Prepaid Insurance Date 5-Jul 31-Jul Accumulated DepreciationDate 31-Jul Accounts Payable Explanation Equipment Supplies Cash Common Stock Explanation Cash Dividends Explanation Cash Retained Earnings Ref. Debit $1,400 Ref. Ref. No.201 Credit Balance $7,000 $7,000 $800 $7,800 $6,400 Debit No.311 Credit Balance $14,000 $14,000 Debit $600 No.332 Credit Balance $600 $600 $0 Salaries and Wages Payable Date 31-Jul Retained Earnings Date 31-Jul 31-Jul Income Summary Date 31-Jul 31-Jul 31-Jul 31-Jul 31-Jul 31-Jul 31-Jul Service Revenue Explanation Accounts Receivable Accounts Receivable Accounts Receivable Income Summary Gasoline Expense Explanation Cash Income Summary Insurance Expense Explanation Prepaid Insurance Income Summary Ref. Debit $6,600 Ref. Ref. No.400 Credit Balance $3,800 $3,800 $1,500 $5,300 $1,300 $6,600 $0 Debit $400 No.633 Credit Balance $400 $400 $0 Debit $150 No.722 Credit Balance $150 $150 $0 Supplies Expense Date 31-Jul 31-Jul Depreciation Expense Date 31-Jul 31-Jul Salaries and Wages Expens Date 31-Jul 31-Jul AL LEDGER Accounts Receivable Explanation Service Revenue Cash Service Revenue Service Revenue Prepaid Insurance Explanation Cash Insurance Expense Ref. Debit $3,800 No.112 Credit $1,500 $1,300 Balance $3,800 $2,400 $3,900 $5,200 No. 130 Debit Credit $1,800 $150 Balance $1,800 $1,650 $1,400 Ref. Accumulated Depreciation-Equipment Explanation Ref. Depreciation Expense-Equipment Debit No. 158 Credit Balance $200 $200 Salaries and Wages Payable Explanation Salaries and Wages Expense Retained Earnings Explanation Income Summary Dividends Income Summary Explanation Service Revenue Supplies Expense Gasoline Expense Depreciation Expense Insurance Expense Salaries and Wages Expense Retained Earnings Ref. Ref. Debit No. 212 Credit $500 Debit No. 320 Credit $3,050 $600 Ref. Debit $700 $400 $200 $150 $2,100 $3,050 Balance $500 Balance $2,450 No. 350 Credit $6,600 Balance $6,600 $5,900 $5,500 $5,300 $5,150.00 $3,050 $0 Supplies Expense Explanation Supplies Income Summary Depreciation Expense Explanation Accumulated Depre-Equip Income Summary Salaries and Wages Expense Explanation Cash Salaries and Wages Payable Income Summary Ref. Ref. No. 631 Debit Credit $700 $700 Debit $200 No. 711 Credit $200 Ref. Debit $1,600 $500 No. 726 Credit $2,100 Balance $700 $0 Balance $200 $0 Balance $1,600 $2,100 $0 PART B Kristen's Maids Cleaning Service Trial Balance July 31, 2017 No. Account Titles 101 Cash 112 Accounts Receivable 126 Supplies 130 Prepaid Insurance 157 Equipment 201 Accounts Payable 311 Common Stock 332 Dividends 400 Service Revenue 633 Gasoline Expense 726 Salaries and Wages Expense Total PART C/E Debit $6,600 $3,900 $800 $1,800 $10,000 Credit $6,400 $14,000 $600 $5,300 $400 $1,600 $25,700 $25,700 No. 101 112 126 130 157 158 201 212 311 332 400 631 633 711 722 726 Kristen's Maids Cleaning Service Adjusted Trial Balance July 31, 2017 Account Titles Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries and Wages Payable Common Stock Dividends Service Revenue Supplies Expense Gasoline Expense Depreciation Expense Insurance Expense Salaries and Wages Expense Total Kristen's Maids Cleaning Service Income Statement PART D For the Month ended July 31, 2017 Debit $6,600 $5,200 $100 $1,650.00 $10,000 Credit $200 $6,400 $500 $14,000 $600 $6,600 $700 $400 $200 $150 $2,100 $27,700 $27,700 Revenues: Service Revenue Expenses: Supplies Expense Gasoline Expense Depreciation Expense Insurance Expense Salaries and Wages E Total Expenses Net Income Dividends Retained Earnings aids Cleaning Service me Statement th ended July 31, 2017 Kristen's Maids Cleaning Service Retained Earnings Statement PART D For the Month ended July 31, 2017 $6,600 $700 $400 $200 $150 $2,100 $3,550 $600 ($3,550) $3,050 ($600) $2,850 Retained Earnings, July 1, 2007 Beginning Reatined Earnings Add: Net Income Less:Dividends Ending Retained Earnings PART D $0 $3,050 ($600) $2,450 Kristen's Maids Cleaning Serv Balance Sheet July 31, 2017 Assets Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation-Eq Total Assets Liabilities and Shareholders Accounts Payable Salaries and Wages Payable Total Liabilities Common Stock Reatined Earnings Total Equity Total Liabilities and Shareho Kristen's Maids Cleaning Service Balance Sheet July 31, 2017 Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation-Equipment Total Assets Liabilities and Shareholders Equity Accounts Payable Salaries and Wages Payable Total Liabilities Common Stock Reatined Earnings Total Equity Total Liabilities and Shareholders Equity PART G $6,600 $5,200 $100 $1,650 $10,000 ($200) $23,350 $6,400 $500 $6,900 $14,000 $2,450 $16,450 $23,350 No. 101 112 126 130 157 158 201 212 311 320 Kristen's Maids Cleaning Service Post-Closing Trial Balance July 31, 2017 Account Titles Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries and Wages Payable Common Stock Retained Earnings Total Debit $6,600 $5,200 $100 $1,650 $10,000 $23,550 Credit $200 $6,400 $500 $14,000 $2,450 $23,550