How to Process Cost Share Transactions

Use these step-by-step instructions to process transactions in the Cost Share Tracking System (CSTS).

Only Awards that have been identified as having "cost sharing" will appear in the Cost Share Tracking system. If you are unable to locate a UC Fund in the Cost Share Tracking system, contact the Extramural Fund Manager and ask to have the cost share indicator on the Award set to yes.

At least one expense account must be active (no expiration date) to access the fund in the Cost Share Tracking system. If the award has ended and the account has been expired, remove the expiration date to process cost share entries, then put the expiration date back when the cost share reporting is complete.

Instructions on the Effort Commitment system are available here.

Additional information on system use is available in the Best Practices section.

What to do/When How to do it

1 Determine that an Award (UC Fund) must report Cost Sharing.

Award set-up

An automated e-mail will be sent to the fiscal officer and project director when Extramural Funds Accounting has set up the UC Fund for cost sharing. Review the information in the e-mail carefully.

2 Log into the system.

Award set-up

Monthly during the life of the award

Close-out

Access CSTS via the DaFIS Decision Support menu by clicking on the FIS Web Applications link.
Note: Access is restricted to project director, fiscal officer, account delegate(s), and account associate assigned to cost-shared Awards. The KFS Account document can be used to make changes to the project director, fiscal officer, and account associate assigned to an account. Account delegates can be changed on the KFS Account Delegate document.

3 Set up Cost Share Tracking Entries.

Award set-up

As needed during the life of the award

From the FIS Web Applications menu, click on the Cost Share Tracking link then the Manage Cost Share Entries link.

Select your UC Fund from the OP Fund drop-down menu in the upper left of the screen.

The Manage Cost Share Entries (Tracking Entry Summary) screen is used to manage cost share commitments and pull transactions from the general ledger into the cost share system. Click on the appropriate link to add entries for committed effort (Salaries and Wages), Equipment, and Supplies/Travel. Fields with red asterisks are required. More than one account can be specified for the different categories (i.e., Salaries and Wages, Equipment, etc) by creating multiple entries.

Note: Only non-federal funded accounts can provide cost shared contributions in the Cost Share Tracking System. Cost shared expenses must be incurred during the performance period.
Note: For payroll periods after June 2011, the Cost Share Tracking system will no longer be used for tracking payroll cost share, as we will soon transition to tracking cost share in KFS. From July 2011 until the cost share process in KFS is available, contact Debra Henn for help reporting cost shared payroll. All other expenses can be cost shared in CSTS as usual.

In this interim period,

Continue to set up non-payroll tracking entries in CSTS and process as usual.

Continue to set up payroll tracking entries in CSTS for pass-through to the Effort Reporting System (ERS).

Contributions from entities outside of UCD, such as volunteer equipment, supplies, or time should be documented by clicking on the Manage 3rd Party Contributions link, available from the main CSTS menu. The value of 3rd party contributions should be properly documented in writing. Review OMB Circular A-110 requirements concerning 3rd party contributions.

4 Import, Review and Approve Transactions for Cost Sharing

Award set-up

At close-out if needed

If there are payroll transactions existing in PPS (prior to July 2011) or non-payroll transactions in the KFS ledgers at the time the Cost Share Tracking entry is created or changed, it is necessary to perform a Retroactive Transaction Import. From the Cost Share Tracking menu, click on the Retroactive Transaction Import link.

Select your UC Fund from the drop-down menu.

Select a tracking entry to look for matching transactions in the PPS or KFS ledgers. The Retroactive Transaction Import must be performed for EACH tracking entry.

Enter a fiscal period range to indicate which ledger months should be searched for transactions that match the tracking entry (usually the award start date through the current period).

After running the query, click the Processing Complete link to jump to the Imported Transaction Review page.
Review the resulting transactions and determine whether each transaction is appropriate for cost sharing on the fund. Refer to the Requirements for Cost Sharing Allowability.

Click Approve or Reject for each transaction that imported. Click the Reject Viewable Transactions link if you want none of the transactions displayed to be cost shared. Only approved transactions will appear on the cost share contribution report.

5 Imported Transaction Approval

Monthly during the life of the award

Monthly throughout the life of the project, CSTS automatically imports non-payroll transactions that match the Cost Share Tracking Entries set up in step 3.

Review the imported transactions monthly by selecting the UC Fund then the Imported Transaction Approval screen from the menu.

Determine whether each transaction is appropriate for cost sharing on the fund. Refer to the requirements for Cost Sharing allowability.

Click Approve or Reject for each transaction that imported. You may also click on Reject Viewable Transactions link if you want none of the given transactions to be cost shared. Only approved transactions will appear on the cost share contribution report.

6 Review Approved Transactions

As needed during the life of the award to ensure commitments will be met

Close-out

From the Cost Share Tracking main menu, click Approved Transaction Review.

Select your UC Fund from the drop-down menu.

The entries are separated into 2 categories: GL transactions and Payroll transactions. Review the transactions as needed and before generating a Contribution Report.

Note: Click on document numbers to drill down to the ledger for more information on a transaction.
Note: Transactions that were previously approved may be deleted by clicking the Remove link if they are found to be unallowable or not needed.

7 Generate Cost Sharing Contribution Report

As needed for cost share reporting during the award period

Close-out

From the Cost Share Tracking main menu, click on Contribution Report.

Select your UC Fund from the drop-down menu.

Choose which type of report you wish to generate. The Summary report will only give "totals" for each tracking entry; the Detail report will show each individual transaction that was approved for cost sharing.

Run the Cost Sharing Contribution Report.

Always round up the total amount of cost share commitments. It must be demonstrated to our sponsors that we met or exceeded the amount of cost sharing committed.

Report must be signed by the project director if reporting to the sponsor is required. Send reports to the appropriate fund manager in Extramural Funds Accounting (EFA)

Note: The cost share contribution report is used to demonstrate to the sponsoring agency that committed cost share commitments were met. It provides documentation for identification of cost shared direct costs when Facilities and Administration (F&A) proposals are prepared, as it is necessary to include cost shared direct costs in organized research base.

8 Close out UC Fund

Close-out, but only AFTER the cost share reporting is finalized.

EFA will close cost sharing for the UC Fund which makes all entries read-only.

When the last expense account for the UC Fund is expired, the fund will no longer be accessible in CSTS.

Back to Effort Commitment & Cost Sharing Help Index

	What to do/When	How to do it
1	Determine that an Award (UC Fund) must report Cost Sharing. Award set-up	An automated e-mail will be sent to the fiscal officer and project director when Extramural Funds Accounting has set up the UC Fund for cost sharing. Review the information in the e-mail carefully.
2	Log into the system. Award set-up Monthly during the life of the award Close-out	Access CSTS via the DaFIS Decision Support menu by clicking on the FIS Web Applications link. Note: Access is restricted to project director, fiscal officer, account delegate(s), and account associate assigned to cost-shared Awards. The KFS Account document can be used to make changes to the project director, fiscal officer, and account associate assigned to an account. Account delegates can be changed on the KFS Account Delegate document.
3	Set up Cost Share Tracking Entries. Award set-up As needed during the life of the award	From the FIS Web Applications menu, click on the Cost Share Tracking link then the Manage Cost Share Entries link. Select your UC Fund from the OP Fund drop-down menu in the upper left of the screen. The Manage Cost Share Entries (Tracking Entry Summary) screen is used to manage cost share commitments and pull transactions from the general ledger into the cost share system. Click on the appropriate link to add entries for committed effort (Salaries and Wages), Equipment, and Supplies/Travel. Fields with red asterisks are required. More than one account can be specified for the different categories (i.e., Salaries and Wages, Equipment, etc) by creating multiple entries. Note: Only non-federal funded accounts can provide cost shared contributions in the Cost Share Tracking System. Cost shared expenses must be incurred during the performance period. Note: For payroll periods after June 2011, the Cost Share Tracking system will no longer be used for tracking payroll cost share, as we will soon transition to tracking cost share in KFS. From July 2011 until the cost share process in KFS is available, contact Debra Henn for help reporting cost shared payroll. All other expenses can be cost shared in CSTS as usual. In this interim period, Continue to set up non-payroll tracking entries in CSTS and process as usual. Continue to set up payroll tracking entries in CSTS for pass-through to the Effort Reporting System (ERS). Contributions from entities outside of UCD, such as volunteer equipment, supplies, or time should be documented by clicking on the Manage 3rd Party Contributions link, available from the main CSTS menu. The value of 3rd party contributions should be properly documented in writing. Review OMB Circular A-110 requirements concerning 3rd party contributions.
4	Import, Review and Approve Transactions for Cost Sharing Award set-up At close-out if needed	If there are payroll transactions existing in PPS (prior to July 2011) or non-payroll transactions in the KFS ledgers at the time the Cost Share Tracking entry is created or changed, it is necessary to perform a Retroactive Transaction Import. From the Cost Share Tracking menu, click on the Retroactive Transaction Import link. Select your UC Fund from the drop-down menu. Select a tracking entry to look for matching transactions in the PPS or KFS ledgers. The Retroactive Transaction Import must be performed for EACH tracking entry. Enter a fiscal period range to indicate which ledger months should be searched for transactions that match the tracking entry (usually the award start date through the current period). After running the query, click the Processing Complete link to jump to the Imported Transaction Review page. Review the resulting transactions and determine whether each transaction is appropriate for cost sharing on the fund. Refer to the Requirements for Cost Sharing Allowability. Click Approve or Reject for each transaction that imported. Click the Reject Viewable Transactions link if you want none of the transactions displayed to be cost shared. Only approved transactions will appear on the cost share contribution report.
5	Imported Transaction Approval Monthly during the life of the award	Monthly throughout the life of the project, CSTS automatically imports non-payroll transactions that match the Cost Share Tracking Entries set up in step 3. Review the imported transactions monthly by selecting the UC Fund then the Imported Transaction Approval screen from the menu. Determine whether each transaction is appropriate for cost sharing on the fund. Refer to the requirements for Cost Sharing allowability. Click Approve or Reject for each transaction that imported. You may also click on Reject Viewable Transactions link if you want none of the given transactions to be cost shared. Only approved transactions will appear on the cost share contribution report.
6	Review Approved Transactions As needed during the life of the award to ensure commitments will be met Close-out	From the Cost Share Tracking main menu, click Approved Transaction Review. Select your UC Fund from the drop-down menu. The entries are separated into 2 categories: GL transactions and Payroll transactions. Review the transactions as needed and before generating a Contribution Report. Note: Click on document numbers to drill down to the ledger for more information on a transaction. Note: Transactions that were previously approved may be deleted by clicking the Remove link if they are found to be unallowable or not needed.
7	Generate Cost Sharing Contribution Report As needed for cost share reporting during the award period Close-out	From the Cost Share Tracking main menu, click on Contribution Report. Select your UC Fund from the drop-down menu. Choose which type of report you wish to generate. The Summary report will only give "totals" for each tracking entry; the Detail report will show each individual transaction that was approved for cost sharing. Run the Cost Sharing Contribution Report. Always round up the total amount of cost share commitments. It must be demonstrated to our sponsors that we met or exceeded the amount of cost sharing committed. Report must be signed by the project director if reporting to the sponsor is required. Send reports to the appropriate fund manager in Extramural Funds Accounting (EFA) Note: The cost share contribution report is used to demonstrate to the sponsoring agency that committed cost share commitments were met. It provides documentation for identification of cost shared direct costs when Facilities and Administration (F&A) proposals are prepared, as it is necessary to include cost shared direct costs in organized research base.
8	Close out UC Fund Close-out, but only AFTER the cost share reporting is finalized.	EFA will close cost sharing for the UC Fund which makes all entries read-only. When the last expense account for the UC Fund is expired, the fund will no longer be accessible in CSTS.

This site maintained by UC Davis Accounting & Financial Services
Questions about this site? Contact us at afsweb@ucdavis.edu.