From the course: Excel for Accountants
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
GL strings - Microsoft Excel Tutorial
From the course: Excel for Accountants
GL strings
- [Instructor] Chart of accounts is a list of all the accounts in a general ledger. Each one is identified by a reference number. The purpose is to organize the finances of that entity by segregating assets versus liabilities, revenue and expenses, really just to give interested parties a better understanding of the financial health of the institution. A strong chart of accounts lets us go through and analyze information systematically so that we see where the organization is efficient and where it's perhaps inefficient. All of this relates to a concept that we call general ledger strings. I'm in the 03_ 03_Begin Excel exercise file. Now we've got our basic general ledger here, and it shows different GL entries. For example, this consolidated mailings, entry for a mailer, purchase of a couple of computers, office equipment, we had a workplace injury, we had some advertising design, et cetera. But in addition to the entries that you see here, we'd want to be able to go through and…
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)
-
-
-