Introduction

The Solution for Better BI

Sage Enterprise Intelligence (SEI) is a robust business intelligence solution that covers all your reporting and data analysis needs from Day 1.

Serving as a central hub for all data sources, SEI simplifies the process of accessing and collecting information, then turns that information into actionable insights for smarter business decisions.

The Universal Finance Data Model presented throughout this document demonstrates the power of having access to well over 100 KPIs that follow financial business reporting standards.

Whether you use the predefined dashboards and reports, or choose to easily create your own, SEI ensures that you’re equipped with everything you need for analyzing your enterprise’s financial activities, performance, liquidity, and profitability.

With minimal set-up required, boosting your enterprise’s performance begins the day you make the decision to work more efficiently with SEI’s streamlined process for accessing, gathering, consolidating, and organizing data.

Hit the ground running today with the financial information you need at your fingertips!

Available For

Sage X3

Sage 100 NA

Sage 200 UK

Sage 200C (Murano)

Sage 200 Evolution

Sage 300

Sage 500 NA

Sage 1000 UK

Sage Intacct

Coming Soon

Quickbooks Desktop

Quickbooks Online

 

Universal Finance Data Model


Finance Budget Model

Budgeting

Allocate your company's financial resources and create targets that will help your business grow with SEI's Budgeting functionality.

  • Budget by Posting or Ending Balance/Opening Balance.
  • Budget by Month or Quarter.
  • Budgeting methods:
    • Last Year Posting + % Increase
    • 0 Posting Budget
    • Last year Posting Average + % Increase
    • Last year Posting Average + % Growth

    • No data, all combinations with 0 Posting
  • Integrated budgeting process including revision, evaluation, and approval.
  • Ability to copy and shift budgets.
  • Ability to combine different budget level details.
  • Budget in Report layout (ex: Income Statement, Balance Sheet, Cash Flow)

Integrating Your Forecast with Your Budget

Integrate your sales forecasting with your financial budget seamlessly with SEI.

Map your sales forecasts within the appropriate GL accounts (ex: by product line) based on the criteria of your choice (ex: product line, territory, country).


Dashboards


Chief Financial Officer

Summary

The Chief Financial Officer dashboard provides a global view of the company’s financial situation by comparing the results against last year’s, including key financial measures such as (Return on Assets, Working Capital and Debt to Equity Ratio).

Audience

Chief Executive Officer (CEO)

Chief Financial Officer (CFO)

Chief Operating Officer (COO)

Features

  • Filter data by Company, Site and Analytical Axis. More filters can easily be added.
  • Show the income statement with drill down capability up to the document number.
  • Visibility over the Sales, EBIDTA and Net Income for the last 12 months.
  • Compare current yearly indicators to the previous year for a better assessment of result.


Company Overview

Summary

The Company Overview dashboard provides a global view of the company’s financial situation based on the last 12 months. It offers a vast number of KPIs to evaluate the company’s financial health.

Audience

Chief Executive Officer (CEO)

Chief Financial Officer (CFO)

Chief Operating Officer (COO)

Features

  • Filter data by Company, Site and Analytical Axis. More filters can easily be added.
  • Visibility over the Gross Margin and Operating Income for the last 12 months.
  • Show the evolution of the Liquidity by measuring the Working Capital (Ratio and Turnover).
  • The 12-month Cash to Cash Cycle expresses the length of time, in days, that it takes for a company to convert resource inputs into cash flows.


Cash Management

Summary

The Cash Management dashboard provides an overview of the cash flow situation. The dashboard allows the CFO to plan the liquidity needs ahead of time.

Audience

Chief Financial Officer (CFO) Treasurer

Features

  • Filter data by Company and/or Site.
  • Provide a cash flow statement comparing this year with the previous year.
  • Show the inflow and outflow of the cash for the last 12 months.
  • Display the cash by bank account in a pie chart.
  • Provide the evolution of the efficiency of the Accounts Payable and Receivable key metrics.


Profit and Loss

Summary

The Profit and Loss dashboard provides a global view of the company’s results over time and compare with last year results. It provides an assesment on the company financial performance.

Audience

Chief Executive Officer (CEO)

Chief Financial Officer (CFO)

Chief Operating Officer (COO)

Features

  • Filter data by Company, Site and Analytical Axis. More filters can easily be added.
  • Display key financial performance KPIs such as the Gross Profit Margin, Opex Ratio, Operating Profit Margin and Net Profit Margin.
  • Show the evolution of the last 12 months’ Operating expenses and Operating Income.
  • Display the current result against the budget with a detailed income statement.


Financial Performance

Summary

The Financial Performance dashboard provides key information in order to evaluate the company’s financial strength. It gives an assessment of the financial future of the company.

Audience

Chief Executive Officer (CEO)

Chief Financial Officer (CFO)

Chief Operating Officer (COO)

Features

  • Filter data by Company and/or Site.
  • Provide a cash flow statement comparing this year with the previous year.
  • Show the inflow and outflow of the cash for the last 12 months.
  • Return on Asset and Equity over the last 12 months compared to the net income.
  • Evolution of key assets over time for the Inventory, Cash and Accounts Receivable.
  • Evolution of the last 12 months of Debt To Equity Ratio compared to the Liabilities.


Income Statement

Summary

The Income Statement dashboard provides an overview of the Net Income Evolution over the last 12 months.

Audience

Chief Executive Officer (CEO)

Chief Financial Officer (CFO)

Chief Operating Officer (COO)

Company Shareholders

Features

  • Filter data by Company, Site and Analytical Axis. More filters can easily be added.
  • Show the income statement, month by month for the last 12 months. Can drill-down and drill-up to the document’s number.
  • Display the evolution of the Sales and EBITDA over the last 12 months.
  • Display the breakdown of the Revenue by Accounts


Actual vs Budget

Summary

The Actual vs Budget dashboard provides an overview of the company performance versus the budget goals. This dashboard allows the management team to analyze the budget variance for different analytical axes.

Audience

Chief Executive Officer (CEO)

Chief Financial Officer (CFO)

Chief Operating Officer (COO)

Features

  • Filter data by Company, Site and Analytical Axis. More filters can easily be added.
  • The Income Statement allows you to compare the actual performance with the budget of your choice.
  • Return on Asset and Equity over the last 12 months compared to the net income.
  • Display a comparison of the performance versus the budget over the last 12 months.
  • Show the % achieved versus the budget goals for the Gross Margin and Net Income.
  • Display the target versus the actual for each section of the Income Statement.


Accounts Receivable

Summary

The Accounts Receivable dashboard provides an overview of all the overdue receivables and the efficiency of the accounts receivable management. This dashboard helps you improve company liquidity.

Audience

Chief Financial Officer (CFO)

AR Manager

Collection Manager

Features

  • Filter by selecting any component in the charts (Country, Company, Sales Rep, Customer, Aging).
  • Show the top 10 sales reps and customers overdue.
  • Display an overview of the current overdue receivable statistics with basic KPIs such as Overdue Total, Avg Days, Qty of Sales Rep, Customers / Documents overdue.
  • Display the Overdue by Aging Categories (1-30, 31-60, 61-90, 91+).


Accounts Payable

Summary

The Accounts Payable dashboard provides an overview of all the overdue payables and the efficiency of the accounts payable management.

Audience

Chief Financial Officer (CFO)

AP Manager

Features

  • Filter by selecting any component of the charts (Companies, Suppliers, Aging, Document).
  • Show an overview of current overdue with basic KPIs such as Overdue Total, Avg Days Overdue, Qty Suppliers and Documents overdue.
  • Display the top 10 Overdue Suppliers, sorted by aging.
  • Display the top 10 Documents Overdue sorted by aging.
  • Display the Overdue by Aging Categories (1-30, 31-60, 61-90, 91+).


Cash Management Forecast

Summary

The Cash Management Forecast dashboard displays the future cash flow situation until the year’s end, giving the CFO insight on company liquidity needs.

Audience

Chief Financial Officer (CFO) Treasurer

Features

  • Filter data by Company, Site and Analytical Axis. More filters can easily be added.
  • Show the Cash Flow forecast, which displays the actual or the budget based on the current period, each month.
  • Display the total Year End Cash value.
  • Show the Net Income Forecast until the year end with the ability to filter the Income Statement by month.
  • Display the Income Statement sections allowing drill-down / drill-up to the account number, to compare the actual and budget.


Reports


Income Statement

Summary

Also known as the Profit and Loss statement or Statement of Revenue and Expenses. Broken into three main sections (Sales, Cost Of Sales and Expenses), the Income Statement reports the company performance.

Audience

Shareholders

Financial Analysts

Financial Institution

Features

  • Filter by company, Site, Ledger, Analytical dimension(s) and more.
  • Drill-down / up to the document number. Each drill-down level can be easily customized.
  • Gives you the Income for the Current Period and YTD with the corresponding Last Year variances.
  • Accessible via Web Browser, Mobile Application or Excel.
  • Also available in a YTD by month format


Balance Sheet

Summary

Show the company’s assets, liabilities and shareholders’ equity at a specific point in time. Broken into three main sections (Assets, Liabilities and Shareholder Equity), the Balance Sheet provides you with a snapshot of what your company owns and owes, as well as the amount invested by shareholders.

Audience

Shareholders

Financial Analysts

Financial Institution

Features

  • Filter by company, Site, Ledger, Analytical dimension(s) and more.
  • Drill-down / up to the document number. Each drill-down level can be easily customized.
  • Gives you the Current and Last Year values with the corresponding variances.
  • Accessible via Web Browser, Mobile Application or Excel.


Cash Flow

Summary

Show the net amount of cash and cash-equivalents being transferred in and out of a business. Broken into three main sections (Cash From Operation, Cash From Investing and Cash From Financing) the Cash Flow shows the company’s ability to create value for shareholders.

Audience

Shareholders

Financial Analysts

Financial Institution

Features

  • Filter by company, Site, Ledger, Analytical dimension(s) and more.
  • Drill-down / up to the document number. Each drill-down level can be easily customized.
  • Current Period and YTD with the corresponding Last Year variances.
  • Accessible via Web Browser, Mobile Application or Excel.


Trial Balance

Summary

The Trial Balance gives you the balances of all accounts to help you identifying if all the entries in a company’s bookkeeping system are mathematically correct.

Audience

Chief Financial Officer (CFO)

Controller

Features

  • Filter by company, Site, Ledger, Analytical dimension(s) and more.
  • Drill-down / up to the document number. Each drill-down level can be easily customized.
  • Shows you the opening, credit, debit, posting and ending balance.
  • Accessible via Web Browser, Mobile Application or Excel.


Key Performance Indicators


Activity

Activity

Account Payable Turnover

Shows investors how many time per year the company pay  its average payable amount.

(Cogs + Inventory) / Average Accounts Payable

Cash to Cash Cycle

Expresses the length of time, in days, that it takes for a company to convert resource inputs into cash flows.

DIO + DSO - DPO

Days Payable Outstanding (DPO)

Measures how long it takes a company to pay its invoices from trade creditors, such as suppliers.

Accounts Payable / (Cost of sales x 365

Account Receivable Turnover

Show the number of times per year that a business collects its average accounts receivable.

Sales / Average Receivable

Days of Inventory Outstanding (DIO)

Measure of a company’s performance that gives investors an idea of how long it takes a company to turn its inventory.

(Average Inventory / Cost of Sales) x 365

Inventory Turnover

Number of times that inventory is sold or used over the course of a year.

Sales / Average Inventory

Average Collection Period

Measure the effectiveness of a company’s ability to collect payments from its credit customers.

365 / Accounts Receivable Turnover

Days of Sales Outstanding (DSO)

Measure of the average number of days that it takes a company to collect payment after a sale has been made.

(Accounts Receivable / Sales) x 365

Total Asset Turnover

Shows how much sales are earned for each dollar invested in assets.

Sales / Assets


Leverage

Leverage

Debt Ratio

Assess company leverage by measuring what proportion of company assets are financed by debt.

Liabilities / Assets

Debt to Asset Ratio

Measures the company’s assets financed with debt.

Assets / Liabilities

Debt to Capital Ratio

Measures a company’s capital structure, financial solvency, and degree of leverage, at a particular point in time.

Liabilities / (Liabilities + Total Equities)

Debt To Equity Ratio (D/E)

This ratio indicates how much shareholder equity and debt is financing a company’s assets and is used to evaluate how much risk a company is taking.

Liabilities / Total Equity

Financial Leverage Ratio

Measure of how much assets a company holds relative to its equity.

Long-term Liabilities / Total Equities

Long-Term Debt To Equity Ratio

Determine the leverage a business has taken on.

Long-term Liabilities / Total Equities


Profitability

Profitability

EBITDA

Earnings before interest, taxes, depreciation and amortization.

Sales - Cogs - Operating Expenses + Amortisation

Net Profit Margin

Shows how much % of profit generated by the Sales in a company as revenue translates into profit.

Net Income / Sales

Operating Income (EBIT)

Earnings Before Interest & Taxes, indicator of a company’s profitability.

Sales - Cogs - Operating Expenses

EBITDA Margin

Measurement of a company’s operating profitability before interest, taxes, depreciation and amortization as a percentage of its total revenue.

EBITDA / Sales

Return on Asset (ROA)

Show to a manager, investor, or analyst an idea as to how efficient a company’s management is at using its assets to generate earnings.

Net Income / Asset

Operating income (EBIT) Margin

Measure of a company’s profitability before interest and taxes on sales over a specific time period.

EBIT / Sale

Gross Margin

Represents the percent of total sales revenue that the company retains after incurring the direct costs associated with producing the goods and services it sells.

Sales - COGS

Return on Equity (ROE)

Measures a corporation’s profitability by revealing how much profit a company generates with the money shareholders have invested.

Net Income / Total Equity

Gross Margin %

Measurement of a company’s gross marging as a percentage of its total revenue.

Gross Margin / Sales

 

Net Income

Measure of how profitable the company is over a period of time.

Sales - Cogs - Expenses

 

Liquidity

Liquidity

Operating Expenses Ratio

Measure of what it costs to operate a piece of property compared to the income that the property brings in.

Operating Expense / Sales

Working Capital Ratio

Show the ability of a business to pay for its current liabilities with its current assets.

Current Assets / Current Liabilities

Working Capital

Measure of both a company’s operational efficiency and its short-term financial health.

Current Assets - Current Liabilities

Working Capital Turnover

Analyze the relationship between the money that funds operations and the sales generated from these operations.

Sales / Working Capital

 

Working Capital Ratio

Measures a company’s ability to meet its short-term obligations with its most liquid assets.

Current Assets - Inventory - Prepaid Expenses / Liabilities


Other Measures

Other Measures

Assets

Resource with economic value that an individual, corporation or country owns or controls with the expectation that it will provide future benefits

Current Liabilities

Company’s debts or obligations that are due within one year.

Liabilities

Company’s financial debt or obligations that arise during the course of its business operations.

Retained Earnings

Percentage of net earnings not paid out as dividends, but retained by the company to be reinvested in its core business, or to pay debt.

Total Equity

Equity is the value of an asset less the amount of all liabilities on that asset.

COGS

Direct costs attributable to the production of the goods sold in a company.

Fixed Assets

Long-term tangible piece of property that a firm owns and uses in its operations to generate income.

Operating Expenses

Expenses a business incurs through its normal business operations. Often abbreviated as OPEX.

Sales

Amount of money that a company actually receives during a specific period, including discounts and deductions for returned merchandise.

Long-term Liabilities

Form part of a section of the balance sheet that lists liabilities not due within the next 12 months including debentures, loans, deferred tax liabilities and pension obligations.

Current Assets

Represents the value of all assets that can reasonably expect to be converted into cash within one year.

Inventory

Raw materials, work-in-process products and finished goods that are considered to be the portion of a business’s assets that are ready or will be ready for sale.

Prepaid Expenses

Assets that arise on a balance sheet as a result of a business making payments for goods and services to be received in the near future.

 

Cash

Usually includes bank accounts and marketable securities, such as government bonds and banker’s acceptances