I have never had to do a 10 column worksheet for a trila balance. Can someone explain it to me?

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.

Quote:

---

Originally Posted by 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.

---

Do you have any suggestions on how to do this on an Excel Workheet showing the formulas used to determine the balances?
Liz

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..

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.

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.

Attached is the worksheet:

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.

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

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.

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, ;)