I've got a question that ask you to prepare a 10 column work sheet based on the information given, the things I'm confused about is the stock section

the business was brought in 1/06/08 with promotional material supplies $550
on 4/06/08 purchase promotional materials $346
on 15/06/08 purchase promotional materials $479

the end of the year (30/06/09) closing stock of promotional materials is $910

in the 10 column worksheet there is an item called "Cost of goods sold", do I need to calculate the cost of goods sold and show it on trial balance or adjustments? Or I just need to show it on P/L and B/S statement? And the cost of goods sold should be $550+$346+$479-$910 = $465?

I'm a little confused. Having pertinent info from the problem is useful.

Is the company selling these promotional materials? Is this merchandise inventory? Or is this like supplies, something they are just using themselves.

If it's selling, what method are you using, perpetual or periodic?

Little difficult to answer if we don't know what they're doing with the promotional materials.

The company is real estate agent, so it is just a supply, they are not selling these

Well, if this is supplies, then it doesn't have anything to do with cost of goods sold. Cost of good SOLD is the cost of what is SOLD. They aren't related to things the company uses for itself, only for sales.

Your math is correct. That is the amount of the supplies that was used. The entry for used supplies is to debit Supplies Expense and credit Supplies. By doing that you are removing the used portion out of the Supplies account, and then the used portion also now gets expense, cause, well, it's used.

Don't assume that any adjustment needs made to COGS. Actually, I'm not quite sure why a real estate company would have such an account. Their revenue is from commissions on sales, not from selling the stuff themselves. They could have "cost of revenue" or something like that, but not cost of GOODS sold, cause they aren't selling any goods.

Thank you very much for explanation

You're welcome.

TRIAL BALANCE June 30 2011
Debit Side: Cash 15000 A/c receivable 28000 opening inventory 32000 building 300000 machinery 140000 purchases 275000 salaries 95000 operating expense 35000 administrative expense 28000

Credit Side: share capital 300000 retained earning 39000 a/c payable 18000 long term loan 100000 sales ravenue 485000 security deposit for sale 6000

Other Data :
1. depreciation on building and machinery was $15000 &$ 14000 respectively deprecation is charged on reducing balance method.
2.interest on long term loan is 10% per annum.
3. income tax paid is $5000 for the year
4. closing stock at June 30,2011 was $38000

Required: profit loss account and balance sheet

Here are your steps for this problem:
1. Set-up a trial balance.
2. Do your adjusting entries for items 1 thru4.
3. Do an adjusted trial balance.
4. Do an income statement and balance sheet.

For steps 1 through 4 use a Worksheet.