SQL Power Business Intelligence & Data Migration ConsultingThe Canadian Business Intelligence (BI) Authority, based in Toronto
Company OverviewConsulting ServicesMobile BIXBRL SolutionsCase Studies: Client Success StoriesResources & TrainingTechnology PartnersContact Us

SQL Power XBRL Solutions

Get Started
Get Started

Free XBRL Case Study
Free XBRL Case Study

What is XBRL?
What is XBRL?

 

XBRL has evolved to be the Global standard for Financial Reporting and for Financial filing throughout the world. SQL Power is partnered with UBmatrix/EDGAR Online to deliver the most comprehensive, automated end-to-end XBRL solution on the market.

SQL Power's XBRL solution removes the onus on the Filer and allows Regulators to facilitate the XBRL filing without encumbering their filers. Best of all, the full solution can be rolled out to production in less than 90 days.

 

The SQL Power Zero Footprint XBRL platform is the optimal medium for controlling, mining and reporting against standardized electronic content worldwide.

 

Introduction



Quick Demo


Built organically from the ground up specifically to satisfy complex and evolving financial regulatory requirements, SQL Power XBRL Solutions are establishing the pattern for disclosure in the 21st century - the preeminent blend of regulatory expertise and enterprise-class software engineering.

Maximum Compliance and Maximum Adoption

Zero-Footprint (or "thin client") offers the highest levels of automated filing to Regulators and their regulated subscriber entities: a subscriber simply logs in via the internet and submits its business information or corporate financial filings via a secure, intuitive submission form dynamically rendered by an XBRL taxonomy (or business rules dictionary).

The submission is then validated in real time, certified, converted and stored as XBRL for easy analysis, management and distribution. The solution permits regulatory bodies to collect high quality financial data quicker, and in an electronic standardized way - ultimately accelerating financial analysis and improving communications between regulatory agencies.

Zero software downloads and zero investment is required at the subscriber level; in fact, very little training if any is necessary. Even smaller, less sophisticated clients can output XBRL instance documents without any previous knowledge of the standard. The system also supports web services for loading and verifying existing XBRL documents, and offers an optional conversion module for CSV, XML and fixed length files.

Best of all, when revisions to the taxonomy are required, or when policy or legislative changes occur, a business user can drag and drop XBRL components using XBRL Designer and publish the new taxonomy. Forms, Analytics and all other application components are updated automatically with one touch, effectively future-proofing your organization.

 

 

SQL Power XBRL Data Capture & Analytics: Components

The SQL Power Zero-Footprint XBRL platform is based on a low-risk, modular architecture to enable the collection, processing, storage and analysis of supervisory, solvency and statistical data. The core components of the platform are:

  1. XBRL Forms and XBRL Power EAS thin-client platforms form the building blocks for the user experience,
  2. XBRL Designer, a business-user lead tool for taxonomy and returns creation,
  3. XBRL Analytics pre-built reporting and analytical solution,
  4. and at the core of these modular applications is the industry's highest performing and most scalable XBRL Processing Engine (XPE).

These application components can be purchased individually or grouped into a fully integrated end to end solution.

XBRL Components

 

XBRL Designer: XBRL Taxonomy Optimization At The Business User Level

XBRL Designer is a rules-based, metadata driven GUI design facility that gives the business user complete control over Data Collection and validation specifications. It enables "self service" for Regulators in the same way XBRL Forms enabled "self service" for filers two years earlier. It demystifies XBRL Taxonomy Design and allows Regulators to rollout their Data Collection requirements in days instead of months.

XBRL Designer puts Taxonomy design back into the hands of the Regulator, at the business user level - simplifying and streamlining the Data Collection design process and allowing regulators to quickly react to changing legislation, standards and policies without IT or 3rd party intervention.

 

XBRL Forms & Processing Engine: Financial Data Capture

XBRL Forms provides an easy-to-use, web-based front end for users to submit financial information and verify the validity of their submission. The processing engine also provides taxonomy and instance document validation and conversion to XBRL.

With the taxonomy identified, the XBRL Forms application renders a set of taxonomy-driven screens and schedules to facilitate the data capture of high quality financial information. XBRL Forms validates each filing in real time against the taxonomy, certifies the return and loads it directly into the XBRL Analytics database. With XBRL Forms, Regulators move beyond compliance by effectively removing the burden and expense of generating XBRL filings from the filing organization, thus encouraging immediate adoption of the new filing standard.

 

XBRL Power Enterprise Application Suite (EAS): Command And Control - Secure Portal To Productivity

Serving as 'mission control' for the entire XBRL Platform, XBRL Power Enterprise Application Suite (EAS) provides the enterprise-level web services required (such as security, collaboration, scheduling, notifications, user management, taxonomy management and document management) for fully-integrated, end-to-end XBRL data collection and analysis. It seamlessly integrates the individual components of the SQL Power XBRL platform to provide a single, secure access point for all users. The integral hub of SQL Power's zero-footprint end-to-end XBRL platform, the XBRL Power EAS 'thin client' runs in any modern web browser, making it easy to use, easy to deploy and instantly accessible for all users within your organization.

 

XBRL Analytics: True Data Mining/Analytics Combined With Sophisticated Financial Reporting For Maximum Disclosure And Transparency

XBRL Analytics bundles SQL Power's proven ETL technology with pre-built MicroStrategy reports, graphs and dashboards (including mobile versions) to deliver regulatory business intelligence value day one.

Standardized electronic data "content" loaded into XBRL Analytics enables intra and cross-sectored analysis and data mining for supervisory purposes. XBRL Analytics supports regulatory processes for macro-prudential supervision (i.e. benchmarking, identifying outliers, etc.) and peer rankings within an industry category or across market sectors. Standardization of data "content" also enables easy collaboration among other regulators, and in particular facilitates group-wide analysis as well as solvency calculations under an extended supervision framework.

XBRL Analytics comes with pre-defined standard reports, as well as web and mobile dashboards. Additional ad-hoc reports and custom standard reports and dashboards can also be developed internally or by SQL Power consultants to deliver a comprehensive and collaborative end-user reporting environment.

 

 

End-to-End XBRL Solution: Benefits

The SQL Power Zero-Footprint XBRL platform is a simple but comprehensive XBRL solution that removes the onus of creating XBRL instance documents from the regulated entities and ensures maximum compliance and adoption.

  • Rules-based, metadata-driven GUI design functionality puts the regulators and policy makers back in control, allowing them to quickly change the Taxonomy (data collection rules) to respond to changing trends and monitoring requirements in mere days- ultimately future proofing the organization.
  • Enables easy collaboration among other regulators, and in particular facilitates group-wide analysis as well as solvency calculations under an extended supervision framework.
  • A comprehensive and fully-integrated XBRL solution provides the optimal medium for controlling, mining and reporting against standardized electronic content.
  • A Zero-Footprint (thin client) forms-based XBRL solution removes the onus on the filing organizations - increasing adoption and compliance, while insulating the filer against the complexities of XBRL.
  • SQL Power's pre-built Analytics Data Mart comes bundled with MicroStrategy, and delivers instant reports, ROLAP cubes, Data Mining, Mobile Dashboards and an ad-hoc Business Intelligence environment.
  • Standardized electronic "content" enables direct system-to-system information sharing between filing entities, Central Banks and other regulatory agencies, and minimizes error rates as information moves from regulated sources through to the regulators analytical software via straight through processing (STP).

 

End-to-End XBRL Solution: Applications

  • Regulators & Central Banks Read more
  • Credit Risk Management in Commercial Lending Read more
  • Capital Markets Investment and Securities Regulation Read more
  • Governments, Statistical and Central Health Authorities
  • Issuers to investors "corporate actions"
  • Other Data Collection organizations

 

While the SEC and many Central Banks have mandated the XBRL standard, until now the onus has typically been on Financial Institutions (FI) or Public Issuers (the filing entities) to incur the substantial expense involved in complying with these mandates.

We are essentially reversing that model - a subscriber simply logs in via the internet and submits its business information or corporate financial filings via an intuitive submission form rendered by a standard or custom taxonomy. The submission is then validated in real time, certified, converted and stored as XBRL for easy analysis, management and distribution. The solution permits regulatory bodies to collect high quality financial data quicker, and in an electronic standardized way, ultimately accelerating financial analysis and improving communications between regulatory agencies.

SQL Power has developed a flexible set of integrated XBRL-based applications and tools used to deploy complete end-to-end, real-time solutions for government and market regulators as well as commercial enterprises - turnkey in nature and battle-tested by Canadian Regulators.

 

 


 

WE NEVER FAIL & NEITHER WILL YOU.

For more information on how SQL Power can help you roll out an end-to-end XBRL solution that reduces cost, improves productivity and facilitates better-informed business decisions, contact us today at info@sqlpower.ca or 1‑866‑SQL‑POWR.

Member Log-in

Email/ID

Password

Need an account?
Register for free