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

    Nov 25, 2007, 06:40 PM
    Doing adjusted Trial Balances
    I have to do a computer project and part of that is making a trial balance using debits and credits, only thing is I can't get them to balance. The balance is supposed to be 1,194,630.

    The template is attached


    I think I am having trouble with which ones are debits and credits... I know that assets are debits and expenses are debits, revenues are credits, but the ones like allowances and prepaids, gain and costs of goods sold I am unsure of. Can someone help get this, some helpful website examples or examples of your own to help.

    Thanks,
    Hopeless0403
    Attached Files
  1. File Type: xls burford.laura.computer2.xls (180.0 KB, 240 views)
    2. bunnykay's Avatar
    bunnykay Posts: 2, Reputation: 1
    New Member
    		  
    #2

    Nov 25, 2007, 08:11 PM
    Quote Originally Posted by hopeless0403
    I have to do a computer project and part of that is making a trial balance using debits and credits, only thing is i can't get them to balance. The balance is supposed to be 1,194,630.

    the template is attached


    I think i am having trouble with which ones are debits and credits...I know that assets are debits and expenses are debits, revenues are credits, but the ones like allowances and prepaids, gain and costs of goods sold i am unsure of. Can someone help get this, some helpful website examples or examples of your own to help.

    Thanks,
    Hopeless0403
    This is always helpful to remember... The Trial Balance is set up in a fairly rigid order. First the Assets, then Liabilities then Equity then Revenue then Expenses.
    So if you know the rules for Debits and Credits and where each of the categories begins and ends then you should be able to balance. ALSO - it looks like you have been asked to calculate tax. The payable will be a credit and the expense a debit.
    bunnykay's Avatar
    bunnykay Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Nov 25, 2007, 08:16 PM
    Quote Originally Posted by hopeless0403
    I have to do a computer project and part of that is making a trial balance using debits and credits, only thing is i can't get them to balance. The balance is supposed to be 1,194,630.

    the template is attached


    I think i am having trouble with which ones are debits and credits...I know that assets are debits and expenses are debits, revenues are credits, but the ones like allowances and prepaids, gain and costs of goods sold i am unsure of. Can someone help get this, some helpful website examples or examples of your own to help.

    Thanks,
    Hopeless0403
    Here is a little more guidance... Gains act like Revenues, Cost of Goods Sold are an expense. Allowance for Doubtful Accounts are a contra account to Accounts Receivable (so they have a credit balance). Prepaid expenses are assets.
    qcmar24's Avatar
    qcmar24 Posts: 65, Reputation: 3
    Junior Member
    		  
    #4

    Nov 25, 2007, 09:50 PM
    Attachment 5378
    Quote Originally Posted by hopeless0403
    I have to do a computer project and part of that is making a trial balance using debits and credits, only thing is i can't get them to balance. The balance is supposed to be 1,194,630.

    the template is attached


    I think i am having trouble with which ones are debits and credits...I know that assets are debits and expenses are debits, revenues are credits, but the ones like allowances and prepaids, gain and costs of goods sold i am unsure of. Can someone help get this, some helpful website examples or examples of your own to help.

    Thanks,
    Hopeless0403
    I had record the debit and credit ammounts for the accounts , some pointers the allowance for doubtful accounts should appear after the accounts receivable, the accoumulated depreciation should appear after the respecting accounts, the cost of goods sold should appear after the sales
    Also try to follow the rigth formating of the trial balance for example the name of the company always goes on top, the Trial Balance, then the date, you don't need 4 colums only 3 account name, debit, credit
    Attached Files
  2. File Type: xls oburford.laura.computer2(1).xls (184.0 KB, 157 views)
    3. student 101's Avatar
    student 101 Posts: 53, Reputation: 1
    Junior Member
    		  
    #5

    Nov 25, 2007, 11:26 PM
    Quote Originally Posted by hopeless0403
    I have to do a computer project and part of that is making a trial balance using debits and credits, only thing is i can't get them to balance. The balance is supposed to be 1,194,630.

    the template is attached


    I think i am having trouble with which ones are debits and credits...I know that assets are debits and expenses are debits, revenues are credits, but the ones like allowances and prepaids, gain and costs of goods sold i am unsure of. Can someone help get this, some helpful website examples or examples of your own to help.

    Thanks,
    Hopeless0403
    Cash is d, accountsrec, is d, notes receivables is a d, inventory is d, prepaid, building, land , equipment, patent are debits, allowence gfor doutful accounts is a credit, accumulated drepreciation are credits, accounts and salaries payables are credits, uneraned resnt is a credit, notes payables are credits, everything payable and common stock are credits, dividends are debits, sales are credits revenues are credits cost of good sold are debits, expenses and everything that has expense on it and is not accumulative is a debit
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!

Adjusted Trial Balance [ 1 Answers ]

Please help! I am having trouble with this adjusted Trial Balance. I have attached What I have done and what is required... Help Adjusted Trial Balance Debit Credit

T-accounts and adjusted trial balances [ 3 Answers ]

I'm having trouble putting amounts in the right places for t-accounts and the adjusted trial balance. Please help.

Adjusted Trial Balance [ 1 Answers ]

I need help!! First time doing adjustments... I have been working on this exercises for a while and I can't get it to balance. DEBIT Cash $26667 Prepaid Insurance $450 Batteries on Hand $250 Watches $20,000 Dividends $1,200 Utilities Expense $3,200 Salaries Expense $2,400

Adjusted trial balance [ 1 Answers ]

My question is how do I adjust these balances : 1) earned but unbilled revenue at march 31 was $600 2) accrued but unpaid employee salaries were $830 What should I debit and what should I credit? Account titles are : cash, accounts , accounts payable, salaries payable, service revenue,...

View more questions Search