{"id":36483,"date":"2025-11-11T20:27:13","date_gmt":"2025-11-11T19:27:13","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/financial-database-xbrl-experience\/"},"modified":"2025-11-11T20:27:13","modified_gmt":"2025-11-11T19:27:13","slug":"financial-database-xbrl-experience","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/financial-database-xbrl-experience\/","title":{"rendered":"Financial Database &#8211; XBRL Experience"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hello,<\/p>\n<p>I\u2019ve been building a platform that reconstructs and displays SEC-filed financial statements (<a href=\"http:\/\/www.freefinancials.com\/\">www.freefinancials.com<\/a>). The backend is working well, but I\u2019m now working through a data-standardization challenge.<\/p>\n<p>Some companies report the same financial concept using different XBRL tags across periods. For example, one year they might use us-gaap:SalesRevenueNet, and the next year they switch to us-gaap:Revenues. This results in duplicated rows for what should be the same line item (e.g., \u201cRevenue\u201d).<\/p>\n<p>Does anyone have experience normalizing or mapping XBRL tags across filings so that concept names remain consistent across periods and across companies? Any guidance, best practices, or resources would be greatly appreciated.<\/p>\n<p>Thanks!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Ok-Access5317\"> \/u\/Ok-Access5317 <\/a> <br \/> <span><a href=\"http:\/\/www.freefinancials.com\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1oui4x7\/financial_database_xbrl_experience\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-36483 jlk' href='javascript:void(0)' data-task='like' data-post_id='36483' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-36483 lc'>0<\/span><\/a><\/div><\/div> <div class='status-36483 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hello, I\u2019ve been building a platform that reconstructs and displays SEC-filed financial statements (www.freefinancials.com). The backend is&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-36483","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/36483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=36483"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/36483\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=36483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=36483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=36483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}