Modern Working Trial Balance

Certified Public Accountants (CPAs) and Chartered Accountants (CAs) know what a working trial balance is.  A working trial balance is a core artifact/tool in the compilation, review, or audit of a set of financial statements.  When I began my career in accounting in 1982 with Price Waterhouse we created a working trial balance on paper spreadsheets.  Shortly thereafter I helped to pioneer the use of the electronic spreadsheet for creating accounting artifacts such as the working trial balance.

Today, I believe, I have contributed to pioneering an even more modern approach to creating a working trial balance and other such accounting and auditing schedules or working papers: the model-based, machine-understandable, standards-based logical spreadsheet.


Here is a working prototype of a working trial balance represented using the global standard XBRL that is machine-understandable. It can be effectively loaded into any fully compliant XBRL software.  Here are three examples using three different software applications:

Pesseract: (working proof of concept)


Auditchain Pacioli: (commercial software under development, view the report below online here)


Auditchain Luca: (commercial software under development, view HTML rendering online here or PDF rendering here)


(Note that the above rendering generated by Luca is not fully functional but will be able to pivot the period dimension similar to Pesseract and Pacioli in the near future.)

If you are curious and want additional information, see this Showcase and these working Examples and Samples (prototypes) to help you get your head around all this.

More 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

Graph Hairball

Image
Knowledge graph system logic, the "things" and "relations between things" that  graph theory calls "vertices" (a.k.a. nodes, points, entities, things) and "edges" (a.k.a.  links, lines, relations, associations), looks like a big graph hairball as some people call it an example of which you can see here: Why?  This common view of a graph is because there has to be some "general view" of the information provided by the graph.  This is just like a general view of the information within a relational database is a table ; a set of ROWS and COLUMNS for exactly one table at a time. So what is interesting is that with a graph database the default view is everything in the graph of knowledge.  Whereas the default view of everything in a relational database is one table at a time. Further, it does not really matter whether the information that populates your knowledge graph comes from, say, CSV files, Excel, JSON, XBRL, RDF, PROLOG or whateve
Read more

PLATINUM Business Use Cases, Test Cases, Conformance Suite

Image
A brick wall is made of exactly two things: bricks, mortar. But a brick wall created by a master craftsman, or mason, and a brick wall created by a “weekend warrior” with no knowledge of masonry will be very different. Master craftsmen are created and that process takes time and effort. This blog post is a first prototype that brings several things together into one useful resource for business professionals.  It pulls together the human readable information of the Showcase of Reports   and the machine readable information of the Conformance Suite of XBRL-based Financial Reports Prepared using the Seattle Method .  Then, I want to incorporate the information found in these PLATINUM XBRL-based Financial Report Examples . The three resources can be useful and used independently; but they are even more useful when used together.  Business professionals really could not care a less about the technical details of getting some result that they want.  But technical professionals need to under
Read more