As part of a semester long project I have to prepare Excel schedules that cover all the accounting cycle steps: Journal, Adjusting, and Closing Entries, Posting, Trial Balances (using a 10-column worksheet) & comparative Financial Statements & Notes, based on a corporation's 2nd period of transactions.

Year one has been completed by the professor and should be completely accurate. I am finished all of the journal entries for year 2, and updated all of the T accounts below them based on the events given. The problem is my trial balance is off by 99,050 and I cannot figure out why! The adjusting balances are also finished, and balance, but everything after that hasn't been updated yet, and should be disregarded at this point. I really want to figure this out before I go on much farther.

Please Help!

I looked at it, but it would take (me) forever to find your error. Given that this was a semester long project, I am not sure anyone else is going to wade through all of that either. Often the number you are off by is a clue. 100,000 in one spot and 50 in another, I'd try for starters.

Thanks. I know its a lot. I just figured fresh eyes on it would help. I can't tell you how many hours I've spent on this part alone. Since my journal entries all balance does that mean it has to be rooted in my beginning balances?

Figured it out! Forgot about retained earnings & Last year's dividends!