bi dashboard and report summary

8/3/2019 BI Dashboard and Report Summary

1/29

Applications versio Dashboard Name Dashboard Page NameFinancial Analytics General Ledger Asset UsageFinancial Analytics General Ledger Asset UsageFinancial Analytics General Ledger Asset UsageFinancial Analytics General Ledger Asset UsageFinancial Analytics General Ledger Asset UsageFinancial Analytics General Ledger Asset Usage

Financial Analytics General Ledger Asset Usage

Financial Analytics General Ledger Asset UsageFinancial Analytics General Ledger Balance SheetFinancial Analytics General Ledger Balance SheetFinancial Analytics General Ledger Balance SheetFinancial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Budget vs. Actual

Financial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Budget vs. ActualFinancial Analytics General Ledger Cash Flow

Financial Analytics General Ledger Cash Flow

Financial Analytics General Ledger Financial StructureFinancial Analytics General Ledger Financial StructureFinancial Analytics General Ledger Financial StructureFinancial Analytics General Ledger Financial StructureFinancial Analytics General Ledger Financial StructureFinancial Analytics General Ledger GL BalanceFinancial Analytics General Ledger Liquidity

Financial Analytics General Ledger LiquidityFinancial Analytics General Ledger LiquidityFinancial Analytics General Ledger LiquidityFinancial Analytics General Ledger LiquidityFinancial Analytics General Ledger LiquidityFinancial Analytics General Ledger Overview

Financial Analytics General Ledger Key RatiosFinancial Analytics General Ledger Key RatiosFinancial Analytics General Ledger Key RatiosFinancial Analytics General Ledger Key RatiosFinancial Analytics General Ledger OverviewFinancial Analytics General Ledger Key RatiosFinancial Analytics General Ledger OverviewFinancial Analytics General Ledger OverviewFinancial Analytics General Ledger Overview

Financial Analytics General Ledger Key RatiosFinancial Analytics General Ledger OverviewFinancial Analytics General Ledger Trial BalanceFinancial Analytics General Ledger Trial BalanceFinancial Analytics General Ledger Trial Balance

Financial Analytics General Ledger Trial BalanceFinancial Analytics Payables All AP TransactionsFinancial Analytics Payables AP BalanceFinancial Analytics Payables AP BalanceFinancial Analytics Payables AP BalanceFinancial Analytics Payables AP BalanceFinancial Analytics Payables AP BalanceFinancial Analytics Payables AP BalanceFinancial Analytics Payables AP Balance

Financial Analytics Payables AP Balance


2/29

Financial Analytics Payables AP BalanceFinancial Analytics Payables AP BalanceFinancial Analytics Payables EffectivenessFinancial Analytics Payables EffectivenessFinancial Analytics Payables EffectivenessFinancial Analytics Payables EffectivenessFinancial Analytics Payables Effectiveness

Financial Analytics Payables Effectiveness

Financial Analytics Payables Invoice DetailsFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables Overview

Financial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables OverviewFinancial Analytics Payables Payment Performance

Financial Analytics Payables Payment Performance

Financial Analytics Payables Payment PerformanceFinancial Analytics Payables Payment PerformanceFinancial Analytics Payables Payment PerformanceFinancial Analytics Payables Payment PerformanceFinancial Analytics Payables Payment PerformanceFinancial Analytics Payables Payment PerformanceFinancial Analytics Payables Payment Performance

Financial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments Due

Financial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Payments DueFinancial Analytics Payables Supplier Report

Financial Analytics Payables Supplier ReportFinancial Analytics Payables Supplier ReportFinancial Analytics Payables Supplier ReportFinancial Analytics Payables Supplier ReportFinancial Analytics Payables Supplier Report

Financial Analytics Payables Supplier ReportFinancial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability Customers

Financial Analytics Profitability Customers


3/29

Financial Analytics Profitability CustomersFinancial Analytics Profitability CustomersFinancial Analytics Profitability MarginsFinancial Analytics Profitability MarginsFinancial Analytics Profitability MarginsFinancial Analytics Profitability MarginsFinancial Analytics Profitability Overview

Financial Analytics Profitability Overview

Financial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability Overview

Financial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability OverviewFinancial Analytics Profitability Overview

Financial Analytics Profitability Overview

Financial Analytics Profitability P&LFinancial Analytics Profitability P&LFinancial Analytics Profitability P&LFinancial Analytics Profitability P&LFinancial Analytics Profitability P&LFinancial Analytics Profitability ProductsFinancial Analytics Profitability Products

Financial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability Products

Financial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability ProductsFinancial Analytics Profitability Revenue

Financial Analytics Profitability RevenueFinancial Analytics Profitability RevenueFinancial Analytics Profitability RevenueFinancial Analytics Profitability RevenueFinancial Analytics Profitability Revenue

Financial Analytics Profitability RevenueFinancial Analytics Profitability RevenueFinancial Analytics Project Invoices Project InvoicesFinancial Analytics Project Invoices Project InvoicesFinancial Analytics Project Invoices Project InvoicesFinancial Analytics Project Invoices Project InvoicesFinancial Analytics Project Invoices Project InvoicesFinancial Analytics Project Invoices Project InvoicesFinancial Analytics Project Invoices Project Invoices

Financial Analytics Receivables All AR Transactions


4/29

Financial Analytics Receivables AR BalanceFinancial Analytics Receivables AR BalanceFinancial Analytics Receivables AR BalanceFinancial Analytics Receivables AR BalanceFinancial Analytics Receivables AR BalanceFinancial Analytics Receivables AR BalanceFinancial Analytics Receivables AR Balance

Financial Analytics Receivables AR Balance

Financial Analytics Receivables AR BalanceFinancial Analytics Receivables Customer ReportFinancial Analytics Receivables Customer ReportFinancial Analytics Receivables Customer ReportFinancial Analytics Receivables Customer ReportFinancial Analytics Receivables Customer ReportFinancial Analytics Receivables Customer Report

Financial Analytics Receivables EffectivenessFinancial Analytics Receivables EffectivenessFinancial Analytics Receivables EffectivenessFinancial Analytics Receivables EffectivenessFinancial Analytics Receivables EffectivenessFinancial Analytics Receivables Effectiveness

Financial Analytics Receivables Effectiveness

Financial Analytics Receivables EffectivenessFinancial Analytics Receivables EffectivenessFinancial Analytics Receivables EffectivenessFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill Reports

Financial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill Reports

Financial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice Aging Drill ReportsFinancial Analytics Receivables Invoice DetailsFinancial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables Overview

Financial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables OverviewFinancial Analytics Receivables Payment Performance

Financial Analytics Receivables Payment PerformanceFinancial Analytics Receivables Payment PerformanceFinancial Analytics Receivables Payment PerformanceFinancial Analytics Receivables Payments DueFinancial Analytics Receivables Payments DueFinancial Analytics Receivables Payments DueFinancial Analytics Receivables Payments DueFinancial Analytics Receivables Payments DueFinancial Analytics Receivables Payments Due

Financial Analytics Receivables Payments Due


5/29

Financial Analytics Receivables Payments DueFinancial Analytics Receivables Payments DueFinancial Analytics U.S. Federal FinanciBudget DetailsFinancial Analytics U.S. Federal FinanciBudget DetailsFinancial Analytics U.S. Federal FinanciBudget SpendingFinancial Analytics U.S. Federal FinanciBudget SpendingFinancial Analytics U.S. Federal FinanciBudget Spending

Financial Analytics U.S. Federal FinanciBudget Summary

Financial Analytics U.S. Federal FinanciBudget SummaryFinancial Analytics U.S. Federal FinanciBudget SummaryFinancial Analytics U.S. Federal FinanciBudget SummaryFinancial Analytics U.S. Federal FinanciBudget SummaryFinancial Analytics U.S. Federal FinanciBudget SummaryFinancial Analytics U.S. Federal FinanciPayablesFinancial Analytics U.S. Federal FinanciPayables


6/29

Report NameGross Margin vs. Cash MarginInventory TurnoverLong-Term Assets TurnoverNet Working CapitalPayables TurnoverReceivables Turnover

Total Assets Turnover

Working Capital TurnoverMonthly Balance SheetMonthly Balance Sheet ChangedQuarterly Balance SheetBudget vs Actual: Current and YTD Total Operating ExpeBudget vs Actual: Revenue and Total Operating ExpensesBudget vs. Actual: Filtered GL Account by Cost Center

Budget vs. Actual: GL Account by Cost CenterExpense vs. Budget by Cost CenterGL Account Budget vs. ActualTop 10 Categories by Expense VarianceTop 10 Cost Centers by Expense VarianceMonthly Cash Flow

Quarterly Cash Flow

Debt CoverageDebt To AssetDebt To EquityInterest CoverageTotal Liabilities CompositionGL Account BalanceCapital Expenditure Coverage

Cash Ratio (Cash to CL)Current Liabilities ConverageDays Cash in HandShort-Term Liquidity (Current Ratio)Short-Term Liquidity (Quick Ratio)Cash Flow Summary

Current Assets CompositionDays Payables OutstandingDays Sales OutstandingExpense Details for Cost CenterExpenses by CategoryInventory DaysNet Working Capital SummaryOperating Cycle & Cash CycleTop 10 Cost Centers by Expenses

Total Cost Center Expenses TrendTotal Expenses TrendTrial BalanceTrial Balance - AP Transactions DetailsTrial Balance - AR Transactions Details

Trial Balance - Journal Lines EntriesAP Transaction DetailsAP Aging by SupplierAP Aging by Supplier GroupAP Aging ReportDPO Monthly TrendOpen Invoice Details - (1-30) Days Aging Report

Open Invoice Details - (31-60) Days Aging ReportOpen Invoice Details - (61-90) Days Aging Report

Open Invoice Details - (90+) Days Aging Report


7/29

Top 10 Suppliers by AP BalanceTop 10 Suppliers by Overdue BalancesInvoice Transactions EfficiencyNumber of AdjustmentsStaff Productivity ReportStaff Productivity Report TrendingTop 10 Suppliers by # of Invoices

Top 10 Suppliers by lowest AP Avg Invoice Amount

Open Invoice Details% AP Overdue Gauge

AP Overdue % GaugeAverage Invoice TransactionDPO and AP Balance by SuppliersDPO GaugeInvoice Transactions Efficiency

Payables SnapshotPayment PerformanceTop 10 Suppliers by lowest AP Avg Invoice AmountTop 10 Suppliers by Overdue AmountsTop 10 Suppliers with lowest average payment daysInvoice Amount vs Payment Amount

Invoice vs Payment Amount

Payment PerformancePayment Performance TrendTop 10 Payments by SuppliersTop 10 Supliers by Average Payment DaysTop 10 Suppliers by Paid Before Due CountTop 10 Suppliers by PaymentsTop 10 Suppliers with lowest average payment days

AP Payments Due AgingAP Payments Due by Payment Due DateAP Payments Overdue Aging ReportAP Payments Overdue to Total %Payments Due Invoice Details - (1-30) Days Aging ReportPayments Due Invoice Details - (31-60) Days Aging Repo

Payments Due Invoice Details - (61-90) Days Aging RepoPayments Due Invoice Details - (90+) Days Aging ReportPayments Overdue Invoice Details - (1-30) Days Aging RPayments Overdue Invoice Details - (31-60) Days AgingPayments Overdue Invoice Details - (61-90) Days AgingPayments Overdue Invoice Details - (90+) Days Aging ReTop 10 Suppliers by Overdue AmountsTop 10 Suppliers by Payments Due in Current Quarter

AP Aging Report by Supplier

AP Payments Due Aging by SupplierAP Payments Due in Payment Month (By Supplier)AP Payments Due in Payment Quarter (By Supplier)AP Payments Overdue Aging Report by SupplierDPO Monthly Trend by Supplier

Payment Performance by SupplierCost Details for Allocated and Direct ExpensesCustomer Expenses by CategoryCustomer Profitability by CustomerCustomer Profitability by Customer CategoryCustomer Profitability StatementDirect vs Allocated ExpensesTop 10 Customers by ExpensesTop 10 Customers by Marketing Expenses

Top 10 Customers by Operating Profit


8/29

Top 10 Customers by Sales ExpensesTop 10 Customers by Service ExpensesKey Cost Ratio TrendsProfitability Returns TrendReturn on Assets DriversReturn on Equity DriversCost Breakdown

Customer Gross Margin

Gross Margin % IndicatorKey Cost Ratio TrendsNet Income Margin % IndicatorOperating Margin %P&L Summary - QuarterlyP&L Summary - Quarterly YTDProduct Gross Margin

Product Gross Margin vs Company MarginProfitability Margins TrendProfitability ReturnsReturn on AssetsROA (EBIT Basis)ROA (Pre-Interest)

ROE Indicator

COGS Trend by ProductCOGS Trend by Product CategoryProfit & Loss - QuarterlyProfit & Loss - Quarterly YTDRevenue Trend by Product Category10 Least Profitable Products (Operating Margin)Cost Details for Allocated and Direct Costs

Direct vs Allocated Expenses for ProductsProduct Expense TrendsProduct Expenses by CategoryProduct Gross Margin vs Company MarginProduct Profitability by ProductProduct Profitability by Product Category

Product Profitability StatementTop 10 Lowest Margin ProductsTop 10 Products by ExpensesTop 10 Products by Marketing InvestmentsTop 10 Products by Operating MarginTop 10 Products by Sales ExpenseTop 10 Products by Service ExpensesTop 10 Revenue Contributing Products with MarginsRevenue Performance by Product Category

Revenue Performance by ProductsRevenue Performance by Products and CustomersRevenue TrendRevenue Trend by CustomerRevenue Trend by Product

Top 10 Customers by RevenueTop 10 Products by Revenue

AP Aging ReportAP Payments Due Aging ReportAP Payments Overdue Aging ReportAR Aging ReportAR Payments Due Aging ReportAR Payments Overdue Aging ReportCash Flow Summary

Invoice Transaction Details


9/29

Aging ReportAging Report by CollectorAR Aging by CustomerAR Aging by Customer CategoryAR Aging TrendDSO Monthly TrendOpen Invoice Details - (1-30) Days Aging Report

Top 10 Customers by AR Balance

Top 10 Customers by Credit Limit Used %AR Aging ReportAR Due Aging ReportAR Overdue Aging ReportDSO Monthly TrendDSO Quarterly TrendTrend of Credit Limit Used %

Aging Report by CollectorAging Report by Collector - DetailInvoice Load by CollectorInvoice Management EfficiencyInvoice Management Efficiency TrendInvoice Transaction Efficiency

Number of Adjustments

Staff Productivity ReportTop 10 Customers by # of InvoicesTop Multiple Invoice Issuances of Same Sales OrderDue Invoice Details - (1-30) Days Aging ReportDue Invoice Details - (31-60) Days Aging ReportDue Invoice Details - (61-90) Days Aging ReportDue Invoice Details - (90+) Days Aging Report

Open Invoice Details - (1-30) Days Aging ReportOpen Invoice Details - (31-60) Days Aging ReportOpen Invoice Details - (61-90) Days Aging ReportOpen Invoice Details - (90+) Days Aging ReportOverdue Invoice Details - (1-30) Days Aging ReportOverdue Invoice Details - (31-60) Days Aging Report

Overdue Invoice Details - (61-90) Days Aging ReportOverdue Invoice Details - (90+) Days Aging ReportOpen Invoice Details% AR Overdue Gauge

AR Largest Customer Overdue BalancesAR Overdue Payments OverviewDSO GaugeDSO OverviewInvoice Transaction Efficiency

Payment PerformanceReceivables Key Performance IndicatorsTop 10 Customers by Lowest Avg Invoice AmountTop 10 Customers with Highest Avg Payment DaysInvoice Amount vs Payment Amount

Payment PerformanceTop 10 Customers by Average Payment DaysTop 10 Customers by Payments

AR Payments Due Aging ReportAR Payments Due Aging TrendAR Payments Due by Payment Due DateAR Payments Due in Payment MonthAR Payments Overdue Aging ReportTop 10 Customers by Overdue Balances

Top 10 Customers by Payments Due in Current Quarter


10/29

Trend of AR Payment Due Amount %Trend of AR Payment Overdue Amount %

Available Authority by Fund DetailsAvailable Authority Period ComparisonBudget Spending SummaryBudget Spending Summary - GraphCurrent Period Spending

Budgetary Resources Period Summary

Current Budget AuthorityStatus of Budgetary ResourcesStatus of Budgetary ResourcesStatus of Budgetary Resources contStatus of Budgetary Resources contElectronic PaymentsPrompt Payment of Invoices


11/29

Report DescriptionDisplays the gross and cash gross margin percentages by fiscal month. An increase in cash collections faster than sales reduces working capital req

Displays the inventory and inventory turnover by month for the trail ing twelve fiscal months.

The long-term asset turnover ratio measures the efficiency of (long-term) capital investment. A higher turnover means that the company is more effici

Displays the net working capital by quarter for the last four fiscal quarters.

Displays the AP and AP turnover by month for the trailing twelve fiscal months.

Displays the AR and AR turnover by month for the trailing twelve fiscal months.

Displays the total assets and total asset turnover by month for the trailing twelve fiscal months.

Working capital turnover indicates the rate at which current asset are turned over. If the company maintains lower inventory for a given sale, then wo

Displays the balance sheet by month for the current fiscal quarter. Balance sheet reports shed light on the different components that constitute the as

Displays the balance sheet by month for the current fiscal quarter. Balance sheet reports shed light on the different components that constitute the as

Displays the balance sheet by quarter for the current month and past few fiscal quarters. Balance sheet reports shed light on the different component

Displays Total Operating (TO) Expenses budget, actual, variance, and variance amount YTD to help track quarterly variances and trends. Total Oper

Displays budget, actual and variance information for revenue and total operating (TO) expenses quarterly tracking. The variance of revenue less tota

The GL Account Budget vs Actual report tracks actual expenditures by budget plans to determine cost center budgetary compliance.

Provides each GL Account's expense, budget and variance amount for the selected cost center, in order to assist with expense monitoring and contr

A report that compares the values of the budget vs. actual expenditures in order to determine expense control.

The GL Account Budget vs Actual report tracks actual expenditures by budget and cost center to determine budgetary compliance.

Displays the top 10 GL Account categories based on Expense Variance to assist with the enforcement of budgetary compliance.

Displays the top 10 Cost Centers based on Expense Variance to assist with expense monitoring and control. Access to a detailed GL account listingDisplays the cash flow by month for the current fiscal quarter. This analysis will provide information on: 1) A firms ability to generate cash from opera

Displays the cash flow by quarter for the current month and past few fiscal quarters. This analysis will provide information on: 1) A firms ability to gen

Displays operating cash flow and long term debt by month for the trailing twelve fiscal months.

Displays the debt to asset ratio and long term debt by month for the trailing twelve fiscal months.

Displays the debt to equity and total shareholder funds by month for the trailing twelve fiscal months. Debt-to-equity ratios examine the firms capital

Displays the times interest earned and interest expense by month for the trailing twelve fiscal months.

Provides the composition of the liabilities for the current fiscal quarter.

Displays GL Account balance for all GL Accounts in a searchable interface.

Displays the capital expenditure ratio and additions to PPE by month for the trailing twelve fiscal months. This report evaluates whether internal cash

Displays the cash to current liabilities and cash by month for the trailing twelve fiscal months.

Provides operating cash flow and cash ratios by fiscal period measured against current liabilities over trailing four fiscal quarters.

Displays the days cash in hand and cash by month for the trailing twelve fiscal months. Days Cash in Hand is another measure of short-term liquidity.Displays the current ratio and current liabilities by month for the trailing twelve fiscal months. This helps evaluate whether the firm is liquid enough to

Displays the quick ratio and CA less inventories by month for the trailing twelve fiscal months.

Displays an overview of the components of cash flow over the last four Fiscal Quarters.

Balance sheet reports shed light on the different components that constitute the assets and liabilities of an organization.

Provides fiscal period AP and DPO balances over the last four fiscal quarters

Provides fiscal period AR and DSO balances over the last four fiscal quarters

Displays an overview of expenses by Cost Center.

Displays an overview of expenses by GL Account Category.

Provides inventory amount and Avg Inventory Days metrics by fiscal period over the last four fiscal quarters.

Provides a summary of the current assets, liabilities and working capital metrics over trailing four fiscal quarters.

Displays how many days of cash are locked up in various components such as accounts receivable and inventory. The review of these individual co

Provides the top ten cost centers by expense amount and contribution to expense total.Provides expense amount by fiscal period trend

Provides expense and cumulative expense amount by fiscal period over time.

Provides list of accounts in general ledger and their debit and credit balances at a specified date. Enables drill down to journal line entries, which allo

Provides list of Accounts Payable transaction details. Target report from drill-down starting with GL account balances.

Provides list of Accounts Receivable transaction details. Target report from drill-down starting with GL account balances.

Provides list of journal line entries. Allows drill across to AP and AR transaction details.

Displays the details of invoices

Displays the AP aging buckets and relative % vs. total by supplier

Displays the AP aging by the supplier account group for the current fiscal quarter

Displays the AP aging buckets and relative % vs. total

Display the days payable outstanding by period for the trailing 12 fiscal periods

Displays payable outstanding to the supplier for 1-30 days



Displays payable outstanding to the supplier for over 90 days


12/29

Display the top 10 suppliers by the AP balance for the current fiscal quarter. This report will help users target suppliers with most outstanding balanc

Display the top 10 suppliers by overdue amount for the current fiscal quarter. If the overdue balance as a % to AP balance is high, this could indicate

Displays the AP average invoice amount and count by period for the current fiscal quarter

Displays the number of adjustments by month for the current fiscal quarter

Displays the invoice amount, count and average amount by username for the current fiscal quarter

Displays the invoice amount, count and average amount by username over the 12 fiscal period on trending basis

Displays the top 10 suppliers by the number of invoices for the current fiscal quarter

Displays top 10 suppliers with lowest average invoice amount in a fiscal quarter

Displays the details of invoices

Displays the percentage of accounts payable overdue for the current fiscal quarter. Overdue amounts are Supplier balances that are past payment d

Displays the percentage of accounts payable overdue for the current fiscal quarter. Overdue amounts are Supplier balances that are past payment d

Displays average invoice amount by fiscal period

This report shows Days Payables Outstanding (DPO) at the overall level compared with DPO by Supplier. This report can be used to identify those S

Displays the number of Days Payable Outstanding for the current fiscal quarter. DPO indicates how long a company is taking to pay its trade creditor

Displays the AP average invoice amount and count by fiscal period for the trailing 12 fiscal periods. Using this report AP Manager can quickly see ho

Displays a snapshot of the key performance indicatores in payables for the current fiscal quarter

Displays the AP average supplier payment days and weighted days in payments by trailing four fiscal quarters

Displays the top 10 by suppliers by lowest average invoice amount

Display the top 10 suppliers by overdue amount for the current fiscal quarter. If the overdue balance as a % to AP balance is high, this could indicate

Displays the top 10 by suppliers by lowest average payment days for the current fiscal quarters

Displays the average supplier payment days, times paid before date and time paid after date by month for the trailing 12 fiscal months

Displays the average supplier payment days, times paid before date and time paid after date by month for the trailing 12 fiscal months

Displays the top 10 suppliers by total payment amount and the number of times paid before and after the due date

Display the top 10 suppliers by the number of times paid before the due date

Displays the top by suppliers by lowest average payment days for the trailing four fiscal quarters

Displays the AP payments due aging for the current fiscal quarter

Displays the payments due by the fiscal month of the due date

Display the AP payments overdue aging for the current fiscal quarter. Overdue amounts are Supplier balances that are past payment due date. If theDisplays the percentage of accounts payable overdue for the current fiscal quarter

This report help identifies supplier who have payments coming up in 1-30 days



This report help identifies supplier who have payments coming up in 90 days

Display the AP invoice payments that are overdue for 1-30 days. Overdue amounts are supplier balances that are past payment due date. If the over

Display the AP invoice payments that are overdue for 31-60 days. Overdue amounts are supplier balances that are past payment due date. If the ov

Display the AP invoice payments that are overdue for 61-90 days. Overdue amounts are supplier balances that are past payment due date. If the ov

Display the AP invoice payments that are overdue for over 90 days. Overdue amounts are supplier balances that are past payment due date. If the o

Display the top 10 suppliers by overdue amount for the current fiscal quarter. Overdue amounts are Supplier balances that are past payment due dat

Displays the top 10 suppliers by payments due in the current fiscal quarter

Displays the AP Aging for the trailing four fiscal quarters for a particular supplier or group of suppliersDisplays the AP Aging by quarter for the trailing four fiscal quarters for a particular supplier or group of suppliers

Displays the outstanding invoice amount and percent of total by fiscal period

Displays the outstanding invoice amount in fiscal quarter

Displays the AP overdue aging by quarter for the trailing four fiscal quarters for a particular supplier or group of suppliers. Overdue amounts are Sup

Displays the days payable outstanding and AP balance for a specific supplier or group of suppliers by month for the trailing 12 fiscal months

Displays the average supplier payment days and weighted days in payments for a particular supplier or group of suppliers

Displays the allocated and direct costs details by customer category for the current fiscal year.

Displays costs details by category for the current fiscal year.

Displays the revenue amount, gross profit, gross margin and operating profit by customerfor the current fiscal year.

isplays the revenue amount, gross profit and operating profit by customer category for the current fiscal year.

Displays the revenue and expenses by quarter for the current fiscal year.

Displays the allocated and direct costs by customer category for the current fiscal year.

Displays the revenue amount and expenses of the top 10 customers by expenses for the current fiscal year.

Displays the revenue and operating profit percentage of the top 10 customers by marketing expenses for the current fiscal year.

Displays the revenue and operating profit of the top 10 customers by operating profit for the current fiscal year.


13/29

Displays the sales expenses and revenue for the top 10 customers by sales expenses for the current fiscal year.

Displays the revenue and operating profit percentage of the top 10 customers by service expenses for the current fiscal year.

Displays the cost ratios by month for the trailing 12 fiscal months

Displays the ROE, ROA and ROCE profitability ratios by month for the trailing 12 fiscal months.

Displays the ROA, EBIT and total assets by month for the trailing 12 fiscal months.

Displays ROE, net income and total shareholder funds by month for the trailing 12 fiscal months.

Displays the percentages of the cost ratios for the current fiscal quarter.

Displays the gross margins by customer category for the current fiscal quarter.

Displays the Gross Margin % for the current Fiscal Quarter.

Trend of key cost ratios over past year

Displays the Net Income Margin % for the current Fiscal Quarter.

Displays the Operating Margin % for the current Fiscal Quarter.

Displays a summary view of the profit and loss by quarter. Profit and loss reports shed light on your profitability by identifying the different component

Profit and loss reports shed light on your profitability by identifying the different components that constitute your total operating cost and profit. P&L r

Displays the gross margins by product for the current fiscal quarter. This report helps to identify underperforming products by comparing Product Gro

This report helps to identify underperforming products by comparing Product Gross Margin with the overall Gross Margin as an internal benchmark.

Displays monthly profitability returns for the current fiscal quarter based on profitability ratios.

Asset Return contains details of return on assets plotted against earnings before interest and tax. The ROA compares income prior to the cost of fin

Displays the Return on Assets (EBIT Basis) for the current Fiscal Quarter.Displays the Return on Assets (pre-interest) for the current Fiscal Quarter.

Displays the Return on Equity ratio for the current fiscal quarter

Provides revenue amount by product over trailing four fiscal quarters.

Displays COGS amount by product category over trailing four fiscal quarters.

Displays the profit and loss by quarter for the trailing four fiscal quarters. Profit and loss reports shed light on your profitability by identifying the differe

Displays the YTD profit and loss by quarter for the trailing four fiscal quarters. Profit and loss reports shed light on your profitability by identifying the d

Provides revenue amount by product category over trailing four fiscal quarters.

Display the 10 least profitable products by operating margin for the current fiscal year.

Displays the allocated and direct costs details by product category for the current fiscal year.

Displays the allocated and direct cost lines by product for the current fiscal year.

Displays revenue and marketing, sales and service expenses by product over trailing four fiscal quarters.

Displays product description and expense amount by Fiscal QuartersProvides comparison of product gross margin % with overall product gross margin and revenue amount by product.

Displays product profitability details - revenue amount, gross profit, gross margin and operating profit - over current fiscal year.

Displays the revenue amount by quarter by customer and product for the trailing four fiscal quarters.

Displays the product profitability by quarter for the current fiscal year.

Displays the lowest products by operating profit percentage for the current fiscal year.

Display the 10 least profitable products by operating margin for the current fiscal year.

Displays the top 10 products by operating profit percentage for the current fiscal year.

Displays the sales expense, revenue and operating profit percentage of top 10 products by sales expense for the current fiscal year.

Displays the services expenses, revenue amount and operating profit percentage of the top 10 products by service expenses for the current fiscal ye

Displays the top 10 products by revenue amount and gross margin for the current fiscal year

Displays the revenue amount and percent of total by quarter and product for the trailing four fiscal quarters.Displays the product revenue amount by quarter for the trailing four fiscal quarters

Displays the revenue amount by quarter by customer and product for the trailing four fiscal quarters.

Displays the group and cumulative revenue amounts by fiscal period for the trailing four fiscal quarters.

Displays the group revenue amount by customer and fiscal period for the trail ing four fiscal quarters.

Displays the group revenue amounts by product and fiscal period for the trailing four fiscal quarters.

Displays the top 10 customers by revenue amount for the current fiscal year.

Displays the top ten revenue amounts and percent of total by product for current fiscal year.

Displays the AP aging buckets and relative % vs. total by project

Displays the AP payments due aging for the current fiscal quarter by project

Displays the AP payments overdue aging for the current fiscal quarter by project

Displays the AR aging buckets and relative % vs. total by project

Displays the AR payments due aging for the current fiscal quarter by project

Displays the AR payments overdue aging for the current fiscal quarter by project

Displays the AP and AR invoices (posted and unposted) in multiple aging buckets to provide consolidated cash flow by project satisfying the report fil

Displays the details of all invoice transactions


14/29

Current Aging Customer Balances at the company and industry level. The Aging is based off of the Invoice Dates.

Current Aging Customer Balances by collector indicates the effectiveness of each collector. The Aging is based off of the Invoice Dates.




DSO is an important measure for Receivables manager to keep track of. Trend provides insight i f it is increasing or decreasing over a period of time.

Displays receivables outstanding for 1-30 days

Displays the AR balance and DSO for the top 10 customers by AR balance for the current fiscal quarter

Displays the credit limit percentage used, credit limit and closing amount for the top 10 customers by credit limit percentage used for the current fisca

Displays the AR due aging by quarter for the trailing four fiscal quarters for a customer or group of customers. Also provides a breakout of AR due ag

Displays the AR overdue aging by quarter for the trailing four fiscal quarters. Also provides a breakout of AR overdue aging for a customer or group o

Displays the AR balance and days sales outstanding by period for the trailing 12 fiscal periods for a customer or group of customers

Displays the AR balance and days sales outstanding by quarter for the trailing 4 fiscal quarters for a customer or group of customers

Displays the credit limit percentage used and closing group amount by quarter for a customer or group of customers. If the credit limit % exceeds a c



Indicates the effectiveness and load of each collector

Displays the invoice count, amount and average amount by staff for the current fiscal year

Displays the invoice count, amount and average amount by staff for last 12 fiscal periodsDisplays the average invoice amount and count by month for the trailing 12 fiscal periods

Displays the AR debit and credit memo counts and amounts by month and quarter for the trailing four fiscal quarters

Displays the total AR outstanding amount by staff for the trailing four fiscal quarters

This report will help focus on top customers for invoice consolidation and reduce the amount of efforts to process transactions.

Displays number of invoices against a sales order

Display the AR invoice payments that are due in 1-30 days



Display the AR invoice payments that are due in 90 days



Displays receivables outstanding for 61-90 daysDisplays receivables outstanding for over 90 days

Displays the AR invoice payments that are overdue for 1-30 days



Displays the AR invoice payments that are overdue for over 90 days

Displays the details of all open invoices

Displays the percentage of accounts receivable overdue for the current fiscal quarter.

This provides an overview of the largest customer overdue payments broken out in 30-day intervals.

This provides an overview of overdue payments broken out in 30-day intervals as well as the % to total due balances.

A measure of the average number of days that a company takes to collect revenue after a sale has been made. A low DSO number means that it tak

DSO is an important measure for Receivables manager to keep track of. Comparison across companies and industries to the total company provide

One of the goals of receivables manager is to reduce the transaction costs since it takes the same amount of processing to enter a $1 Million VouchThis provides a overview trending analysis of key performance indicators for measuring the effectiveness of collection activ ity.

Overview status on key Receivables KPIs. Drill on values to navigate to further detail.

Displays the top 10 customers with lowest average invoice amount in fiscal period/quarter

Displays the top 10 customers average payment days, weighted days and number of times paid before and after the due date for a fiscal period

Displays the payment amount and invoice percentage by month for a fiscal year

Displays the average payment days and weighted payment days by month

Displays the top 10 customer's average payment days, weighted days and number of times paid before and after the due date for a fiscal year

Displays the top 10 customer's AR total payment amount by customer name for the trailing four fiscal quarters

Displays the AR due aging for the trailing four fiscal quarters. This report help identifies customers who have payments coming up in near future. If th

Displays the AR due aging on a trending basis

Displays the invoice overdue status and remaining amount

Displays the invoice amount, due amount and overdue amount by month

Displays the AR overdue aging for the trailing four fiscal quarters. Overdue amounts indicate that customers failed to pay some of the money owed o

Monitor top 10 overdue balances by customer. Overdue amounts indicate that customers failed to pay some of the money owed on time. If the overd

This helps gain visibility into customers with largest payments due in the current quarter, especially valuable in month-end and quarter-end activities.


15/29

Trend provides visibility on credit terms obtained from customers. For example, if the credit terms are shorter, then the 30 days balance will trend up.

Trend provides visibility on credit terms obtained from customers. For example, if the credit terms are shorter, then the 30 days balance will trend up.


16/29

Remark

uirements. Similarly if cash inputs (due to inventory and payables) as a % to COGS decreases, then it indicates that inventory is ma

ent.

king capital turnover will be favorable (i.e. higher). The objective should be to minimize inventory, maximize receivables and extend

sets and liabilities of an organization.

sets and liabilities of an organization.

s that constitute the assets and liabilities of an organization.

ating Expenses components are Sales & Marketing, R&D and Other Operating Expenses.

l operating expenses YTD metric provides trending information to assist with the monitoring of business operations. Total Operating

Answer

l. Displays information in both a chart and table format for easier navigation.

Answer

Answer

by cost center is provided to help identify businesses areas outside of budgetary compliance.ions 2) Trends in the flow of cash relating to investing and financing decisions 3) Management decisions regarding financial policy (

erate cash from operations 2) Trends in the flow of cash relating to investing and financing decisions 3) Management decisions rega

tructure and, indirectly, its ability to meet current debt obligations.

generation is enough to fund the capital expenditure requirements of the firm. Rapid growth of a firm is often accompanied by incre

AnswerIt provides intuitive feel for a firms liquidity. However this is more conservative than some of the other ratios such as current, quick

meet all its liabilities. While a high current ratio is considered to be safe, this could conflict with efficient usage of working capital. So

AnswerAnswerAnswerAnswer

Answer

ponents makes it easier to find the reason for increases or decreases in working capital.

Answer

ws drill across to AP and AR transaction details.

AnswerAnswerAnswer

Answer

Answer

AnswerAnswerAnswer


17/29

.

Answer

Answer

Answer

e date. If the overdue balance as a % to AP balance is high, this could indicate problems with the supplier. There could be a disput

AnswerAnswerAnswer

well the AP processing staff is performing

AnswerAnswerAnswerAnswerAnswer

Answer

Answer

Answer

overdue balance as a % to AP balance is high, this could indicate problems with the supplier. There could be a dispute with the sup

AnswerAnswerAnswerAnswerAnswerAnswerAnswerAnswerAnswer

. If the overdue balance as a % to AP balance is high, this could indicate problems with the supplier. There could be a dispute with

Answerlier balances that are past payment due date. If the overdue balance as a % to AP balance is high, this could indicate problems wit

AnswerAnswerAnswer

Answer


18/29

Answer

Answer

Answer

Answer

Answer

Answerthat constitute your total operating cost and profit. P&L reports are available for an analysis date, a range of months, quarters and

Answer

s Margin with the overall Company Gross Margin (Internal Benchmark).

Answer

Answer

Answer

Answer

AnswerAnswer

Answer

Answernt components that constitute your total operating cost and profit. P&L reports are available for an analysis date, a range of months,

ifferent components that constitute your total operating cost and profit. P&L reports are available for an analysis date, a range of mo

AnswerAnswer

Answer

Answer

Answer

AnswerAnswer

Answer

Answer

Answer

Answer

Answer

Answer

Answer

Answer

ter criteria. This report does not provide any other information that is typically part of financial cash f low statement.


19/29

AnswerAnswer

AnswerDSO is an integral part of Cash Conversion Cycle.

Answer

l quarter

Answer

ing by customer.

f customers.

Answer

rtain value, either sales should be stopped until the customer clears some part of the balance or credit limit should reviewed. The c

AnswerAnswerAnswer

Answer

AnswerAnswerAnswerAnswerAnswerAnswerAnswerAnswer

AnswerAnswerAnswerAnswerAnswer

Answer

es a company fewer days to collect its accounts receivable. A high DSO number shows that a company is selling its product to cust

Answerr and a $1 Voucher. Keeping track of No. of invoices and average invoice amount per transaction is important. The no. of invoices

AnswerAnswer

AnswerAnswerAnswer

n time. If the overdue balance to total outstanding balance is high, then the firm should be cautious in selling more to those custome

e balance to total outstanding balance is high, then the firm should be cautious in selling more to those customers. Also the firm sh


20/29

AnswerAnswer


21/29

aged better or firm has received better credit terms from the supplier. The cash gross margin will lead gross margin if working capit

the credit with suppliers without affecting the operations in order to improve working capital turnover.

Expenses components are Sales & Marketing, R&D and Other Operating Expenses.

leverage), dividend policy, and investment for growth.

rding financial policy (leverage), dividend policy, and investment for growth.

ses in capital expenditures and negative free cash flows, resulting in liquidity problems.

and cash ratios.there are two objectives: the firm should be liquid enough and the firm should conserve cash through better working capital mgmt.


22/29

with the supplier. If it is not resolved, then the vendor might stop supply, which could disrupt production

plier. If it is not resolved, then the vendor might stop supply, which could disrupt production.

the supplier. If it is not resolved, then the vendor might stop supply, which could disrupt production.

the supplier. There could be a dispute with the supplier. If it is not resolved, then the vendor might stop supply, which could disrupt


23/29

ear to date.

quarters and the year to date.

nths, quarters and the year to date.


24/29

redit limit is allocated depending on the risk profile of the customer. If greater than 100%, then every additional dollar credit sales is

mers on credit and taking longer to collect money

ay increase in relation to the growth of the business, but the average invoice amount per transaction should not decline.

rs. Also the firm should take aggressive steps to collect the money

uld take aggressive steps to collect the money.


25/29


26/29

l is managed efficiently.


27/29

production.


28/29


29/29

t a higher risk of not turning into cash.

bi dashboard and report summary

Documents