A Bright Future for Orange Button & Solar Energy

CoreFiling recently joined XBRL US, the SunSpec Alliance, Wells Fargo and the US Department of Energy’s SunShot Initiative, to co-host the “Orange Button” webinar. This webinar focused on the role of XBRL in the US DoE’s Orange Button program – a solar energy development plan aimed at reducing solar energy costs (and growing the US solar industry).

Mark Goodhand, Head of Research at CoreFiling and a global authority on XBRL specifications, was on hand to give attendees expert advice about XBRL and its features. Solar energy is already big business in America, and a data-led approach is key to its growth; Mark showed that adopting XBRL will simplify and standardise solar data, aiding (and in some cases enabling) all aspects of the SunShot Initiative. The discussion of XBRL’s benefits covered everything from improved feasibility studies and financial projections, to better planning, smarter construction, and support for future research.

Chris Mills then put theory into practice, by taking the audience through a detailed demonstration of CoreFiling’s taxonomy development suite, Yeti.

The webinar was a real success, and gave the audience an exciting look at the bright future of solar development. Click here to watch the webinar on YouTube, or read a write-up on the XBRL US page. You can also get involved with solar energy by attending the InterSolar conference in July.

Launched: Beacon can solve your regulatory submission errors.

Filing rejections are a real problem for businesses that submit to regulators. Even if you have a solution in place to create your XBRL filings, there is no easy way to decode them, or to check what you’re actually sending. Using our 20+ years of experience in data integrity, we’ve created the solution:

CoreFiling is excited to announce the launch of Beacon: our cloud-based filing review platform. And to celebrate, we’re offering free trial access to Beacon for all users.

Beacon is a secure, collaborative review and validation tool that integrates effortlessly into your existing workflow. XBRL filings contain a lot of encoded information that you can’t see (or check) – but with Beacon, you can view that data in incredible, granular detail. The Beacon trial gives you access to Beacon’s advanced review tools: users can upload and review one XBRL document, completely free. Better yet, you can store your document in our cloud for up to three years… and review it as many times as you like.

Plus, we’re holding a free webinar for all filers, showing you how to avoid the most common errors in CRD IV (incl. IFRS 9) & Solvency II submissions.

Here are just a few of the ways that Beacon helps your organisation solve its submission errors:

The Benefits

  • Beacon lets you decode the XBRL filing. You can view your data inside a regulatory template, and see your filing as the regulator will see it. You can investigate broad sections of the filing, or drill down to individual data points, then apply targeted validation rules if you spot an error.
  • Beacon creates an advanced filing management system that’s flexible enough to fit right into your current workflow. Store all your filings in a secure, change-tracked environment. Control data access through custom user profiles. Import LDAP users and connect to your existing data sets with Beacon APIs.
  • Beacon promotes collaboration. Cloud access means colleagues can work together, anytime, anywhere. In fact, Beacon allows an unlimited number of users to view and mark up a filing at any one time. And thanks to Beacon’s cloud architecture, even the largest XBRL documents are accessed quickly – with no performance loss on your PC.

Download the PDF for more information about Beacon.

How do I sign up?

You can access Beacon right away by visiting our launch page, here. All you need to enter is your name, e-mail address and company. And don’t forget to sign up for our free Solvency II & CRD IV webinar too.

Announced: Seahorse® is the T4U Successor

After the recent EIOPA announcement that the XBRL reporting tool T4U will be decommissioned next month, many filers are now looking for a quick solution to keep their submissions compliant.

At CoreFiling, it’s our business to keep you compliant – that’s why we are proud to announce that we are offering a free trial to our cloud-based regulatory filing platform, Seahorse®. The successor to T4U.

This free trial gives you the opportunity to create one complete filing to submit to a regulator – and even better, users will have three months to explore the software before submitting their filing. Here are just some of the ways in which Seahorse® can help your organisation:

The Benefits

  • Seahorse® lets you create fast, error-free XBRL filings. Unlike T4U, its data rendering is XBRL-based, so the reports you send will never have data conversion errors or approximations. The data is 100% accurate every time.
  • Seahorse® is hosted in the cloud. Its architecture lets you update taxonomies instantly, with no tedious installations. You can create and view your filings anywhere, any time.
  • Seahorse® allows you to easily create XBRL filings in the familiar environment of Microsoft Excel.

How do I sign up?

Trial access is available to anyone. To claim your trial, simply visit our website and fill out the sign up form.

XBRL accounting taxonomy design and categorisation – Part 2: Architecture

In this series of articles, we propose a categorisation of taxonomies based on three aspects of their design: architecture, coherence and extensibility.  Using this categorisation we look at the evolution of taxonomy design through three generations.

1. An example of three taxonomy generations

In this article we look at the architecture of three taxonomies that are good examples of each generation:

2. What is architecture?

The ancient Greeks bequeathed us the word they used for the “chief builder” – architect.  Good architecture manifests itself in perceived simplicity, elegance, or consistency of form; making the best or even inspired use of the available materials and prevailing building techniques; enhancing, working with or at least complementing the environment in which it resides; and performing its intended function effectively and reliably.

In the modern world architecture doesn’t just apply to physical structures. In the software world, it can be applied to any moderately complex logical structure. There is little doubt that an XBRL taxonomy qualifies in this regard, so it is reasonable to apply the principles of good architecture to taxonomies.

3. First generation: standards based – the IFRS taxonomy

The International Accounting Standards Board’s IFRS taxonomy has been in existence for over ten years – its latest incarnation is for 2016. By that measure alone it might be regarded as a first generation taxonomy.

Its architecture is derived from the structure and content of the International Financial Reporting Standards. These standards were drawn up without the knowledge that an XBRL taxonomy would be based upon them.

The IASB was breaking new ground when it first developed its IFRS taxonomy, and to provide the taxonomy with authority it was essential to model the underlying standard as closely as possible.  The design focused on ensuring that each concept in the taxonomy mapped directly into IFRS standard which, while being a good way of reflecting the precise structure of the standard, was not able to benefit from the elements of normalisation common to modern IT data design.  The result is a taxonomy that contains silos of repetitive concept definitions, labels and dimensions.  It is also dimensionally incomplete, using dimensions only where they are absolutely necessary to fully describe data relationships.

Secondly, in limiting the content of the IFRS taxonomy strictly to the scope of the underlying standard, it was unable to provide guidance to the builders of other taxonomies based on IFRS until the creation in 2014 of the IFRS Taxonomy Consultative Group (ITCG).  One consequence of this approach is that taxonomies already derived and extended from the IFRS taxonomy vary markedly from jurisdiction to jurisdiction.  This design freedom has turned out to have a critical side effect, which is that it makes it more difficult to compare financial data drawn up against different IFRS-based taxonomies.

4. Second generation: document based – the US GAAP taxonomy

The US GAAP taxonomy has a rigorous and well-documented three-layer architecture comprising a domain model, a logical model and a physical model, with clean separation between the layers.

Similar to the IFRS taxonomy, the US GAAP taxonomy is the embodiment of a set of accounting standards.  It was modelled on the various kinds of documents that arise from the practical application of a set of accounting standards rather than the standards themselves.

The taxonomy is characteristic of architectures that have to cater for, and are developed by, numerous stakeholders.  Each of these stakeholders works with a variety of different documents each of which need to be modelled by the taxonomy leading to an unavoidable loss of focus.

This document-centric model has influenced the taxonomy in a number of ways. These include a proliferation of one- and two-dimensional hypercubes that closely resemble the tables that typically appear in documents and a requirement for HTML-marked-up “text block” data items.

5. Third generation: data model based – the UK FRS taxonomy

The UK FRS taxonomy is primarily based on the International Financial Reporting Standards (though not the IFRS taxonomy) so one might expect similarities with the IASB’s IFRS taxonomy. However, the architecture is very different.

The UK FRS taxonomy has no formally documented architecture, but nevertheless it does have a design that is modular and consistent.  The approach has been to model the data defined by the standards rather than the documents. This allows the taxonomy to focus on the data rather than document structure or presentation.  The key is in understanding the data and its potential dimensionality.

The taxonomy team at the FRC expended a considerable amount of time working with preparers and consumers to analyse over eight million Inline XBRL financial reports that had been produced in the UK since 2011, tapping into their experience to understand how the data is collected, organised and used. This has resulted in a data-centric architecture with a complete and comprehensive dimensional model.

6. Conclusion

We’ve described three contemporary taxonomies in terms of their architecture and indicated why we think each of them are good exemplars of the changing architectural approaches that characterise each of the three generations.

With each generation the foundation of the taxonomy’s architecture has become deeper and more analytical, moving from a model based on standards, to documents, and then to data. In the process, presentation, as an architectural concern at least, has been stripped away.

In following articles we’ll discuss other aspects of these three taxonomies that reinforce this characterisation.

7. A final thought

It is worth noting that you can arrive at substantially the same conclusion by different architectural routes.

If you look at the Presentation Linkbases of these three taxonomies you’ll see much the same document-centric, IFRS-oriented structure, thanks in part to the alignment of reporting terminology.  However, the underlying architectures differ significantly.

Despite this, the architects of these three taxonomies have arranged for users to see and browse the reporting structures with which they are familiar.  It wasn’t necessary to follow one particular method of deriving a taxonomy to do this.  This is a powerful demonstration that presentation is neither a by-product of design, nor something that has to be “designed in” from the outset.

XBRL accounting taxonomy design and categorisation

1. The future of taxonomy design

This is the first in a series of articles in which I propose a novel categorisation of accounting taxonomies based on three aspects of taxonomy design: Architecture, Coherence and Extensibility.

In this first overview article I will introduce the three design aspects. In future articles I will cover these aspects in more detail and examine how they apply to the US GAAP, IFRS and UK FRS taxonomies. The series will conclude with a discussion of how I’ve categorised these taxonomies and how this categorisation might inform the current direction of taxonomy design.

2. Why are taxonomies so important?

XBRL taxonomies are the key components of any electronic financial or business reporting system. An XBRL taxonomy is the formal definition of a financial or business reporting vocabulary for a given jurisdiction or reporting domain, imparting meaning to the concepts which describe the facts being reported and providing a framework within which reports are structured. It defines, the “contract” between reporter and regulator.
Just as importantly, it defines what is not permitted, except insofar as “locally negotiated” extensions allow. A taxonomy also defines relationships between reporting concepts, meaning that the “contract” not only defines the reporting vocabulary (the “what”) but also the grammar (the “how”) – how reported concepts can legitimately be combined and related to each other.
It is for these reasons that taxonomies matter in an electronic world. They are fundamental to any financial or business reporting regime and their design exerts a direct influence on the capabilities and expressive power of reporting and analysis tools.
XBRL tools and technologies are still evolving to suit the market’s needs. Experience has shown that deploying XBRL solutions takes a considerable amount of time and effort, and a large portion of this is invested in taxonomy design and development. Taxonomy authors are continually developing new ways to address the complex challenges of financial and business reporting.
It’s clear that XBRL taxonomies are currently undergoing a period of rapid evolution as they colonise a number of new financial niches, with new taxonomies building on the successes – and avoiding the perceived failures – of previous generations. I’m proposing the establishment of a new classification system for taxonomy evolution, with the hope of illuminating the future of taxonomy design.

3. Taxonomy evolution

In the family tree of taxonomies, those concerned with company financial statements can be broadly classified according to three key aspects. This has resulted in taxonomies that can be classified as belonging to one of three generations.

3.1 Aspects of taxonomy design

3.1.1 Architecture

Some taxonomies model the applicable accounting or financial standards; some model the required reporting documents; and some model the underlying data.

3.1.2 Coherence

‘Coherence’ is the degree to which a taxonomy “hangs together” and permits the creation of a body of instance documents that are consistent and comparable. At one extreme some taxonomies give the freedom to combine reportable concepts with any dimensions and to combine dimensions freely. At the other extreme such combinations are carefully controlled by the taxonomy.

3.1.3 Extensibility

Some taxonomies are very permissive when it comes to extension, to the point that “anything goes”; some taxonomies provide specific extension points so that extension can be controlled, if not actually defined; and some taxonomies provide specific mechanisms to support extension.

3.2 Taxonomy classification

3.2.1 First generation

First generation taxonomies are literal interpretations of accounting or financial standards, where the filer can do pretty much whatever they please with the base taxonomy, and any additional structured information can be captured as a privately-defined but uncontrolled extension.

3.2.2 Second generation

Second generation taxonomies model not the accounting or financial standards themselves but the regime’s required document structures derived from the applicable accounting or financial standards. Additional structured information can be captured in a private extension that should follow certain rules or guidelines laid down by the taxonomy author.

3.2.3 Third generation

Third generation taxonomies move away from an architecture derived from the accounting/financial standards or reporting document structures and instead simply model the data within the taxonomy. Additional structured data can be captured by ‘extension’ mechanisms built in to the data model of the base taxonomy itself.

All three generations exhibit convergent evolution in that they all provide a document-oriented browsing and presentation view that will be familiar to preparers and accountants, but each is derived in a fundamentally different way.

4. A new taxonomy classification system

The key taxonomy design aspects that categorise taxonomy evolution are summarised as follows:

Taxonomy Classification

5. Next article

In the next article in this series I will discuss the Architecture aspect of taxonomy design in depth, with reference to the US GAAP, IFRS and UK FRS taxonomies.

I would like to also thank Andy Greener for his contributions.

Life after the removal of Excel-based CRD IV reporting in Portugal

In June 2014, to ease the transition to its new CRD IV reporting regime, the Bank of Portugal introduced a free reporting system based upon the completion of Excel spreadsheets. Not surprisingly, very many Portuguese financial institutions took this easy way out and for the past year have been filing their CRD IV returns using this method.

Only XBRL accepted from the end of June 2015

However, as was fully explained at the time, reporting in Excel was introduced as an interim step only, and the ability to use the spreadsheet-based system is about to disappear. From the end of June 2015 the large number of filers currently using the Excel-based reporting application will have to find an alternative approach.

Seahorse, the XBRL lifeline

Seahorse®, CoreFiling’s cloud-based XBRL conversion software, will provide a lifeline to Portuguese financial institutions now that they need to find ways of converting their spreadsheet data into fully validated XBRL instance documents before submission to the Bank of Portugal. Seahorse provides an easy to use, risk-free solution to the problem of complying with the CRD IV XBRL mandate. It is a SaaS-based application, readily accessible from any internet browser. There is no software to install or maintain, and Seahorse requires no effort on the part of the user when taxonomy changes occur, as these are handled behind the scenes.

Continue reading “Life after the removal of Excel-based CRD IV reporting in Portugal”

The count-down to Solvency II Pillar 3 reporting – 5

How do I keep up to date with XBRL taxonomy changes?

The whole process of gathering relevant data and implementing an effective workflow to turn that data into valid XBRL reports is daunting enough, but the challenges do not stop there. What happens when the underlying XBRL taxonomy changes, as it undoubtedly will? What solutions are available to help smooth the reporting process?

The impact of Solvency II taxonomy changes

Without specialist insight into the taxonomy structure it is difficult to understand what changes have occurred from one version to the next and, more significantly, how the changes might impact both technical considerations and the preparation of XBRL reports.

Compliance with EIOPA business rules

The business rules imposed by EIOPA and the NCAs may also be amended from time to time, and this could have a profound effect on the data that needs to be reported. How will your reporting systems cope with frequent updates? How will you make sure that your systems remain current, producing totally valid XBRL documents that will not be rejected at the point of submission?

Some systems rely on hard-coding and may prove inflexible, so you would do well to make sure that you will not incur massive system and cost overheads just to bring your reporting into line each time.

Continue reading “The count-down to Solvency II Pillar 3 reporting – 5”

The count-down to Solvency II Pillar 3 reporting – 4

How do I report to my NCA?

Although it remains at the discretion of the individual NCA, many regulated firms will find that they must now submit their quantitative reports in XBRL, which may be an unfamiliar format presenting a new set of challenges, particularly since there is now so much more data to be handled (at a recent conference estimates were quoted at over 10K data items for solo reporting, and 200K for group reporting during the preparatory phase, increasing to around 40K and 800K data items respectively when full scope reporting arrives in January 2016).

Integration or standalone?

How to handle the data is a key issue. Many insurers will have existing workflow and security processes in place, but must now integrate them with the less familiar requirements of XBRL preparation, validation and rendering, so both the IT department and the business will need to engage to ensure that the relevant data can be captured and turned into the required reports.

Decisions need to be made: whether to create a standalone environment or embed reporting into current architecture; whether to rely on process professionals to provide the specialist XBRL capabilities (which may be outside their core competence), or to seek help from a dedicated XBRL technology company.

Continue reading “The count-down to Solvency II Pillar 3 reporting – 4”

The count-down to Solvency II Pillar 3 reporting – 3

What do I report?

As mentioned in the previous Blog Post, even firms that begin reporting during the Solvency II preparatory phase will notice a hefty increase in the number of templates they need to complete when full scope reporting arrives in January 2016.

Quantitative and qualitative reporting

Solvency II Pillar 3 brings a huge increase in the amount of data that needs to be reported. For example, for the first time detailed asset data must be included. Firms will also need to take into account a new set of reporting requirements, relating to both quantitative and qualitative disclosures. Under Pillar 3, the main focus is on two particular reports, which require both qualitative and quantitative data:

  • SFCR – Solvency and Financial Condition Report
  • RSR – Report to Supervisors

Public vs private reporting

Reporting also occurs on two levels – public and private. For example, a few of the quantitative templates and qualitative data will be made public in the SFCR, whereas all quantitative templates and a detailed set of qualitative data must be reported privately to the regulator in the RSR.
Continue reading “The count-down to Solvency II Pillar 3 reporting – 3”

The count-down to Solvency II reporting – 2

Do I need to report and when?

In the second of our blog series, we examine which insurance undertakings will have to begin reporting under the preparatory phase that EIOPA has introduced as a precursor to full Solvency II reporting which finally takes effect in January 2016.

While all insurers are expected at least to start preparing for the full implementation of the Solvency II regime, only certain organisations meeting prescribed thresholds will need to report to their NCA during the preparatory phase, but this is due to begin in June 2015, so time is very short.

Interpretation of the EIOPA thresholds

The thresholds specified by EIOPA are:

  • Individual annual reporting for firms representing at least 80% of the national market share
  • Individual quarterly reporting for firms representing at least 50% of the national market share
  • Group quarterly or annual reporting for firms with more than EUR 12 billion (period ending during 2012)

Continue reading “The count-down to Solvency II reporting – 2”