By Carol Wiley, Accountingedu contributing writer
Updated April 2013
Accountants use an accounting worksheet to compile, organize, and structure data from the ledger accounts onto one page. In the past, worksheets were constructed on basic ruled paper, but today worksheets are prepared mostly using spreadsheet software.
Worksheets aren't formal documents and are an optional intermediary step for preparing financial statements. Accountants generally prepare worksheets at the end of an accounting period to make sure the books are balanced and to pull together information for the financial statements.
Although the structure of a worksheet can vary, depending on the purpose for which the accountant is preparing the sheet, the traditional accounting worksheet usually has a far left column that contains a list of all the open accounts, plus five pairs of debit and credit columns. One pair at a time would be completed, from left to right.
If the worksheet contains the third, adjusted trial balance column, the accountant can take the numbers from that third column and enter them in the appropriate place in either the fourth or fifth column.
After completing the fourth and fifth columns, the accountant finds the sum totals of the columns. In the income statement columns, if total credits are more than total debits, there’s net income. The accountant then adds the net income number to the debit column for the income statement and to the credit column (representing an increase in owner's equity) for the balance sheet.
If the income statement column shows total debits more than total credits, there’s a net loss. The accountant then adds the net loss number to the income statement’s credit column and to the balance sheet’s debit column.
The worksheet is now complete and can be used to prepare financial statements.