Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Can someone explain how to do a 10 column worksheet? (https://www.askmehelpdesk.com/showthread.php?t=437858)

  • Jan 22, 2010, 09:39 AM
    Jemont
    Can someone explain how to do a 10 column worksheet?
    I have never had to do a 10 column worksheet for a trila balance. Can someone explain it to me?
  • Jan 23, 2010, 02:16 AM
    morgaine300

    There is an example of one on this page:
    Principles of Accounting Chapter 4

    The trial balance itself hasn't changed. You're simply putting it on a different sheet of paper. Except for the adjustments column (which requires knowledge of adjusting entries), most of the rest of it is a bunch of copying and some math. Not nearly as scary as it looks.
  • Jan 24, 2010, 09:12 PM
    Elizabeth1951
    Quote:

    Originally Posted by morgaine300 View Post
    There is an example of one on this page:
    Principles of Accounting Chapter 4

    The trial balance itself hasn't changed. You're simply putting it on a different sheet of paper. Except for the adjustments column (which requires knowledge of adjusting entries), most of the rest of it is a bunch of copying and some math. Not nearly as scary as it looks.

    Do you have any suggestions on how to do this on an Excel Workheet showing the formulas used to determine the balances?
    Liz
  • Jan 24, 2010, 09:24 PM
    Sissielala

    One thing you can try is going on Utube and type in your question and there may be a video showing you how to do this. I learned how to knit by going on Utube and searching for how to knit etc..
  • Jan 25, 2010, 12:53 AM
    morgaine300
    1 Attachment(s)

    I can't imagine someone filming someone doing a worksheet.

    When I do these in Excel, I start in the top row (cash presumably) of the adjusted trial balance. Oh jeez, how to explain this... Well, let me just go do a partial one and attach it, and include a bit of explanation.

    OK, I'm using something I did for someone on here a while back (cause it's already done & I never deleted it), which will show the equations, and I wrote a bit of
    explanation to the side. This is just some sloppy thing I did quickly so don't expect perfection.
  • Jan 25, 2010, 06:30 AM
    Elizabeth1951
    Thank you for this sample. However, I need to have the IF performed to show the NET INCOME OR LOSS on the worksheet. I have an attachment of what I have done so far on the worksheet, but am unsure how to attach it to this.
  • Jan 25, 2010, 06:37 AM
    Elizabeth1951
    1 Attachment(s)

    Attached is the worksheet:
  • Jan 25, 2010, 11:51 AM
    ArcSine
    Elizabeth, are you saying that you want a balancing number to appear in either H27 or I27 -- but not both -- depending on whether there is a net profit or a net loss?

    If so, the following will do the trick. (I'll just focus on the P&L columns of H and I; you can do something similar for the two Balance Sheet columns of J and K.)

    Suppose the column of expenses (H19 to H25) is given a range name of "expenses", and the revenue cells (I17 and I18) are named "revenue".

    In Cell H27 put

    =if(sum(revenue) > sum(expenses), sum(revenue) - sum(expenses), "")

    If there is a net profit, the net profit amount will be placed into H27; if there's a loss, the cell will be left blank.

    Into Cell I27 you'll code a similar formula...

    =if(sum(expenses) > sum(revenue), sum(expenses) - sum(revenue), "")

    This will put a net loss into I27, or leave it blank if there is a net profit.

    Hope that helped a bit, if that's what you were asking about.
  • Jan 26, 2010, 02:40 PM
    Elizabeth1951
    To ArcSine-
    Thank you, thank you! You are truly great!. I may need more help, so how can I contact you when I need more assistance?
    Liz
  • Jan 26, 2010, 06:27 PM
    morgaine300

    Will you PLEASE stop posting this same subject all over the place. It's getting darn confusing! You posted one time over on the Accounting forum, one time here asking about IF functions and never even answered me there, and now on this one, tagging onto someone else's thread. It's really difficult trying to track all this down, and time-wasting to try to answer you, just to discover that someone else has answered you elsewhere.

    Think about how this is from our point of view when we don't know what you're doing.
  • Jan 27, 2010, 07:52 AM
    ArcSine
    Liz, it's always a pleasure to help out... and I do appreciate the kind words.

    For any future questions, the best and most direct route is to simply post back here in the forum. Follow Morgaine's suggestions and initiate a new thread for a new question, rather than tacking onto the end of an old thread.

    Take care, ;)

  • All times are GMT -7. The time now is 06:56 PM.