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

    Jun 11, 2012, 10:24 PM
    How to use work sheet? 10 columns
    How to use work sheet?10 columns
    paraclete's Avatar
    paraclete Posts: 2,706, Reputation: 173
    Ultra Member
     
    #2

    Jun 12, 2012, 05:43 AM
    Quote Originally Posted by sevenjad View Post
    how to use work sheet?10 columns
    usually the columns represent the various sources and outputs of data and the rows represent individual accounts, totals, etc

    so the columns might be captioned A trial balance, B accrued expenses, C prepayments,D inventory adjustments, E other adjustments, F revised trial balance, G P&L, H non cash adjustments,I Cash Flow, J Balance Sheet.

    Then A + B -C +D +E = F = G - H = I and so on

    If I were constructing it, there would be linkages to subsidiary worksheets

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!

10 columns work sheet using peach tree accounting software [ 1 Answers ]

How to prepare a ten columns work sheet using peach tree accounting software

From 3 columns of data creating a 4th column with the most recent columns data [ 2 Answers ]

Hello, I was wondering if anyone can help with an excel query I have... I have 3 columns of information and want to summarise the most recent information in to a 4th column. i.e. the most up to date information. If the most recent column is blank use the information from the 2nd most recent...


View more questions Search