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

    Mar 22, 2009, 02:29 PM
    Correcting a trial balance (I cannot figure this out)
    Cash 5,850
    Accounts Receivable 2,750
    Prepaid Insurance 700
    Equipment 8,000
    Accounts Payable 4,500
    Property Taxes Payable 560
    M Sterling, Capital 11,700
    Service Revenue 6,690
    Salaries Expense 4,200
    Advertising Expense 1,100
    Property Tax Expense 800

    1. The totals of the debit sides of Prepaid Insurance, Accounts Payable, and Property Tax Expense were each
    Understated $100
    2. Transposition errors were made in Accounts Receivable and Service Revenue. Based on posting made, the
    Correct balances were $2,570 and $6,960 respectively.
    3. A debit posting to Salaries Expense of $200 was omitted.
    4. A $1,000 cash drawing by the owner was debited to M. Sterling, Capital for $1,000 and
    Credited to Cash for $1,000
    5. A $520 purchase of supplies on account was debited to Equipment for $520 and
    Credited to Cash for $520
    6. A cash payment of $450 for advertising was debited to Advertising Expense for $45 and
    And credited to Cash for $45
    7. A collection from a customer for $210 was debited to Cash for $210 and credited to
    Accounts Payable for $210
    jdadawn07's Avatar
    jdadawn07 Posts: 3, Reputation: 1
    New Member
     
    #2

    Mar 22, 2009, 03:10 PM
    The first thing I did was add $100 to Dr. of accounts payable, prepaid insurance, and property tax expense. Was that correct?

    Then I changed the amounts to 2570 and 6960 of account receivable and service revenue respectfully. I moved service revenue to the credit side, was that correct?

    Next I debited owners drawings 1000 and credited M. Sterling, Capital 1000.

    I debited supplies 520 and credited accounts payable 520. I guess I subtract 520 from equipment on the debit side and subtract 520 from cash on the credit side.

    Next, I debited advertising expense for 405 and credited cash for 405.

    Finally, I debited cash for 210 and credited accounts receivable for 210.

    I need help determining what side everything goes on as well, please.
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #3

    Mar 22, 2009, 04:01 PM

    First thing to do is set up a trial balance on Excel or use a 2 column paper.

    Assets & Expenses have a normal Debit Balance. Liabilities and capital accounts have a normal Credit Balance.

    1. Subtract 100 from A/P, Add 100 to both Prepaid Insurance and the Expense account.
    2. Change the amounts in the accounts.
    3. Add 200 to the Expense account.
    4. Add a Drawing account with 1000 Debit balance, and subtract 1000 from the Capital Account.
    5. Add a supplies account with 520 Debit balance, subtract 520 from the Eqpt Balance, add 520 to the Cash balance and add 520 to A/P account.
    6. Subtract 405 from the Cash Balance, add 405 to the Expense Account.
    7. subtract 210 from A/R and subtract 210 from A/P.
    jdadawn07's Avatar
    jdadawn07 Posts: 3, Reputation: 1
    New Member
     
    #4

    Mar 22, 2009, 04:50 PM

    Cash $5,965 amount
    Accounts Receivable 2,360 amount
    Prepaid Insurance 800 amount
    Equipment 7,480 amount
    Accounts Payable amount $4,710
    Property Taxes Payable amount $560
    M Sterling, Capital amount 10,700
    Service Revenue amount 6,960
    Salaries Expense 4,400 amount
    Advertising Expense 1,505 amount
    Property Tax Expense 900 amount
    M Sterling, Drawing 1,000 amount
    Supplies 520 amount

    I got a debit balance of $2000.
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #5

    Mar 23, 2009, 06:28 PM

    Your Debits and Credits should Equal 24,410

    See attached Excel file
    Attached Files
  1. File Type: xls Trial Balance.xls (20.0 KB, 371 views)
  2. firelilly568's Avatar
    firelilly568 Posts: 2, Reputation: 1
    New Member
     
    #6

    Feb 2, 2011, 07:04 PM
    Do you guys have the answer for this? The correct balance should be 24,930. I got the debit side to balance but not the credit side. Can you walk me through this? I included my numbers belows
    Trial Balance
    Account Name
    Cash 6,565 Dr
    Accounts Receivable 2,570 Dr
    Prepaid Insurance 800 Dr
    Supplies 520 Dr
    Equipment 7,480 Dr
    Accounts Payable 4,610 Cr
    Property Taxes Payable 560 Cr
    M Sterling, Capital 12,700 Cr
    M Sterling, Drawing 1,000 Dr
    Service Revenue 6,960 Cr
    Salaries Expense 4,400 Dr
    Advertising Expense 695 Dr
    Property Tax Expense 900 Dr
    Total 24,930 (Debit) 24,830 (Credit)
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #7

    Feb 3, 2011, 01:35 PM

    This is a duplicate post and I posted a corrected explanation and a corrected Excel file in response to your other post in the Business & Careers Accounting thread.

    I guess when I worked on it before I did not have my coffee yet, or my Wheaties (lol).

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 & Post Close Trial Balance [ 5 Answers ]

I’m struggling with both trial balance and post close trial balance. From my understanding the post trial balance should include all items that would show on the balance sheet right? It would show total assets and total liabilities right? The assets and expenses would be under debit and...

Correcting a trial balance [ 5 Answers ]

I seem to be having trouble correcting a trial balance. Please help. Thanks. Question 1: A debit posting to Wages Expense of 670 dollars was omitted. So do I now credit or debit Waged Expense? Question 2: A payment of 65 dollars for telephone charges was recorded as a debit to Office...

Cannot figure out how to balance an unadjusted trial balance. [ 1 Answers ]

I am trying to balance an unadjusted trial balance and I can't. I have been given the answer as to how much my totals should be, and my credits are right, but I cannot figure out where I went wrong on the debit side. I am over by $44. I have a transaction in the form of sales discounts for $44, but...

Is there a simplified explanation of how to figure an adjusted trial balance? [ 1 Answers ]

In working on a 10 Column worksheet with adjustments, I seem to be having difficulty figuring out where exactly the adjustments go, and how to find the depreciation expenses and accumulated depreciation. I also cannot seem to separate the two. Any help whatsoever would be amazing.


View more questions Search