Tools and Resources

Tools: Mechanisms for accomplishing tasks

Tools DescriptionAdditional Information
Account Analysis Pivot MacroThe macro should be used with the Account Analysis Report to filter, sort, and view transaction data by funding source.
Account Analysis Pivot Instructions
Approval Workflow Maintenance FormComplete this form to update standard approval workflow in OFC.
Standard Operating Procedure
Budget Office Pivot MacroThe macro should be used with the Account Analysis Report to filter, sort, and view remaining balance and fund balance and drill to transaction data detail.
Budget Office Pivot Instructions
Budget Transfer TemplateComplete and email template to request budget transfers.Budget Transfer Instructions
Correcting Entry RequestComplete to request corrections to invoices for Expense Reports, Requisitions, Internal Payments, and P-Card Transactions.Video Instructions
Departmental Deposit TemplateComplete and email template to request a departmental deposit. Creating and Submitting a Departmental Deposit
Detail Transaction Pivot MacroThe macro should be used with the Account Analysis Report and Salary Ledger Report to filter, sort, and view transaction data by funding source.Detail Transaction Pivot Instructions
Grant Account Analysis Pivot MacroThe macro should be used with the Account Analysis Report to filter, sort, and view transaction data by funding source. Budget data may be manually added.Grant Account Analysis Pivot Instructions
Internal Payment RequestInternal Payments are completed to charge internal funding sources for goods or services received from the University. The Department of the Internal Supplier providing the good or service must retain all documentation for charges.
Internal Payment TemplateComplete and attach to Internal Payment Request.Creating and Submitting Internal Payments
Journal Entry RequestComplete to request surplus transfers, reallocations, and corrections to transactions with no transaction number.Video Instructions
Journal Entry TemplateComplete and attach to Journal Entry RequestCreating and Submitting a Journal Correction
Multiple Correcting Entry RequestComplete to request corrections to invoices for Expense Reports, Requisitions, Internal Payments, and P-Card Transactions.Video Instructions
Multiple Correction TemplateComplete and attach to Multiple Correcting Entry Request.
Payroll Correction RequestComplete to make corrections to posted payroll expenses.Video Instructions
Payroll Correction TemplateComplete and attach to Payroll Correction Request.Creating and Submitting a Payroll Correction
Plan Ledger Pivot MacroThe macro should be used with the Account Analysis Report to filter, sort, and view transaction data by funding source. Budget data may be manually entered by accounting period and account type.
Plan Ledger Pivot Instructions
Segment Maintenance FormComplete form to add, change, or deactivate a funding source segment.Segment Maintenance Context
Standard Requisition Payment ApprovalThis form provides approval to proceed with payment against a Standard Requisition (PO; also known as “Ok to Pay”)

Resources: Reference documents or guides

ResourcesDescription
Account Analysis Report ContextProvides context for each of the columns in the Account Analysis Report.
Criteria Matching for ReportingMatch reporting criteria on the Budget vs. Actual - Strategic, Account Analysis, and Detail Balances reports in OFC.
Correcting Entry MatrixProvides a decision matrix for requesting corrections.
Frequently Used Account CodesProvides reference or look-up for expense account codes.
Hierarchies for Reporting Provides a list of segment values and the node to which they roll up in order to use in reporting for more than one funding source.
Payment Decision WizardProvides a decision matrix for making payments to employees and suppliers.
Reporting Tools MatrixDescribes reporting functionality of reports found in OFC.
Standard Approval Workflow MatrixIdentify designated approvers by department.
University Financial Services ContactsA guide to the correct department by topic/issue
All Segment ValuesLists all available funding source segment values. Each segment types differentiated by tab and includes Fund, Department, Cost Center, Account, Supplemental, and Project.

Standard Operating Procedures

Standard Operating ProceduresDescription
Accounts ReceivableDetailed end-user process and requirements for submitting invoices to record accounts receivable.
Approval WorkflowDetailed end-user process and documentation requirements to review, modify, and troubleshoot standard approval workflow.
Coding Mail ChargesDetailed end-user process and requirements to appropriately code mail with funding source segments.
Correcting Financial DataDetailed end-user process, responsible party, and documentation requirements to correct financial data in the General Ledger.
Expense ReportDetailed end-user process and documentation requirements to complete Expense Reports.
Independent ContractorDetailed end-user process and documentation requirements to request payment for an Independent Contractor.
Invoice PaymentDetailed end-user process and documentation requirements to request payment for a supplier or non-employee.
Standard RequisitionDetailed end-user process and documentation requirements to complete a Standard Requisition.
Travel AuthorizationDetailed end-user process and documentation requirements to complete Travel Authorizations.