XBRL GL to XBRL FR The Power of
XBRL GL to XBRL FR: The Power of Integration Eric E. Cohen Founder, XBRL GL Working Group Co-chair, XBRL GL-FR Subcommittee 10/30/2020 13 th XBRL International Conference 1
Agenda • Brief overview: XBRL GL • XBRL GL’s role in integrating the business reporting/audit reporting supply chain • Demonstration • Issues under discussion in our GL-FR efforts • Call to action 10/30/2020 13 th XBRL International Conference 2
Other “views” of data UBL ACORD EDI 10/30/2020 Master Files * Operational Details Journal Entries * Trial Balances Setup Files and more 13 th XBRL International Conference Statutory Filings Statistics Tax Returns Financial Statements 3
Scope and role of XBRL Processes Business Operations XBRL GL, the External Internal Journal Busine. Taxonomy Busines ss Reporti ng s Reportin g Trading Partners Management Accountants Economic Policymaki ng “Financial Reporting” Financial Publishers and Data Aggregators Companies Participants Investme nt, Lending, Regulatio XBRL n Auditors Software Vendors Investors Regulators Central Banks
EEC’s Vision • A piece of business information, once entered into any system, anywhere, never has to get retyped as it flows along the information supply chain. ” • Manager’s vision: drill down from end reporting to underlying detail • Auditor’s vision: easy access to the original source document, tracking full authorization of entries (accountability) 10/30/2020 13 th XBRL International Conference 5
With XBRL GL • You can associate accounts, documents, entries to end reporting concepts anywhere along the audit reporting supply chain • Facts can be associated with multiple reporting concepts simultaneously • You can track multiple sets of books • Tracking book to tax differences (FAS 109/IAS 12) comes standard 10/30/2020 13 th XBRL International Conference 6
Integration: From Detail to Reporting • With inspiration from the leading financial reporting extender • Assignment of accounts to reporting • Reporting trees • Reporting calendars 10/30/2020 13 th XBRL International Conference 7
Assignment of Accounts to Reporting • Accounts in all their varieties • Traditional accounts • Customer, employees, banks, jobs 10/30/2020 13 th XBRL International Conference 8
The xbrl. Info Structure • xbrl. Include • Label roles • Matching to appropriate elements • summary. Reporting. Element • detail. Matching. Element Time Sheet 100 hrs @ € 1000 10/30/2020 13 th XBRL International Conference <measurable. Quantity> <amount> 9
Assignment: xbrl. Info Balance Sheet Assets Cash XBRL GL <xbrl. Info> <xbrl. Include>ending_balance <summary. Reporting. Element>Cash </xbrlinfo> Statement of Changes in Cash <xbrl. Info> <xbrl. Include>period_change <summary. Reporting. Element>Change. In. Cash </xbrlinfo> 10/30/2020 13 th XBRL International Conference 10
Multi-GAAP Reporting US GAAP XBRL GL <xbrl. Info> <xbrl. Include>ending_balance <summary. Reporting. Element>usfr-pt: Cash </xbrlinfo> IFRS <xbrl. Info> <xbrl. Include>ending_balance <summary. Reporting. Element>ifrs-gp: Cash </xbrlinfo> <xbrl. Include>ending_balance <summary. Reporting. Element>irs-1120: Cash </xbrlinfo> <xbrl. Include>ending_balance <summary. Reporting. Element>xyz-fr: Cash </xbrlinfo> 10/30/2020 US Tax Management Reporting 13 th XBRL International Conference 11
Glossary of “Drilling” Concepts • Drill down • Starting with summarized information, moving towards underlying detail, eventually back to the source document and original entry. Focusing on one fact and finding more information on that fact. • Drill up • Starting with detail, moving toward summarization of that detail, eventually to the end assertion. An action that removes the “children” and focuses on the “parent”. • Drill around* • Being able to change direction and move up or down a different path than the original drill down or drill path 10/30/2020 13 th XBRL International *A concept I was introduced to by Navision. Conference 12
Drill Up, Drill Down, Drill (All) Around XBRL GL <xbrl. Info> <xbrl. Include>ending_balance <summary. Reporting. Element>usfr-pt: Cash </xbrlinfo> <xbrl. Include>ending_balance <summary. Reporting. Element>irs-1120: Cash </xbrlinfo> <xbrl. Include>ending_balance <summary. Reporting. Element>xyz-fr: Cash </xbrlinfo> 10/30/2020 13 th XBRL International Conference US GAAP US Tax Management Reporting 13
Reporting Trees Northeast Lynn Jones Bill Le. Page Americas Northwest United States Southeast Mary Epp Mary O’Donnelly Southwest 10/30/2020 13 th XBRL International Conference 14
XBRL GL’s Sophisticated Accounts segment. Parent. Tuple - parent. Subaccount. Code - parent. Subaccount. Type - reporting. Tree. Identifier - parent. Subaccount. Proportion Utilities primary account 5300 -302 -000 -107 -G Reporting Structure 302: Northeast Division 10/30/2020 000: General Profit Center Multiple reporting trees Fractional allocation 107: Sales Department 13 th XBRL International Conference G: Government Project 15
Reporting Calendars • • Days Weeks Months Quarters Years Calendar Custom 10/30/2020 13 th XBRL International Conference 16
Demonstration XBRL GL 10/30/2020 13 th XBRL International Conference 17
Integration Additional Proposed Solutions • Limit XBRL GL • Virtual limitations through profiles • Hard code end reporting hints 10/30/2020 13 th XBRL International Conference 18
Conclusion • The power of integration is • Bringing together detail from disparate systems anywhere along the information supply chain • Drill up, drill down, drill around • All of the support for reporting in one place • Enabled today, more powerful tomorrow • The facilitator for the seamless audit trail 10/30/2020 13 th XBRL International Conference 19
Feedback • Requirements • Please share • xbrlgl@xbrl. org • http: //groups. yahoo. com/group/xbrl-gl-public • Your speaker • • Eric E. Cohen XBRL Global Technical Leader, Pw. C Eric. E. Cohen@us. pwc. com +1 -585 -271 -4070 10/30/2020 13 th XBRL International Conference 20
- Slides: 20