|  
               
                |  |  | 
                    
                    
                    
                 |  
 
	
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      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
 |  
    |  |  
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      Nov 25, 2007, 08:11 PM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        
	
		
			
			
				
					  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.
     |  
    |  |  
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      Nov 25, 2007, 08:16 PM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        
	
		
			
			
				
					  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.
     |  
    |  |  
	
		
	
	
  | 
    
      
                |  | Junior Member |  | 
 
                  
                      Nov 25, 2007, 09:50 PM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        Attachment 5378
	
		
			
			
				
					  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
     |  
    |  |  
	
		
	
	
  | 
    
      
              |  | Junior Member |  | 
 
                  
                      Nov 25, 2007, 11:26 PM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        
	
		
			
			
				
					  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
     |  
    |  |  
 
 
 
  
    | Question Tools | Search this Question |  
    |  |  |  
 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
 
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
 
 |