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 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
