Home » Bookkeeping articles » Trial balance worksheet definition

Trial balance worksheet definition

August 11, 2023
Bill Kimball

Accountants use a trial balance to test the equality of their debits and credits. A trial balance is a listing of the ledger accounts and their debit or credit balances to determine that debits equal credits in the recording process. Preparing and adjusting trial balances aid in the preparation of accurate financial statements. Although you can prepare a trial balance at any time, you would typically prepare a trial balance before preparing the financial statements. Accounts within an accounting system are generally categorized in specific accounts with a parent account such as an asset.

order of trial balance

A transposition error occurs when two digits are reversed in an amount (e.g. writing 753 as 573 or 110 as 101). A slide error occurs when you place a decimal point incorrectly (e.g. $ 1,500 recorded as $ 15.00). Thus, when a difference is divisible by 9, compare the trial balance amounts with the general ledger account balances to see if you made a transposition or slide error in transferring the amounts. When the trial balance does not balance, try re-totaling the two columns. If this step does not locate the error, divide the difference in the totals by 2 and then by 9.

Explore the types of accounts in accounting and see the characteristics of these account categories. I wanted to really thank you as well for the time and effort you have put into these videos. I textbook I have for this course is so dry and after watching your videos all the concepts have become so much more clear for me.

Three columns are used to display the account names, debits, and credits with the debit balances listed in the left column and the credit balances are listed on the right. An adjusted trial balance is a listing of all company accounts that will appear on the financial statements after year-end adjusting journal entries have been made. You might be wondering why it is such a big deal to organize the trial balance in this manner.

Related Videos:

It is also important to note that even when the trial balance is considered balanced, it does not mean there are no accounting errors. For example, the accountant may have failed to record an account or classified a transaction incorrectly. These are accounting errors that would not show up in the trial balance. Businesses prepare a trial balance regularly, usually at the end of the reporting period to ensure that the entries in the books of accounts are mathematically correct. The trial balance is the first step toward recording and interesting your financial results. Preparing the trial balance perfectly ensures that the final accounts are error-free.

  • It is primarily used to identify the balance of debits and credits entries from the transactions recorded in the general ledger at a certain point in time.
  • This trial balance reflects all the activity recorded from day-to-day transactions and is used to analyze accounts when preparing adjusting entries.
  • Next up is editing the information before we can publish our story in financial statements.
  • A trial balance is a report that lists the balances of all general ledger accounts of a company at a certain point in time.
  • Both ways are useful depending on the site of the company and chart of accounts being used.

In addition to error detection, the trial balance is prepared to make the necessary adjusting entries to the general ledger. It is prepared again after the adjusting entries are posted to ensure that the total debits and credits are still balanced. It is usually used internally and is not distributed to people outside the company. To prepare a trial balance, you will need the closing balances of the general ledger accounts. The trial balance is prepared after posting all financial transactions to the journals and summarizing them on the ledger statements. The trial balance is made to ensure that the debits equal the credits in the chart of accounts.

Assets and liabilities should be listed in order from most liquid to least liquid. Liquidity refers to how quickly an asset could be converted to cash and how quickly a liability will be paid off with cash. The most liquid asset is cash, because it has already been converted to cash (who knew?).

The worksheet is still occasionally used when a business wants to adjust its accounts at the end of an accounting period and produce financial statements. However, the spreadsheet is much more likely to be used when a business does not have accounting software (which can produce the same information much more easily). Thus, the trial balance worksheet is primarily found in situations where accounting records are kept manually. The adjusted trial balance is completed after the adjusting entries are completed. This trial balance has the final balances in all the accounts and is used to prepare the financial statements. An adjusted trial balance is formatted exactly like an unadjusted trial balance.

Using the Adjusted Trial Balance

Typically, the next most liquid asset is accounts receivable because most companies collect their receivables within 30 days. You could also take the unadjusted trial balance and simply add the adjustments to the accounts that have been changed. In many ways this is faster for smaller companies because very few accounts will need to be altered. Both ways are useful depending on the site of the company and chart of accounts being used. Before the errors can be identified and corrected, a temporary suspense account is created to match the trial balance totals temporarily. Under balance method, only the balances of all the ledger accounts are shown in the trial balance.

order of trial balance

A trial balance worksheet is a multi-column spreadsheet that contains the ending balances of all general ledger accounts used by a business. The worksheet is useful for converting ending account balances into financial statements, if there is no accounting software on hand that can accomplish this task automatically. You could post accounts to the adjusted trial balance using the same method used in creating the unadjusted trial balance. The account balances are taken from the T-accounts or ledger accounts and listed on the trial balance.

The Trial Balance

You can also think of assets and liabilities in terms of current and long-term. A current asset is one that will most likely be used up in less than 12 months. A current liability is one that will be paid off in less than 12 months. Long-term assets and liabilities are those that will be on the trial balance for more than 12 months.

Since each transaction is listed in a way to ensure the debits equaled credits, the quality should be maintained in the general ledger and the trial balance. If the sum of debits does not equal the sum of credits, an error has occurred and must be located. Now that the trial balance is made, it can be posted to the accounting worksheet and the financial statements can be prepared. The purpose of a trial balance is to ensure all the entries are properly matched. If the trial balance totals do not match, it could be the result of a discrepancy or accounting error.

The total of the debit side is placed in the debit column and the total of the credit side in the credit column of the trial balance. The total of the debit column and credit column should be the same. In a double-entry account book, the trial balance is a statement of all debits and credits.

Essentially, you are just repeating this process again except now the ledger accounts include the year-end adjusting entries. The unadjusted trial balance is prepared before adjusting journal entries are completed. This trial balance reflects all the activity recorded from day-to-day transactions and is used to analyze accounts when preparing adjusting entries. For example, if you know that the remaining balance in prepaid insurance should be $600, you can look at the unadjusted trial balance to see how much is currently in the account.

Accounts:

The trial balance is the edit phase of our story before we publish the results in financial statements. Finally, if some adjusting entries were entered, it must be reflected on a trial balance. In this case, it should show the figures before the adjustment, the adjusting entry, and the balances after the adjustment. It is so amazing how simplistic you’ve made understanding accounting for me. You’ve made me a to-listen-to while I’m conversating in the midst of financial accountants.

The purpose of the trial balance is to make your life easier when preparing financial statements. A trial balance includes a list of all general ledger account totals. Each account should include an account number, description of the account, and its final debit/credit balance. In addition, it should state the final date of the accounting period for which the report is created. Once all the accounts are posted, you have to check to see whether it is in balance. If the difference is divisible by 9, you may have made a transposition error in transferring a balance to the trial balance or a slide error.

Furthermore, the assets and liabilities have to be listed in order of liquidity, which refers to how quickly an asset can be converted to cash to pay off liabilities. The trial balance accounts are listed in a specific order to help in the preparation of financial statements. As with all financial reports, trial balances are always prepared with a heading. Typically, the heading consists of three lines containing the company name, name of the trial balance, and date of the reporting period. Preparing an adjusted trial balance is the fifth step in the accounting cycle and is the last step before financial statements can be produced. Using Paul’s unadjusted trial balance and his adjusted journal entries, we can prepare the adjusted trial balance.

A trial balance is a report that lists the balances of all general ledger accounts of a company at a certain point in time. The accounts reflected on a trial balance are related to all major accounting items, including assets, liabilities, equity, revenues, expenses, gains, and losses. It is primarily used to identify the balance of debits and credits entries from the transactions recorded in the general ledger at a certain point in time.

Both the debit and credit columns are calculated at the bottom of a trial balance. As with the accounting equation, these debit and credit totals must always be equal. If they aren’t equal, the trial balance was prepared incorrectly or the journal entries weren’t transferred to the ledger accounts accurately. The equality of the two totals in the trial balance does not necessarily mean that the accounting process has been error-free. Serious errors may have been made, such as failure to record a transaction, or posting a debit or credit to the wrong account. For instance, if a transaction involving payment of a $ 100 account payable is never recorded, the trial balance totals still balance, but at an amount that is $ 100 too high.

AccountingTools

While we still have not prepared financial statements, we have captured the activity and organized it into a trial balance. Next up is editing the information before we can publish our story in financial statements. The following video summarizes what elements are included in a Trial Balance and why one is prepared.

If the difference is divisible by 2, you may have transferred a debit-balanced account to the trial balance as a credit, or a credit-balanced account as a debit. When the difference is divisible by 2, look for an amount in the trial balance that is equal to one-half of the difference. Once the errors are located, adjusting entries are posted to the trial balance. Once this is done, the trial balance is considered an adjusted trial balance.

Note that only active accounts that will appear on the financial statements must to be listed on the trial balance. If an account has a zero balance, there is no need to list it on the trial balance. The worksheet is generally structured as an electronic spreadsheet, into which accounting ending balances are manually entered from the general ledger. The spreadsheet may contain pre-set subtotal and total formulas, which are useful for aggregating the account information into financial statements. Preparing a trial balance regularly helps a business in spotting errors in its books. With accounting software, business owners don’t have to wait for the end of the year to make a trial balance and assess their financial information.