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.

General ledger overview

General ledger overview - Microsoft Excel Tutorial

From the course: Excel for Accountants

Start my 1-month free trial

General ledger overview

“

- [Instructor] For larger organizations, the general ledger is a key tool, and Excel gives us the ability and the flexibility to be as detailed or as high level as we'd like. So while large organizations often use purpose-built tools like those from Oracle as part of their GL, Excel can be either a substitute or a compliment for those existing purpose-built software packages. Let me show you what I mean. I'm in the 03_01 Begin Excel exercise file. Now we're in the itemized expenses tab, and what we see here is that we have different itemized expenses based on transactions undertook by this particular company. So there's two sample transactions we have. The first is for GL code 1000 requested by John Smith, where $750.75 was paid to Consolidated Mailings for a mailer that was sent out. And this was filed with the company's ledger on January 4th, 2018. We have a second transaction here under GL code 7,000 requested by George Jones, where $2,500 was spent for two computers from Dell…

Contents