Contents
1 Introduction
2 Subject Areas
- Overview
- Budgetary Control - Balances Real Time
- Budgetary Control - Transactions Real Time
- Cash Management - Bank Statement Balances Real Time
- Cash Management - Bank Statement Line Charges Real Time
- Cash Management - Bank Statements Real Time
- Cash Management - External Cash Transactions Real Time
- Expenses - Cash Advances Real Time
- Expenses - Employee Expense Overview Real Time
- Expenses - Expense Transactions Real Time
- Financials Common Module - Intercompany Transactions Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Transactions Real Time
- General Ledger - Average Daily Balances Real Time
- General Ledger - Balances Real Time
- General Ledger - Journals Real Time
- General Ledger - Period Status Real Time
- General Ledger - Transactional Average Daily Balances Real Time
- General Ledger - Transactional Balances Real Time
- Joint Venture Management - Joint Venture Transactions Real Time
- OTBI Performance Real Time
- OTBI Usage Real Time
- Payables Invoices - Installments Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Invoices - Trial Balance Real Time
- Payables Invoices - Withholding Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Credit Memo Requests Real Time
- Receivables - Customer Account Site Tax Profile Real Time
- Receivables - Customer Real Time
- Receivables - Customer Tax Profile Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Payment Schedules Real Time
- Receivables - Receipt Conversion Rate Adjustments Real Time
- Receivables - Receipts Details Real Time
- Receivables - Revenue Adjustments Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Revenue Management - Customer Contracts Real Time
- Revenue Management - Standalone Selling Price Real Time
- Security - Audit Real Time
- Security - Roles and Privileges Real Time
- Subledger Accounting - Journals Real Time
- Subledger Accounting - Payables Summary Reconciliation Real Time
- Subledger Accounting - Receivables Summary Reconciliation Real Time
- Subledger Accounting - Supporting References Real Time
3 Business Questions
- Overview
- For each budget account within a control budget, which transactions had funds checked or reserved for a selected budget date range?
- Have automatic receipts been approved?
- How are exemptions handled for customer account sites?
- How are exemptions handled for each customer?
- How do expenses for the current period compare to the previous period in my organization?
- How long is the standalone selling price effective for?
- How many billing sites belong to each customer account?
- How much has been billed on the contract?
- How much revenue has been recognized for a contract?
- How much revenue will be recognized next month?
- Is the tax registration information for customer account sites accurate?
- What adjustments are against which transactions?
- What approval actions are applied to an invoice?
- What are all the transactions performed on selected assets?
- What are the assets reinstated during a specified period?
- What are the bank statement amounts for each back account in a given time period?
- What are the characteristics (control level, status, source budget type, etc.) of the control budget?
- What are the details for a payment including banking details and invoices paid?
- What are the details for an invoice including related purchase order, amounts, and payment details?
- What are the entered external cash transactions that are more than x dollars for a specified cost center and date range for a bank account?
- What are the expense amounts for each expense category in my organization?
- What are the external cash transactions that are recorded on a specific date for each bank account?
- What are the invoice details of the invoices which are unpaid or partially paid that Payables transferred to general ledger as of a particular date?
- What are the journal entered and accounted amounts for a given account and period?
- What are the late charge settings for customers with the DEFAULT customer profile class assigned?
- What are the most common reasons for credit memos?
- What are the most prevalent reversal reasons that may indicate a process improvement is needed?
- What are the most violated policies for the top violators in my organization?
- What are the payables and accounting beginning and ending balances for the period?
- What are the period statuses for a given set of ledgers?
- What are the receivable and accounting beginning and ending balances for the period?
- What are the reconciliation statuses and balance amounts in the most recent bank statements?
- What are the reconciliation statuses of all the lines in the most recent bank statements?
- What are the taxes and surcharges paid from the bank accounts for a range of dates?
- What are the transaction details that make up the summary view for payables and accounted amounts in the summary report?
- What are the transaction details that make up the summary view for receivable and accounted amounts in the summary report?
- What are the trial balance details for secondary ledger or reporting currency ledger?
- What are the trial balance details for suppliers with negative balances only?
- What are the void payments for a bank, bank branch, and bank account?
- What are the year-to-date depreciation amounts for all assets in an asset book?
- What assets are currently operational in a particular department and what is their current cost, net book value, and accumulated depreciation reserve?
- What assets have a book value within a specified dollar value range?
- What assets have been retired this past month with sale proceeds above a specified dollar amount?
- What assets have been transferred from one location or cost center to another during a given period?
- What Contract Identification Rule was used to identify and create the contract?
- What contracts are pending revenue recognition?
- What contracts have been revised due to variable consideration estimate correction or contract modification?
- What control budgets are defined in the system for each ledger and project?
- What credit memo requests were approved for the period by business unit?
- What customer accounts were updated this month?
- What external cash transactions have hit natural account this month?
- What external cash transactions were recorded in each legal entity last month?
- What intercompany transactions are awaiting approval?
- What intercompany transactions created invoices?
- What intercompany transactions were approved during a particular period?
- What intercompany transactions were entered during a particular period between two given legal entities?
- What invoices have I received for a given asset during the current year?
- What invoices were included in this payment?
- What is my total receipt amount by currency and remittance bank account?
- What is the account balance for a given account and cost center for a given period?
- What is the account balance for a given account for a given period and the journals that contribute to the balance in the period?
- What is the account balance for a period broken down by supporting reference values?
- What is the accounted amount by bank for receipts for the period by business unit?
- What is the age of the available prepayments so that older prepayments can be applied to new standard invoices from that supplier?
- What is the amount and count of miscellaneous receipts for the period by business unit, bank account name, and bank account number?
- What is the amount and count of miscellaneous receipts for the period by business unit, general ledger account, and cost center?
- What is the amount of open bills receivable pending acceptance for the period by business unit?
- What is the amount of open bills receivable pending remittance for the period by business unit?
- What is the bank statement balance for each bank account in a given time period?
- What is the cost account balance for a specific asset or asset book or period?
- What is the cost of removal of a retired asset?
- What is the count of intercompany transactions between each pair of legal entities?
- What is the coverage period used to derive the standalone selling price?
- What is the depreciation expense amount for all the assets with a specified asset category that have been depreciated in a particular cost center?
- What is the differences between payables transactional amount and accounted amount, and how to resolve or reconcile the differences?
- What is the differences between receivable transactional amount and accounted amount, and how to resolve or reconcile the differences?
- What is the ending balance for an asset by verifying the activities that happened in a period?
- What is the exchange gain and loss due to exchange rate conversions?
- What is the financial history for a given asset?
- What is the justification given for a particular expense line item?
- What is the list of customers for a given state or province?
- What is the most common reason for an adjustment?
- What is the organization's outstanding contract liability as of today?
- What is the original amount due, remaining amount due by business unit, by customer, and by due date?
- What is the outstanding commitment or obligation balance for a selected budget period?
- What is the payment schedule for installment invoices over time?
- What is the potential discount lost if such invoices are paid late?
- What is the reserve account balance for a specific asset or asset book or period?
- What is the satisfaction plan for a performance obligation?
- What is the standalone selling price profile for an item?
- What is the status of credit requests?
- What is the total amount of all transactions for the period by business unit?
- What is the total amount of credits that is still open, by supplier?
- What is the total amount of receipt applications for the period by business unit?
- What is the total amount of revenue adjustments by item and time period?
- What is the total amount of tax withheld by a supplier?
- What is the total amount of transactions for a specific customer?
- What is the total amount paid, by currency?
- What is the total amount paid, by disbursement bank account?
- What is the total amount paid, by supplier, for a particular period?
- What is the total available prepayments for a particular supplier or business unit?
- What is the total count of customers by receipt method?
- What is the total depreciation since the beginning of the asset's life?
- What is the total of all adjustments for the period, by business unit?
- What is the total of all adjustments for the period?
- What is the total of all unpaid and partially paid invoices that Payables transferred to the General Ledger as of particular date with totals grouped by liability account, supplier, and ledger?
- What is the total record cost and depreciated value of an asset during a specified time period?
- What is the total unpaid invoice amount, by supplier, for a particular time period?
- What journals were created for a given account by source for this period?
- What journals were created for a given period and category?
- What journals were created for a given period for a given account?
- What payables invoices for a given supplier have contributed to a given account balance for a given period?
- What payments were not reconciled yet?
- What Performance Obligation Identification Rule was used to identify and create the performance obligation?
- What portion of transactions is made up of invoices, credit memos, chargeback, or debit memos?
- What project costing transactions have contributed to a given account for a given period?
- What receipts are not applied during the period by business unit?
- What receipts were applied to other receipts allowing the combined balance to be applied to invoices?
- What receipts were reversed for a specific remittance bank over a range of reversal dates?
- What receivables invoices for a given customer have contributed to a given account balance for a given period?
- What standalone sales were used to derive the standalone selling price for an item in a given effective period?
- What standalone selling prices are not yet established?
- What tax registration information has been established for customer account sites?
- What tax registration information has been established for customer?
- What tax registrations exist for the account sites of a customer?
- What tax validations exist for a group of customers?
- What is the status of the open credit memo requests for the period by business unit?
- What is the total amount of open credit memo requests for the period by business unit?
- What transactions were my credit memos applied to for the period by Business unit?
- What types of credit are most frequently requested?
- What types of credit are generated most often by customers?
- What unapproved journals exist for a given period?
- What unposted journals exist for a given period?
- What vendor invoices were charged to a cost center for an asset?
- What was the volume of credit card refunds and chargebacks for the period?
- When are receipts cleared?
- When was the payment cleared?
- When were confirmed receipts remitted?
- Which adjustments require investigation or rejection?
- Which are the prepayments already applied for a invoice and needs to be unapplied?
- Which are the prepayments available to be applied for a particular standard invoice?
- Which assets have a remaining life that is less than one year from today?
- Which cost centers are my top spenders?
- Which customers generate the most credit memos?
- Which employees contribute to the majority of the expenses in my organization?
- Which expense reports are more than two weeks old and have not been approved?
- Which invoices are currently on hold and are preventing period close?
- Which invoices are currently pending approval?
- Which invoices or invoice lines are placed on hold?
- Which invoices for a particular business unit, supplier, and supplier site have a specified approval status?
- Which invoices have been disputed?
- Which invoices pending approval or validation are at risk of late payment?
- Which merchants did we spend the money on?
- Which miscellaneous receipts from previous months were reversed this month?
- Which payments for this supplier have not cleared?
- Which receipts are posted to the customer's account but not applied to invoices?
- Which receipts do not have the customer identified?
- Which receipts had earned or unearned discounts and how much for each?
- Which sub ledger journals have posted accounting entries to a given account balance for this period?
- Which suppliers have invoices frequently put on a particular hold?
- Which transactions affect the customer open balance for collections purposes, but not the general ledger account balance?
- Which transactions make up the outstanding commitment or obligation balance for a selected budget period?
- For each customer, who are the contacts, their roles, and email addresses?
- Who are the top expense violators?
- Who are the top spenders?
- Who is the budget manager for the control budget?
- Who are requesting cash advances above the company limit?
- How many cash advances are open per employee?
- What is the average number of days that employees are taking to apply cash advances?
- How are cash advances trending?
- What is the cash advance status?
- What does the advance history look like, who has taken action and what are the action dates?
- What are the payment information?
- Which are the business units with the highest cash advance amount?
- Who requested a cash advance?
- How many users run OTBI analyses?
- Who are the top N OTBI users?
- What is the weekly OTBI analysis usage trend?
- What are the top N most frequently-run OTBI analyses?
- How many predefined OTBI analyses have been run in the past month?
- How many custom OTBI analyses have been run in the past month?
- How many ad-hoc OTBI analyses have been run in the past month?
- What is the execution history of dashboard X in the past month?
- Which analyses have low usage in the past month?
- How many OTBI SOAP web services have been run in the past month?
- What are the long-running analyses in the past month?
- What is the OTBI execution time histogram in the past month?
- Which analyses have the longest response time?
- Which analyses have high data row count?
- Which analyses reached OTBI max row limit?
- What are the common execution errors in the past month?
- How many analyses and dashboards failed in the past month?
- What are the most commonly used OTBI subject areas?
- What are the least-used OTBI subject areas?
- Which subject areas have slow performance?
- Which subject areas have large data volume?
- Which analyses have low usage because of poor performance?
- What is the database SQL execution time and row count?
- Why am I not able to view certain subject areas with my login credentials?
- Which data security policy would provide access to the data I need to see?
- Can I view and edit a particular page? If yes, which functional security policy do I need to provide to a user who needs similar access?
- I have not added a specific role to a user, but the user seem to have this job role. Can I trace how has this been inherited by the user?
- What are all the data security privileges that a specific user added?
- Which roles were added with a specific functional security policy, and who added them?
- What is the average daily balance for a given account and cost center for a given period ?
- What is the average daily balance for a given account for a given period and the journals that contribute to the balance in the period?
- What is the total amount by account and period of the transactions that will be processed for a joint venture?
- What is the total amount by period that was processed for a joint venture?
- What are the joint venture transactions that are on hold for a joint venture?
- What are the joint venture transactions that are awaiting payment for a joint venture?
- What is the total amount of transactions since the inception of the joint venture by account?
- What is the total distribution amount by stakeholder that was processed for a joint venture?
- What is the total distribution amount covered or not covered by a partner contribution by stakeholder?
4 Job Roles
- Overview
- Accounts Payable Invoice Supervisor
- Accounts Payable Manager
- Accounts Payable Payment Supervisor
- Accounts Payable Specialist
- Accounts Payable Supervisor
- Accounts Receivable Manager
- Accounts Receivable Manager Segregated Role
- Accounts Receivable Specialist
- Accounts Receivable Specialist Segregated Role
- Advanced Revenue Analyst
- Advanced Revenue Manager
- Application Implementation Consultant
- Asset Accountant
- Asset Accounting Manager
- Billing Manager Segregated Role
- Billing Specialist Segregated Role
- Budget Manager
- Cash Management Self Service Reporting Duty
- Cash Manager
- Expense Manager
- Federal Year-End Close Manager
- Financial Analyst
- Fixed Asset Self Service Reporting Duty
- General Accountant
- General Accounting Manager
- General Ledger Self Service Reporting Duty
- Grants Accountant
- Grants Administrator
- Grants Department Administrator
- IT Security Manager
- Intercompany Accountant
- Intercompany Transactions Entry
- Joint Venture Accountant
- Joint Venture Accounting Manager
- Joint Venture Application Administrator
- Obsolete: Treasury Accountant
- Obsolete: Treasury Analyst
- Payables Self Service Reporting Duty
- Principal Investigator
- Project Accountant
- Project Administrator
- Project Billing Specialist
- Project Manager
- Receivables Self Service Reporting Duty
- Revenue Management Self Service Reporting Duty
5 Duty Roles
- Overview
- Budgetary Control Analysis Duty
- Cash Management Transaction Analysis Duty
- Expense Transactions Transaction Analysis Duty
- Expenses Summary Transaction Analysis Duty
- Fixed Asset Transaction Analysis Duty
- Fixed Depreciation Transaction Analysis Duty
- General Ledger Transaction Analysis Duty
- Grants Management Transaction Analysis Duty
- Inter Company Transaction Analysis Duty
- Joint Venture Transaction Analysis Duty
- OTBI Report Performance Transactional Analysis Duty
- OTBI Report Usage Transactional Analysis Duty
- Payables Invoice Transaction Analysis Duty
- Payables Payment Transaction Analysis Duty
- Payables to Ledger Reconciliation Transaction Analysis Duty
- Project Contract Invoice Transaction Analysis Duty
- Project Costing Transaction Analysis Duty
- Project Journals Transaction Analysis Duty
- Receivables Customer Transaction Analysis Duty
- Receivables Receipts Transaction Analysis Duty
- Receivables Revenue Adjustments Transaction Analysis Duty
- Receivables Transaction Analysis Duty
- Receivables to Ledger Reconciliation Transaction Analysis Duty
- Revenue Management Administration Duty
- Security Transaction Analysis Duty
- Subledger Accounting Transaction Analysis Duty