Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me do the attach excel sheet for Trey's Fast Cleaning Service Assignments Trey's Fast Cleaning Service General Journal Week 1 Journal Entries Date
please help me do the attach excel sheet forTrey's Fast Cleaning Service Assignments
Trey's Fast Cleaning Service General Journal Week 1 Journal Entries Date 20xx Trans # 1-Dec 1-Dec 1-Dec 1-Dec 2-Dec 2-Dec 2-Dec 2-Dec 3-Dec 3-Dec 3-Dec 3-Dec 3-Dec 5-Dec Description Debit Credit try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again 5-Dec 5-Dec 5-Dec 6-Dec 6-Dec 6-Dec 7-Dec 7-Dec 7-Dec 8-Dec 8-Dec 9-Dec 10-Dec 10-Dec 12-Dec 12-Dec try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again 13-Dec 13-Dec 14-Dec 14-Dec 14-Dec 15-Dec 15-Dec 15-Dec 16-Dec 16-Dec 16-Dec 17-Dec 19-Dec 19-Dec 20-Dec 20-Dec try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again 20-Dec 21-Dec 21-Dec 21-Dec 22-Dec 22-Dec 23-Dec 23-Dec 23-Dec 24-Dec 24-Dec try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again Customer/Vendor Info 101 - Cash 105 - Petty Cash 110 - Accounts Receivable 141 - Cleaning Supplies 142 - Office Supplies 150 - Prepaid Insurance 181 - Office Equipment 181.1 - Accum. Depr. -Offic 188 - Vehicles 188.1 - Accum. Depr. -Vehic 201 - Accounts Payable 311 - Trey Anderson, Capita 312 - Trey Anderson, Drawi 313 - Income Summary 401 - Service Revenue 512 - Advertising Expense 521 - Rent Expense 522 - Salary Expense 523 - Cleaning Supplies Exp 524 - Office Supplies Expen 525 - Telephone Expense 534 - Charit. Contributions 535 - Insurance Expense 538 - Vehicles Expense 541 - Depr. Expense -Office 543 - Depr. Expense -Vehicl 549 - Miscellaneous Expens 105 - Petty Cash 110 - Accounts Receivable 141 - Cleaning Supplies 142 - Office Supplies 150 - Prepaid Insurance 181 - Office Equipment 181.1 - Accum. Depr. -Office Eqpt. 188 - Vehicles 188.1 - Accum. Depr. -Vehicles 201 - Accounts Payable 311 - Trey Anderson, Capital 312 - Trey Anderson, Drawing 313 - Income Summary 401 - Service Revenue 512 - Advertising Expense 521 - Rent Expense 522 - Salary Expense 523 - Cleaning Supplies Expense 524 - Office Supplies Expense 525 - Telephone Expense 534 - Charit. Contributions Expense 535 - Insurance Expense 538 - Vehicles Expense 541 - Depr. Expense -Office Eqpt. 543 - Depr. Expense -Vehicles 549 - Miscellaneous Expense Trey's Fast Cleaning Service General Journal Week 2 Journal Entries Date Trans # 20xx 27-Dec Description Debit Credit Debit Credit try again try again 29-Dec try again try again 29-Dec try again try again 29-Dec try again try again 30-Dec try again try again 30-Dec try again try again 31-Dec try again try again 31-Dec try again try again 31-Dec try again try again 31-Dec try again try again try again try again try again try again Adjusting Entries: Date Description 20xx 31-Dec EOY #5 try again try again 31-Dec EOY #5 try again try again 31-Dec EOY #5 try again try again 31-Dec EOY #5 try again try again Closing Entries: Date Description 20xx 31-Dec EOY #6(a) Debit try again try again 31-Dec EOY #6(b) try again try again try again try again try again try again try again try again try again try again try again try again try again 31-Dec EOY #6(c ) try again try again 31-Dec EOY #6(d) try again try again Credit Customer/Vendor Info try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again try again 101 - Cash 105 - Petty Cash 110 - Accounts Receivable 141 - Cleaning Supplies 142 - Office Supplies 150 - Prepaid Insurance 181 - Office Equipment 181.1 - Accum. Depr. -Office Eqpt. 188 - Vehicles 188.1 - Accum. Depr. -Vehicles 201 - Accounts Payable 311 - Trey Anderson, Capital 312 - Trey Anderson, Drawing 313 - Income Summary 401 - Service Revenue 512 - Advertising Expense 521 - Rent Expense 522 - Salary Expense 523 - Cleaning Supplies Expense 524 - Office Supplies Expense 525 - Telephone Expense 534 - Charit. Contributions Expense 535 - Insurance Expense 538 - Vehicles Expense 541 - Depr. Expense -Office Eqpt. 543 - Depr. Expense -Vehicles 549 - Miscellaneous Expense Trey's Fast Cleaning Service Bank Reconciliation December 27, 20xx Balance per Bank Statement, December 21, 20xx Add December Deposits in Transit Total $ - try again Less Outstanding Checks: Ck No. 482 Ck No. 487 Ck No. 488 Ck No. 489 Ck No. 490 Ck No. 491 Ck No. 492 Ck No. 493 Ck No. 494 $ - try again Balance per Books, Decemember 27, 20xx $ - try again Trey's Fast Cleaning Service End of Year Worksheet For the Year Ended December 31, 20xx ACCOUNT TITLES 101 Cash 105 Petty Cash 110 Accounts Receivable 141 Cleaning Supplies 142 Office Supplies 150 Prepaid Insurance 181 Office Equipment 181.1 Accum. Depr. - Office Equipment 188 Vehicles 188.1 Accum. Depr. - Vehicles 201 Accounts Payable 311 Trey Anderson, Capital 312 Trey Anderson, Drawing 401 Service Revenue 512 Advertising Expense 521 Rent Expense 522 Salary Expense 523 Cleaning Supplies Expense 524 Office Supplies Expense 525 Telephone Expense 534 Charitable Contributions Expense 535 Insurance Expense 538 Vehicles Expense 541 Depr. Expense - Office Equipment 543 Depr. Expense - Vehicles 549 Miscellaneous Expense TRIAL BALANCE DEBIT CREDIT 11,273.15 625.00 14,170.00 12,353.20 7,512.00 27,550.00 6,260.00 70,670.00 24,280.00 786.50 62,500.00 57,125.20 181,101.70 1,284.35 23,650.00 32,140.00 1,843.10 1,340.00 4,326.00 7,632.45 1,433.75 274,928.20 274,928.20 ADJUSTMENTS DEBIT try again try again - Net Income try again y's Fast Cleaning Service nd of Year Worksheet ear Ended December 31, 20xx ADJUSTMENTS CREDIT INCOME STATEMENT DEBIT CREDIT - try again try again try again BALANCE SHEET DEBIT CREDIT - - - try again try again Trey's Fast Cleaning Service Income Statement For the Year Ended December 31, 20xx Revenue: Service Revenue try again Expenses: Advertising Expense Rent Expense Salary Expense Cleaning Supplies Expense Office Supplies Expense Telephone Expense Charitable Contributions Expense Insurance Expense Vehicles Expense Depreciation Exp - Office Equipment Depreciation Exp - Vehicles Miscellaneous Expense Total Expenses Net Income - try again $ - try again Trey's Fast Cleaning Service Statement of Owner's Equity For the Year Ended December 31, 20xx Trey Anderson, Capital, January 1, 20xx Net Income for the year Less withdrawals for the year $ - Increase in Capital Trey Anderson, Capital, December 31, 20xx $ - try again Trey's Fast Cleaning Service Balance Sheet As of December 31, 20xx Assets Current Assets: Cash Petty Cash Accounts Receivable Cleaning Supplies Office Supplies Prepaid Insurance Total Current Assets $ Property, Plant & Equipment: Vehicles Less: Accumulated Depreciation Office Equipment Less: Accumulated Depreciation Total Assets - try again $ - try again Liabilities Current Liabilities: Accounts Payable Owner's Equity Trey Anderson, Capital Total Liabilities & Owner's Equity $ - try again Trey's Fast Cleaning Service Post-Closing Trial Balance December 31, 20xx ACCT # ACCOUNT 101 Cash 105 Petty Cash 110 Accounts Receivable 141 Cleaning Supplies 142 Office Supplies 150 Prepaid Insurance 181 Office Equipment 181.1 Accumulated Depr - Office Equipment 188 Vehicles 188.1 Accumulated Depr - Vehicles 201 Accounts Payable 311 Trey Anderson, Capital DEBIT $ CREDIT try again $ try againStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started