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.
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.
- Account Transactions.
- Account Balance by Period.
- Account Budget Balance by Period.
- 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.