Financial BI for xtuple PostBooks

Release 1.4 of BI for PostBooks is available providing financial business intelligence.  Here’s an overview:

The release is available on SourceForge:

Tour the Financial Solution

Your 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.

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.

Read more

About fblauer

Fred Blauer is a senior consultant with more than 20 years of experience providing information systems consulting, ERP implementation, syste
This entry was posted in Accounting/ERP, Business Intelligence and reporting, Business open source, Integrations, Tools, xtuple. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s