Friday, November 20, 2009

(Extensible Business Reporting Language (XBRL)

Extensible Business Reporting Language (XBRL)

XBLR SAP BPC:


XBRL is a language for the electronic communication of business and financial data which is revolutionising business reporting around the world. It provides major benefits in the preparation, analysis and communication of business information. It offers cost savings, greater efficiency and improved accuracy and reliability to all those involved in supplying or using financial data.

XBRL stands for eXtensible Business Reporting Language. It is one of a family of "XML" languages which is becoming a standard means of communicating information between businesses and on the internet.
XBRL is a language for the electronic communication of business and financial data which is revolutionising business reporting around the world. It provides major benefits in the preparation, analysis and communication of business information. It offers cost savings, greater efficiency and improved accuracy and reliability to all those involved in supplying or using financial data.

XBRL stands for eXtensible Business Reporting Language. It is one of a family of "XML" languages which is becoming a standard means of communicating information between businesses and on the internet.

XBRL provides a number of benefits, including:

  • Computer readable, transmittable over the Internet
  • Global agreement on reporting standards
  • Automatable, reliable re-use of data
  • Reduce re-keying of information to reuse it
  • Focus on numbers, not presentation
  • Mechanism for building "dictionaries" of terms to be exchanged
  • Extensible (extendable, flexible, scalable)

Term

Description

Attribute

A property of an element, including its name, balance, data type and whether the element is abstract. Attributes of XBRL US GAAP Taxonomy elements cannot be changed.

Axis

An instance document contains facts; an axis differentiates facts, and each axis represents a way that the facts may be classified. For example, Revenue for a period might be reported along a business unit axis, a country axis, a product axis and so forth.

Cloud Report

The Cloud Report is a validation tool created by a third party to assist with the XBRL filing process. This report was designed as a collaborative tool to help vendors and filers interpret the SEC EDGAR Rules.

DFN

Detailed FootNote

Deprecated Element

Element that has been removed in later revisions of the taxonomy. Their use should be avoided.

Dimensions

Permits use of same element in multiple contexts (as opposed to separate tags for each item). Most commonly found in Statement of Shareholders Equity. Also an XBRL technical term for axis.

Domain

An element that represents an entire set of other elements; the domain and its members are used to classify facts along the axis of a table.

Element

XBRL components (items, domain members, dimensions, etc.) The representation of a financial reporting concept, including: line items in the face (financial statements without the notes or schedules) of the financial statements, important narrative disclosures and rows and columns in tables.

Extended Element

See Taxonomy Extension

FAF

Financial Accounting Foundation - Maintains the U.S. GAAP Financial Reporting Taxonomy in XBRL for the SEC.

Flow-through

When shared elements and/or values exist in more than one of the financial statements.

Mapping

Process of determining the elements that correspond to lines and columns in a financial statement and which elements must be created by extension. Partially used by Rivet to assist clients in viewing given tags to be used in clients' filings.

Native XBRL Files

Native XBRL files submitted to SEC as part of Official EDGAR submission. XBRL submission consists of the following 6 files:

  • Instance Document - XBRL version of client's filing contains the reported values and their data tags.
  • Extension Schema - Contains information about each data tag: its name, (Marketable Securities), characteristics (US$) and relationship (Balance Sheet item).
  • Calculation Linkbase - Contains the calculation rules which are used to validate the data. (Revenue – Total Expense = Operating Profit)
  • Label Linkbase - Contains the text labels that will be presented for display to the end user in each statement. “Cash and Cash Equivalents”, “Marketable Securities”. Contains the definitions associated with custom extensions.
  • Definition Linkbase - Contains sets of user-defined descriptions which allows for a degree of customization within the XBRL standard to define relationships between concepts. For example, when companies report dimensional elements, such as the Shareholders Equity table items, a definition linkbase is required to map the linkage. (Common Stock Member à Beginning Balance & End Balance - these are linked to the highest dimension of Shareholder’s Equity).
  • Presentation Linkbase - Contains information about how to order each Financial Statement and each line item within the statement for display to the user. (Balance Sheet Income Statement Cash Flow Statement)

Rendering

Viewing - Since XBRL is computer code and cannot be understood by simply reading it, the files need to be "rendered" and put into a readable format.

Segments

Tag that allows additional information to be included in the context of an instance document; this information captures segment information such as an entity's business units, type of debt, type of other income, etc. Commonly used with subsidiaries.

Significant Accounting Policies

Accounting policies that are truly significant and should be tagged at Level 2

Tag (noun)

Markup information that describes a unit of data in an instance document. All facts in an instance document are enclosed by tags.

Tag (verb)

To apply markup to an instance document.

Tag Attribute

Each tag has specific attributes to identify a specific tag, such as period type, tag type, standard definitions, etc.

Taxonomy

List of common accounting terms used to tag individual line items

Taxonomy Extension

If no appropriate tag can be found in existing taxonomy, an element may be "extended" by creating a new, more focused element.

Test Filing

An XBRL filing submitted to EDGAR to ensure filing is accurate before final submission by a client.

US GAAP Taxonomy

List of common accounting terms approved by the SEC to use when tagging line items.

Validate

Process of checking that instance documents and taxonomies correctly meet the rules of the XBRL specification.

XBRL

eXtensible Business Reporting Language - Computer language designed specifically for business users to make data "interactive" and understandable across languages, currencies and global accounting terms.

Business Challenges
• Pressure to implement an XBRL publishing solution quickly
• Desire for more control and flexibility than XBRL outsourcing offers
• Limited in-house resources who can work with complex XBRL syntax directly

Key Features
• XBRL taxonomy navigation – Quickly search and filter large, complex taxonomies to find tags relevant for your business data
• Mapping – Map taxonomy tags to data using a drag-and-drop mapping environment
• Validation – Use comprehensive validation functionality to confirm accuracy and completeness and identify issues
• Disclosure inclusion – Link to and import management discussions, disclosures, footnotes, and other narratives created in Microsoft Word to XBRL documents
• Taxonomy extension – Easily extend published XBRL taxonomies to include other information
• Compliance – Be confident that your XBRL documents comply with the business rules of third-party taxonomies

Business Benefits
• Reduced time and effort to create XBRL documents thanks to integration with Microsoft Excel, taxonomy navigation tools, and drag-and-drop functions that simplify mapping
• Lower audit costs because auditors can “slice and dice” your financial data quickly and easily, enabling them to perform audits faster, more accurately, and at lower cost
• Greater confidence in your financial disclosures because data and mappings are validated as accurate, complete, and in compliance with business rules defined by third-party taxonomies
• Increased flexibility and control and lower costs by eliminating the need for XBRL outsourcing services

XBRL Formulas

* Assertions: For example asserting that the balance sheet balances or Assets = Liabilities + Equity.
* Computations: For example, calculating things, such as Total Property, Plant and Equipment = Land + Buildings + Fixtures + IT Equipment + Other Property, Plant, and Equipment.
* Process-oriented rules: For example, the disclosure checklist commonly used to create a financial statement which might have a rule, "If Property, Plant, and Equipment exists, then a Property, Plant and Equipment policies and disclosures must exist."
* Regulations: Another type of rule is a regulation which must be complied with, such as "The following is the set of ten things that must be reported if you have Property, Plant and Equipment on your balance sheet: deprecation method by class, useful life by class, amount under capital leases by class . . ." and so on. Many people refer to these as re portability rules.
* Instructions or documentation: Rules can document relations or provide instructions, such as "Cash flow types must be either operating, financing, or investing."

International Financial Reporting Standards (IFRS)

International Financial Reporting Standards (IFRS)

International Financial Reporting Standards (IFRS) are principles-based Standards, Interpretations and the Framework (1989) adopted by the International Accounting Standards Board (IASB).

International Financial Reporting Standards comprise:

  • International Financial Reporting Standards (IFRS)—standards issued after 2001
  • International Accounting Standards (IAS)—standards issued before 2001
  • Interpretations originated from the International Financial Reporting Interpretations Committee (IFRIC)—issued after 2001
  • Standing Interpretations Committee (SIC)—issued before 2001
  • Framework for the Preparation and Presentation of Financial Statements (1989)

Qualitative characteristics of financial statements

  • Understandability
  • Reliability
  • Comparability
  • Relevance
  • True and Fair View/Fair Presentation

Qualitative characteristics of financial statements include:

  • Understandability
  • Reliability
  • Comparability
  • Relevance
  • True and Fair View/Fair Presentation

Measurement of the Elements of Financial Statements

a) Historical cost. Assets are recorded at the amount of cash or cash equivalents paid or the fair value of the consideration given to acquire them at the time of their acquisition. Liabilities are recorded at the amount of proceeds received in exchange for the obligation, or in some circumstances (for example, income taxes), at the amounts of cash or cash equivalents expected to be paid to satisfy the liability in the normal course of business.

(b) Current cost. Assets are carried at the amount of cash or cash equivalents that would have to be paid if the same or an equivalent asset was acquired currently. Liabilities are carried at the undiscounted amount of cash or cash equivalents that would be required to settle the obligation currently.

(c) Realisable (settlement) value. Assets are carried at the amount of cash or cash equivalents that could currently be obtained by selling the asset in an orderly disposal. Assets are carried at the present discounted value of the future net cash inflows that the item is expected to generate in the normal course of business. Liabilities are carried at the present discounted value of the future net cash outflows that are expected to be required to settle the liabilities in the normal course of business.


Sunday, November 8, 2009

SAP(BPC) Legal & management consolidation

SAP Business Planning and Consolidation (BPC):


Legal & management consolidation

Consolidation capabilities that deliver a complete portfolio of financial results and an integrated business intelligence platform for financial and management reporting and analysis.

SAP BPC full suite of financial and management consolidation capabilities deliver a complete portfolio of financial results, and provides an integrated performance management platform for financial reporting, analysis and planning.

  • Finance manages the process
  • Prepare global and local financial consolidations
  • Manage performance from a broader perspective with financial reporting and analysis
  • Breakthrough Consolidation(Legal/Management) with SAP BPC performance management solutions
  • Integrate easily with current and future IT environments

  • Prepare and consolidate financial information in a centralized, controlled, compliant environment to ensure the end-to-end completion of the close process.
  • Put finance users in control with self-service, automation and reporting and analysis functionality.
  • Manage, control and certify financial statement reporting.
  • Evaluate financial results with confidence and accuracy for multiple countries, currencies and legal entities, each with their own accounting policies intact.
  • Support better planning and forecasting with reliable consolidated.

Finance manages the process

  • Amend entities, organisational structures or account details with absolutely no coding, scripting, or complex language to create and test.
  • Accommodate mergers, acquisitions or reorganisations with ease.
  • Update structures and business rules once and see them reflected throughout the application automatically.
  • Provide critical financial data for regulatory compliance reporting, including Sarbanes-Oxley (SOX), IFRS and multi-jurisdictional GAAP reporting.
  • Meet the demands of management and get instant analysis any time during the close with more than 200 pre-configured, ready-to-use reports.
  • Prepare and certify financial results that support the requirements of external and internal stakeholders.

Prepare global and local financial consolidations

  • Collect and present financial data in multiple reporting and transaction currencies.
  • Use standard reports, measurements and metrics for scorecarding, dashboards and adhoc analysis and financial reporting to deliver operational, management and financial information.
  • Define critical success factors and link strategies to specific plans and metrics using embedded dashboards.
  • Meet the requirements for consolidation reporting, financial reporting and management reporting—using a single solution.
  • Process massive data volumes quickly and efficiently and allow access by large numbers of users, regardless of their location.
  • Centralized database ensures efficient processing and administration, and a single, shared source of strategic data offers accessibility and speed, regardless of user location.
  • Perform data entry, modeling and calculations with ease using the embedded Microsoft© Excel© interface enables easy data entry, modeling, calculation and reporting.
  • Perform advanced formula calculations using YTD values, averages and multiple periods combining financial and non-financial metrics.
  • Automate allocations between companies and accounts, as well as business dimensions.
  • Ensure data consistency with a thorough validation process that readily reconciles data for accuracy and notifies you immediately of any inconsistencies.

Legal Consolidation

Legal Consolidation mean financial information based on the accounting standard US GAAP

It Gives the enterprise to report its financial data accurately, timely and consistently.

Key Points

  • Data upload from subsidiaries' financial systems
  • Currency translation
  • Inter-company elimination
  • Inter-company journal elimination
  • Consolidation reports

SAP Note 1326320, which provides essential information about this starter kit including information on further documentation.

Legal consolidation Task

Currency Conversion,

Inter unit Elimination,

Consolidation of Investment

Legal Consolidation.
In consolidation, working with BPCNW version

1. Consolidation-( all the consolidation part)
2.Rate- ( all the currency conversions and Eliminations )
3.Ownership

Dimensions....

C_Acct (A)
C_Category (C)
C_Datasrc (D)
Flow (S)
Group (R)
Entity (E)
Intco (I)
Time (T)
R_Acct (A)
InputCurrency(R)
Groups(R)
O_Acct (A)

Category©

Entity (E)

Account (A)

Currency(R)

Time(T)

Intercompany(I)

Sub Table(S)

User defined(U)

Data source(D)

1. Load the master data(Dimensions)
2.create the Applications.
3.Load the Appset and Application Parameters.
4.Customizing the Logic(We have the existing logic in BPC-BI use that Logic).
5. Reports are based on your Business request form Client Base.

Management Consolidation

A managerial consolidation may be Consider the several ways, but focuses on internal factors and may have a different entity structure than that of the Legal structure. Management reports are typically used at the end of any given reporting cycle (actual/budget/forecast etc) and allow 'management' to gauge the performance/review the data of their business.

Management consol depends on client definition and client practice in the data that they collect from the entities.

Strategic questions focus on long-term profitability, which is a result of consolidation

Industry structure, i.e. market drivers such as bargaining power of customers/suppliers, threat of new entries/of substitutes

Competitive differentiation, i.e. a company’s uniqueness regarding customers (products, services, pricing) and competitors (costs) .

With the deregulation of markets and increasing internationalization, the industry structure gains in importance when compared to competitive differentiation.

To succeed Management Consolidation of International Business , four competences have to be met:

competitive competence

A company indicates a high competitive competence when it copes with the rules of the market place better than any other competitor. Key performance indicators are productivity per employee and market capitalization.

financial competence

High competitive competence is not sufficient, though, to shape a process of industry consolidation. In addition, financial competence is needed to raise funds, e.g. for takeovers. Key performance indicators are earnings before interest and tax (EBIT), equity, return on equity (RoE), gearing and the structure of investors (in order to raise additional funds).

internationalization competence

As consolidation today refers either to a multinational trade region (EU, NAFTA, APEC, etc.) or a globally driven environment, a company has to assess its preconditions for a successful internationalization process. Key performance indicators are the existing foreign business and the management board’s international expertise.

change competence

Consolidation usually imposes heavy reorganization upon a company (due to new business models, rapid internal growth, and/or merger and acquisitions). It is therefore vital to identify reorganization needs in time and to successfully drive the reorganization process. Key performance indicators are the number and size of successfully completed reorganizations.

The consolidation index serves as a management tool:

to identify a company’s position in a consolidating environment and

to assess a company’s strategy in the light of a larger consolidation process.

This Management Consolidation leads to the following questions:

European banking Industires

• Which banks have the potential to drive the consolidation process in the European market?

How may incumbents be able to achieve a generalist position in the European market?

How will the German banks and their home market be affected by the European market consolidation?

Under consideration are the ten European as well as the three leading German banks. The consolidation competences have been specified as follows:

competitive competence

revenues per employee and market capitalization

financial competence

earnings before tax, return on equity (RoE before tax), and tier I capital7

internationalization competence

share of “non-home market” revenues and “non-domestic board” representation

change competence

size and number of reorganizations and integrations within the last ten years

Based on a rating scheme from 1 (low) to 5 (high) for all four consolidation competences. The results have been plotted in a matrix of competitive/financial competence and internationalization/change competence.

The questions arising here are as follows:

European utilities industry

Which utility companies have the competencies to drive the consolidation process?

Are the current market definitions of integrated gas/power companies still valid in this process or do oil/gas companies have to be included as competitors?

Competitive competence

revenues, EBIT per employee, market capitalization and access to energy resources;

financial competence

earnings before interest and tax (EBIT), free cash flow (FCF), equity, return on equity (RoE before tax), and net debt/free cash flow;

internationalization competence

share of revenues outside the home market;

change competence

size and number of reorganizations and integrations within the last three years.

Over all Every Industry follows their own subsidies and Process of Management Consolidation Process