Financial Database – XBRL Experience

Hello,

I’ve been building a platform that reconstructs and displays SEC-filed financial statements (www.freefinancials.com). The backend is working well, but I’m now working through a data-standardization challenge.

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., “Revenue”).

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.

Thanks!