Accounting Intelligence Article Index for
Accounting 		Website Links For
Accounting 		 

Information About

Accounting Intelligence
  CATEGORIES ABOUT ACCOUNTING INTELLIGENCE
   
business intelligence
   
data management
   
accounting software
   
erp software
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...




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 accounting packages. 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 accounts database 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 accounts package 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 and implement than traditional Business Intelligence solutions, with inquiries 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
  • 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 supported accounting or ERP systems.