Accounting intelligence

A specialist form of Business Intelligence, Accounting Intelligence is the general name for the set of technologies used to extract , analyse and present information from accounting and ERP applications such as J.D. Edwards, Oracle E-Business Suite or SAP.

Accounting Intelligence compared to Business Intelligence

Accounting Intelligence differs from standard Business Intelligence in some key ways:-

* Accounting Intelligence applications are specifically designed to analyse data from specific ERP systems. Business Intelligence is a more general tool that can be applied to any application that uses a database.

* In Accounting Intelligence, there is no staging of data in a Data Warehouse or OLAP cube. Information is extracted directly from the ERP at the time that a query is run. A Business Intelligence application typically involves a batch process to extract data from the live database, and store it in a denormalised form. This process is normally referred to as Extract, Transform, Load, or ETL. Typically around 75-80% of the development cost expended when creating a Business Intelligence system, goes into the design and development of the ETL process.

* Accounting Intelligence applications leverage the structure of the chart of accounts, so for example dimension structures can be automatically created based on business unit hierarchies, level of detail or account category codes. Time based functions specifically allow for YTD, rolling average and year on year analysis.

* Querying an accounts database directly means the information returned is up to the second real time data. Discrepancies in the accounts can be corrected and a fresh trial balance viewed immediately. Some aggregation in accounting systems is performed by the ERP when new journal entries are posted, so there is no need to use a cube to aggregate every journal entry from scratch.

* As there is no ETL process, Accounting Intelligence solutions are typically much simpler to install, implement and maintain than traditional Business Intelligence solutions. Inquiries and reports typically created by end users rather than software developers.

* Accounting Intelligence solutions can make SOX compliance easier for many companies, as there is no need to separately audit both the accounts themselves and a separate data warehouse and ETL process.

Key Advantages Compared to Business Intelligence

* An Accounting Intelligence (AI) system ensures that an Enterprise Resource Planning (ERP) system is the single source of all operational reporting and analysis, and that it can be relied upon to give accurate and secure information.

* Out of the box solution, much quicker to implement than a standard BI solution.

* As there is no data warehouse, there is no need to separately audit the staged data.

* Data returned is real time, live data, not a snapshot.

Key Disadvantages Compared to Business Intelligence

* Can only be applied to specific ERP systems, such as JDE, Oracle E-Business and SAP.

* Can not integrate data from outside the ERP system.


Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Intelligence in the American Revolutionary War — Intelligences in the American Revolutionary War was essentially monitored and sanctioned by the Continental Congress to provide military intelligence to the Continental Army to aid them in fighting the British during the American Revolutionary… …   Wikipedia

  • Intelligence analysis management — This article deals with the roles of processing/analysis in the real world intelligence cycle as a part of intelligence cycle management. See Intelligence analysis for a discussion of the techniques of analysis. For a hierarchical list of… …   Wikipedia

  • Comparison of accounting software — The following comparison of accounting software documents the various features and differences between different professional accounting software and personal finance packages. Contents 1 Free and open source software 2 Proprietary software 3… …   Wikipedia

  • Defense Finance and Accounting Service — Official seal Official logo …   Wikipedia

  • Access Accounting — Infobox Company name = Access Accounting Ltd type = Private foundation =UK (1991) location= Stratford St Mary, UK industry= Computer software products= FoundationsXP, Horizons, Dimensions, Dimensions Lite revenue= £9.1m num employees = 140 (26… …   Wikipedia

  • Emotional intelligence — (EI) is a skill or ability in the case of the trait EI model, a self perceived ability to identify, assess, and control the emotions of oneself, of others, and of groups. Various models and definitions have been proposed of which the ability and… …   Wikipedia

  • Defense Intelligence Agency — This article is about the United States agency. For other countries agencies, see Defence Intelligence Agency. DIA redirects here. For other uses, see Dia (disambiguation). Defense Intelligence Agency Seal of the DIA …   Wikipedia

  • Technical intelligence — In a pure military context, Technical Intelligence (TECHINT) is intelligence about weapons and equipment used by the armed forces of foreign nations (often referred to as foreign materiel).The related term, scientific and technical intelligence,… …   Wikipedia

  • National Geospatial-Intelligence Agency — Know the Earth, Show the Way. NGA seal …   Wikipedia

  • Foreign Intelligence Service (Russia) — Infobox Government agency agency name = Foreign Intelligence Service nativename = nativename a = nativename r = Служба Внешней Разведки logo = logo width = logo caption = seal width = 150 px seal caption = Seal of the SVR formed = December 1991… …   Wikipedia


Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.