Adjusted Trial Balance Worksheet Template. This form gives you the column headings and lines for you to list your organization's general ledger account balances, any needed adjusting entries, and the resulting adjusted balances. It shows the balances of all accounts, including those adjusted, at the end of the accounting period.
With an adjusted trial balance, necessary adjusting journal entries are incorporated in the trial balance. All account names are written in the first column, the debit What about the worksheet; doesn't this allow you to come up with the information? Then prepare a three column worksheet.
The file contains a Microsoft Excel.
The adjusted amounts can then be inserted into the appropriate income statement and balance sheet columns.
Since it is a spreadsheet template, you can add or delete accounts or otherwise modify it to suit your needs and preferences. How to find the Adjusted Trial Balance of the worksheet. In the above example, unrecorded liability related to unpaid salaries and unrecorded revenue amount has been included in the adjusted trial balance.