0
Start with the Heading. There are three lines in the heading, the name of the company, the title of the report which is "worksheet", and the tag "For the Year Ended and then the ending date. List all the accounts on the accounts column. All the accounts entered in the trial balance and the accounts appeared in the adjustments. Then write the following Column Titles: Trial Balance - 1st two columns, Adjustments 3rd & fourth column; Adjusted Trial Balance - 5th & 6th columns; Income Statement on the 7th & 8th columns; and Balance Sheet for the 9th & 10th column. Then list all the debit and credit amount on their respective columns. The Trial Balance coming from the Trial Balance report. The adjustments coming from the different accounts that need to be adjusted (e.g. accruals, prepaid expense, unearned income, depreciation and bad debts) The Adjusted Trial Balance - by just combining the first two columns the Trial Balance and Adjustments to fill-up this column. Example: If there is an amount on both Trial Balance and Adjustment columns you need to get the sum of the two amount - if the amount is on the same side (both debit or both credit) otherwise get the difference. If only one of the two mentioned columns has an amount, just copy that amount on the Adjusted Trial Balance. For the Income Statement Column, enter all amounts under the accounts of revenues and expenses then the rest should be entered under the balance sheet column. Get the total of all the debit and credit of the different columns. Add an amount either on the debit or credit of the Income Statement to make both sides equal. Do the same with the Balance sheet column. Identify this added amount either as Net Income or Net Loss and write it under the Account Column below the first total.
Wiki User
∙ 15y ago
Wiki User
∙ 11y agoList the steps in preparing a 10-column worksheet?
a. the first we must have information about
-trial balance
-adjusting
-adjusting trial balance
-income statement
-balance sheet
Add your answer:
Earn +20 pts
How do you keep the title and column labels of a worksheet on the screen no matter where the worksheet is scrolled?
how do you keep the title and column labels of a worksheet on the screen no matter where the worksheet is scrolled
How does an 8-column worksheet differ from a 10-column worksheet?
An 8-column worksheet is standard for the following: Unadjusted Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, and Balance Sheet. The 10-column worksheet has an extra two columns for the Post-Closing Trial Balance.
Can you have two different column widths on one excel worksheet?
Yes. Every column on the worksheet can have a different width, if you like.
What is used to add worksheet column and row titles on a worksheet in excell?
Text
What is a vertical arrangement of information on a worksheet?
column
What would happen if you autosum the width of column A after you entered the worksheet title?
AutoSum has nothing to do with column width or a worksheet title, so nothing significant.
Does a worksheet column heading start with 1 and appear down the left side of a worksheet?
No, column headings start with A and go across the worksheet. The row headings start with 1 and go down the left.
What is a column of data in a worksheet called?
It is called a column. There is no other official special name.
What is the place where a row and column in a worksheet cross is?
A Cell.
What is another term for worksheet?
The interserction of a column and a row
What is the intersection of a row and a column in a worksheet called?
The intersection of row and column is called a cell.
What do you call a vertical group of cells in a worksheet?
microsoft excel
