• Business Questions
  • Overview
  • What is the trend of AP for last 8 quarters?
  • How are my asset balances tracking across regions (COA) for last 2 years?
  • What are the CapEx requirements in near future? Will PPE hold up, or will an early capital infusion be needed?
  • What is the working capital position and trend for past x quarters?
  • How is debt equity mix structured at present, and is it actionable for improved financial gearing?
  • What is the trend of Gross Margins for past 2 years across business units?
  • What is the composition of fixed cost elements vs variable cost elements for past 2 years?
  • What is the proportion of operating profits taken up by interest and financing cost?
  • What is the trend around operating and net margins for past 2 years?
  • How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
  • What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
  • What is the QoQ, YoY trend for accrual bookings due for reversal in next accounting period?
  • What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
  • What is the count and amount of invoices processed for the period by business units and trend comparison?
  • What are the invoice types processed by AP department and the payment methods used to understand the downstream activities?
  • What is the validation, approval and accounting status of invoices processed during the period?
  • No. of invoices paid vs unpaid including partly paid with amount?
  • Analysis around payment terms by transaction type, transaction source for the invoices processed?
  • What is the count and amount of payments processed for the period by business units and trend comparison?
  • What is the ratio of on-time payment performance?
  • What is count and amount of overdue payments?
  • What is the avg. supplier payment days by BU's?
  • What are the interest penalties paid by amount and percentage?
  • What are the liabilities distribution details of AP Balances?
  • What is the accounting status of liability distributions by invoices?
  • What is the average time available to pay off the outstanding AP invoices?
  • What is the count and value of AP invoices overdue?
  • What is the summary of AP invoices across aging buckets, count, and value?
  • What is the trend of outstanding AP Balances at consolidated level, supplier level, and Business Unit level?
  • How are AP balances trending for a particular supplier over last 8 quarters?
  • What are the top 10 suppliers with maximum AP outstanding?
  • Whether the company was able to meet the guided revenue growth for past quarters or years?
  • How is the actual performance vs the budgeted performance of top Balance Sheet metrics for the last quarter or year?
  • What is the trend for profitability metrics actual vs budget and direction of variance?
  • Is higher than anticipated OPEX a one-off case or how is the trend for past eight quarters?
  • What is the split of budgeted receivables by entity or ledgers?
  • What is the budgeted revenue activity on monthly or quarterly basis?
  • What is the target revenue for next quarter in best case and worst case scenario?
  • What is the count and amount of AP Invoices that have either Header Level Hold, Line Level Hold, or combination?
  • What is the outstanding AP amount for AP Invoices on Holds?
  • What is the current AP amount out of outstanding AP amount for Invoices on Hold?
  • What is the overdue AP amount out of outstanding AP amount for Invoices on Hold?
  • What is the average number of days for invoices on hold and the trend for past six quarters?
  • What is the count and amount of AP Invoices on Hold due to distribution variances?
  • What is the count and amount of AP Invoices on Hold due to PO matching variances?
  • What is the count and amount of AP Invoices on Hold due to supplier site limits?
  • What is the split of invoices on Hold by manual holds vs system holds?
  • What is the summary of invoices (count and amount) by various hold reasons and hold by user?
  • What is the summary of invoices (count and amount) by various release reasons and released by user?
  • What is the amount of AP Expenses by each Business Unit?
  • What is the trend of AP Expenses for the past six quarters?
  • What is the distribution of AP Expenses by top 10 suppliers?
  • What is the distribution of AP Expenses by the top five Natural Accounts or Financial Categories?
  • What is the distribution of AP Expenses by each of the cost center?
  • What is the count and amount of transactions processed over the period of time?
  • What is the classification of transactions processed during the period by Transaction Type and Source?
  • What are the payment terms and receipt methods associated with the transactions?
  • What is the summary of Transactions by statuses?
  • What is the count and amount of receipts processed over the period of time?
  • What is the count and amount of applied receipts?
  • What is the count and amount of unapplied receipts?
  • What is the trend for Average Receipt Days?
  • What is the analysis of due and overdue receipts?
  • What is the amount of discount Taken vs Lost?
  • What is the count and amount of credit memo applications during the period?
  • What is the analysis of credit memo applications by Business Unit, Time Period, Customers, GL Accounts, and so on?
  • What is the status of CM application transactions?
  • What is the count and amount of AR Adjustments processed during the period?
  • What is the analysis of AR Adjustments by Business Unit, Time Period, Customers, GL Accounts, and so on?
  • What is the ratio of AR Adjustments applications to Invoice %?
  • What is the status of AR Adjustments?
  • What is the count and value of AR invoices Overdue?
  • What is the count and value of AR Invoices Current?
  • What is the summary of AR invoices across aging buckets, count and value?
  • What is the summary of AR invoices overdue with respect to their aging buckets and payment terms?
  • What is the trend of outstanding AR Balances by Customer or Business Unit?
  • What is the AR account activity for the period and balance amount by Business Unit?
  • How are AR balances trending for a particular customer over the last eight quarters?
  • What are the top 10 customers with maximum AR outstanding?
  • What is the trend for operating revenue for past 6 quarters by Ledger, Legal Entity, Billing BU, etc?
  • What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, transaction type?
  • What is the distribution of Revenue by top 10 customer accounts?
  • What is the contribution of non operating revenue and trend for past quarters?
  • What is the distribution of revenue by top 5 revenue accounts?
  • What is the amount of deferred revenue further classified by long term and short term deferred revenue?
  • What is the revenue recognition for the fiscal period in comparison to billings in prior periods (Bill in Advance) or billing in future (Bill in Arrears)?
  • What is the breakdown of inter company revenue vs external revenue based on AR transaction type, transaction source?
  • What is the Revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc?
  • What is the summary as well as detailed analysis of revenue vs billed amount (including taxes) in Transaction Currency, Ledger Currency, Analytics Currency?
  • How to reconcile GL Balances/Journals and all contributing subledger transactions including manual journals in GL with post SLA accounting details in a single consolidate report?
  • How to analyze GL Balances/Journals with the ability to get the extended details of subledger transaction attributes and accounting events?
  • How to get consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
  • How to facilitate intuitive drill to details for GL Balances, Journals or subledger transactions for detailed analysis with minimum number of clicks?
  • How to support account analysis across multi period, multi ledger at detailed or roll up account levels across Chart of Account Segments?
  • How to monitor GL accounts with respect to accounting and posting activity for all contributing transactions during an accounting period?
  • How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?
  • Identify items and categories with cost-saving potential in procurement operations based on prices.
  • Identify the key areas for improving process efficiencies.
  • Identify items, categories, and suppliers with compliance issues in their purchase agreements.
  • What is the employee expense Spend by Business Units?
  • What are the top expense reports which are paid?
  • What is the total expenses by number of expense reports for employee, manager, organization, cost centers?
  • WHat is the Total Expense Trend for last few quarter's?
  • Which are top cost centers by employee expenses?
  • What is the expense breakdown by expense type?
  • What is the number of expenses which are filed late?
  • Who are the top managers by expenses?
  • Which are the top cost centers and organizations with Audit violations for expense reports which are paid?
  • What is the percentage of reports which are Auto approved?
  • What is the trend in Credit vs Cash expense?
  • What are the cycle times for report submission, filing, approvals?
  • What commodities and services have been purchased, in what volume and price?
  • How is purchase distributed across suppliers?
  • Is a company using strategic suppliers and contracts effectively?
  • What are my purchase volume across business units?
  • What is my contract vs off contract spend?
  • What are cycle times in terms of PR and PO Approval, PR to PO conversion?
  • How many times are we amending purchase orders and whether amendment initiation is internal or external?
  • How many approvers on a average are approving purchase orders?
  • What are my lead time standard and variances in purchase cycles?
  • What are purchase orders creation sources and corresponding requisition sources?
  • When were products shipped and what is the average delivery times?
  • Which suppliers deliver consistently on time?
  • What is accepted and rejected rates for commodities, by suppliers?
  • What are return rates for suppliers?
  • What receipts are created manually or through ASN's?
  • What are my processing and post processing lead time standards and variances for an Item?
  • What are my products and services for which we have agreements?
  • What are the agreements utilization rates?
  • Which agreements are under utilized?
  • Which agreements are utilized before expiry?
  • What are the creation sources for agreements?
  • What are my cycle times for agreement approvals?
  • What are my negotiation to agreement approval cycle times?
  • How many times are we amending agreements and whether amendment initiation is internal or external?
  • How many approvers on a average are approving agreements?
  • How long does it take for purchase requisitions to get approved?
  • What is the centralized view of all procurement requests for purchasing department?
  • What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?
  • How many non-catalog purchase requisitions are created by volume, item, and amount?
  • What is the actual cost by Project and Task?
  • What is the actual cost by Project Type?
  • What is the actual cost by Project Organization?
  • What is the actual cost by GL Account for a specific period?
  • What are the expenditures that contributed to the actual costs?
  • What are the costs by expenditure type and category?
  • What % of costs have been Capitalized?
  • What % of cost have been billed?
  • What is the actual cost by Project Class codes?
  • What are the ITD, YTD and PTD actual costs?
  • What is the Labor cost and effort breakup by Employee, Job?
  • What is the trend of cost?
  • What is the total project cost by Project Organization, Project Type, Expenditure type, Expenditure Category, Expenditure Organization?
  • What is the trend of Project Cost by Organization, Project type etc?
  • What is the overall net book value for PP&E assets and trend over multiple periods by entity, asset book,etc?
  • What is the period active asset unit details for particular asset category and trend details?
  • What is period active asset mix across various asset categories?
  • What is the asset mix across various asset types CIP, Capitalized, Expensed?
  • What are the period wise last active asset employee assignment details?
  • Summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.
  • What is the average life of asset by asset category?
  • What is summary of assets which has exceeded economic life or nearby end of life?
  • How to track asset book health, lifecycle tracking with historic data?
  • What is the summary of asset addition/ CapEx for a particular entity, asset book, asset category?
  • What are the source document details for asset additions?
  • What is the trend of asset retirement over a period of time in terms of cost retired, NBV retired?
  • What are the details of asset retired by various asset categories?
  • What is the average cost of removal per unit for retired assets?
  • What is the amount of assets revalued during past 6 quarters?
  • What is the amount and quantity of assets reclassified during the period?
  • What is the amount and quantity of assets adjusted by transaction type and GL accounts, segments?
  • What is the total commitment cost by Project?
  • What are the outstanding requisitions, purchase orders and supplier invoices by Project that still have commitment costs?

Copyright © 2019, 2022, Oracle and/or its affiliates.