Data collection takes up to 2/3 of finance department’s time in most organisations1.  Is yours one of them?

The finance function of the future

Over the past decade, the finance function has undergone a complete transformation driven by a diverse set of internal and external forces.

What has not changed, however, is the fundamental objective of finance. Even today, the finance department of a company provides insight to the rest of the organisation, ensures effective risk management, and drives operational efficiency.

Being a company dedicated to helping businesses derive value from data, Excel in Business provides a comprehensive suite of financial analytics solutions to its clients. With our EiB Financial Analytics solution, we provide you with a quicker, simpler, and more intelligent way to consolidate and analyse data, saving you precious time and resources.

For simple but insightful financial reporting

EiB Financial Analytics for Sage 200 Designed for small- and medium-sized businesses, the software removes the burden of manually gathering and maintaining multiple spreadsheets, saving your finance department more time for data analysis. Learn More

EiB Financial Analytics for Sage 500/1000 This solution works with on-premise or cloud-based Sage 500/1000. With its intuitive user-interface and advanced features, the software is an ideal choice for large enterprises with complex financial analysis and reporting needs. Learn More

EiB Financial Analytics for Sage X3 This financial reporting solution works with a Sage X3 accounting solution hosted on premise or in the cloud. Despite it numerous features and advanced reporting capabilities, the software ensure a low cost of ownership. Learn More

In addition to our EiB Financial Analytics for Sage product range, we can also deliver bespoke solutions to businesses that are not currently using Sage as their preferred accounting software. Tailor-made to client’s specific needs, our bespoke solutions offer the same level of functionality and ease of use.

EiB Financial Analytics Modules

Financial Reporting Module

Provide multiple forms of P&L (e.g. Management, Statutory or Bank), Balance Sheet and Trial Balance analysis for comprehensive Cost Centre and/or Departmental comparisons.

Fully investigate Actual v Budget comparisons and comprehensively audit your data, by drilling back to the underlying transactions in Sage behind any number.

Provide multiple forms of P&L (e.g. Management, Statutory or Bank), Balance

EiB Financial Analytics 2018 - Financial Reporting Module
EiB Financial Analytics 2018 - Cross-Company Reporting Module

Cross Company Reporting Module

Report by each of your companies with ease.

Compare and contrast across all or selected companies in a single report.

Consolidate your companies how you need to. Create hierarchic and intermediate consolidations not available in Sage e.g Regions, Manager Groupings etc.

Dashboarding Module

Fully dynamic data visualisation. Allow the user to control interactive dashboards from multiple data sources

Charts designed and inspired by leading industry visualisation experts with additional charts not available from standard Excel.

Dashboards are native to Excel so can be opened without needing EiB installed.

EiB Financial Analytics 2018 - Dashboards
EiB Financial Analytics - SQL Module

SQL Reporting Module

For non-Financial information in Sage 200 e.g. Product and Customer analyses or from other external SQL applications in your organisation.

Create fully interactive, dynamic reports from SQL tables and SQL views of data created by you and/or 3rd Parties, in Excel.

Connect directly to Sage tables or views to create interactive reports such as Aged Creditors and Aged Debtors.

Report Distribution Module

Fully automate distributions of monthly report packs to your managers, by removing the need to manually create reports and subsequent emails.

Email, save or print all of your report packs at a touch of a button. Send via email or cloud storage services e.g. OneDrive or Google Docs.

Create offline reports for users without connection to your EiB server, whilst maintaining report drilldown features.

EiB Financial Analytics - Report Distribution Module
EiB Financial Analytics 2018 - Budgeting & Forecasting Module

Budgeting and Forecasting Module

Full actual v budget v forecast consolidation, reporting and dashboarding.

Report from budgets stored in your Sage application, or loaded directly.

Add any number of additional budgets and forecast versions through simple Excel importation features.

Multi-Currency Module

Convert sections of your P&L and Balance Sheets at different exchange rates e.g. Period End, Average, YTD Average.

Consolidate and report multiple companies with different base currencies to a common reporting currency.

Have full control and input of all exchange rates required by period.

EiB Financial Analytics 2018 -Multi-Currency Module
EiB Financial Analytics - Train of Thought Analysis

Train of Thought Analysis

Explore any point on interest within the cube, to unleash ad-hoc analyses of the entirety of your data

Save your new points of interest, so you can reproduce your reports again at a click of a button

Analyse data from any tabular data source, including databases, spreadsheets and text files, and add detailed insight by building upon both tabular and multi-dimensional reports.

Web & Mobile Reports – Power BI

Natively integrate your EiB Financial Analytics application with the #1 visualisation tool, Microsoft Power BI

Deployable on ALL devices including all iOS and Android tablets and phones

Cause and effect intelligence, empowering you to explore business correlations instantaneously

EiB Financial Analytics Web and Mobile Power BI Reports

EiB Financial Analytics Products – Features, Functions and Modules Matrix

EiB Financial Analytics Sage 200

EiB Financial Analytics Page - sage200
  • Financial Reporting Module Yes
  • Cross Company Reporting Module** Optional Upgrade
  • Dashboarding Module*  Optional Upgrade
  • SQL Reporting Module* Optional Upgrade
  • Report Distribution Module* Optional Upgrade
  • Budgeting and Forecasting Module* Optional Upgrade
  • Multi-Currency Module* Optional Upgrade
  • Adhoc Reporting* Yes
  • Data Error Trapping* Yes
  • EiB AppStudio Optional Upgrade

EiB Financial Analytics Sage X3

EiB Financial Analytics Page - sageX3
  • Financial Reporting Module Yes
  • Cross Company Reporting Module** Yes
  • Dashboarding Module* Yes
  • SQL Reporting Module* Yes
  • Report Distribution Module* Yes
  • Budgeting and Forecasting Module* Yes
  • Multi-Currency Module* Yes
  • Adhoc Reporting* Yes
  • Data Error Trapping* Yes
  • EiB AppStudio Optional Upgrade

EiB Financial Analytics Sage 500 / 1000

EiB Financial Analytics Page - sage500
  • Financial Reporting Module Yes
  • Cross Company Reporting Module** Yes
  • Dashboarding Module* Yes
  • SQL Reporting Module* Yes
  • Report Distribution Module* Yes
  • Budgeting and Forecasting Module* Yes
  • Multi-Currency Module* Yes
  • Adhoc Reporting* Yes
  • Data Error Trapping* Yes
  • EiB AppStudio Optional Upgrade

EiB Financial Analytics for ShipNet

EiB Financial Analytics - shipnet
  • Financial Reporting Module Yes
  • Cross Company Reporting Module** Yes
  • Dashboarding Module* Yes
  • SQL Reporting Module* Yes
  • Report Distribution Module* Yes
  • Budgeting and Forecasting Module* Yes
  • Multi-Currency Module* Yes
  • Adhoc Reporting* Yes
  • Data Error Trapping* Yes
  • EiB AppStudio Optional Upgrade

*All these modules essentially form EiB ReportStudio – For Sage X3, 500/1000 and ShipNet products, you will receive this within the standard package.

**mandatory module if there is more than one company in Sage.

Please note EiB Training and Services will be required for each individual module, and are provided at an additional cost.

Product/Modules, Functions & Features Financial Reporting Module Cross Company Reporting Module** Dashboarding Module SQL Reporting Module Report Distribution Module Budgeting and Forecasting Module Multi-Currency Module Adhoc Reporting Data Error Trapping EiB AppStudio
EiB Financial Analytics Sage 200
EiB Financial Analytics Sage X3
EiB Financial Analytics Sage 500 / 1000
EiB Financial Analytics for ShipNet