Sign Up for Discounts
This form does not yet contain any fields.
    Monday
    Jan072013

    What is a trial balance worksheet?

    A trial balance worksheet is a multi-column spreadsheet that contains the ending balances of all of the general ledger accounts of a business. It is generally structured as an electronic spreadsheet, into which accounting ending balances are manually entered from the general ledger. The spreadsheet may contain pre-set subtotal and total formulas, which are useful for aggregating the account information into financal statements.

    The worksheet is still occasionally used when a business wants to adjust its accounts at the end of an accounting period and produce financial statements. However, the spreadsheet is much more likely to be used when a business does not have accounting software (which can produce the same information much more easily). Thus, the trial balance worksheet is primarily found in situations where accounting records are kept manually.

    The one situation in which a trial balance worksheet may be found even in a computerized accounting environment is when the financial results of multiple entities are being combined; the spreadsheet format makes it easier to see the consolidating entries.

    The key columns in a trial balance worksheet are:

    1. Column 1 contains the account number of every account that has a balance. The accounts are almost always listed in ascending numerical order, which usually means that the order of priority in the spreadsheet is assets, then liabilities, then equity accounts, then revenue, and then expense accounts.
    2. Column 2 contains the account description associated with each account number.
    3. Column 3 contains the ending debit balance in each account. If the balance is instead a credit balance (which is likely for liability, equity, and revenue accounts) then it appears in Column 4.
    4. Column 4 contains the ending credit balance in each account. If the balance is instead a debit balance (which is likely for asset and expense accounts) then it appears in Column 3.
    5. Columns 5 and 6 include any adjustments to the debit and credit balances in Columns 3 and 4. These adjustments are typically for such matters as accrued expenses, or deferring expenses by shifting them into asset accounts.
    6. Columns 7 and 8 contain the final adjusted debit (Column 7) and credit (Column 8) account balances. These two columns are known as the adjusted trial balance.
    7. Additional columns may be added in which to carry forward revenue and expense balances to create an income statement. In addition, there may be additional columns in which asset, liability, and equity accounts are carried forward to create a balance sheet.

    In short, the trial balance worksheet is useful for converting ending account balances into financial statements, if there is no accounting software on hand that can accomplish this task automatically.

    Similar Terms

    A trial balance worksheet is also known as a trial balance sheet.

    Related Topics

    The trial balance 
    Trial balance errors 
    What is a post-closing trial balance? 
    What is a working trial balance? 
    What is an adjusted trial balance? 
    What is an extended trial balance? 
    What is an unadjusted trial balance? 

    PrintView Printer Friendly Version

    EmailEmail Article to Friend

    Reader Comments

    There are no comments for this journal entry. To create a new comment, use the form below.
    Editor Permission Required
    You must have editing permission for this entry in order to post comments.