New Hyperion Report: Credit Split and Indirect Cost Detail Report
July 6, 2016
The Finance Competency Center has developed a new Hyperion report entitled “Credit Split and Indirect Cost Detail” to assist the University research community in analyzing indirect costs. The new report has seven sub-reports which can all be exported to Excel. The report can be accessed in Hyperion in the Research Community Folder and is titled “Credit Split and Indirect Cost Detail”. If you need access to Hyperion, please send an email to email@example.com.
Report Layout Information
The credit split section of this report provides four separate sub-reports and is based on real-time information that is housed in Banner, not the fiscal year and period selected in the prompts on the dashboard. The first sub-report, “Credit Split Detail”, provides the detail with grant, fund and org codes, grant, fund and org titles, principal investigator first and last name and user id, credit split percentage, and effective begin and end dates of the credit split. The second sub-report, “Credit Split Summary by Grant and Fund”, is a pivot table based on the detailed credit split information by grant and fund code. The third sub-report, “Credit Split Summary by Principal Investigator”, is also a pivot table and provides the detailed credit split information by principal investigator.
The indirect cost section of the new report provides a detail and a summary report, as well as two pivot tables combining credit split information with indirect cost information. This report is based on the fiscal year and period that is selected in the dashboard prompts. The “Indirect Costs Detail” report lists on the left side of the report the indirect cost document code and its corresponding grant, fund, org, account, program, amount and transaction date. On the right hand side of the report is the original document code, original grant, fund, org, account and program, original (direct cost) amount, fiscal year and period. The “Indirect Costs Summary” provides the total of the indirect costs by grant and fund by period. This report should assist in validating the corresponding direct costs related to the indirect costs that post to your award each evening via a “K” document code. The “Indirects Totals by Credit Split” provides a summary of the indirect costs by fund and principal investigator with the split percentage for the time period selected in the prompts from the dashboard. Finally, the “Indirects Totals By Credit Split and PI” provides the total indirect costs by principal investigator and includes the credit split percentage.
Department administrators should use the information in the credit split reports to validate their current credit splits and generate journal entries to allocate credit split earnings. If there are any errors identified in your review of the credit splits or changes that are needed for a future time period, these items should be reported to firstname.lastname@example.org. Remember, changes to credit splits are effective the first day of the following month they are reported to Research Accounting Services (RAS). Therefore, if you report a credit split change on July 5, 2016, that change will be effective August 1, 2016. RAS will then update the indirect cost distribution code and attribute codes in Banner, effective the first of the following month. Credit split changes should be submitted as early as possible in any month, but any items received after the 25th of the month will not be guaranteed to be effective the first of the following month.
If you have any questions concerning this report, please contact email@example.com.