ERP Business Questions

Overview
What is the count and amount of AP invoices that have either header level hold, line level hold, or a 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 count and value of AP invoices overdue?
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 summary of invoices (count and amount) by various hold reasons and holds by users?
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 release reasons and released by user?
What is the average time available to pay off outstanding AP invoices?
What is the summary of AP invoices across aging buckets, count, and value?
What is the trend of outstanding AP Balances at the consolidated level, supplier level, and business unit level?
How are AP balances trending for a particular supplier over last eight quarters?
Which are the top 10 suppliers with the maximum AP outstanding?
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 the top 10 suppliers?
What are the invoice types processed by the AP department and the payment methods used to understand the downstream activities?
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 centers?
What is the count and amount of invoices processed for the period by business units and trend comparison?
What is the validation, approval, and accounting status of invoices processed during the period?
What is the number of invoices paid vs. unpaid including partly paid with amount?
What is the analysis around payment terms by transaction type and transaction source for the invoices processed?
What are the liabilities distribution details of AP Balances?
What is the accounting status of liability distributions by invoices?
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 average supplier payment days by business unit?
What are the interest penalties paid by amount and percentage?
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 status of AR adjustments?
What is the ratio of AR adjustments applications to invoice percentage?
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?
Which are the top 10 customers with maximum AR outstanding?
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 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 trend for operating revenue for past six quarters by ledger, legal entity, billing BU, etc?
What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, and transaction type?
What is the distribution of revenue by the top 10 customer accounts?
What is the contribution of non-operating revenue and the trend for past quarters?
What is the distribution of revenue by top five 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 and 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 the detailed analysis of revenue vs. billed amount (including taxes) in transaction currency, ledger currency, and analytics currency?
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 overall net book value for PP&E assets and trend over multiple periods by entity, asset book, etc.?
What are the period active asset unit details for particular asset categories and trend details?
What is period active asset mix across various asset categories?
What is the asset mix across the various asset types CIP, capitalized, and expensed?
What are the period-wise last active asset employee assignment details?
What is the 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 the summary of assets which have exceeded economic life or near end of life?
How do I track asset book health and what is lifecycle tracking with historic data?
What is the summary of asset additions/ CapEx for a particular entity, asset book, and 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 or NBV retired?
What are the details of assets 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 and segments?
What is the employee expense spend by business units?
What are the top expense reports which are paid?
What are the total expenses by number of expense reports for employee, manager, organization, and cost centers?
What is the total expense trend for last few quarters?
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 expenses?
What are the cycle times for report submission, filing, and approvals?
How do I 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 do I analyze GL balances/journals with the ability to get the extended details of subledger transaction attributes and accounting events?
How do I get a consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
How do I facilitate intuitive drill-to details for GL balances, journals, or subledger transactions for detailed analyses with a minimum number of clicks?
How do I support account analyses across multi-period and multi-ledger at detailed or roll-up account levels across chart of account segments?
How do I monitor GL accounts with respect to accounting and posting activity for all the contributing transactions during an accounting period?
What is the trend of AP for last eight quarters?
How are my asset balances tracking across regions (COA) for last two years?
What are the CapEx requirements in the 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 the debt equity mix structured at present, and is it actionable for improved financial gearing?
Was the company 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 a monthly or quarterly basis?
What is the target revenue for the next quarter in the best case and worst case scenarios?
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 the next accounting period?
What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
What is the trend of gross margins for past two years across business units?
What is the composition of fixed cost elements vs. variable cost elements for past two years?
What is the proportion of operating profits taken up by interest and financing costs?
What is the trend around operating and net margins for past two years?
What is the total capitalized cost of my assets?
Which cost distributions are included in an asset line?
Which assets are built and placed in service?
What are the CIP assets assigned to a project?
What are the assets retired and the retirement adjustment costs?
What is the capitalizable and non-capitalizable costs on my project?
What is the budgeted raw and burdened cost for the project?
What are the changes in budgeted quantity and amounts from my original budget?
What is the budgeted revenue for the project?
What is the original and current margin of budget on the project?
What is the cost variance from approved budget by project, task, and resources?
Which project organizations have overrun their budgets in the last quarter periods?
What is the planned labor budget for projects across the project organizations?
What is the budgeted revenue by business unit and project organizations?
What is the budgeted revenue by customer?
What is the split of budgeted cost and revenue by project, task, and resources?
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?
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 percentage of costs have been capitalized?
What percentage of cost have been billed?
What is the actual cost by project class code?
What are the ITD, YTD and PTD actual costs?
What is the labor cost and effort breakup by employee and job?
What is the trend of cost?
What is the total project cost by project organization, project type, expenditure type, expenditure category, and expenditure organization?
What is the trend of project cost by organization, project type, etc.?
What are the forecasted raw and burdened costs for projects?
What are the changes in quantity and amounts from my original forecast?
What is the forecasted revenue for the project?
What is the original and current margin of forecast on the project?
What is the cost variance from approved forecast by project, task, and resources?
What is the labor forecast for projects across the project organizations?
What is the EAC cost and revenue of the project?
What is the ETC cost and revenue for the project?
What is forecasted revenue by business unit and project organization?
What is the forecasted revenue by customer?
What is the split of forecasted cost and revenue by project, task, and resources?
Which contracts and customers are funding the project?
How much of the contract amount isn't allocated?
How much of the project contract amount has been invoiced?
How much revenue has been recognized for the project contract?
What is the contract amount for external, intercompany, and interproject contract types?
What is the billing amount by contract, project, and task?
What is the intercompany, interproject invoice amount by provider and receiver?
What is the write-off, cancellation, and concession invoice amounts?
Who are the top 10 contract customers by invoice amount?
What is the actual revenue by contract, project, and task?
What is the actual revenue by contractorganization?
What is the actual revenue by event type and revenue category?
What is the actual revenue by GL account for a specific period?
What is the trend of revenue?
What is my project margin?
What is the intercompany revenue, and interproject revenue by provider and receiver?
What are the products and services for which we have agreements?
What are the agreement 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 are the amendment initiations internal or external?
How many approvers on a average are approving agreements?
What commodities and services have been purchased, and in what volume and price?
How are purchases distributed across suppliers?
Is the company using strategic suppliers and contracts effectively?
What are my purchase volumes across business units?
What is my contract vs. off-contract spend?
What are the cycle times in terms of PR and PO approval, and PR to PO conversion?
How many times are we amending purchase orders, and are the amendment initiations internal or external?
How many approvers on average are approving purchase orders?
What are my lead time standards and variances in purchase cycles?
What are the purchase order creation sources and corresponding requisition sources?
When were products shipped and what are the average delivery times?
Which suppliers deliver consistently on time?
What are the accepted and rejected rates for commodities, and by suppliers?
What are the return rates for suppliers?
What receipts are created manually or through ASNs?
What are my processing and post-processing lead time standards and variances for an item?
How long does it take for purchase requisitions to get approved?
What is the centralized view of all procurement requests for the purchasing department?
What are the classifications of purchase requisitions by status, type, and source created for a period, and what are the associated purchase order details?
How many non-catalog purchase requisitions are created by volume, item, and amount?
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 allocated funding amount for each project of an active award?
What awards have funding unallocated to projects?
What is the total funding by organization year over year?
What is the projected spend percentage or burn rate?
What is the amount consumed on the award?
Which awards are currently active?
Which awards are past their end dates but weren't closed?
Which contracts are expiring in next one months by suppliers, business unit?
What is the count of contracts and contract amounts by suppliers, business units, products?
What are the active contracts by contract type?
What is contract cycle time in days for contracts?
What are the contracts with policy deviations?
What are the Receipt Accounting Transactions for the current Period?
What are the Receipt Accounting Distributions generated for the current period?
Which of the POs are accrued where the Accrual is at Receipt?
Which POs are Matched against Invoice?
Is the Un-invoiced Receipt transactions Manually Cleared?
What are the Awards / Projects with the most labor Schedules Active?
Which Labor schedules end in the next 3 months?
What are the Labor schedules with Awards / Projects Ending Soon?
Who has a labor schedule with no costs associated?
What payroll batches have loaded recently and where did they distribute to?
How many costs are being distributed to GL vs Projects over time?
What are the labor distributions that have errors?
How much is the PO Receipt Accruals by BU, Inventory Org, Item Category, Supplier for a specific time frame?
How many Receipts are Accrued by BU, Inventory Org, Item Category, Supplier, PO for a specific time frame?
How many of POs are pending accrual by BU, Inventory Org, Item Category, Supplier for a specific time frame?
What is the amount of Goods Received and not Invoiced for Accruals at period end by BU, Inventory Org, Item Category, Supplier for a specific time frame?