Tools and Resources

Tools: Mechanisms for accomplishing tasks

Tools	Description	Additional Information
Account Analysis Pivot Macro	The 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 Form	Complete this form to update standard approval workflow in OFC.	Standard Operating Procedure
Budget Office Pivot Macro	The 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 Template	Complete and email template to request budget transfers.	Budget Transfer Instructions
Correcting Entry Request	Complete to request corrections to invoices for Expense Reports, Requisitions, Internal Payments, and P-Card Transactions.	Video Instructions
Departmental Deposit Template	Complete and email template to request a departmental deposit.	Creating and Submitting a Departmental Deposit
Detail Transaction Pivot Macro	The 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 Macro	The 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 Request	Internal 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 Template	Complete and attach to Internal Payment Request.	Creating and Submitting Internal Payments
Journal Entry Request	Complete to request surplus transfers, reallocations, and corrections to transactions with no transaction number.	Video Instructions
Journal Entry Template	Complete and attach to Journal Entry Request	Creating and Submitting a Journal Correction
Multiple Correcting Entry Request	Complete to request corrections to invoices for Expense Reports, Requisitions, Internal Payments, and P-Card Transactions.	Video Instructions
Multiple Correction Template	Complete and attach to Multiple Correcting Entry Request.
Payroll Correction Request	Complete to make corrections to posted payroll expenses.	Video Instructions
Payroll Correction Template	Complete and attach to Payroll Correction Request.	Creating and Submitting a Payroll Correction
Plan Ledger Pivot Macro	The 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 Form	Complete form to add, change, or deactivate a funding source segment.	Segment Maintenance Context
Standard Requisition Payment Approval	This form provides approval to proceed with payment against a Standard Requisition (PO; also known as “Ok to Pay”)

Resources: Reference documents or guides

Resources	Description
Account Analysis Report Context	Provides context for each of the columns in the Account Analysis Report.
Criteria Matching for Reporting	Match reporting criteria on the Budget vs. Actual - Strategic, Account Analysis, and Detail Balances reports in OFC.
Correcting Entry Matrix	Provides a decision matrix for requesting corrections.
Frequently Used Account Codes	Provides 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 Wizard	Provides a decision matrix for making payments to employees and suppliers.
Reporting Tools Matrix	Describes reporting functionality of reports found in OFC.
Standard Approval Workflow Matrix	Identify designated approvers by department.
University Financial Services Contacts	A guide to the correct department by topic/issue
All Segment Values	Lists 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 Procedures	Description
Accounts Receivable	Detailed end-user process and requirements for submitting invoices to record accounts receivable.
Approval Workflow	Detailed end-user process and documentation requirements to review, modify, and troubleshoot standard approval workflow.
Coding Mail Charges	Detailed end-user process and requirements to appropriately code mail with funding source segments.
Correcting Financial Data	Detailed end-user process, responsible party, and documentation requirements to correct financial data in the General Ledger.
Expense Report	Detailed end-user process and documentation requirements to complete Expense Reports.
Independent Contractor	Detailed end-user process and documentation requirements to request payment for an Independent Contractor.
Invoice Payment	Detailed end-user process and documentation requirements to request payment for a supplier or non-employee.
Standard Requisition	Detailed end-user process and documentation requirements to complete a Standard Requisition.
Travel Authorization	Detailed end-user process and documentation requirements to complete Travel Authorizations.