This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Technical

Data mining your general ledger with Excel Logo aicpa

  J. Carlton Collins, CPA |   Free |   AICPA |   01 Jan 2017 |   Journal of Accountancy

Learn how to use Microsoft Excel to unearth and interpret the wealth of data hidden in the general ledger.

Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational
  • IT management & assurance: Technical: Information management: Data management & analytics, Foundational

2 Comments/Reflections

Christopher Stevenson

Christopher Stevenson Oct 2017

Excellent article covering a lot of the methods I use when Data Mining and a few more that I was unaware of but will certainly use in future exercises.
Alan Makins

Alan Makins Jul 2017

Interesting. Will be creating new G/L chart of accounts soon. Need to consider potential to mine data in defining structure.