An accounting worksheet is a document used within the accounting department to analyze and model account balances. A worksheet is useful for ensuring that accounting entries are derived correctly. Several examples of accounting worksheets are as follows:
- Trial balance adjustments. The unadjusted trial balance for a reporting period is exported from the accounting software into a spreadsheet, and then adjusted in the spreadsheet to determine the effects of possible adjusting entries. If the outcome is correct, the entries are then input into the general ledger.
- Account balances. An accountant may maintain a detailed listing in a worksheet of the contents of each balance sheet account. If a worksheet total does not match the account balance to which it is linked, it may be necessary to adjust the balance of the account. These worksheets may be provided to the auditors as part of the annual audit, as evidence that the balance sheet accounts are correct.
Accounting worksheets may contain errors or formula inaccuracies, since they are separate from the accounting database and are manually maintained. Consequently, it is necessary to review them carefully before relying on their summary totals.