Answered step by step
Verified Expert Solution
Link Copied!

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: image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
I need the unadjusted trial balance image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing The Art and Science of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Joanne C. Jones

13th Canadian edition

133405508, 978-0133405507

More Books

Students also viewed these Accounting questions

Question

Evaluating or appraising employees work.

Answered: 1 week ago