Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This goes with the question above, the Excel Spreadsheet is listed below: I need the unadjusted trial balance The transaction of accounts is the journal
This goes with the question above, the Excel Spreadsheet is listed below:
I need the unadjusted trial balance
The transaction of accounts is the journal entry
A s Insert Arial AutoSave File Home X Draw comprehensive_problem1 (2) - Compatibility Mode - Sav.... Page Layout Formulas Data Review View Help 10 A A = Wrap Text A Merge & Center BIU - Alignment Font Clipboard 097 COMPREHENSIVE PROBLEM 1 - The following ledger accounts appear below, in this order: Fees Eamed Salary Expense, Rent Expense, Supplies Expense, Depreciation Expense, Insurance Expense, Miscellaneous Expense - Beginning balances from the textbook have already been entered. - The remaining accounts are found on the previous page. The entries in the ledgers will not grade or mark correct or incorrect. LEDGERS - Income Statement accounts Fees Earned Post Balance Date Item Ref. Dr. Dr. Cr. 5/15 Fees Earned 5/17 Fees Earned 5/21 Fees Earned 5/25 Fees Earned 5/31 Fees Earned 5/31 Fees Earned 9,180 8,360 4,820 7,900 3,300 2,650 36,210 Salary Expense Date Item - Post Ref. Dr. Balance Cr. Dr. 5/16 Salary Expense 630 5/28 Salary Expense Income Statement Accounts Balance Sheet Accounts 750 View Help AutoSave Home X A Insert Draw Acid BIU - 23 Wrap Text comprehensive problem! (23 - 0 Page Layout Formulas Data Review 10 A A E - - A Merge & Center Alignment Font 097 Salary Expense Balance Post Ref. Dr. Cr. Dr. Cr. - Date Item 5/16 Salary Expense 5/28 Salary Expense 630 750 1,380 Rent Expense Date item Post Ref. Dr. C. Balance Dr. Supplies Expense Date Hem 5:20 Supplies Expense Post Rer. Dr. cr. ance Balance Dr. cx Income Statement Accounts Balance Sheet Accounts e se AutoSme File Home = comprehensive problem1 (2) - Compatibility Mode - Sav... Page Layout Formulas Data Review View Help insert Draw A Are BIU- 10 - A A 2 Wrap Text Merge & Center E Alignment 097 . fr Depreciation Expense - Item Post Rei Dr. cr. Balance Dr. Cr. Insurance Expense Date Post Ref Rot. Dr. Balance C. Dr. Cr. Miscellaneous Expense Dule Post - Ret Dr. Cr. Balance 59 Miscellaneous Expense 500 Miscellaneous Expense 501 Miscellaneous Expense Dr. Cr. 225 260 810 1295 Income Statement Accounts Balance Sheet Accounts Help AutoSave A File Home Insert c omprehensive problem1 (2) - Compatible Page Layout Formulas Data Review View Draw A = 2 Wrap Text Merge & Center v X = E Arial BTU - 10 - A A Font Alignment Clipboard 016 Accounts Receivable Balance Post Dato Hem Cr. Pet Dr. cr. Dr. ooo 3,400 5/1 Balance Supplies Post Date Dato tem Ret. Dr. cr. Dr. Balance 5/1 Balance 1,350 Prepaid Rent De nom Post Ret 5/1 Balance Dr. Cr. Balance Dr Cr. Income Statement Accounts Balance Sheet Accounts 3,200 ut o Se me Home x comprehensive problem1 (2) Compatibility Mode - Sav Insert DrawPage Layout Formulas Data Review View Help! Arial 10 - A M = = = 28 Wrap Text BI USA E l Merge & Center Alignment 016 Accumulated Depreciation Date Item Ret Dr. C. Balance Dr. 5/1 Balance Post Balance Accounts Payable Date Item 5/1 Balance Ref. Dr. Cr. Dr. Cr 800 Salaries Payable Date Item Post Ref. Dr. Cr. Balance Dr. Cr 5/1 Balance Income Statement Accounts Balance Sheet Accounts May 3 Course Project Journal Entry farkelly Consulting Debit Credit cash $4,500 V cames pecs 4.500 Cash 2,450 - Accounts Receivable 2450 Miscellaneous Expense 225 Accounts Payable 640 May S May 9 225 *May 13 9180 750 8360 735 8360 735 4820 4820 May Is Accounts Receivable fees Earned May 16 Salary Expense Salary payable lugh Nos o 17 cash Fees Earned May 20 Supplies Expanse Accounts Payable - Man 21 Accounts Receivable I Fees Eamed - Man 25 cash I fees Eamed May 27 (ash Accounts Receivable -XMay 28 Salary Expanse I Cash -*May 30 Miscellaneous Expense cash May 31 Miscellaneous Expense cash - Man 31 cash fees Earred 7900 7900 9520 9520 750 256 260 260 810 3300 3300 A s Insert Arial AutoSave File Home X Draw comprehensive_problem1 (2) - Compatibility Mode - Sav.... Page Layout Formulas Data Review View Help 10 A A = Wrap Text A Merge & Center BIU - Alignment Font Clipboard 097 COMPREHENSIVE PROBLEM 1 - The following ledger accounts appear below, in this order: Fees Eamed Salary Expense, Rent Expense, Supplies Expense, Depreciation Expense, Insurance Expense, Miscellaneous Expense - Beginning balances from the textbook have already been entered. - The remaining accounts are found on the previous page. The entries in the ledgers will not grade or mark correct or incorrect. LEDGERS - Income Statement accounts Fees Earned Post Balance Date Item Ref. Dr. Dr. Cr. 5/15 Fees Earned 5/17 Fees Earned 5/21 Fees Earned 5/25 Fees Earned 5/31 Fees Earned 5/31 Fees Earned 9,180 8,360 4,820 7,900 3,300 2,650 36,210 Salary Expense Date Item - Post Ref. Dr. Balance Cr. Dr. 5/16 Salary Expense 630 5/28 Salary Expense Income Statement Accounts Balance Sheet Accounts 750 View Help AutoSave Home X A Insert Draw Acid BIU - 23 Wrap Text comprehensive problem! (23 - 0 Page Layout Formulas Data Review 10 A A E - - A Merge & Center Alignment Font 097 Salary Expense Balance Post Ref. Dr. Cr. Dr. Cr. - Date Item 5/16 Salary Expense 5/28 Salary Expense 630 750 1,380 Rent Expense Date item Post Ref. Dr. C. Balance Dr. Supplies Expense Date Hem 5:20 Supplies Expense Post Rer. Dr. cr. ance Balance Dr. cx Income Statement Accounts Balance Sheet Accounts e se AutoSme File Home = comprehensive problem1 (2) - Compatibility Mode - Sav... Page Layout Formulas Data Review View Help insert Draw A Are BIU- 10 - A A 2 Wrap Text Merge & Center E Alignment 097 . fr Depreciation Expense - Item Post Rei Dr. cr. Balance Dr. Cr. Insurance Expense Date Post Ref Rot. Dr. Balance C. Dr. Cr. Miscellaneous Expense Dule Post - Ret Dr. Cr. Balance 59 Miscellaneous Expense 500 Miscellaneous Expense 501 Miscellaneous Expense Dr. Cr. 225 260 810 1295 Income Statement Accounts Balance Sheet Accounts Help AutoSave A File Home Insert c omprehensive problem1 (2) - Compatible Page Layout Formulas Data Review View Draw A = 2 Wrap Text Merge & Center v X = E Arial BTU - 10 - A A Font Alignment Clipboard 016 Accounts Receivable Balance Post Dato Hem Cr. Pet Dr. cr. Dr. ooo 3,400 5/1 Balance Supplies Post Date Dato tem Ret. Dr. cr. Dr. Balance 5/1 Balance 1,350 Prepaid Rent De nom Post Ret 5/1 Balance Dr. Cr. Balance Dr Cr. Income Statement Accounts Balance Sheet Accounts 3,200 ut o Se me Home x comprehensive problem1 (2) Compatibility Mode - Sav Insert DrawPage Layout Formulas Data Review View Help! Arial 10 - A M = = = 28 Wrap Text BI USA E l Merge & Center Alignment 016 Accumulated Depreciation Date Item Ret Dr. C. Balance Dr. 5/1 Balance Post Balance Accounts Payable Date Item 5/1 Balance Ref. Dr. Cr. Dr. Cr 800 Salaries Payable Date Item Post Ref. Dr. Cr. Balance Dr. Cr 5/1 Balance Income Statement Accounts Balance Sheet Accounts May 3 Course Project Journal Entry farkelly Consulting Debit Credit cash $4,500 V cames pecs 4.500 Cash 2,450 - Accounts Receivable 2450 Miscellaneous Expense 225 Accounts Payable 640 May S May 9 225 *May 13 9180 750 8360 735 8360 735 4820 4820 May Is Accounts Receivable fees Earned May 16 Salary Expense Salary payable lugh Nos o 17 cash Fees Earned May 20 Supplies Expanse Accounts Payable - Man 21 Accounts Receivable I Fees Eamed - Man 25 cash I fees Eamed May 27 (ash Accounts Receivable -XMay 28 Salary Expanse I Cash -*May 30 Miscellaneous Expense cash May 31 Miscellaneous Expense cash - Man 31 cash fees Earred 7900 7900 9520 9520 750 256 260 260 810 3300 3300 Step 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