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

    Jan 10, 2010, 03:27 PM
    How to figure out owners capital on worksheet if unknown
    No information was give as to what the owner capital was. I did have a owner withdrawal but I am know doing the worksheet and can't figure this out help!
    Trial Balance
    Account Debit Credit
    Cash 135,911
    Accounts receivable 18,200
    Merchandise inventory 189,519
    Office supplies 0
    Store supplies 0
    Prepaid insurance 2,765
    Office equipment 25,690
    Accum. Depr. office equip. 10,227
    Store equipment 38,920
    Accum. Depr. store equip. 18,123
    Accounts payable 53,059
    J. Colo, Capital
    J. Colo, Withdrawals 7,000
    Sales 0
    Sales discounts 0
    Sales returns and allowances 0
    Cost of goods sold 0
    Depr. Expense, office equip. 0
    Depr. Expense, store equip. 0
    Office salaries expense 0
    Sales salaries expense 0
    Insurance expense 0
    Rent exp. office space 0
    Rent exp. selling space 0
    Office supplies expense 0
    Store supplies expense 0
    Utilities expense 0
    Totals
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #2

    Jan 10, 2010, 04:59 PM

    There's really insufficient information because what you're describing cannot be the case. If you were to the worksheet you would have balances in all those revenues and expenses.

    My suspicions are that you are not to a worksheet, but that rather this is balances being carried over from a prior period, which contains a missing number. All you have to do is total the two columns, which should be equal, and find out how much is missing in the credit column.
    accounting10's Avatar
    accounting10 Posts: 3, Reputation: 1
    New Member
     
    #3

    Jan 10, 2010, 05:18 PM
    Quote Originally Posted by morgaine300 View Post
    There's really insufficient information because what you're describing cannot be the case. If you were to the worksheet you would have balances in all those revenues and expenses.

    My suspicions are that you are not to a worksheet, but that rather this is balances being carried over from a prior period, which contains a missing number. All you have to do is total the two columns, which should be equal, and find out how much is missing in the credit column.
    Okay this is what was on the worksheet unadjusted trial balance as I begin to start I on the general ledger the balance from the previous month was 308085. On the ledger I was to make posts from the General journal income summary section but I can't even began to explain how to do that either. Any suggestions
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #4

    Jan 10, 2010, 07:23 PM

    I can't make any sense of what you're doing. An unadjusted trial balance on a worksheet would have revenues and expenses on it. An unadjusted trial balance is done at the end of an accounting period, after all regular entries have been made (meaning those revenue & expense accounts would have balances in them), but before adjusting entries are done.

    So that is absolutely NOT an unadjusted trial balance.

    After closing is done, then you would end up with something that looks like what you have. That is after all the adjustments are done, financial statements, etc. -- all the period-end processes that go on. Then everything is closed out and it looks like your trial balance. That is then carried into the next month as a beginning trial balance. That isn't the same as an "unadjusted" trial balance.

    Posting is posting is posting. Posting an income summary entry is no different than posting anything else. I don't see how you can be posting an income summary entry when your trial balance has nothing in it to even close. It looks like one that has already been posted. That is, it's reflecting a closing that's already been done, which cannot be the case if you haven't posted the closing entries yet. So that makes no sense.

    If you just total the debit & credit columns like I said in the other post, you will find the missing number is 389,655. That does not match the 308,085 from the previous month. This means that your trial balance there CANNOT be carried over from the previous month. That, however, means that it's not a beginning trial balance for this month. Or that the 308,085 is not correct and I really don't know where you got that from.

    So in the end, I have no idea what you are trying to do. Nothing meshes, and what you're saying and what you're showing me don't match up.
    accounting10's Avatar
    accounting10 Posts: 3, Reputation: 1
    New Member
     
    #5

    Jan 10, 2010, 08:52 PM

    Geez I guess I am so overwhelmed by this problem. Do you have any email address that I could send the information as it appears in the spreadsheet. I don't know what I am doing here and I need some kind of help to gauge me in figuring this out. The excel spreadsheet won't fit on this page and it would just be better for me to send you the information if you are willing, since you seem pretty knowledgeable.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #6

    Jan 11, 2010, 03:39 AM

    You can attach the Excel spreadsheet. Click on the "go advanced" button. I don't give out my email.

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!

Journal Entry for fixed asset paid via owners capital [ 3 Answers ]

I have a question about how to log a journal entry. I have a piece of furniture that I want to enter as a fixed asset. It was paid by owners capital/investment. Would this be a double journal entry? What are my dr/cr entries? Thanks!

Fashion figure n normal figure [ 2 Answers ]

What is the difference between a fashion figure and a normal figure.

Trial balance worksheet, adjustments and Adjusted Trial Balance Worksheet [ 1 Answers ]

Can anyone please send me a worksheet of trial balance, adjustments and adjusted trial balance

Capital figure in Balance sheet [ 1 Answers ]

I have encountered a problem in understanding a balance sheet. A private limited company with only one shareholder was registered 6 years ago with authorized capital of INR 500,000.00. Now in the year end figure of 2008, the balance sheet reflects 'Capital Investment" as INR 3,000,000.00. Isn't...


View more questions Search