Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with ACCT 2301 final excel worksheet JKL Company Worksheet Account Cash Accounts Receivable Office Supplies Prepaid insurance Office Equipment Accumulated depreciation, office equipment

Need help with ACCT 2301 final excel worksheetimage text in transcribed

JKL Company Worksheet Account Cash Accounts Receivable Office Supplies Prepaid insurance Office Equipment Accumulated depreciation, office equipment Accounts Payable Interest payable Salaries Payable Unearned consulting fees Long Term notes payable J. Logan, Capital J. Logan, Withdrawals Consulting fees Unadjusted Trial Balance Debit Credit 34,000 14,000 16,000 8,540 84,000 14,000 9100 0 0 18,000 52,000 40,000 5,000 123,240 Depreciation Expense, office equipment Salaires Expense Interest expense Insurance expense Rent Expense Office supplies expense Advertising Expense Totals 0 67,000 1,200 0 14,500 0 12,100 256,340 256,340 Adjustments Letter Debit A Credit 8,000 H Letter 3,000 A, H 11,000 Adjusted Trial Balance Debit Credit 34,000 22,000 2,000 2,960 84,000 20,000 10,000 1,000 7,000 15,000 52,000 40,000 5,000 134,240 6,000 74,000 2,200 5,580 14,500 14,000 13,000 279,240 279,240 JKL COMPANY Worksheet Account Cash Accounts receivable (A) Office supplies (B) Prepaid insurance Office equipment Accumulated depreciation, Office equipment (D) Accounts payable (E) Interest payable (F) Salaries payable (G) Unearned consulting fees (H) Long-term notes payable J. Logan, Capital J. Logan, Withdrawals Consulting fees earned Depreciation expense, Office equipment Salaries expense Interest expense Insurance expense Rent expense Office supplies expense Advertising expense Totals Unadjusted Trial Balance Debit Credit $34,000 14,000 16,000 8,540 84,000 $14,000 9,100 0 0 18,000 52,000 40,000 5,000 123,240 0 67,000 1,200 0 14,500 0 12,100 $256,340 $256,340 Adjustments Debit Credit Adjusted Trial Balance Debit Credit $34,000 22,000 2,000 2,960 84,000 $20,000 10,000 1,000 7,000 15,000 52,000 40,000 5,000 134,240 6,000 74,000 2,200 5,580 14,500 14,000 13,000 $279,240 $279,240 A six column table for JKL Company is given. The first two columns contain the unadjusted trial balance for the company as of July 31, 2008/ The last two columns contain the adjusted trial balance as of the same date. Analyze the differences between the unadjusted and adjusted trial balances to determine the eight adjustments that likely were made. Show the results of your analysis by inserting these adjustments amounts in the table's two middle columns. Label each adjustment with a letter A thru H A. Accounts Receivable is associated with what credit account? See also H transaction B. Office Supplies is associated with what expense account? C. Prepaid Insurance is associated with what expense account? D. Accumulated Deprecation, office equipment is associated with expense account? E. Accounts Payable is associated with what expense account ? F. Interest Payable is associated with what expense account? G. Salaries Payable is associated with what expense account? H. Unearned consulting fees is associated with what revenue account? A and H is associated with the same credit account

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

Step: 3

blur-text-image

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

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions

Question

What courses do your students assist with teaching this semester?

Answered: 1 week ago