Ask Experts Questions for FREE Help !
Ask
    okichick21's Avatar
    okichick21 Posts: 1, Reputation: 1
    New Member
     
    #1

    Jun 10, 2010, 12:05 AM
    I have to create an adjusted trial balance for the following:
    These are the account balances at dec 31 2007 before the adjusting entries:
    Cash 26667 debit
    Prepaid insurance 450 debit
    Film on hand 250 debit
    Cameras 20000 debit
    Accumulated depreciation 3667 credit
    Accounts payable 7000 credit
    Unearned revenue 3000 credit
    Capital stock 1000 credit
    Retained earnings 5800 credit
    Dividends 1200 debit
    Revenue 28000 credit
    Utilities expense 3200 debit
    Salaries expense 2400 debit
    Other information:
    Insurance policy was dated dec 1 2007. Monthly insurance cost is 50
    Film on hand at dec 31 2007 was 180
    The cameras were purchased jan 1 2007. Estimated life of 5 years
    The balance in unearned revenue was 2000
    Inerest owed but not paid on the note was 30
    Salaries owed but not paid at dec 31 were 2000

    I have no idea where to even start.
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #2

    Jun 12, 2010, 09:01 AM

    First set up a worksheet in Excel with a trial balance of your account balances. From the information provided your trial balance will not balance, so you need to double check the amounts listed.

    I have attached the worksheet for you.

    Your adjusting entries will go in columns D and E, then balance them down. Next you will carry your balances over to columns F and G, then balance them down. Your Debits should equal Credits for columns B and C, Columns D and E, and columns F and G.
    Attached Files
  1. File Type: xls Worsheet.xls (20.5 KB, 146 views)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Trial Balance Worksheet, Adjustments & Adjusted Trial Balance [ 4 Answers ]

I'm trying to do a Trial Balance worksheet and this is what I have to do, I believe these go in the adjustments section. a. Unexpired insurance balance at December 31, 2008: $2,500 b. Supplies on hand at December 31, 2008: $500 c. Depreciation on building for the...

Accounting need assistance with adjusted trial balance, doesn't balance [ 3 Answers ]

1. Office supplies on hand at year end amounted to $ 420 2. The equipment costing $30,000 has an expected life of six years and no salvage value. Mike uses straight-line depreciation. 3. A premium of $ 1500 for a one year insurance policy was paid on November 1. 4. Wages earned by employees but...

PLEASE help me create an unadjusted trial balance and an adjusted balance? [ 1 Answers ]

PLEASE help me create an unadjusted trial balance and an adjusted balance. Three friends opened a roller rink on October 1, 2008. The following transactions occurred during the first month. Oct 1. Received contribution of $22,000 from EACH three principal owners of the business in exchange...

Trial Balance & Adjusted Trial Balance [ 1 Answers ]

I have a question that doesn't seem to make too much sense. Can anyone explain this to me? Which of the accounts below would appear on an adjusted trial balance but probably would not appear on the trial balance? -Fees Earned -Accounts Receivable -Unearned Fees -Depreciation Expense The...


View more questions Search