[bgibbs11]

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!

[joypulv]

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.

[bgibbs11]

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?

[bgibbs11]

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