Ask Experts Questions for FREE Help !
Ask
    DORIGINALBOSS's Avatar
    DORIGINALBOSS Posts: 3, Reputation: 1
    New Member
     
    #1

    Dec 10, 2013, 02:36 PM
    How can I create a balance sheet from a trial balance?
    My trial balance:

    capital 100,000
    sales 294,898.75
    purchases 68,227.92
    salary 84000
    utilities 16,200
    insurance(for the year) 1500
    Business License(for year) 300
    advertising 3000
    motor vehicle expense 7800
    rent 18000
    packaging 12,975.60
    vehicle 65000
    furniture 1030.00
    utensils 419
    appliances 450
    cooling equipment 9000
    electronics 4300
    fixtures and fittings 650
    carriage 3200
    cash 98,846.22


    the total of all fixed assets dep by 15%, which by my calculations = 12,127.35

    how do I create a balance sheet whit this info?
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #2

    Dec 10, 2013, 09:00 PM
    Use a worksheet for this problem, preferably in Excel. You will set up your columns for account names, trial balance, adjustments, adjusted trial balance, income statement and balance sheet. I have attached a sample worksheet so you can see the format of one.

    From your adjusted trial balance you will carry your balances to either the income statement or the balance sheet. Your income statement will not be in balance and the difference will be net income which will carry to the balance sheet.
    Attached Files
  1. File Type: xls Lakeside Worksheet - IS and BS added.xls (23.0 KB, 147 views)
  2. DORIGINALBOSS's Avatar
    DORIGINALBOSS Posts: 3, Reputation: 1
    New Member
     
    #3

    Dec 11, 2013, 10:15 AM
    Thanks

    But I will like assistance in to which heading they will fill in the balance sheet?

    Whether it be fixed asset, current asset or current liability?
    DORIGINALBOSS's Avatar
    DORIGINALBOSS Posts: 3, Reputation: 1
    New Member
     
    #4

    Dec 11, 2013, 11:53 AM
    When I did it, its off by a little over $2000.

    Need help!!

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

A single question for journal n leger,p&l a/c,balance sheet,trial balance [ 2 Answers ]

A single question for journal n leger,p&l a/c,balance sheet,trial balance

Passing journal entry ,ledger account, trial balance & balance sheet? [ 0 Answers ]

Building 60,000 Machinery 17000 Bad debts 2800 Cash 500 Discount received 3000 Bank overdraft 10000 Creditors 50000 Purchase 100000 Capital 73600 Fixtures 5600

PLEASE help me create an unadjusted trial balance and an adjusted balance? [ 1 Answers ]

PLEASE help me create an unadjusted trial balance and an adjusted balance. Three friends opened a roller rink on October 1, 2008. The following transactions occurred during the first month. Oct 1. Received contribution of $22,000 from EACH three principal owners of the business in exchange...

Preparing is, re and balance sheet from Trial balance adjustement sheet [ 3 Answers ]

I am trying to do my income statement, retained earnings and balance sheet from my adjusted trial balance sheet. I am confused from my book about the debits and credits. When I transfer them over from the adjusted sheet. Do they stay on the same sides. For example: assests will be on the...

How to record partners'current acounts in the trial balance and balance sheet [ 1 Answers ]

Two persons started their own business with the amount of dhs 175000 paid by one of them who doesn't work in the company . And the other one work in the company as a general manger .Considering the money as a loan to be paid back to the partner within 18 months, when their first financial...


View more questions Search