{"id":11846,"date":"2024-02-02T09:17:15","date_gmt":"2024-02-02T00:17:15","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=11846"},"modified":"2024-02-02T22:15:06","modified_gmt":"2024-02-02T13:15:06","slug":"requirements-for-xbrl-gl-srcd-taxonomy-using-xbrl-csv-with-hierarchical-tidy-data-structure","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=11846&lang=en","title":{"rendered":"Requirements for XBRL-GL SRCD Taxonomy Using XBRL-CSV with Hierarchical Tidy Data Structure"},"content":{"rendered":"<p>Views: 12<\/p><div id=\"header\">\n<h1>Requirements for XBRL-GL SRCD Taxonomy Using XBRL-CSV with Hierarchical Tidy Data Structure<\/h1>\n<\/div>\n<div id=\"content_adoc\">\n<div class=\"sect1\">\n<h2 id=\"_prerequisite_understanding_xbrl_gl_srcd_taxonomy_with_xbrl_csv\">1. Prerequisite Understanding XBRL-GL<br \/>\n            SRCD Taxonomy with XBRL-CSV<\/h2>\n<div class=\"sectionbody\">\n<div class=\"sect2\">\n<h3 id=\"_difference_between_fr_and_gl\">1.1. Difference Between FR and GL<\/h3>\n<div class=\"paragraph\">\n<p>XBRL Financial Reporting (FR) and Global Ledger (GL) serve distinct purposes:<\/p>\n<\/p><\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p><strong>XBRL FR<\/strong>: Used for high-level financial reporting like balance sheets and income statements for external stakeholders. Elements in XBRL FR summarize financial data.<\/p>\n<\/li>\n<li>\n<p><strong>XBRL GL<\/strong>: Captures detailed, transaction-level information for internal use, such as audit trails and operational reporting. It requires a finer granularity of ata, with elements capturing every minute detail of financial transactions.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/p><\/div>\n<div class=\"sect2\">\n<h3 id=\"_role_of_srcd_in_xbrl_gl\">1.2. Role of SRCD in XBRL-GL<\/h3>\n<div class=\"paragraph\">\n<p>The SRCD module connects detailed GL data with FR summaries:<\/p>\n<\/p><\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p>It ensures that every transaction in XBRL-GL can be mapped to a summarized element in XBRL-FR, providing traceability and transparency in financial reporting.<\/p>\n<\/li>\n<li>\n<p>In the context of XBRL-GL and XBRL-FR, the SRCD (Summary Reporting Contextual Data) module acts as a connector that maps detailed transactions to summary-level data for financial reporting.<\/p>\n<\/li>\n<li>\n<p>Taking the salary payment example, here&#8217;s how SRCD would facilitate its reporting to an FR taxonomy and instance:<\/p>\n<\/li>\n<\/ul><\/div>\n<div class=\"paragraph\">\n<p><strong>GL Level (Detailed Transaction)<\/strong>:<\/p>\n<\/p><\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p>At the GL level, the transaction is recorded with all specifics: date (2024-01-25), amount (10,000 USD), debit entry to &#8220;Salary Expense&#8221; (Account 4001), and credit entry to &#8220;Bank Account&#8221; (Account 5001).<\/p>\n<\/li>\n<\/ul><\/div>\n<div class=\"paragraph\">\n<p><strong>SRCD Usage<\/strong>:<\/p>\n<\/p><\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p>SRCD would then be used to define how this GL entry detail relates to the FR taxonomy. It would specify that the &#8220;Salary Expense&#8221; account at the GL level corresponds to a particular &#8220;Salary Expense&#8221; element within the FR taxonomy.<\/p>\n<\/li>\n<\/ul><\/div>\n<div class=\"paragraph\">\n<p><strong>FR Level (Summarized Reporting)<\/strong>:<\/p>\n<\/p><\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p>In the FR instance, instead of listing individual transactions, the data would be aggregated to show total salary expenses for a period. SRCD ensures that the aggregated amount in the FR instance is directly traceable to individual transactions in the GL, maintaining the relationship between the detailed data and the summary report.<\/p>\n<\/li>\n<\/ul><\/div>\n<div class=\"paragraph\">\n<p>By using SRCD, stakeholders can see not just the summarized figures in the financial statements but also have the capability to drill down to the transactional details if necessary, enhancing the transparency and usability of financial data.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"sect2\">\n<h3 id=\"_hierarchical_tidy_data_in_xbrl_csv\">1.3. Hierarchical Tidy Data in XBRL-CSV<\/h3>\n<div class=\"paragraph\">\n<p>A hierarchical tidy data structure using XBRL-CSV might look like this for a salary payment:<\/p>\n<\/p><\/div>\n<table class=\"tableblock frame-all grid-all stretch\">\n<colgroup>\n<col style=\"width: 16.6666%;\">\n<col style=\"width: 8.3333%;\">\n<col style=\"width: 8.3333%;\">\n<col style=\"width: 16.6666%;\">\n<col style=\"width: 8.3333%;\">\n<col style=\"width: 8.3333%;\">\n<col style=\"width: 8.3333%;\">\n<col style=\"width: 8.3333%;\">\n<col style=\"width: 16.667%;\">\n                    <\/colgroup>\n<thead>\n<tr>\n<th class=\"tableblock halign-left valign-top\">header<\/th>\n<th class=\"tableblock halign-left valign-top\">line<\/th>\n<th class=\"tableblock halign-left valign-top\">entry date<\/th>\n<th class=\"tableblock halign-left valign-top\">header comment<\/th>\n<th class=\"tableblock halign-left valign-top\">dr\/cr indicator<\/th>\n<th class=\"tableblock halign-left valign-top\">account number<\/th>\n<th class=\"tableblock halign-left valign-top\">account name<\/th>\n<th class=\"tableblock halign-left valign-top\">amount<\/th>\n<th class=\"tableblock halign-left valign-top\">entry comment<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">2024-01-25<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Payment for monthly salary for John Doe<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Debit<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">4001<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Salary Expense<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">10000<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Salary payment to John Doe<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">2<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\"><\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Credit<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">5001<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Bank Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">10000<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Payment from Bank Account<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph\">\n<p>In this structure:<\/p>\n<\/p><\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p><strong>Header Layer<\/strong>: Contains the date and a description of the overall<br \/>\n                                transaction.<\/p>\n<\/li>\n<li>\n<p><strong>Line Item Layer<\/strong>: Breaks down the transaction into debits and credits,<br \/>\n                                specifying accounts and amounts.<\/p>\n<\/li>\n<\/ul><\/div>\n<div class=\"admonitionblock note\">\n<table>\n<tr>\n<td class=\"icon\">\n<div class=\"title\">Note<\/div>\n<\/td>\n<td class=\"content\">\n                                In the context of the XBRL-GL to XBRL-FR data mapping, the &#8216;Salary&#8217; account (with the account number 4001) represents the transaction detail at the GL level. This account number corresponds to a &#8216;Salary Expense&#8217; element within the FR taxonomy. However, there is no direct &#8216;Salary&#8217; element in GL; it&#8217;s an element in FR where such expenses are summarized for reporting purposes. This distinction is crucial for understanding the data structure and the mapping process between detailed ledger entries (GL) and summarized financial statements (FR).\n                            <\/td>\n<\/tr>\n<\/table><\/div>\n<div class=\"paragraph\">\n<p>Further details can be found at the following link; <a\n                            href=\"https:\/\/www.sambuichi.jp\/?p=10720&amp;lang=en\">The New Era of Data Conversion: Semantic and Syntactic Binding through Hierarchical Tidy Data<\/a><\/p>\n<\/p><\/div>\n<div class=\"paragraph\">\n<p>Another blog page to be checked: <a href=\"https:\/\/www.sambuichi.jp\/?p=4209&amp;lang=en\">Why Consider a Dimension Only Approach For XBRL GL \u2013 Part 2 \u2013<\/a><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"sect1\">\n<h2 id=\"_requirements_for_xbrl_gl_srcd_taxonomy_using_xbrl_csv_with_hierarchical_tidy_data_structure\">2.<br \/>\n            Requirements for XBRL-GL SRCD Taxonomy Using XBRL-CSV with Hierarchical Tidy Data Structure<\/h2>\n<div class=\"sectionbody\">\n<div class=\"olist arabic\">\n<ol class=\"arabic\">\n<li>\n<p><strong>Element Differentiation<\/strong>: Define distinct elements for XBRL Financial Reporting (FR) and Global Ledger (GL), with FR focusing on summary financial data and GL on detailed transactional data.<\/p>\n<\/li>\n<li>\n<p><strong>SRCD Module Implementation<\/strong>: Utilize the SRCD module to link detailed XBRL-GL data with summarized XBRL-FR data, ensuring traceability from transaction-level details to summarized data.<\/p>\n<\/li>\n<li>\n<p><strong>XBRL-CSV Format Utilization<\/strong>: Adopt XBRL-CSV for efficient handling of large datasets, incorporating a hierarchical tidy data structure to represent complex types, such as tuples in XBRL-GL standards.<\/p>\n<\/li>\n<li>\n<p><strong>Data Integrity and Compliance Standards<\/strong>: Establish rules and protocols for maintaining data integrity and ensuring compliance with financial reporting standards.<\/p>\n<\/li>\n<li>\n<p><strong>Comprehensive Documentation<\/strong>: Provide detailed documentation and user guidelines for implementing and using the XBRL-GL SRCD taxonomy.<\/p>\n<\/li>\n<li>\n<p><strong>User-Friendly Interface and Accessibility<\/strong>: Develop intuitive tools for easy access and manipulation of XBRL-GL SRCD taxonomy data.<\/p>\n<\/li>\n<li>\n<p><strong>ISO Audit Data Services Standards Integration<\/strong>: Incorporate classes and properties from ISO standards to enhance representation of financial data in a structured, dimensional format.<\/p>\n<\/li>\n<li>\n<p><strong>Taxonomy Structure Definition<\/strong>: Clearly outline the structure of the XBRL-GL SRCD taxonomy, detailing all necessary financial elements, attributes, and relationships.\n                        <\/p>\n<\/li>\n<li>\n<p><strong>Dimensional Modeling<\/strong>: Specify the interaction of different dimensions such as time periods, geographical locations, or organizational units with financial elements.\n                        <\/p>\n<\/li>\n<li>\n<p><strong>Hierarchical Tidy Data Structure Requirement<\/strong>: Ensure data is organized hierarchically to represent complex relationships within the financial data accurately.<\/p>\n<\/li>\n<li>\n<p><strong>XBRL-CSV Format Specification<\/strong>: Clearly describe how XBRL-GL data should be<br \/>\n                            formatted within XBRL-CSV files, including layout and tag associations.<\/p>\n<\/li>\n<li>\n<p><strong>Linkbase Utilization<\/strong>: Explain the use of dimension linkbase to establish relationships between taxonomy elements and facilitate multidimensional analysis.<\/p>\n<\/li>\n<li>\n<p><strong>Validation Rules for Compliance and Accuracy<\/strong>: Implement validation rules to ensure XBRL-GL data accuracy within the SRCD taxonomy.<\/p>\n<\/li>\n<li>\n<p><strong>Use Cases and Examples<\/strong>: Illustrate the XBRL-GL data structure in XBRL-CSV format using practical examples, such as the payment of a salary. For instance, an entry dated 2024-01-25 with the header comment &#8220;Payment for monthly salary for John Doe&#8221; could include debit lines for &#8220;Salary Expense&#8221; and credit lines for &#8220;Bank Account&#8221; transactions, demonstrating the hierarchical relationship between the entry header and individual line items.<\/p>\n<\/li>\n<li>\n<p><strong>Documentation and Support<\/strong>: Offer comprehensive support materials to facilitate the effective use of the taxonomy.<\/p>\n<\/li>\n<\/ol><\/div>\n<div class=\"paragraph qed\">\n<p>Q.E.D.<\/p>\n<\/p><\/div>\n<div class=\"paragraph\">\n<p>Nobuyuki SAMBUICHI<br \/>\n                    Advisor at <a href=\"https:\/\/www.xbrl.or.jp\/\">XBRL Japan<\/a><br \/>\n                    <a href=\"https:\/\/www.iso.org\/committee\/5648297.html\">ISO\/TC295 Audit data services<\/a><br \/>\n                    \u3000Convener at SG1 Semantic model<br \/>\n                    \u3000Co-project leader at WG1 <a href=\"https:\/\/www.iso.org\/standard\/86895.html?browse=tc\">AWI 21926 Semantic data model for audit data services<\/a><br \/>\n                    \u3000Liaison representative from XBRL International Inc.\n                <\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<div id=\"footer\">\n<div id=\"footer-text\">\n        Last updated 2024-02-02 09:45:43 +0900\n    <\/div>\n<\/div>\n<div id=\"toc\" class=\"toc2\">\n<div id=\"toctitle\">Table of Contents<\/div>\n<ul class=\"sectlevel1\">\n<li><a href=\"#_prerequisite_understanding_xbrl_gl_srcd_taxonomy_with_xbrl_csv\">1. Prerequisite Understanding<br \/>\n                XBRL-GL SRCD Taxonomy with XBRL-CSV<\/a><\/p>\n<ul class=\"sectlevel2\">\n<li><a href=\"#_difference_between_fr_and_gl\">1.1. Difference Between FR and GL<\/a><\/li>\n<li><a href=\"#_role_of_srcd_in_xbrl_gl\">1.2. Role of SRCD in XBRL-GL<\/a><\/li>\n<li><a href=\"#_hierarchical_tidy_data_in_xbrl_csv\">1.3. Hierarchical Tidy Data in XBRL-CSV<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_requirements_for_xbrl_gl_srcd_taxonomy_using_xbrl_csv_with_hierarchical_tidy_data_structure\">2.<br \/>\n                Requirements for XBRL-GL SRCD Taxonomy Using XBRL-CSV with Hierarchical Tidy Data Structure<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Views: 12 Requirements for XBRL-GL SRCD Taxonomy Using XBRL-CSV with Hierarchical Tidy Data Structure 1. Prere [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":11859,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[76,17,66],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/11846"}],"collection":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11846"}],"version-history":[{"count":8,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/11846\/revisions"}],"predecessor-version":[{"id":11878,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/11846\/revisions\/11878"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/11859"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}