Purpose
The following guide is intended for employees who are looking to view or complete any of the following actions:
- View Internal Billing Invoice information, answer business questions, export a base report to Excel for detailed analysis.
Terminology
Calendar Month Accounting Date: A code that represents the year and month of the Accounting Date. The year is first, followed by the month (202309 represents Sept 2023 business).
Invoice Number: Can be numeric or alphanumeric and uniquely identifies the invoice.
Invoice Date: Date when goods/services were provided or when invoice was created.
Validation Status:
- Canceled: Invoice was Canceled.
- Needs Revalidation: Error was found during Validation.
- Validated: Invoice is ready for Approval Workflow.
Invoice Source Name: Who/what created the Invoice.
Approval Status:
- Initiated: Approval Workflow has been Initiated
- Manually Approved: Invoice was Force Approved
- Rejected: Invoice was Rejected
- Required: Invoice has been Saved or Validated
- Workflow Approved: Invoice was Approved by Workflow or Approver
- Not Required: Invoice was Canceled.
Accounting Year: University of Chicago's Fiscal Year
Accounting Date: Date transaction falls in the selected accounting period (For example, an invoice created February 1st for January business would have an accounting date between January 1 and January 31).
Business Questions
What are the invoices by a specified supplier?
-
- Utilize the Supplier filter by selecting a specified supplier and clicking Apply.
- View the table.
What are the invoices by project?
-
- Utilize the Project Number or Project Name filter by selecting a specified value and clicking Apply
- Can also utilize Task Number, Expenditure Type, and Expenditure Organization
- View the table
Who created the invoice?
-
- Utilize the filters to narrow the table to a specified invoice
- View the Invoice Created By column in the table
What is the invoice status?
-
- Utilize the filters to narrow the table to a specified invoice
- View the Validation Status column in the table
What are the transactions by Fund?
-
- Run the report and export to Excel to analyze all transactions for a particular Fund (I.e. recharge)
Added Functionality
When exporting the Internal Billing report, if you export the report as CSV Data it comes with COA Codes to allow extended filtering for the user.
Report Preview
