Financial Analysis

See how your suppliers and buyers perform against cost, quality, and timeliness target

Companies rely on their supply chain to efficiently meet their demand for goods and services. Managing those suppliers to ensure that they are meeting corporate purchasing targets is critical to the overall success of the company. The goal of this Solution is to provide management and buyers with up to date, accurate information on how their suppliers perform against cost, quality, and timeliness goals.

Chart of Accounts Screenshot

iQ data analysis to answer your most pressing questions

How are different companies and business units performing?
Accounts are grouped into business units and/or companies. Users can drill down to the underlying transactional details as needed.

How does my financial performance vary by department, cost center and account?
Transactions are grouped by department, cost center and/or account so that the relative spend and performance of each can be evaluated. Department heads and senior managers can easily track and analyze spending at the department, account, and even transaction level.

When did these transactions occur?
In addition to the information described above, users will also be able to decide what time period(s) to review, which will show when specific metrics were achieved (or missed), and how those numbers are changing. The time dimension is available at the top of the Analysis UI, or can be displayed in one of the view quadrants. Generally the most relevant settings will be period (view data for a single period) period over period (to quickly compare performance relative to a prior time) or rolling 12 period analysis, where a period can be a month, quarter, or year (or any other available period). In addition, data from different time periods can be displayed in adjacent columns to compare recent history with comparable periods in the past.

Financial Evaluation Metrics
This will allow users to select a metric of interest out of the available measures to be displayed with the dimensions listed above. Users will be able to change the metric of interest to drive different types of investigation. Users can investigate how the values of the following measures vary with the dimensions described above:

• Balance Sheet
• Income Statement
• Trial Balance

Time dimension handling
The standard solution includes adjustments for fiscal vs. calendar time (if needed), period-over-period, rolling period, and last 12 period analyses. Standard periods are years, half years, quarters, months, weeks, and days.

Additional information:
The standard Solution includes summary and detail cubes. If possible, other relevant dimensions and metrics will be defined and added to the Solution during the Solution delivery. However, not all systems or implementations support the information listed below. Other potentially useful information includes budget data, so expense levels can be compared to budgets.

Data Presentation

Performance vs. Key Performance Indicators (KPIs):
Bullet graphs or conditional cell color changes can be configured to highlight performance that either fails to meet or exceeds corporate targets. These goals can be set and modified easily in the Analysis front end so that the business users can set the appropriate goals and also adjust them as needed as performance improves.

Screen Gallery

A sampling of dashboard dispalys from iQ Financial Analysis

Chart of Accounts

Receivables Aging Analysis

Expense Analysis

Problem Account Analysis

Profit and Loss