From the course: Excel for Accountants
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Recording transactions in a GL - Microsoft Excel Tutorial
From the course: Excel for Accountants
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
General ledger overview4m 16s
-
(Locked)
Recording transactions in a GL4m 54s
-
(Locked)
GL strings3m 39s
-
(Locked)
Corporate financial statements in Excel4m 19s
-
(Locked)
Financial statement links in Excel3m 25s
-
(Locked)
Key corporate accounting ratios4m 14s
-
(Locked)
International accounting standards vs. the US2m 14s
-
(Locked)
XBRL, Edgar, and corporate financial reporting3m 55s
-
(Locked)
-
-
-