From the course: Excel for Accountants

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Recording transactions in a GL

Recording transactions in a GL - Microsoft Excel Tutorial

From the course: Excel for Accountants

Start my 1-month free trial

Recording transactions in a GL

“

- [Instructor] After you get comfortable with the linkages in the general ledger, you'll want to think carefully about the information that your firm needs to collect in its GL. Excel offers us the ability to categorize things neatly and to add categories over time. Let me show you what I'm talking about. I'm in the 03_02_Begin Excel Exercise folder. Now we're here on the year to date budget summary. And as you can see, the Budget Summary links clearly to the other sheets. So the actual amount, for example, is drawn from the Monthly Expenses Summary, which in turn is drawn from our Itemized Expenses. Now, maybe we want to add a new code. For example, currently our GL codes go from 1000 to 10,000, include Advertising, Office Equipment all the way down to, as an example, Building Codes and Transportation. We've also got two additional codes at the bottom, Charitables and Sponsorships, related to charity activities for the firm. Maybe we're interested in adding in a new code that's…

Contents