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

    May 5, 2009, 09:11 PM
    How to do Balance sheet in account format
    Hi Guys,

    I have this difficult homework, the teacher ask me to to do the Balance sheet in account format. I tried many times, but I got lost and end up with unbalance number:( PLEASE HELP ME...

    This is the description:

    Cash $5670
    A/R $37100
    Inventory $60500
    Supplies $ 3930
    Prepaid rent $ 6000
    Furniture $ 26500
    Accumulated depreciation $21200
    A/P $46340
    Unearned sales revenue $3500
    Notes payable-long term $35000
    Capital $23680
    Withdrawal $48000
    Sales revenue $$346700
    Sales discount $ 10300
    Sales return & allowance $ 8200
    Purchases $175900
    Purchase discount $ 6000
    Purchase return and allowance $ 7430
    Freight in $9300
    Salary expenses $ 82750
    Rent expenses $7000
    Utility expenses $ 5800
    Interest expenses $ 2900

    Thank you so much for the result...

    Bizou
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #2

    May 5, 2009, 10:09 PM

    Difficult for you, easy for me.
    Due to the rules here, I really cannot do your homework for you.
    SORRY!
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #3

    May 6, 2009, 01:05 AM

    We don't do your homework for you... that is, we're not going to give you the "result" you want, but if you will show the work you did to get that unbalanced number, then we can see where you've gone wrong.
    akbizou's Avatar
    akbizou Posts: 2, Reputation: 1
    New Member
     
    #4

    May 6, 2009, 07:13 AM

    This what I did:
    On Asset:
    I put: Cash, A/R, Inventory, Supplies, Prepaid rent, Furniture, Accumulate depreciation, and capital.

    On Liabilities:
    I put:
    A/P, Long term notes payable, salary, rent expense, utility and interest.

    The numbers are not balance. Is there anything I need to add on each section?

    Thnk in Advance

    Bizou
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #5

    May 6, 2009, 06:45 PM

    akbizou,

    You are far from being correct.
    It would appear that you are tackling a problem far ahead on what you have reached in accounting.

    Let me start you , pace by pace.

    You need to do this as I suggest.

    Mark each item as to whether it is a DEBIT OR a CREDIT.

    Cash $5670***DR
    A/R $37100***DR
    Inventory $60500
    Supplies $ 3930
    Prepaid rent $ 6000
    Furniture $ 26500
    Accumulated depreciation $21200***CR
    A/P $46340
    Unearned sales revenue $3500
    Notes payable-long term $35000
    Capital $23680
    withdrawal $48000
    Sales revenue $$346700
    sales discount $ 10300
    sales return & allowance $ 8200
    purchases $175900
    purchase discount $ 6000
    purchase return and allowance $ 7430
    freight in $9300
    salary expenses $ 82750
    Rent expenses $7000
    utility expenses $ 5800
    interest expenses $ 2900

    _____________________________________
    Just to help you:-

    All assets and all expenses are DEBITS.
    All liabilities and all incomes and all EQUITY
    are CREDITS.
    This is the Accounting Formula.=
    A + E = L + I + EQUITY.

    ------------------------------------------------------

    When you total all the Debits and all the Credits in separate columns , you find that they should be equal.
    Try and see how you go.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #6

    May 6, 2009, 09:37 PM

    The original accounts given already balance. While you do need to know debits & credits, I don't see what that has to do with doing financial statements, nor does it have to do with the errors that you are making. (There isn't anything here that shows us your knowledge of debits & credits, but most people could use some review in that area.)

    You need to learn what the five classifications of accounts are and which accounts belong in each category. And you need to know which accounts go on which financial statement.

    The five classifications:
    Assets - stuff you own or have some kind of claim on
    Liabilities - what you owe or have an obligation to
    Equity - net worth of the company (and therefore net amount the owner has in the company)
    Revenue - what you earn
    Expenses - services done for you or the use of assets

    Those are the quickie definitions. The accounts are already in order.

    What you have in assets ia almost correct. Notice that you've just copied them off the list, right in order from the top, which is exactly where assets ought to be. Except it doesn't include capital. Capital is just a net worth - it's not a thing. Since assets are first, followed by liabilities, once you hit the liabilities, you're done with assets and need to move to the next section. As you see, capital is several accounts down.

    But the liabilities are pretty messed up. You've included a lot of expenses in there - those aren't liabilities. For instance, salaries expense is the amount the employees have earned for their work - not how much your owe them. If you still owed them, it would be salaries payable.

    You also cannot do a balance sheet first. You must do the income statement so you have net income, and then do a statement of owner's equity to update that account, and then you can do your balance sheet. So that's part of the problem also.

    Your text should have examples of these. Go look these up and study them and see if you can fit these accounts in with the examples. (Keep in mind they won't have the same accounts, but also keep in mind the accounts are in order so you've already got a headstart right there.)

    Considering that you're into merchandising at these point, everything I said above is a few chapters back. These concepts aren't going away, so if you need to, go back and review earlier chapters, like probably the first chapter which should give the basic types of accounts and what they are, and should present simple financial statements. An income statement for a merchandising company has more stuff, but should be in the merchandising chapter.

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!

Closing stock in trading account and balance sheet [ 1 Answers ]

Why Should Closing stock appear in trading account and balance sheet ? Is this the only double entry?


View more questions Search