Ioppolo and Associates

Ioppolo and Associates

Combining External Data with Odoo

combining external data with odoo
Many businesses may operate external applications or systems in addition to Odoo. This may include for example, special processing or manufacturing machinery which has its own sensors and associated software that captures key production centric data that often when combined with financial data may provide key insights into overall business performance. Sometimes key data associated with business performance may be coming from external sources or a business may have a requirement to store historical information that resides in other systems in an environment that will facilitate easy comparisons and seamless reporting with current business activity. Specific examples of this “mashing up” of data for the purpose of management reporting may include;
  • The adding of additional budget/reforecast information not present in Odoo which may be by customer, product, territory and branch.
  • The need to group certain analytic accounts across multiple entities together to produce a report that represents a managers sphere of responsibility.
  • The need to bring in data captured from your processing plant such as wastage, processing volumes etc. that you may like to evaluate against costs.

Odoo is seldom used as the platform for producing businesses management reports.

For many businesses, “mashing up” activity is undertaken in Excel where end users have the ability to format and add additional information to the data sourced out of Odoo to frame up a comprehensive formatted view of business performance which is commensurate with the way the business is viewed and managed. However, using a myriad of hard to manage spreadsheets to deliver this outcome  becomes time consuming to update and can provide business decision makers with error prone information. With complex spreadsheets also comes “Keyman” risk, where business management may be beholden to the developers of these spreadsheets for the information needed to run their business.

I&A has developed a solution called Essatto which through its built in connector integrates with Odoo and delivers comprehensive budgeting and forecasting, aggregates ALL of the businesses data including Odoo into a central Data Analytics platform and provides streamlined reporting to save a business time and value add by helping to uncover cost savings and revenue opportunities.
Essatto Architecture - Odoo Perth WA
Essatto Architecture

ESSATTO KEY FEATURES

  • “One Click” Management Reporting through the integration of your existing Excel management reporting pack
  • Multi-Scenario Budgeting and Forecasting
  • Multi-Dimensional Actual vs. Budget vs. Reforecast performance and variance analysis including by entity, customer, product, district, store, Responsibility Centre and Sales representative
  • The ability to integrate Odoo data with data coming from other sources
  • A simplified consolidation module that facilitates consolidation of actual as well as budget/reforecast data, accounting for minority interests and foreign currency impacts
  • Extensive reporting and dashboarding including “live-link” excel read and writeback and web dashboards and reports
  • Also being delivered in the next release of Essatto, is a comprehensive forecast Cash Flow capability that takes into account expected future flows derived from Odoo as well as future flows that are not reflected in Odoo such as cashflow impacts of projected sales
Best Essatto implementation and management in Perth WA

ASK US A QUESTION

Scroll to top