How to Prepare Balance Sheet from Trial Balance with Example (2024)

By : Matthew Martin

Updated

What is a Balance Sheet?

The Balance Sheet attempts to show how much the business is worth. It does this by illustrating the value of the business’s net assets.

In order to do this, our balance sheet displays the difference between a business’s assets and liabilities. This difference is known as the business’s net assets and is considered to be the “value” of the business. Obviously, every successful business owner wants to amass the highest amount of net assets as possible!

How to Prepare a Balance Sheet from Trial Balance

Here are steps to make a balance sheet from trial balance

  • Step 1) Source Documents
  • Step 2) Journals
  • Step 3) Ledgers
  • Step 4) Balance Day Adjustments
  • Step 5) Trial Balance
  • Step 6) Profit and Loss statement
  • Step 7) Balance Sheet

Trial Balance Example

To create our balance sheet, we’re going to need the remaining sections of our Trial Balance – Assets, Liabilities, Owners Equity, and Drawings. Take a quick look at those.

TRIAL BALANCE FOR (NAME)’S BAKERY AS AT (TODAY’S DATE)
DEBIT SIDECREDIT SIDE
AssetsLiabilities
Bank $21,650Loan $9,000
Computer $1,500John’s Car Shop $3,000
Car $3,000Accumulated depreciation $400
iPhone $500Taxation Payable $675
Oven $500
ExpensesRevenue
Cake mix $3,000Sales $7,000
Interest expense $1,000
Telephone expense $300
Repairs expense $50
Depreciation $400
Tax Expense $675
DrawingsOwners’ Equity
Drawings $1,000Owner’s Equity $15,000
Balance $34,400Balance $34,400

Let’s take a look at these numbers:

Assets

  • Bank $24,150
  • Computer $1,500
  • Car $3,000

Liabilities

  • Loan $9,000
  • Johns Car Shop $3,000
  • Taxation Payable $675
  • Accumulated Depreciation $400

Owners’ Equity

  • Owners Equity $15,000
  • Drawings $1,000

We’ll also need to know our net profit for the year, which we know from our Profit and Loss statement, which is $1,575. Alright, that’s all the information we need. Let’s get started. The basic format of a Balance Sheet is:

Assets – Liabilities = Owners Equity (Net Assets)

Using the figures from our Trial Balance, simply fill in the blanks on the Balance Sheet below. Note that there are two formats, a “T” format and a list format. Both formats are commonly used, and are simply different methods of displaying the same information.

BALANCE SHEET FOR (NAME)’S BAKERY AS AT (TODAYS DATE)
AssetsLiabilities
Bank$21,650Loan$9,000
Computer$1,500John’s Car Shop$3,000
Oven$2,000Taxation Payable$675
iPhone$500
Car less accumulated depreciation$2,600
Total Assets$28,250Total Liabilities$12,675
Owner’s Equity
Owner’s Equity at start of year$15,000
Minus: Drawings$1,000
Plus: Net Profit After Tax$1,575
Owner’s Equity at year end$15,575
Total$28,250Total$28,250
BALANCE SHEET FOR (NAME)’S BAKERY AS AT (TODAYS DATE)
Owner’s Equity
Owner’s Equity at start of year$15,000
Minus: Drawings$1,000
Plus: Net Profit After Tax$1,575
Owner’s Equity at year end$15,575
Represented by:
Assets
Bank$21,650
Computer$1,500
Oven$2,000
iPhone$500
Car less accumulated depreciation$2,600
Total Assets$28,250
Less: Liabilities
Loan$9,000
John’s Car Shop$3,000
Taxation Payable$675
Total Liabilities$12,675
NET ASSETS (Total Assets minus Total Liabilities)$15,575

GREAT! We’ve just completed our Balance Sheet.

How to Read a Balance Sheet

Let me point out a few interesting things about it.

1. Notice how the Owner’s Equity at the top of the statement balances with the Net Assets at the bottom of the statement. They’re both $15,575. This is where the term Balance Sheet comes from. If your Balance Sheet doesn’t balance, you’ve got a problem!

2. Notice how your Owner’s Equity changed. It’s now $15,575, even though you’ve only put $15,000 into the business, which was the original amount. This is because you made a profit. As the owner, this profit is yours! Each year, any profit you make will carry over to the Owner’s Equity section of the Balance Sheet. If you’ve been in business for ten years, then ten years of profit will have been accumulated in your Owner’s Equity. Think of Owner’s Equity as the amount the business owes to you, so whenever you make a profit, it’s yours! Oh, the joys of being a business owner!

3. Your Owner’s Equity only increased by $575, even though you made $1,575 in profit. Why is that? It’s because you took $1,000 of drawings during the year. That means although the $2,250 profit is yours, you already took $1,000 of it. Owners need to be careful not to withdraw so much in drawings that their Owner’s Equity falls below zero.

That’s it friends! We’ve started our business, recorded all our transactions, prepared a list of journal entries, entered them into our ledgers, taken our ledger balances into a trial balance, and finally produced a Profit and Loss Statement and a Balance Sheet!

This is the accounting process in action, and we now have two key reports that provide valuable information and will allow us to make good financial decisions.

We’ll talk a bit about that in a later tutorial.

You Might Like:

  • How to Calculate Depreciation: Straight Line, Diminishing Value
  • How to Prepare Trial Balance with Example
  • Accounting Tutorial for Beginners: Learn Bookkeeping in 7 Days
  • Purpose of Accounting (It’s Need and Importance)
  • Top 134 Accounting Interview Questions and Answers (PDF)
  • 11 BEST Accounting Books for Beginners (2024 Update)
  • 10 BEST Free POS Systems for Small Business (2024)
How to Prepare Balance Sheet from Trial Balance with Example (2024)

FAQs

How to make p&l and balance sheet from trial balance? ›

In the trial balance all debit balances and expenses will appear and on the debit side and in the credit side all credit balances at the end of year will appear along with income and gains. e. g. On debit side assets such as plant and machinary ,buildings ,salaries ,stationary etc wii appear.

How to prepare 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.

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 I prepare 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.
Jun 14, 2024

Does the trial balance have to match the balance sheet? ›

A further important purpose of the trial balance is that it forms the basis for the preparation of the balance sheet. If the total of the debit balances do not equal the total of the credit balance then there is a mistake somewhere, which needs to be investigated and corrected.

Which comes first balance sheet or trial balance? ›

A trial balance is usually prepared as the first step towards preparing the balance sheet of the company. A trial balance summarises the closing balance of the different general ledgers of the company, while a balance sheet summarises the total liabilities, assets, and shareholder's equity in the company.

What information for preparing a trial balance on a worksheet is obtained from? ›

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.

How to make BS from trial balance? ›

How to Prepare a Balance Sheet from Trial Balance
  1. Step 1) Source Documents.
  2. Step 2) Journals.
  3. Step 3) Ledgers.
  4. Step 4) Balance Day Adjustments.
  5. Step 5) Trial Balance.
  6. Step 6) Profit and Loss statement.
  7. Step 7) Balance Sheet.
Mar 9, 2024

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

Balance sheet accounts include Cash accounts, Marketable Securities, Accounts Receivable, Inventory, Fixed Assets, Prepaid Expenses, and Intangible Assets. Liabilities include Accounts Payable, Accrued Liabilities, Short-term Portion of Notes Payable, Notes Payable-Long Term, and Deferred Revenues.

What are the steps in preparing a trial balance worksheet? ›

How to prepare a trial balance
  1. Calculate the account balances for your ledger accounts. ...
  2. Record credit and debit balances on your trial balance. ...
  3. Calculate the total in your credit column. ...
  4. Calculate the total in your debit column. ...
  5. Compare your debit and credit totals. ...
  6. Look for errors. ...
  7. Close your trial balance.

What is the main purpose of a trial balance? ›

A Trial Balance helps in summarising the financial transactions done while running a business. It is a consolidated summary of the financial transactions that have taken place within a financial year. It can help the management in making business decisions as well.

Is a P&L the same as a trial balance? ›

Balance sheet: your business's current 'net worth'. Trial balance: to discover if there are any errors in your accounting. Profit and loss statement: the revenues, costs and expenses incurred over a specific period.

How do you go from trial balance to income statement? ›

Your trial balance may include one or more revenue or sales accounts. Add up all the revenue line items on the trial balance and enter the total on the revenue line item of your income statement.

How do you transfer P&L to balance sheet? ›

Print a Trial Balance for the first period in the new year, and note the amount called prior year's net profit/loss. If the trial balance shows a profit, use Ledger Entry to debit the profit and loss account and credit the balance sheet account with this amount. If you are posting a loss, reverse these signs.

How to calculate profit and loss from balance sheet? ›

Net Sales (or revenue) – Cost of Sales (or Cost of Goods Sold) = Gross Profit (or Gross Margin) Gross Profit – Operating Expenses = Net Operating Profit. Net Operating Profit + Other Income – Other Expenses = Net Profit Before Taxes. Net Profit Before Taxes – Income Taxes = Net Profit (or Loss)

Top Articles
Latest Posts
Article information

Author: Kareem Mueller DO

Last Updated:

Views: 6690

Rating: 4.6 / 5 (66 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Kareem Mueller DO

Birthday: 1997-01-04

Address: Apt. 156 12935 Runolfsdottir Mission, Greenfort, MN 74384-6749

Phone: +16704982844747

Job: Corporate Administration Planner

Hobby: Mountain biking, Jewelry making, Stone skipping, Lacemaking, Knife making, Scrapbooking, Letterboxing

Introduction: My name is Kareem Mueller DO, I am a vivacious, super, thoughtful, excited, handsome, beautiful, combative person who loves writing and wants to share my knowledge and understanding with you.