How to Prepare a Trial Balance? - QS Study
QS Study

A trial balance is prepared at the end of each reporting period. This is done in order to aggregate accounting information for inclusion in the financial statements.

 

To prepare a trial balance, follow these steps:

  • Create an eight-column worksheet, with column headers for the account number, account name, debit total, and credit total. These cover the initial entries into the spreadsheet. We will add the remaining column titles later.
  • For each general ledger account, summarize the account balance so that there is a single ending account balance that is either a debit or a credit.
  • Beginning with the first account in the general ledger, transfer to the trial balance worksheet the account number and account name. If the ending balance in the account is a debit, enter this amount in the debit column for that account. if the ending balance is a credit, enter this amount in the credit column for that account.
  • Add up the amounts in the debit column and add up the amounts in the credit column. The totals should match. If not, either an account balance was not transferred over to the trial balance, or it was carried forward incorrectly, or the general ledger is incorrect. Fix these issues before proceeding.
  • Add titles to the fifth and sixth columns of the worksheet, which are for adjusting debits and adjusting credits. Use these columns to enter any adjusting entries. These adjustments are usually for accrual entries to either defer or accelerate the recognition of expenses.
  • Add titles to the seventh and eighth columns of the worksheet, which are for the final debit totals and final credit totals. The entries in this column are the original debits and credits, plus or minus the adjusting entries.
  • Add up the amounts in the final debit column and add up the amounts in the final credit column. The totals should match. If not, an adjusted account balance was not carried forward correctly. Fix these issues before proceeding.

 

The trial balance is now ready for use in the preparation of financial statements. It is quite possible that the preliminary financial statements that are derived from this trial balance will require further adjustments, in which case the additional changes are made to the adjusting entry columns, and new financial statements are created.

A trial balance is not needed in a computerized accounting system, since the software automatically prepares the financial statements from the information in the general ledger; there is no intermediate step to also prepare a trial balance.