Tour the Financial Solution

accountingYour company’s general ledger provides all the information to understand your financial health, efficiency and performance against objectives.  Financial reports and indicators derived from financial report categories provide the information.  But with reports alone it can be difficult to recognize trends, see relationships and calculate key financial performance indicators.

Business Intelligence can improve your financial analysis with visual tools making it easy to ask new questions, find new relationships and find new trends:

  • You can quickly understand the current status at a glance with dashboards.
  • The important Key Performance Indicators are revealed in each operational area.
  • Key Performance Indicators can be analyzed over time.

The ERP BI for PostBooks Financial Solution provides an open source BI solution with measurements and key performance indicators specific to financial analysis.  The solution is built on the open source Pentaho community edition.

The solution provides extract, transform and load processes to load a data mart designed for financial performance.  It provides dashboards giving an overview of important measures over time and pivot tables to view data from in more detail.  You can also use ad-hoc analysis tools to explore sales data.

Data Mart
ETL processes extract your general ledger data and load a data mart that is structured for fast analysis by different dimensions.  The processes can extract data based on a date range to initially load the data mart.  The processes can also extract updates to the general ledger to incrementally load updates into the data mart.

The data mart provides a set of relational tables and OLAP cubes organized for financial analysis.  The data mart is organized into four sets of facts.

  1. Account Transactions.
  2. Account Balance by Period.
  3. Account Budget Balance by Period.
  4. Account Actual and Budget Balance by Period.

Dashboards are organized by the following financial analysis subjects:

Profitability.  Categories and measures derived from income statements providing information on revenue, costs, income and margins.

Cash Flow.  Categories and measures from cash flow statements providing information on cash flow activities and efficiency.

Liabilities and Assets.  Categories and measures derived from balance statements providing information on debt, leverage ratios and return ratios.

Budget.  Comparison of budget forecasts with actual results using key performance indicators.

You can quickly review the status of each of these subjects using the financial overview dashboard.


The key performance indicators are shown with a comparison to industry averages and the current target.  Also, the trailing 12 periods are shown compared to the previous 12 periods.

High level dashboards are provided for each subject area showing key measures by period.  For example, the Cash Flow Dashboard show cash flow activities, cash balance and efficiency measures by period.


Filters are provided to view change companies, the ending period and profit center.

KPI dashboards allow you to break down each key performance indicator.  For example, Net Cash Flow is shown in the following dashboard.


  • Net Cash Flow is shown as percent increases compared to the same period in the previous year.
  • A comparison of net cash flow by profit center is provided.
  • The details for each general ledger account used to compute net cash flow are provided by year and period.  The accounts are organized by cash flow activity so you can understand how net cash flow is computed:

       Net Cash Flow = Net Income + Operating Activities + Investing Activities + Financing Activities

You can also drill down to detailed transactions for each account:



Value of BI for ERP

Best Open Source Business Intelligence

Best Open Source Business Intelligence

Take advantage of best-of-breed open source business intelligence technology.  Reliable, cost effective solutions can be developed providing value to your organization.  The more popular technology is highlighted in the presentation Open Source Business Intelligence[...]

Rev Up the Value of Your ERP Data

Rev Up the Value of Your ERP Data

Companies who utilize business intelligence with their ERP system get the most value and are more likely to implement business performance improvements.  These are the results of Aberdeen's 2011 ERP servey of 549 organizations (see ERP Plus BI: Maximizing the Return on Your ERP). Top performing [...]

Why Don’t Small/Mid-size Businesses Utilize BI?

Why Don't Small/Mid-size Businesses Utilize BI?

Great post on why Business Intelligence is only utilized by 22% of small to mid-size businesses.  Invest in Business Intelligence Right Now Solutions built with open source business intelligence technology can remove the "Too Expensive" excuse.  And pre-built solutions are even a better way[...]

How Efficient is Your Business?

How Efficient is Your Business?

By some estimates, about 13% of a company’s revenue can be tied up in excess working capital.  Freeing up this capital can make more cash available for needed investments or to reduce debt. Your company’s financial data can give you valuable insights into how efficiently you operate.  Three[...]

What You Should Know About Open Source Business Intelligence

What You Should Know About Open Source Business Intelligence

Open Source Business Intelligence Technology is growing rapidly - see Open Source Technology Heats Up. Open Source Business Intelligence (OSBI) offers a number of advantages over proprietary business intelligence including cost-effectiveness, high innovation and ease of integration with existing sy[...]

Developing BI Solutions

No posts available

Blogger PostShare