Trial Balance Worksheets - BC Bookkeeping Tutorials|dwmbeancounter.com

Title
Go to content

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  / DescriptionTrial Balance

DebitCredit



  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  / DescriptionTrial Balance Adjustments Adjusted Trial Balance

DebitCreditDebitCreditDebitCredit







  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  / DescriptionAdjusted Trial Balance Closing EntriesAfter Closing Trial Balance

DebitCreditDebitCreditDebitCredit







  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
Back to content