- Overview
- 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 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 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 Receipts are Accrued by BU, Inventory Org, Item Category, Supplier, PO for
a specific time frame?
- 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 documents have more than two Change Orders?
- How many documents have more than two Change Orders?
- How many journal batches, headers, lines are unposted?
- 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 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 much did the organization spend with suppliers, commodities, buyers, cost center,
contracts versus non contracts and leakage?
- 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 revenue has been recognized for the project contract?
- 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?
- 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 statement amounts for each back account in a given time period?
What are the Payments and Deposits?
- 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 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 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 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 total expenses by number of expense reports for employee, manager, organization,
and cost centers?
- 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 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 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 for invoices on hold and the trend for past six
quarters?
- What is the average supplier payment days by business unit?
- 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 current AP amount out of outstanding AP amount for invoices on hold?
- 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 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 projected spend percentage or burn rate?
- 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 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 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 gross margins for past two years across business units?
- 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 receipts are created manually or through ASNs?
- When were products shipped and what are the average delivery times?
- Which Labor schedules end in the next 3 months?
- Which POs are Matched against Invoice?
- Which activities are consuming the budget?
- Which agreements are under-utilized?
- Which agreements are utilized before expiry?
- 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 contracts and customers are funding the project?
- Which contracts are expiring in next one months by suppliers, business unit?
- Which cost distributions are included in an asset line?
- Which of the POs are accrued where the Accrual is at Receipt?
- Which project organizations have overrun their budgets in the last quarter periods?
- Which suppliers deliver consistently on time?
- Which suppliers or contracts represent the highest lease payment commitments?
- 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?
Copyright © 2019, 2025, Oracle and/or its affiliates.