ERP Business Questions
Overview
Are any strategies running without any work items?
For each budget account within a control budget, which transactions had funds checked or reserved for a selected budget period?
How are AP balances trending for a particular supplier over last eight quarters?
How are AR balances trending for a particular customer over the last eight quarters?
How are accounted and unaccounted payments trending by payment date and accounting date?
How are active lease contracts distributed by lease start date, location, or asset type?
How are my asset balances tracking across regions (COA) for last two years?
How are our Scope 1 emissions trending when we normalize for the growth of our company?
How are our Scope 2 location-based emissions trending when we normalize for the growth of our company?
How are our Scope 2 market-based emissions trending when we normalize for the growth of our company?
How are our Scope 3 emissions trending when we normalize for the growth of our company?
How are purchases distributed across suppliers?
How are we progressing with regard to our Scope 1 emissions intensity reduction goal?
How are we tracking toward our carbon reduction goal?
How are we tracking toward our goal of reducing each component?
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 facilitate intuitive drill-to details for GL balances, journals, or subledger transactions for detailed analyses with a minimum number of clicks?
How do I get a consolidated abstract view of GL account activity for a period and associated subledger transaction activity?
How do I monitor GL accounts with respect to accounting and posting activity for all the contributing transactions during an accounting period?
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 support account analyses across multi-period and multi-ledger at detailed or roll-up account levels across chart of account segments?
How do I track asset book health and what is lifecycle tracking with historic data?
How do actual lease expenses compare across business units or locations?
How do lease accounting distributions map to GL segments or balancing segments?
How do overdue, on-time, and discount metrics compare for accounted versus unaccounted payments?
How does expense spend flow from requisition to purchase order, receipt, and invoice?
How has each account's score changed over the past 90 days?
How have component-level scores changed over time for a given account?
How is the actual performance vs. the budgeted performance of top balance sheet metrics for the last quarter or year?
How is the debt equity mix structured at present, and is it actionable for improved financial gearing?
How is the reconciliation performed for the statement lines. Are they automatically reconciled or manually reconciled?
How is the trend analysis for journals from subledger sources against manual GL journals, both in terms of amount and volume?
How long does it take for purchase requisitions to get approved?
How many Change Orders are in Pending for Approval status?
How many Change Orders are in Pending for Approval status?
How many Initiatives are in pending acceptance state and pending evaluation state?
How many Receipts are Accrued by BU, Inventory Org, Item Category, Supplier, PO for a specific time frame?
How many Regular hours, Overtime hours are processed across various time periods?
How many accounts had a strategy reassigned due to score change?
How many accounts have a score below the strategy assignment threshold?
How many approvers on a average are approving agreements?
How many approvers on average are approving purchase orders?
How many costs are being distributed to GL vs Projects over time?
How many delinquent accounts have an active strategy?
How many documents have more than two Change Orders?
How many documents have more than two Change Orders?
How many initiatives were created last year by business unit?
How many intercompany transactions are accounted vs unaccounted along with the details?
How many invoices are in each delinquency status?
How many journal batches, headers, lines are unposted?
How many new suppliers got created in the last quarter?
How many non-catalog purchase requisitions are created by volume, item, and amount?
How many of POs are pending accrual by BU, Inventory Org, Item Category, Supplier for a specific time frame?
How many project time cards are submitted, approved, or rejected?
How many strategies were cancelled in the last 30/60/90 days?
How many suppliers are manually registered?
How many suppliers are registered as spend classified?
How many suppliers were qualified in the last quarter?
How many times are we amending agreements, and are the amendment initiations internal or external?
How many times are we amending purchase orders, and are the amendment initiations internal or external?
How many transactions are currently in draft, submitted, approved, or invoiced status?
How many transactions are stuck in workflow, and what is the average processing cycle time?
How many work items are due today and how many are overdue?
How may suppliers are pending to be approved?
How much did the organization spend with suppliers, commodities, buyers, cost center, contracts versus non contracts and leakage?
How much intercompany activity occurred this period by legal entity, business unit, and transaction type?
How much invoice expense is linked to projects, tasks, and funding sources?
How much is the PO Receipt Accruals by BU, Inventory Org, Item Category, Supplier for a specific time frame?
How much of the contract amount isn't allocated?
How much of the project contract amount has been invoiced?
How much payment activity is accounted versus unaccounted across suppliers and business units?
How much revenue has been recognized for the project contract?
How much total outstanding receivables are currently delinquent?
Identify items and categories with cost-saving potential in procurement operations based on prices?
Identify items, categories, and suppliers with compliance issues in their purchase agreements?
Identify the key areas for improving process efficiencies?
Is higher than anticipated OPEX a one-off case, or how is the trend for past eight quarters?
Is the Un-invoiced Receipt transactions Manually Cleared?
Is the company using strategic suppliers and contracts effectively?
New suppliers by geography (City/County etc)?
Total number of suppliers by business units?
Was the company able to meet the guided revenue growth for past quarters or years?
What are foreign currency transactions in the bank account?
What are my cycle times for agreement approvals?
What are my lead time standards and variances in purchase cycles?
What are my negotiation-to-agreement approval cycle times?
What are my processing and post-processing lead time standards and variances for an item?
What are my purchase volumes across business units?
What are the Awards / Projects with the most labor Schedules Active?
What are the CIP assets assigned to a project?
What are the CapEx requirements in the near future? Will PPE hold up, or will an early capital infusion be needed?
What are the ITD, YTD and PTD actual costs?
What are the Labor schedules with Awards or Projects Ending Soon?
What are the Receipt Accounting Distributions generated for the current period?
What are the Receipt Accounting Transactions for the current Period?
What are the Unreconciled Statements and Statement lines and how long they are Unreconciled?
What are the accepted and rejected rates for commodities, and by suppliers?
What are the active contracts by contract type?
What are the agreement utilization rates?
What are the assets retired and the retirement adjustment costs?
What are the bank account transfer and Adhoc Payment details of the external transactions?
What are the bank statement amounts for each back account in a given time period? What are the Payments and Deposits?
What are the billing completed events for a contract or contract line which are not invoiced or revenue recognized?
What are the changes in budgeted quantity and amounts from my original budget?
What are the changes in quantity and amounts from my original forecast?
What are the classifications of purchase requisitions by status, type, and source created for a period, and what are the associated purchase order details?
What are the component-level scores for each account (score explainability)?
What are the contracts with policy deviations?
What are the costs by expenditure type and category?
What are the creation sources for agreements?
What are the cycle times for report submission, filing, and approvals?
What are the cycle times in terms of PR and PO approval, and PR to PO conversion?
What are the details of assets retired by various asset categories?
What are the details of entries booked in GL for reclassification from expense to assets and vice versa?
What are the expenditures that contributed to the actual costs?
What are the external cash transactions that are accounted for a specified cost center and date range for a bank account?
What are the external transactions created and accounted for a period for a business unit /legal entity?
What are the external transactions created for various sources?
What are the forecasted raw and burdened costs for projects?
What are the interest penalties paid by amount and percentage?
What are the invoice types processed by the AP department and the payment methods used to understand the downstream activities?
What are the journals that contribute to the encumbrance balance?
What are the labor distributions that have errors?
What are the labor hours by Project, Task, Expenditure Type, Expenditure Organization, etc.?
What are the liabilities distribution details of AP Balances?
What are the outstanding requisitions, purchase orders, and supplier invoices by project that still have commitment costs?
What are the payment terms and receipt methods associated with the transactions?
What are the period active asset unit details for particular asset categories and trend details?
What are the period-wise last active asset employee assignment details?
What are the products and services for which we have agreements?
What are the purchase order creation sources and corresponding requisition sources?
What are the reconciliation statuses and balance amounts in the most recent bank statements?
What are the return rates for suppliers?
What are the source document details for asset additions?
What are the top expense reports which are paid?
What are the top reasons for non-payment across my portfolio?
What are the total expenses by number of expense reports for employee, manager, organization, and cost centers?
What are the unreconciled external cash transactions?
What are the upcoming lease payment obligations over a selected future period?
What awards have funding unallocated to projects?
What commodities and services have been purchased, and in what volume and price?
What control budgets are defined in the system for each ledger and project?
What is contract cycle time in days for contracts?
What is count and amount of overdue payments?
What is forecasted revenue by business unit and project organization?
What is my company's carbon footprint for Scope 1, Scope 2 and Scope 3?
What is my company's carbon footprint?
What is my contract vs. off-contract spend?
What is my project margin?
What is our current net intercompany exposure between provider and receiver entities?
What is period active asset mix across various asset categories?
What is the AR account activity for the period and balance amount by business unit?
What is the Amount Changed for Change Orders in a given period?
What is the Amount Changed for Change Orders in a given period?
What is the Average Initiative creation to completion cycle time?
What is the Budget vs Actuals and Encumbrance analysis by GL Account?
What is the EAC cost and revenue of the project?
What is the ETC cost and revenue for the project?
What is the Encumbrance balance for a specific account and period?
What is the GL balance by Encumbrance type?
What is the QoQ, YoY trend for accrual bookings due for reversal in the next accounting period?
What is the accounting status of liability distributions by invoices?
What is the actual cost by GL account for a specific period?
What is the actual cost by project and task?
What is the actual cost by project class code?
What is the actual cost by project organization?
What is the actual cost by project type?
What is the actual revenue by GL account for a specific period?
What is the actual revenue by contract organization?
What is the actual revenue by contract, project, and task?
What is the actual revenue by event type and revenue category?
What is the allocated funding amount for each project of an active award?
What is the amount and quantity of assets adjusted by transaction type and GL accounts and segments?
What is the amount and quantity of assets reclassified during the period?
What is the amount consumed on the award?
What is the amount of AP expenses by each business unit?
What is the amount of Goods Received and not Invoiced for Accruals at Receipt end by BU, Inventory Org, Item Category, Supplier for a specific time frame?
What is the amount of assets revalued during past 6 quarters?
What is the amount of deferred revenue further classified by long term and short term deferred revenue?
What is the amount of discount taken vs lost?
What is the analysis around payment terms by transaction type and transaction source for the invoices processed?
What is the analysis of AR adjustments by business unit, time period, customers, GL accounts, and so on?
What is the analysis of credit memo applications by business unit, time period, customers, GL accounts, and so on?
What is the analysis of due and overdue receipts?
What is the asset mix across the various asset types CIP, capitalized, and expensed?
What is the average cost of removal per unit for retired assets?
What is the average life of asset by asset category?
What is the average number of days a strategy stays OPEN before closure?
What is the average number of days for invoices on hold and the trend for past six quarters?
What is the average number of days invoices stay in delinquent status before being cured?
What is the average supplier payment days by business unit?
What is the average supplier response time?
What is the average time available to pay off outstanding AP invoices?
What is the billing amount by contract, project, and task?
What is the breakdown of inter-company revenue vs. external revenue based on AR transaction type and transaction source?
What is the breakdown of lease payment accruals by accounting period and supplier?
What is the budget, commitment, obligation, and expenditure balances by budget account?
What is the budgeted raw and burdened cost for the project?
What is the budgeted revenue activity on a monthly or quarterly basis?
What is the budgeted revenue by business unit and project organizations?
What is the budgeted revenue by customer?
What is the budgeted revenue for the project?
What is the capitalizable and non-capitalizable costs on my project?
What is the centralized view of all procurement requests for the purchasing department?
What is the classification of transactions processed during the period by transaction type and source?
What is the closing balance by fiscal Date/Period for the Legal Entity and Bank Accounts?
What is the composition of fixed cost elements vs. variable cost elements for past two years?
What is the contract amount for external, intercompany, and interproject contract types?
What is the contribution of non-operating revenue and the trend for past quarters?
What is the cost variance from approved budget by project, task, and resources?
What is the cost variance from approved forecast by project, task, and resources?
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 distribution variances?
What is the count and amount of AP invoices on hold due to supplier site limits?
What is the count and amount of AP invoices that have either header level hold, line level hold, or a combination?
What is the count and amount of AR adjustments processed during the period?
What is the count and amount of applied receipts?
What is the count and amount of credit memo applications during the period?
What is the count and amount of invoices processed for the period by business units and trend comparison?
What is the count and amount of payments processed for the period by business units and trend comparison?
What is the count and amount of receipts processed over the period of time?
What is the count and amount of transactions processed over the period of time?
What is the count and amount of unapplied receipts?
What is the count and value of AP invoices overdue?
What is the count and value of AR invoices current?
What is the count and value of AR invoices overdue?
What is the count of Journal Batches, Headers, Lines by Journal Source, Created by, Period etc.?
What is the count of contracts and contract amounts by suppliers, business units, products?
What is the cure rate and what percentage of delinquent invoices returned to current?
What is the current AP amount out of outstanding AP amount for invoices on hold?
What is the current risk score for each delinquent account?
What is the delinquent amount by Business Unit?
What is the delinquent amount by aging bucket (1-30, 31-60, 61-90, 90+ days)?
What is the distribution of AP expenses by each of the cost centers?
What is the distribution of AP expenses by the top 10 suppliers?
What is the distribution of AP expenses by the top five natural accounts or financial categories?
What is the distribution of revenue by the top 10 customer accounts?
What is the distribution of revenue by top five revenue accounts?
What is the distribution of suppliers by product and service category?
What is the employee expense spend by business units?
What is the expense breakdown by expense type?
What is the forecasted revenue by customer?
What is the forecasted revenue for the project?
What is the fund available by control budget account and period?
What is the fund budget and consumption balances for a specific control budget in a range of periods?
What is the intercompany revenue, and interproject revenue by provider and receiver?
What is the intercompany, interproject invoice amount by provider and receiver?
What is the labor cost and effort breakup by employee and job?
What is the labor forecast for projects across the project organizations?
What is the last balance date and the associated balance for the bank accounts?
What is the monthly or quarterly expense recognized for leases by GL account or cost center?
What is the number of expenses which are filed late?
What is the number of invoices paid vs. unpaid including partly paid with amount?
What is the original and current margin of budget on the project?
What is the original and current margin of forecast on the project?
What is the outstanding AP amount for AP invoices on holds?
What is the overall net book value for PP and E assets and trend over multiple periods by entity, asset book, etc.?
What is the overdue AP amount out of outstanding AP amount for invoices on hold?
What is the pattern of bookings in tax sensitive GL accounts in comparison to revenue and cost?
What is the percentage of reports which are auto-approved?
What is the planned labor budget for projects across the project organizations?
What is the portfolio-wide average score trend over the past 12 months?
What is the projected spend percentage or burn rate?
What is the promise-to-pay compliance rate for delinquent invoices?
What is the proportion of operating profits taken up by interest and financing costs?
What is the ratio of AR adjustments applications to invoice percentage?
What is the ratio of on-time payment performance?
What is the revenue mix by geography, business units, product lines, SKU, key customers, transaction source, and transaction type?
What is the revenue mix from services, subscription fees, material installation, merchant fees, sale of goods, etc.?
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 score distribution across accounts with active strategies?
What is the score distribution across the portfolio today?
What is the score velocity and how quickly are scores changing across the portfolio?
What is the split of budgeted cost and revenue by project, task, and resources?
What is the split of budgeted receivables by entity or ledgers?
What is the split of forecasted cost and revenue by project, task, and resources?
What is the split of invoices on hold by manual holds vs. system holds?
What is the status of AR adjustments?
What is the status of CM application transactions?
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 summary of AP invoices across aging buckets, count, and value?
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 summary of asset additions/ CapEx for a particular entity, asset book, and asset category?
What is the summary of assets by original cost, salvage value, net book value by entity, category, time historic, etc.?
What is the summary of assets which have exceeded economic life or near end of life?
What is the summary of invoices (count and amount) by various hold reasons and holds by users?
What is the summary of invoices (count and amount) by various release reasons and released by user?
What is the summary of transactions by statuses?
What is the supplier registration cycle time?
What is the target revenue for the next quarter in the best case and worst case scenarios?
What is the total capitalized cost of my assets?
What is the total commitment cost by project?
What is the total expense trend for last few quarters?
What is the total funding by organization year over year?
What is the total lease liability by legal entity, business unit, or supplier?
What is the total project cost by project organization, project type, expenditure type, expenditure category, and expenditure organization?
What is the trend around operating and net margins for past two years?
What is the trend for average receipt days?
What is the trend for operating revenue for past six quarters by ledger, legal entity, billing BU, etc.?
What is the trend for profitability metrics actual vs. budget and direction of variance?
What is the trend in credit vs. cash expenses?
What is the trend of AP expenses for the past six quarters?
What is the trend of AP for last eight quarters?
What is the trend of asset retirement over a period of time in terms of cost retired or NBV retired?
What is the trend of closing balance for the bank accounts?
What is the trend of cost?
What is the trend of external transaction accounted amounts for each cost center and account by business unit and legal entity?
What is the trend of gross margins for past two years across business units?
What is the trend of intercompany transactions over time (monthly, quarterly, yearly)?
What is the trend of outstanding AP Balances at the consolidated level, supplier level, and business unit level?
What is the trend of outstanding AR Balances by customer or business unit?
What is the trend of project cost by organization, project type, etc.?
What is the trend of revenue?
What is the unposted net amount value by Journal Source, Category, GL Account, Period etc.?
What is the validation, approval, and accounting status of invoices processed during the period?
What is the working capital position and trend for past x quarters?
What is the write-off, cancellation, and concession invoice amounts?
What payroll batches have loaded recently and where did they distribute to?
What percentage of cost have been billed?
What percentage of costs have been capitalized?
What percentage of predelinquent accounts escalated to delinquent strategy?
What percentage of predelinquent accounts escalated to delinquent strategy?
What percentage of total outstanding receivables is delinquent?
What receipts are created manually or through ASNs?
What score band does each account fall into (High/Mid/Low risk)?
When were products shipped and what are the average delivery times?
Which Billing events are having Invoicing hold or revenue hold?
Which Labor schedules end in the next 3 months?
Which POs are Matched against Invoice?
Which Projects, Departments, or Employees have maximum Overtime Hours?
Which accounts have seen their score deteriorate (decrease) in the last 30 days?
Which accounts have seen their score improve in the last 30 days?
Which activities are consuming the budget?
Which agreements are under-utilized?
Which agreements are utilized before expiry?
Which are the billing events for a project or contract and contract line?
Which are the billing events which would generate revenue for the next x months?
Which are the top 10 customers with maximum AR outstanding?
Which are the top 10 suppliers with the maximum AP outstanding?
Which are the top cost centers and organizations with audit violations for expense reports which are paid?
Which are top cost centers by employee expenses?
Which assets are built and placed in service?
Which awards are currently active?
Which awards are past their end dates but weren't closed?
Which billing events are missing an event completion date?
Which cancelled, stopped, or voided payments remain unaccounted?
Which collector has the highest delinquent portfolio?
Which collectors have the most open work items today?
Which component is most commonly driving scores below the risk threshold?
Which contracts and customers are funding the project?
Which contracts are expiring in next one months by suppliers, business unit?
Which cost centers and procurement categories are contributing most to tax and freight charges?
Which cost distributions are included in an asset line?
Which customers have the highest delinquent balances?
Which delinquent invoices have unapplied receipts or on-account cash that has not yet been applied against the invoice? What is the effective delinquent balance after netting out this pending cash?
Which legal entities or business units have the highest intercompany volumes or values?
Which of the POs are accrued where the Accrual is at Receipt?
Which payment transactions are pending accounting by payment method, batch, or process request?
Which project organizations have overrun their budgets in the last quarter periods?
Which purchase orders and receipts are associated with the highest invoice charges?
Which strategy templates are assigned most frequently?
Which strategy templates have the highest work item completion rates?
Which suppliers and categories are driving the highest project and award-related expenses?
Which suppliers deliver consistently on time?
Which suppliers or bank accounts have the highest value of unaccounted payments?
Which suppliers or contracts represent the highest lease payment commitments?
Which transactions are pending approval at initiator or receiver side?
Which transactions have failed budgetary control check?
Which transactions make up the outstanding commitment or obligation balance for a selected budget period?
Who are the top 10 contract customers by invoice amount?
Who are the top managers by expenses?
Who has a labor schedule with no costs associated?
Who initiated, approved, and posted each transaction, and when?