How to Prepare Balance Sheet from Trial Balance - Pediaa.Com (2024)

It is important to know what is meant by the terms trial balance and balance sheet before learning how to prepare balance sheet from trial balance. Thus, this article explains,

1. What is a Trial Balance?

2. What is a Balance Sheet?

3.How to Prepare Balance Sheet from Trial Balance?

What is a Trial Balance

A trial balance is a statement that provides a clear account of all the ledger balances at a particular point in time. The main objective of preparing a trial balance is to ensure that all the journal entries and ledger balances recorded are mathematically accurate. A trial balance provides all the ending balances in a single document; all the debit balances are recorded in one column whereas all the credit balances in another. Therefore, it is easy to use as a reference tool.

A trial balance mainly consists of 3 columns. In column 1, all the descriptions of individual ledger balances are recorded (e.g.: Cash, accounts receivables, equipment, bank loan). Column 2 is the debit balances column where all the ending debit balances are recorded. Column 3 is dedicated to the recording of all the credit ending balances.

e.g.: Cash is an asset, thus the ending balance will be debit

Bank loan is a liability, thus the ending balance will be creditHow to Prepare Balance Sheet from Trial Balance - Pediaa.Com (1)

How to Prepare a Trial Balance

What is a Balance Sheet

Balance sheet, also known as statement of financial position, is one of the principal year-end financial statements prepared by companies along with the Income statement (record of operating and non-operating incomes and expenses of the company over an accounting period), Statement of cash flow (statement reflecting how the cash flow has been affected due to the changes in assets, liabilities, incomes and expenses) and Statement of changes in equity (movement in the shareholders equity over an accounting period).

Format of Balance Sheet

The format of the balance sheet is prepared in accordance with the main accounting formula:

Non-current assets + Current assets = Equity + Non- current liabilities + Current liabilities

Non-current Assets

Long-term investments whose full valuewill not be realized within the accounting year.

E.g. Property plant and equipment, machinery

Current Assets

Assets whose full value can be reasonably expected to be converted into cash within the accounting year.

E.g. Cash and cash equivalents, accounts receivables

Equity

Securities that represents the owner’s interest in the company

E.g. Common stock, retained earnings

Non-current Liabilities

Long-term financial obligations that do not mature within the accounting period

E.g. Long-term loans, bonds payable

Current Liabilities

Short-term financial obligations that settlement is due within the accounting period

E.g., Accounts payable, interest payable

Both the trial balance and the balance sheet preparation are parts of the accounting cycle below.

How to Prepare Balance Sheet from Trial Balance - Pediaa.Com (2)

How to Prepare Balance Sheet from Trial Balance

It becomes evident from the above, that trial balance is an interim statement that assists in the preparation of the financial statements. Once the trial balance is prepared, certain adjustments such as accruals of revenues, accruals of expenses, prepayments and depreciations.

It becomes evident from the above, that trial balance is an interim statement that assists in the preparation of the financial statements. Once the trial balance is prepared, certain adjustments such as accruals of revenues, accruals of expenses, prepayments and depreciation will also be made. The resulting trial balance is named the ‘adjusted trial balance.’

The above process is a time consuming and lengthy process where a significant amount of paperwork is involved. The number of transactions a business conducts within an accounting period (most accounting periods are for one year) may be massive. While all the transactionsare recorded in journals as and when they arise, they are categorized into a number of accounts when been recorded in the ledgers. The final balances in the ledger accounts are taken to be entered into the trial balance. Thus, once the trial balance is completed, it serves as a summary of all the recording of financial information that is ready to be used in the preparation of the final statement.How to Prepare Balance Sheet from Trial Balance - Pediaa.Com (3)

The trial balance includes the closing balances of assets, liabilities, equity, incomes and expenses. The income and expenses balances will be recorded in the income statement while the balances of assets, liabilities and equity will be recorded on the balance sheet.

E.g: If accounts receivable ending balance is $2250, this is the amount to be included in the balance sheet as the final accounts receivable amount.

The income statement needs to be prepared before the balance sheet because the net income (total income – total expenses) or loss amount needs to be entered in the equity section of the balance sheet. In the balance sheet,thetotal of assets should be equal to the total of equity and liabilities. Even if the trial balance is balanced off it does not guarantee that the financial statements are accurate. This is because that all the errors in the accounting process will not be captured in the trial balance.

E.g: If a cash sale of $ 500 is completely omitted from records this will not cause a discrepancy in the trial balance. However, inventory is overstated by $ 500 and cash is understated by $ 500 in this situation.

Reference List:

“What is the difference between a journal and aledger? – Questions & Answers – AccountingTools.” Accounting CPE & Books – AccountingTools. N.p., n.d. Web. 26 Jan. 2017.

“Accounting Trial Balance Example and Financial Statement Preparation.” Money Instructor. N.p., n.d. Web. 26 Jan. 2017.

“Trial Balance.” Investopedia. N.p., 08 Apr. 2015. Web. 26 Jan. 2017.

“All Advantages and Disadvantages of Trial Balance.” Bank of Information. N.p., 02 Oct. 2016. Web. 26 Jan. 2017.

Image Courtesy:

“Restricted cash”By Zceisab – Own work (CC BY-SA 4.0) via Commons Wikimedia

“DWBA Trial Bal”By John M PASSMORE – Accounting for a Better Life isbn 978-1-905886-66-1 (GFDL) via Commons Wikimedia

How to Prepare Balance Sheet from Trial Balance - Pediaa.Com (2024)

FAQs

How do you create a balance sheet from a trial balance? ›

You can follow the steps given below in order to prepare a balance sheet:
  1. Step 1 – Make a trial balance. ...
  2. Step 2 – Arrange it properly. ...
  3. Step 3 – Remove all revenue and expense accounts. ...
  4. Step 4 – Make a calculation of the remaining accounts. ...
  5. Step 5 – Validate your balance sheet. ...
  6. Step 6 – Present it in the required format.
Dec 5, 2022

How is the balance sheet derived from the trial balance? ›

Accounts in the trial balance are split between balance sheet accounts and income statement accounts. The balance sheet accounts and their balances are sorted into assets, liabilities, and owner's equity to create the balance sheet.

How do you extract a trial balance from a balance sheet? ›

In order to prepare a trial balance, we first need to complete or 'balance off ' the ledger accounts. Then we produce the trial balance by listing each closing balance from the ledger accounts as either a debit or a credit balance.

Which of the steps in preparing a trial balance worksheet? ›

How to prepare a trial balance?
  1. Balance each ledger account. Businesses record their transactions as journal entries at first, and then make the entries in the respective ledger accounts. ...
  2. Prepare the trial balance worksheet. ...
  3. Fill out the worksheet. ...
  4. Add the values in each column. ...
  5. Close the trial balance.
Feb 19, 2024

How do you create a balance sheet step by step? ›

How to make a balance sheet
  1. Invest in accounting software. ...
  2. Create a heading. ...
  3. Use the basic accounting equation to separate each section. ...
  4. Include all of your assets. ...
  5. Create a section for liabilities. ...
  6. Create a section for owner's equity. ...
  7. Add total liabilities to total owner's equity.

Is the trial balance prepared before the balance sheet? ›

Trial balance is a worksheet in bookkeeping that contains ledger balance compiled in sections of debit and credit. This worksheet is used for creating the balance sheet. Preparation of trial balance is to ensure mathematical correctness of the transactions recorded.

What is trial balance sheet format? ›

In a trial balance, each general ledger account is listed with the account number, account name description, debit amount in the Debit column, and credit amount in the Credit column. At the bottom of the trial balance report document, the Debit and Credit column totals are presented.

What is trial balance sheet and how it is prepared? ›

A trial balance is a bookkeeping worksheet in which the balances of all ledgers are compiled into debit and credit account column totals that are equal. A company prepares a trial balance periodically, usually at the end of every reporting period.

What goes on the debit side of a trial balance? ›

All the assets must be recorded on the debit side. All the liabilities must be recorded on the credit side. All incomes or gains must be recorded on the credit side. All the expenses must be recorded on the debit side.

What happens to a completed trial balance? ›

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. The post-closing trial balance shows the balances after the closing entries have been completed.

What are the five balance sheet items in a trial balance? ›

A trial balance typically includes five elements:
  1. Credits and debits to each account from transactions during the accounting period.
  2. The associated account names.
  3. The associated account numbers.
  4. The dates of the accounting period.
  5. The total sum of all debit balances and credit balances.
Jul 11, 2023

What are the 3 methods of preparing trial balance? ›

Which are as follows :
  • Total Method or Gross Trial Balance.
  • Balance Method or Net Trial Balance.
  • Compound Method.
Nov 21, 2019

What is an example of a trial balance? ›

Trial Balance is the report of accounting in which ending balances of the different general ledgers of the company are available; For example, utility expenses during a period include the payments of four different bills amounting to $ 1,000, $ 3,000, $ 2,500, and $ 1,500, so in the trial balance, single utility ...

What is the formula for the trial balance? ›

The trial balance formula is total debits = total credits. This equation ensures that the total of the debit column matches the total of the credit column. If they do not match, it indicates that an error has been made.

What is the formula for calculating the balance sheet? ›

The balance sheet is based on the fundamental equation: Assets = Liabilities + Equity. As such, the balance sheet is divided into two sides (or sections).

How do you calculate the balance sheet? ›

What is Balance Sheet Formula? The Balance Sheet Formula is a fundamental accounting equation that mentions that, for a business, the sum of its owner's equity & the total liabilities is equal to its total assets, i.e., Assets = Equity + Liabilities. It is based on a double-entry system of accounting.

How do you project a balance sheet account? ›

If you need to create a projected balance sheet for your company, here are some steps to follow to do so:
  1. Create a format for the projected balance sheet. ...
  2. Gather past financial statements. ...
  3. Review your past and ongoing assets and liabilities. ...
  4. Project your fixed assets. ...
  5. Estimate the company's debt. ...
  6. Forecast your equity.
Jun 24, 2022

Top Articles
Latest Posts
Article information

Author: Edwin Metz

Last Updated:

Views: 6017

Rating: 4.8 / 5 (58 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Edwin Metz

Birthday: 1997-04-16

Address: 51593 Leanne Light, Kuphalmouth, DE 50012-5183

Phone: +639107620957

Job: Corporate Banking Technician

Hobby: Reading, scrapbook, role-playing games, Fishing, Fishing, Scuba diving, Beekeeping

Introduction: My name is Edwin Metz, I am a fair, energetic, helpful, brave, outstanding, nice, helpful person who loves writing and wants to share my knowledge and understanding with you.