What is a Trial Balance Worksheet?

A trial balance worksheet is a multi-column spreadsheet that contains the ending balances of all general ledger accounts used by a business. The 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.

The worksheet 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 financial 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.

Related AccountingTools Courses

Bookkeeping Guidebook

Closing the Books

The Year-End Close

Contents of the Trial Balance Worksheet

The key columns in a trial balance worksheet are as follows:

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.
Column 2 contains the account description associated with each account number.
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.
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.
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.
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.
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.

Advantages of Using a Trial Balance Worksheet

There are several advantages associated with using a trial balance worksheet, which are as follows:

Error detection. The trial balance worksheet ensures that the total debits equal the total credits, helping identify mathematical errors or omissions in ledger entries. Errors can be traced and corrected before preparing formal financial statements, reducing the risk of inaccuracies.
Facilitates adjustments. The worksheet allows accountants to review the unadjusted trial balance to ensure that all entries are complete and accurate. It also provides a structured format for recording adjusting entries, such as accruals, deferrals, and depreciation, before finalizing the financial statements.
Simplifies financial statement preparation. A trial balance worksheet organizes account balances, making it easier to transfer information to financial statements like the income statement, balance sheet, and cash flow statement.
Increased efficiency. With a centralized document, accountants can quickly review account balances, adjustments, and the resulting financial positions. Further, by identifying and resolving issues early, it minimizes the need for rechecking or recalculating financial records.
Improves accuracy. The worksheet serves as a checklist to confirm all accounts have been included in the financial statements.
Aids auditors. The worksheet provides a clear record of adjustments and balances, facilitating external audits.

In summary, a trial balance worksheet is an indispensable tool for maintaining accuracy and streamlining processes, making it a cornerstone of effective accounting practices.

Trial Balance Worksheet Best Practices

The main best practice for using a trial balance worksheet is to fully document each of the adjusting entries, with an identifying number next to each one. Otherwise, it can be difficult to ascertain why an adjustment was made to the worksheet. This is a particular concern when there are many adjusting entries.

A good best practice when combining the results of multiple entities onto a trial balance worksheet is to ensure that they all have consistent account codes and account titles. Doing so makes it easier to ensure that accounts are classified properly for the combined entity.