New Tool for Accountants, Auditors, Analysts

A new type of tool will be available (is becoming available) to support professional accountants.  This tool is somewhat similar to the traditional electronic spreadsheet but it works differently and provides different capabilities to professional accountants. This new tool will supplement the arsenal of tools available to accountants, auditors, and analysts.

This new tool is semantic oriented, model-based, and a global standard technical format.  To describe this tool in the past I have used the terms "modern spreadsheet" and "professional knowledge graph" and "deductive apparatus" and "semantic oriented accounting and audit working papers" and "knowledge product" and "logical spreadsheet" and "logic programming" and "logical digital twin of financial reports".

This new type of tool will help usher in modern accountancy. In this new era, machines will support accountants, auditors, and analysts even more than they do now.  Skilled craftsmen will create these new tools.  If you read Informatics for Accountancy you cannot help to understand why this new type of tool is important to accountants, auditors, and analysts.

To understand this new tool, first think of the traditional electronic spreadsheet, a useful workhorse.  But let us "tweak" that traditional tool, making some useful modifications for certain specific types of tasks.  The objective is to enable certain tasks currently performed by humans to be performed or augmented by computer-based processes.  Human task performance by a computer system.  Machine supporting humans.

Think "Lego blocks".  But rather than plastic Legos,  the blocks are blocks of information.  The block of information is glued together using logic.  You can string these information blocks together and create an information flow.  You create a "problem solving system".  The requirements of this problem solving system are:

  1. The system MUST be easy enough for the typical accountant, auditor, and  analyst to use effectively.
  2. The system MUST be safe and reliable, free from catastrophic failure of the software system.
  3. The system MUST be useful; performing work better, faster, and cheaper than current processes.

This new system will be used to create model-based semantic-oriented financial reports, accounting working papers, audit schedules, and financial analysis models. 

Here is how you make that new problem solving system work:

  • Rather than creating a general system that can do anything and therefore extremely hard for business professionals to use; you create a specialized system that performs only specific (narrow set of) tasks. (An example of a general system is SWI-Prolog. An example of a specialized system is an information block creation system built using SWI-Prolog.) 
  • Rather than using a presentation-oriented approach by storing information in “workbooks”, “sheets”, “rows”, “columns”, and “cells”; information is stored within the information Legos in logical-oriented models.
  • In order to store information within a high level logical model; you have to create that high level logical model and make that model understandable to accountants, auditors, and analysts.  This model is referred to as a "meta-model", a high level model that all other information Lego models that accountants, auditors, and analysts create must follow.
  • A software system is created that understands that high level  model.  What this provides the user of that software system is an approachable level of complexity (i.e. simplicity) that accountants, auditors, and analysts making use of that software can do so effectively.  The complexity is carefully and deliberately hidden from the software user, absorbed by the software system and platform which is used by the software system.
  • The software system has a global perspective (context), not a local perspective (context).
  • The software system is self-documenting; each information block is documented by the information block itself.
  • Information is linked to other information not by the position of the information (i.e. the cell or sheet or workbook) which can be brittle; a more robust, trustworthy, and reliable linking mechanism is used and since the software has a global perspective as opposed to local perspective; all links are guaranteed to be unique globally.
  • Wild behavior is simply not allowed. Rather, everything is intentionally and deliberately controlled.  If you need flexibility, then use a traditional spreadsheet.  But if you can live within the boundaries, guardrails, and bumpers defined by the logic of the robust model; high quality will be guaranteed by the software system.
  • The software system has access to any other system that you have been granted access rights to anywhere on the internet.  One benefit of this, as an example, is the ability for one set of rules to be published and some set of information blocks published by some set of publishers can all share those same rules to be sure that every information publisher is following the rules.
  • The software system has a built in global standard multidimensional model; think pivot table type flexibility.
  • The software system is readable by both machines and by humans.  This is possible because the machine readable information is 100% convertible to a natural or neutral human readable presentation format using the logic of the information.  Further, while the "natural" or "neutral" human readable presentation format might be good enough 80% of the time; for the other 20% of your information use cases,  there is a mechanism that provides effectively "pixel perfect" human readable presentations of the machine readable information.
  • Remember that this information Lego is a global standard.  You are not locked into using any specific software system.  To change software systems, simply point the information Lego to some other off-the-shelf software system that supports the global standard you might prefer.
  • State-of-the-art logic processing is available to every accountant, auditor, and analyst via the safe, reliable, predictable de facto standard DATALOG.
Can this system do 100% of what you need? No, it cannot.  But it can do 80% of what you demand and perform those tasks with certainty; guaranteed.  Therefore it is very possible to effectively automate a very significant portion of your work. (click for larger image)


Will traditional spreadsheets still be available?  Absolutely.  Traditional spreadsheets will still be useful.  This new type of tool provides new types of capabilities beyond what is possible with a traditional spreadsheet.

Additional Information:

Comments

Post a Comment

Popular posts from this blog

Relational Knowledge Graph System (RKGS)

Image
Relational Knowledge Graph System (RKGS) is an interesting idea that combines the relational paradigm and the knowledge graph paradigm.  This documentation, Why RKGS , explains the idea. This gets even more interesting with the notion of "relational AI".  RelationalAI is described as follows by the company of the same name, Relational.ai : “RelationalAI is a cloud-based relational knowledge graph management system, with state of the art probabilistic processing and declarative reasoning at scale to make developing Data Applications a superpower for your business.” This notion of knowledge graphs represented in relational databases fits into my belief that knowledge graphs have two aspects: the expression SYNTAX and the logic of what is expressed or SEMANTICS. While the LOGIC of a knowledge graph is always the same regardless of technical syntax used to express that logic; there are many, many different technical syntaxes that can be used to represent a knowledge graph. There
Read more

Getting Started with Auditchain Luca

Image
The Innovator's Dilemma points out that disruptive innovations often look like toys that are doing everything wrong. Auditchain Luca , which is part of the Auditchain Suite , is a unique approach to creating a knowledge graph .  To experience using Auditchain Luca, have a look at the Getting Started with Auditchain Luca instructions. Be sure to grab the Excel and JSON import files used for this getting started exercise.   This getting started exercise uses one of several different approaches to getting information into a tool for constructing and viewing professional quality knowledge graphs .  Additional getting started guides will be made available over time. Auditchain Luca might not make sense to you if you don't understand the paradigm shift that is occurring and if you have not shifted your mental map. For the next step in your journey, consider trying creating a report using a financial reporting scheme template . If you are struggling to figure out how to register or
Read more

Evaluating the Quality of XBRL-based Financial Reports

Image
From the time public companies started submitting XBRL-based financial reports to the U.S. Securities and Exchange Commission, I have been looking at those reports, trying to understand the XBRL-based reports, and trying to figure out how to get them right.  That information was used to figure out how to create software applications that help professional accountants get these reports right. Here is information that summarizes my testing and results which I stopped doing March 31, 2019: Analysis of the high level accounting relationships in the 10-Ks of about 5,716 financial reports  (5,063 public companies, about 89.1% got all these high level accounting relationships consistent with expectation, 623 were inconsistent and manual confirmation revealed the inconsistency was an error) Documentation that helps you understand 26 different types of errors in XBRL-based reports High quality documentation of hundreds of errors in XBRL-based reports submitted by public companies to the SEC Doc
Read more