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

    Nov 13, 2008, 11:41 AM
    Preparing an accounting worksheet using excel
    Prepare work sheet showing trial balance, adjustments, adjusted trial balance, income and balance sheet.
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
    		  
    #2

    Nov 14, 2008, 03:00 PM

    Set up 11 columns for your worksheet.
    Column 1 is the name of your Accounts
    Columns 2 & 3 is your Trial Balance
    Columns 4 & 5 is for your Adjustments
    Columns 6 & 7 is your Adjusted Trial balance
    Cloumns 8 & 9 is for the Income Statement
    Columns 10 & 11 is for your Balance Sheet

    Columns 2,4,6,8,10 are your Debits
    Columns 3,5,7,8,11 are your Credits
    The accounts in the Adjusted Trial Balance transfers to the Income Statement & the Balance Sheet
    The difference in Debits and Credits in the Income Street goes into the Balance Sheet as Retained Earnings.
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!

How to Preparing Accounting worksheet [ 6 Answers ]

I would like to know the steps of preparing the accounting worksheet.

Preparing a worksheet [ 3 Answers ]

I have to create a worksheet using the following information: 1. Prepare a 10 column work sheet for fiscal year 2008, starting with the unadjusted trial balance and inluding adjustments based on these additional facts. (columns include in this order: unadjusted trial balance, adjustments, adjusted...

Excel: Linking from one worksheet to another [ 8 Answers ]

I'd like to link from a cell in one worksheet to a LINE in another. If that doesn't make sense, I've got a member list of people with address, phone, etc. For folk that have not renewed this year, I want to have a separate worksheet that documents my contact efforts... so to link from the...

Gridlines for MS Excel Worksheet [ 1 Answers ]

Hi: I have installed MS Excel 2000 and MS Excel 2003 on my two emachines computers with Windows XP. Both versions of Excel are perfect on one computer, but they are not on the other one. On my second computer, Excel worksheets of both versions never have gridlines. The sheets or tables look...

Microsoft Excel 2003 Worksheet Problem [ 1 Answers ]

Hi: Would you please help me solve the problem I am having! This is the problem: I have installed MS Office 2003 on my two home computers. Everything is OK on one computer, but MS Excel 2003 is a problem on another computer. When I open a new workbook, I always get a blank worksheet that has...

View more questions Search