310 likes | 548 Views
A project of :. The Supplier. The Customer. The Regulator. Semansys Technologies BV. Dutch Waterboard. Dutch Statistics. XBRL in Production. Dutch local government . Part 1: The XBRL project . The Business case The Project steps The Users The Results
E N D
A project of : The Supplier The Customer The Regulator Semansys Technologies BV Dutch Waterboard Dutch Statistics XBRL in Production • Dutch local government
Part 1: The XBRL project • The Business case • The Project steps • The Users • The Results Paul F. Snijders - Semansys Technologies
XBRL Deployment Manager XBRL receiving and processing application XBRL validator Conformance Suite Support Scripting & Automation Professional XBRL Development Kit XBRL 2.1 Composer XBRL 2.0 Composer XBRL 1.0 Composer 90’ties 1999 2000 2001 2002 2003 2004 2005 2006 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,
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 • Int’l XBRL Specification Workgroup • XBRL.NL, Solutions • XBRL Domain, • XBRL CRAS • XBRL.DE AG 4 Tools • XBRL.UK implementation group
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
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
External accounting rules (EMU) 30 days to report 6 months to implement GL GL 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)
Ministry of the Internal Regulator Software vendors Joint effort Preparers andSemansys 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
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,
CBS Regulator IASC Taxonomy EMU Reporter Semansys XBRL Composer Semansys GL System CODA, PinkRoccade SAP, IBS etc Solution outline XBRL World Wide Web
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
Lessons learned - facts • Do’s • Align stakeholders • Concept XBRL appealing but difficult for preparers • Quality and support for taxonomy is vital • Use XBRL as enabler, not solution • Don’t • Hard code XBRL in application • Show XBRL to user • Forget to loop back as processor • Forget about taxonomy publishing procedures
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
XBRL is government policy Dutch Administration: XBRL is the most effective way to reduce administrative burden Expense reduction through XBRL: euro 420 million
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-Vlaanderen • 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
Part 2: The XBRL project • Agenda Marko Marko Roos – Dutch Statistics
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?
Migrating: background • Update of taxonomy content neccesary • Complaints users about • long elementnames, • lack of overview, • lack of control
Pro’s More diversity in software suppliers supporting XBRL 2.1 Better presentation possibilities taxonomy and instances Easier to maintain Lower threshold other regulators Con’s: New software neccesary after only one year New mappingeffort needed Migrating: pro’s and con’s
Decision: migrate • Decision made by Union of waterboards and Statistics Netherlands:Go! • Transition costs softened because of maintenance contracts Semansys • Statistics Netherlands to make new taxonomy and taxonomy implementation guide
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
Formset taxonomy balance linkrole Report taxonomy P P P P P P P C C C C C C Formset taxonomy fin. Fixed assets linkrole Formset taxonomy message linkrole L Dutch waterboard taxonomy architecture Formset taxonomy emu-balance linkrole Formset taxonomy … linkrole Formset taxonomy exploitation linkrole Formset taxonomy contact linkrole Financial element base taxonomy Contact element base taxonomy Datatype taxonomy Datatype taxonomy L
Calculation view based on linkrole EMU-saldi Calculation linkroles
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)!
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
Future plans • 2.1 taxonomy for states and municipalities: • Extensive use of dimensional taxonomy technology