Log in

View Full Version : How do I prepare a 10-column work sheet?


mindcandy76
Jul 20, 2008, 07:56 PM
I have to do a work sheet starting with an unadjusted trial balance and including adjustments. I have no clue where to start or how to do it on excel can anyone please point me in the right direction for some help and maybe some websites that can help??

Criado
Jul 20, 2008, 08:44 PM
The first column in excel is the account title

For the second and third column, unadjusted trial balance (debit and credit)

For the fourth and fifth column, adjustments (debit and credit)

For the sixth and seventh column, adjusted trial balance (debit and credit)

For the eighth and ninth column, balance sheet (debit and credit)

For tenth and eleventh, income statement (debit and credit)

http://img329.imageshack.us/img329/8176/worksheetnc9.th.png (http://img329.imageshack.us/my.php?image=worksheetnc9.png)