BLOG:  Digital Financial Reporting

This is a blog for information relating to digital financial reporting.  This blog is basically my "lab notebook" for experimenting and learning about XBRL-based digital financial reporting.  This is my brain storming platform.  This is where I think out loud (i.e. publicly) about digital financial reporting. This information is for innovators and early adopters who are ushering in a new era of accounting, reporting, auditing, and analysis in a digital environment.

Much of the information contained in this blog is synthasized, summarized, condensed, better organized and articulated in my book XBRL for Dummies and in the chapters of Intelligent XBRL-based Digital Financial Reporting. If you have any questions, feel free to contact me.

Entries in General Information (257)

Agile Software Development Manifesto

A lot of people say they use agile software development methodology but few actually do.  Check out the Agile Software Developement Manefesto and the principles behind the Agile Manefesto.  If you are a business professional, you should software developers to these standards.  If you are a software engineer, you should consider following these Agile principles.

###############################

Leading Answers

Simple but wrong; or complext but right.

Posted on Wednesday, December 1, 2021 at 07:27AM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

Are accountants the last hope for the world's ecosystems?

The Guardian article by Jonathan Watts, Are accountants the last hope for the world's ecosystems?, says:

So it has come to this. The global biodiversity crisis is so severe that brilliant scientists, political leaders, eco-warriors, and religious gurus can no longer save us from ourselves. The military are powerless. But there may be one last hope for life on earth: accountants.

Wow.  Eco-accounting.  Well, as is said..."If you cannot measure it, you cannot control it."

The story ends with, "Accountants as agents of revolution? Now there's a thought."

Become the accountant who changed the world.

###############################

United Nations Green Economy

United Nations Situation Room

 

Posted on Friday, October 22, 2021 at 01:55PM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

JSON Viewer

I ran across an interesting and useful tool today, a JSON Viewer.

To try this tool out, have a look at this by clicking on it. That will open a JSON file that was provided within the JSON viewer.  Click on the "Viewer" tab and have a look.

That JSON information was created by the Pacioli logic/rules/reasoning engine. The XBRL-based report that was used to generate that JSON was this PROOF report. Pacioli took the XBRL instance, XBRL taxonomy, all the rules used to verify the report and generated this file. The file itself is not like an XML file that can expand and collapse because of a stylesheet supported by most browsers.  (Like this)

Now, the JSON provided is not financial report logic based, it is XBRL technical syntax based for the most part. So that file itself is not particularly useful.  One day I will get the information I want if I have to create it myself.

But, this does give me an idea!  Stay tuned.

Here are some other JSON Viewers: 

Posted on Wednesday, September 29, 2021 at 01:46PM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

The GQL Manifesto

The GQL Manifesto is an international effort to create an industry standard graph query language (GQL).

SQL, or structured query language, is a declarative language that one of the key underpinnings of modern information technology. SQL is the way one interfaces with a relational database management system (RDBMS) which is used to store data.  One of my personal favorite tools that I have made use of during my entire career as an accountant has been Microsoft Access and Microsoft SQL Server.

The international effort to create GQL is an industry attempt to create a similar industry standard for graph databases.  It is highly likely that this effort will be successful and GQL will very likely become an ISO standard GQL.

What would be incredible in my view is if Microsoft were to create a product similar to Microsoft Access or if they were to enhance Microsoft Access to support GQL.  Having this as part of the Microsoft Office suite of products would be a very good thing in my view.

The book Graph Databases that is published by Neo4j provides an excellent explanation of the fundamental difference between a graph database and a relational database.  See Chapter 2, Options for Storing Connected Data, page 11 which is PDF page 29.  Here is my attempt to explain that difference.

In a relational database, information about relationships is not part of the actual relational model.  In a graph database, information about relationships is fundamentally part of the information model.

That statement might seem odd. But it is true.  Relationships are not "first class citizens" in relational databases, but they are in graph databases.  Now, you can absolutely express relationships and even the meaning of relationships in relational databases.  But, you have to do it in the database itself, you cannot do it as part of the database schema.  In a graph database the relationship information is part of the schema rather than added into the data.

Graph databases are fundamentally more powerful that relational databases.

Posted on Tuesday, September 28, 2021 at 09:23AM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

The Accountant Quits

The Accountant Quits is a blog and podcast related to accountants and change. This is worth checking out.

Posted on Monday, September 27, 2021 at 07:13AM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint