Ask Experts Questions for FREE Help !
Ask
    Peachey's Avatar
    Peachey Posts: 99, Reputation: 1
    Junior Member
     
    #1

    Jun 30, 2009, 12:41 PM
    Worksheet Adjustments Corrections
    Hi! We have tried and tried and we came up with this, I know some of the entries are incorrect and some we can't get out, please someone help us. This is as far as we can reach. Please show the calculations: confused:

    Enter the prepaid, inventory and accrual adjustments, extend the adjusted balances to the adjusted trial balance, income statement, & balance sheet, compute the net profit.
    A.. Bad Debt Expenses--$118... E.. . Depreciation Expense
    B.. March 31,2009 Physical Inventory... Store Equipment--$1,350
    Merchandise --$21,056... Office equipment--738
    Store Supplies--1,136... Building--8,122
    Office Supplies--492

    C.. Insurance Expense... F.. Payroll Tax Expenses for end of the period
    Store--$753... Store--$43
    Office--441... Office--42

    D.. Property tax Expense... G.. Payroll Expenses for the end of the period
    Store 1,356... Store--$570
    Office--486... Office--319
    Attached Files
  1. File Type: xls Worksheet Calculations.xls (25.5 KB, 392 views)
  2. morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #2

    Jul 3, 2009, 02:45 AM

    A. Correct.
    B. Inventory. The closing out of the beginning balance also goes through the rev/exp summary. The balance in that account will be the difference between the beginning & ending balances. That difference, combined with the purchases & such will end up creating cost of goods sold. (It's a little odd & you need not concern yourself with how that works out on the worksheet.)
    B. Supplies. I've never seen this done this way though it could work. If there's 1136 left, then you've used 461. All you need to do is credit 461 out of supplies & debit it into supplies expense. That's how much was used and therefore is how much is expensed. Perhaps you were taught this method but it seems a little long and unnecessary. Ditto the other supplies. (That method is used for inventory for a different reason.)
    C, D, E Correct
    F & G - I suspect both the payroll and the payroll tax are being lumped into the "store payroll" and "office payroll" accounts.

    As to some of the adjusted balances. Apparently the accumulated depreciation for the building had no prior balance. You can't put a ? In there since that would have come straight from the ledgers, and it does balance at the bottom, meaning there was nothing there. It has a 0 balance. (Meaning it was purchased this year & had no prior depreciation done.) So zero + 8122 equals what?

    Store & office supplies: if we assume you're even supposed to do these this way, think t account. If you had a debit balance, put in another debit, and then put in a credit, how would that balance out? It's not more complicated because you have both a debit & credit adjustment. We put lots of debits & credits through a lot of accounts (like cash), and we total (foot) the debits, total the credits, and subtract those two.
    Peachey's Avatar
    Peachey Posts: 99, Reputation: 1
    Junior Member
     
    #3

    Jul 3, 2009, 07:05 AM

    Thank you I got it out except for the capital what is the formula to calculate that.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #4

    Jul 3, 2009, 11:07 PM

    Hmm... never seen a post-closing T/B on a worksheet before. Capital is beginning balance plus any investments, plus net income (or minus net loss), minus withdrawals.

    Essentially on a worksheet, it would be everything that comes below the capital account, all netted out and combined in with capital. Think about that. :-)
    Janelle101's Avatar
    Janelle101 Posts: 60, Reputation: 1
    Junior Member
     
    #5

    Jul 4, 2009, 05:53 AM

    Thank you very much you are the best.
    Capital is $100,207.00
    You learn something new everyday.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #6

    Jul 4, 2009, 01:05 PM

    You're welcome. :-)

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!

How do you find the numbers for the adjustments column on a accounting worksheet [ 4 Answers ]

How do you find the numbers for the adjustments column on a accounting worksheet

How to make adjustments on a worksheet [ 1 Answers ]

If fees earned totals $14400 and fees earned but unrecorded and collected at the end of the accounting period are $408, what do I credit and what do I debit?

Corrections needed [ 2 Answers ]

Can some one please correct this for me? Please make sure that I used all the rules of grammar, spelling, and punctuation People have argued and suggested that using word processor on ones computer is fare more advanced, rather then using a pencil and paper. Word processor and hand writing...

Adjustments for worksheet [ 1 Answers ]

I am trying to do some adjustments and just want to know if I'm doing them right or if things need to be changed... a). Supplies available at end of fiscal year had cost of 3200. Unadjusted supplies is 8900 so I subtracted the two and got a debit to supplies expense for 5700 and credit...


View more questions Search