• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

What is Trial Balance? Definition, Types & Errors

What is Trial Balance? Definition, Types & Errors

Trial Balance – Definition

Trial Balance is a document in which we record the closing balances of all the ledger accounts at the end of the accounting period. It is a statement with all closing balances of ledger accounts on a certain date.

Usually, it is prepared at the end of an accounting period that assists us in the easy drafting of other financial statements.

Preparing this document is the first and foremost step in the preparation of financial statements. ( balance sheet, Income Statement, Cash flow Statement, etc)

Types of Trial Balance

There are 3 types of Trial Balance:

Trial Balance

1. Unadjusted

Unadjusted Trial Balance is the first and foremost document to be prepared for final accounts. You need to prepare it before passing any adjustment entries. In other words, it is prepared to find the unadjusted ledger balances if there are any in our ledgers.

2. Adjusted

Adjusted Trial Balance is prepared to see whether the adjustment entries passed are correct or not after making all adjustments.

3. Post-Closing

Usually, Post-Closing Trial Balance will be same as above. Sometimes due to adjustments or unrecorded entries, the balances of ledgers might change. It is helpful for adding the opening balances for the next accounting year.

Purpose of Making a Trial Balance

  • It is the first step towards the yearly closing.
  • Helps to identify, rectify and balance debit and credit entries of ledger accounts according to the double-entry system.
  • It ensures the accuracy of extraction from the account balances from the ledgers.

How to Prepare Trial Balance?

Follow the below-given steps:

  1. To prepare this document, all the ledger balances are separated into debit and credit balances.
  2. On the debit side, you record the Assets and expenses accounts. Whereas, on the credit side you record the liabilities, capital and income accounts.
  3. The main purpose of preparing this document is to ensure that all the entries are made according to the ruling of the double-entry system.
  4. Totals of both debit and credit side should match. If the totals don’t match, we need to investigate the differences. It is mandatory to resolve before the preparation of financial statements.
  5. It is mandatory to resolve before the preparation of financial statements.

Limitations and Undetectable Errors

This statement can easily identify any mistake in terms of mathematical or typographical errors entered in the ledger. There are some errors where it doesn’t help. They are:

  • A transaction not entered in the books of account or ledger will not have entries on both sides.  Thus, the balance of debit and credit side will match.
  • In case, you entered the wrong amount on both sides; debit and credit. Still, it will balance it.
  • When you do an opposite entry; report the debit amount in credit and the credit amount in debit. This will also balance the statement and will not rectify this error.
  • Doesn’t rectify the reporting of the amount under the wrong head.

Trial Balance in Excel

We have created a ready-to-use template with predefined formulas. This template helps you easily prepare and find the difference.

Click on the link below to download the template:

Trial Balance Excel Template

If you have any queries or questions, share them in comments below and I will be more than happy to help you.

Filed Under: Accounting Glossary

You are Here: Home / Accounting Glossary / What is Trial Balance? Definition, Types & Errors

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • Calculators
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2025. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT