Trial Balance Worksheets

Worksheets-Financial Statements

Trial Balance Worksheet

Let's discuss the Layout and what information is included in this worksheet.

Heading Area

Name of the Company
Title/Description of the Worksheet
Period Ending Date

Columns

Name and/or Number of Account and Other Descriptions
Trial Balance Column with Debit and Credit Columns - These unadjusted account balances for the debit and credit columns are taken directly from your General Ledger.

Totals are included in the Worksheet in order to prove the accuracy of our postings. They prove that our debit balances actually do equal our credit balances.

Sample Trial Balance Worksheet

Shabby Computer Systems
Trial Balance Worksheet
December 31, xxxx
Account Name / Description	Trial Balance
	Debit	Credit

Totals

Use: Worksheet used for checking that Debit Balance Accounts equal Credit Balance Accounts

Adjusted Trial Balance Worksheet

Let's discuss the Layout and what information is included in this worksheet.

Heading Area

Name of the Company
Title/Description of the Worksheet
Period Ending Date

Columns

Name and/or Number of Account and Other Descriptions
Trial Balance Column with Debit and Credit Columns - The unadjusted account balances for the debit and credit columns are taken directly from your Trial Balance Worksheet.
Adjustments Column with Debit and Credit Columns - The debit and credit amounts entered in these columns are obtained from a review of your business activities to determine if any transactions have not been accounted for.
Adjusted Trial Balance Column with Debit and Credit Columns - This column is a calculated by taking the balance in the Trial Balance Column and adding or subtracting the debit and/or credit adjustments in the Adjustments Column to arrive at the Adjusted Trial Balance Amount.

Totals are included in the Worksheet in order to prove the accuracy of our postings. They prove that our debit balances actually do equal our credit balances.

Sample Adjusted Trial Balance Worksheet

Shabby Computer Systems
Adjusted Trial Balance Worksheet
December 31, xxxx
Account Name / Description	Trial Balance		Adjustments		Adjusted Trial Balance
	Debit	Credit	Debit	Credit	Debit	Credit

Totals

Use: Worksheet used for entering Adjusting Entries

After Closing Trial Balance Worksheet

Let's discuss the Layout and what information is included in this worksheet.

Heading Area

Name of the Company
Title/Description of the Worksheet
Period Ending Date

Columns

Name and/or Number of Account and Other Descriptions
Adjusted Trial Balance Column with Debit and Credit Columns - The Adjusted Account Balance amounts for the debit and credit columns are taken directly from your Adjusted Trial Balance Worksheet.
Closing Entries - The debit and credit amounts entered in these columns are the amounts needed to zero out the revenue and expense accounts.
After Closing Trial Balance - This column is a calculated by taking the balance in the Adjusted Trial Balance Column and adding or subtracting the debit and/or credit closing entry adjustments in the Closing Entries Column to arrive at the After Closing Trial Balance Amounts.

Totals are included in the Worksheet in order to prove the accuracy of our postings. They prove that our debit balances actually do equal our credit balances.

Sample After Closing Trial Balance Worksheet

Shabby Computer Systems
After Closing Trial Balance Worksheet
December 31, xxxx
Account Name / Description	Adjusted Trial Balance		Closing Entries		After Closing Trial Balance
	Debit	Credit	Debit	Credit	Debit	Credit

Totals

Use: Worksheet used for entering closing entries

Well, it's nice to see what the Worksheets look like and what they're used for; but, where do the amounts come from ?

You've probably heard the expression "hold your horses", well it applies now. Later lessons will hopefully answer your questions.

What's Next ?

Formal Financial Statements