XBRL in Production

1
XBRL in Production

• Dutch local government

2
Part 1 The XBRL project

• The Business case
• The Project steps
• The Users
• The Results
• Paul F. Snijders - Semansys Technologies

3
Why Semansys was involved
Semansys is the first to offer a complete
application suite for digital reporting based on
XBRL, enabling organizations to optimize their
internal and external financial reporting and
business monitoring processes.
Semantic Business Intelligence
XBRL 1.0, XBRL 2.0, XBRL 2.1, XBRL GL
,Conformance Suite, Dimensions, LRR, FRTA, FRIS,
Formulas,
4
Our role in XBRL

• First European projects XBRL
• Dutch Treasure,
• NTP, Netherlands Taxonomy Project
• Water Boards,
• Local Gov,
• Bank,
• Founding Member XBRL Netherlands
• Board Member EU Consortium
• Member of
• Intl XBRL Specification Workgroup
• XBRL.NL, Solutions
• XBRL Domain,
• XBRL CRAS
• XBRL.DE AG 4 Tools
• XBRL.UK implementation group

5
The Business case

• Transparency needed in Financial situation
• hidden capital and unclear financial position
  local gov.
• Politicians in Europe demand more control over
  monetary policy.
• No European wide reporting standard in use.
• New reporting requirement to implement
• EMU reporting (European Monetary Union) to
  European Commission, European Central Bank
• More detail, More frequent
• Faster within 30 days
• Need for reduction in Administrative burden

6
The project

• A small group of preparers
• start with 16 Water Boards
• All participants in reporting chain involved
• Benefits for preparers and regulators
• A showcase implementation of XBRL
• Standard XBRL software utilized

7
The users

• Start with Water Boards
• Semi government, Euro 2.5 Billion Budget
• Water management, dyke control, water quality
• Expanded to local government orgs in Holland
  (900)

8
Joint effort
Preparers and Semansys compose the solution for
the complete reporting chain
Sales package to regulator
Realized High level support
Software vendors adopt XBRL
Preparers
All local government organizations MUST report in
XBRL
Integrated Semansys OEM solution
9
Project scope

• Minimal burden for preparers
• Foundation for other reporting tasks
• Water boards have 99 reporting obligations
• Low cost, easy deployment
• Showcase for 900 other organizations
• Blueprint for other closed loop reporting duties
• Ministry of Health, Education,

10
Solution outline
XBRL
World Wide Web
11
New preparer environment

• Walk-up user interface
• 1 day introduction on background, no training or
  not application
• Potentially 1 3 button operation
• Prepare report, Display, results, Send
• Operation steps introduced on request

12
New preparer environment
13
New preparer environment
14
New preparer environment
15
New preparer environment
16
Lessons learned - facts

• Dos
• Align stakeholders
• Concept XBRL appealing but difficult for
  preparers
• Quality and support for taxonomy is vital
• Use XBRL as enabler, not solution
• Dont
• Hard code XBRL in application
• Show XBRL to user
• Forget to loop back as processor
• Forget about taxonomy publishing procedures

17
Lessons learned - Conclusions

• Highly feasible
• Keep it simple
• No hassle
• Do not hype XBRL
• Results
• Closed loop solution realized
• Proven integral approach
• No threshold for direct utilization
• Standard software available
• Implementation at low cost
• Instant advantages for preparers and regulator

18
XBRL is government policy
Dutch Administration
XBRL is the most effective way to reduce
administrative burden
Expense reduction
through XBRL
euro 420 million
19
CreditsWith special thanks to
Association of Water Boards Wijnand Dekking The
users Aa en Maas Alblasserwaard De Brielse
Dijkring De Dommel Groot Salland Hollands
Noorderkwartier Noorderzijlvest Reest en
Wieden Rivierenland Rijn en Ijssel Vallei Eem
Velt en Vecht Veluwe Brabantse Delta Zeeuws-Vlaand
eren Zuiderzeeland Statistics Netherlands
(CBS) Gerrit de Bolster Marko Roos Dick van
Tongeren Léonard Haakman LogicaCMG Corné
Hordijk Ralf van den Ham Deloitte. Dave van den
Ende Rob Dubbeldeman
Minister of the Interior Minister J.
Remkes Minister of Finance Minister G.
Zalm Dutch Administration For advancing
adoption XBRL-NL Jan Pasmooij XBRL
International Walter Hamscher IBS Nederland
BV Jan van Wijngaarden Marcel Baelemans Robert
Jan Vonk CODA David Boot Felix
Rijnierse Wilfried Teunissen Peter van Ass Hans
van Leur PinkRoccade Jos van Kollenburg Koen
Laurijsen Frank Kanne
20
Part 2 The XBRL project

• Agenda Marko
• Marko Roos Dutch Statistics

21
(No Transcript)
22
Migrating the Dutch Waterboards taxonomy

• XBRL based reporting waterboards implemented Q1
  2004
• Taxonomy and instances based on XBRL version 2.0
• XBRL version 2.1 introduced december 2003
• Continue with 2.0 or migrate to 2.1?

23
Migrating background

• Update of taxonomy content neccesary
• Complaints users about
• long elementnames,
• lack of overview,
• lack of control

24
Migrating pros and cons

• Pros
• More diversity in software suppliers supporting
  XBRL 2.1
• Better presentation possibilities taxonomy and
  instances
• Easier to maintain
• Lower threshold other regulators

• Cons
• New software neccesary after only one year
• New mappingeffort needed

25
Decision migrate

• Decision made by Union of waterboards and
  Statistics NetherlandsGo!
• Transition costs softened because of maintenance
  contracts Semansys
• Statistics Netherlands to make new taxonomy and
  taxonomy implementation guide

26
Architecture of the waterboard taxonomy 2006

• Follows the architecture of the Dutch Taxonomy
  Project
• Modular approach
• Element taxonomies
• Datatype taxonomies
• Relational taxonomies (formsets, linkroles)
• Report taxonomy
• Important roles for linkroles

27
Dutch waterboard taxonomy architecture
Formset taxonomy emu-balance linkrole
Formset taxonomy exploitation linkrole
Formset taxonomy linkrole
Formset taxonomy contact linkrole
Financial element base taxonomy
Contact element base taxonomy
Datatype taxonomy
Datatype taxonomy
L
28
Calculation view based on linkrole EMU-saldi
Calculation linkroles
29
Problems encountered

• Still some duplicate elementnames
• Incorporate some hierarchy in naming
• Mutations elements (durations) calculate to
  balanced elements (instants) cross context
  calculation impossible.
• Changed everything to duration attribute (not
  nice)!

30
Current situation

• Initial reactions of waterboards positive
• No black box anymore
• More overview
• Easier to map and to maintain
• Added value because of calculation
• First data to be received May 1 st 2006

31
Future plans

• 2.1 taxonomy for states and municipalities
• Extensive use of dimensional taxonomy technology