Cost Transfers (CTs) are considered to be high risk as they can be an indication of weak Internal Controls.  To mitigate UW’s risk, a spreadsheet of select CTs is received by PAFC and distributed to the Dean’s offices for their review and distribution to the departments.

The transaction identified are those that we anticipate could be questioned in the event of an audit or other sponsor review. 

Campus is encouraged to review the data and graphs to identify trends, gaps in internal controls, training opportunities, and any other areas of concern.  Individual transaction data is provided to assist in this review.

 

  

How to Read the Cost Transfer Data Analytics Spreadsheet ELearning (Approximately 15 minutes)

Note: Data for Cost Transfers completed within the last 30 days or after the award end date, and purchases prior to the award start date is not available for the Q2 2017 report.

Data Analytics Report Filter & Indicators

While all Cost Transfers (CTs) are considered to be of some risk, the CT Data Analytics report filters the Cost Transfer transactions to identify those that may be of particularly high risk.  A list of the specific filters and calculations added is described below:

Filters Applied:

Where the expense is being moved onto a Federally-sponsored Award.  Federal regulations typically are more restrictive and are subject to more scrutiny than other sponsors.  The Originating budget (Orig or where the expense is being moved from) line of the transaction is only included in the report if the Orig line is also a federally-sponsored Award.

Where the Budget Number is different on the Orig (from budget) and the To (budget the expense is moved onto) side of the transaction.  A change in Budget Number means that the expense is being moved from one funding source to another and raises the concern that the expense meets all four Cost Principles for the Award that the expense is being moved onto.

Where the value of the expense being moved is equal to or greater than $100.

Where the expense is NOT being moved between a Parent and Sub-Budget or between Sub-Budgets with the same Parent.

Indicators Applied:

The following indicator was added to the report to highlight those high risk transactions.   All calculations use the Total Period Start/End date of the Award, rather than the Budget Period Start/End date as the risk factor is higher.

CTs completed more than 120 days from when the expense was originally posted (Calculation: Count of days from Original Posting to Date of Cost Transfer posting):   The first pivot table lists the To (budget the expense was moved onto) side of the transaction.  The second pivot table shows CTs where the expense has been moved 120+ days from (originating) a Federal Award onto another Award. 

 

Cost Transfer Report (Spreadsheet) Information

Click on an icon below:

 

Data Tab                                                       Report Columns

 

Volume Tab                                                       120+ Tab