How Do You Prepare An Accounting Worksheet?
Accountants often use worksheets as a preliminary step to preparing the financial statements and consolidating a great deal of information. The worksheet is a tool for creating a trial balance and an adjusted trial balance. It uses all of the accounts contained in the company’s accounting records, records adjusting entries and calculates the final numbers to enter on the financial statements. Creating a worksheet is an optional step and is most often used in manual accounting systems. A worksheet may be used as an analysis tool in a computerized or manual accounting system. Format the worksheet. Starting at the first line near the top right of the page, list each of the accounts from the company’s complete chart of accounts. The next column is considered the first column of the worksheet. Label the first and second columns “Trial Balance.” Label the third and fourth columns “Adjustments.” Label the fifth and sixth columns “Adjusted Trial Balance.” Label the seventh and eighth columns “
