Grants and Projects Checklist & Process Steps Guide

Purpose:  Use this document as a reference to assist in the standard or end-to-end processes in chronological order for a specific Finance Module.

Audience:  Finance/Grant Fiscal Staff

The following spreadsheet below provides the standard key processes of Grants, such as: Cost Reimbursable and Fixed Price Grants, Capital Projects, Queries and Roles.

Grants Checklist and Process Steps Guide

Or for better accessibility, use the following drop-down checklist style for the Grants and Projects Checklist & Process Steps Guide:

Cost Reimbursable Grants

To view inserted information, select the down facing arrow on the right of the checklist title. 

Set up basic information for the grant - name, description, activities, sponsor, grant PI, dates, location, etc.  

Related QRG(s)

Set up initial budget for the grant.    

Related QRG(s)

Identify the grant terms, such as cost-reimbursable.  

Related QRG(s)

Identify the project type for each project associated with the grant.

Related QRG(s)

Finalize the budget for the grant. Add complete chart string information.  

Related QRG(s)

Set up and activate the customer contract associated with the grant.  Customer contracts manage billing parameters for the grant.  

Related QRG(s)

Related QRG(s)

College shares chart string information with applicable staff, which may include business office staff, purchasing staff, staff who will charge travel to the grant, staff supporting those overseeing the grant, etc.  

Colleges spends money as needed for the project.

Spending occurs in other modules such as Accounts Payable and may require Purchase Orders.  Collaborate with other college staff as needed.

College monitors expenses and budget.  This can be done in the commitment control (KK) module or via various queries and reports, such as QFS_PC_PROJ_RESOURCE_PYMNT or BFS_KK_GRANT.  

Reconcile Project Resource data to GL data. Ensure all BIL lines are for expense accounts. Ensure all expenses belong in the grant and other expenses are not missing. Review with grant PI or others as applicable.

Proj Resoruce Analysis Types ACT + GLE should equal BIL + DEF + BLD, which also should equal expense lines from GL. Verify that BIL, BLD, DEF lines are all expenses (no cash or liabilities). Suggested queries:  QFS_PC_PROJ_RESOURCE_PYMNT and QFS_GL_ACCOUNT_ANALYSIS.

If applicable, do corrections in the GL and/or sub-modules.

Calculate and post F&A/Indirect if applicable.

Grant Billing (bill grant as often as required per grantor requirements)

Run queries to gather billable data.

Related QRG(s)

Run the Over the Limit (OLT) query. OLT rows are transactions that exceed the maximum value of the customer contract and are not billable.  

Related QRG(s)

If there are OLT transactions, amend the customer contract and release the OLT rows as necessary so the rows will get picked up as billable data.  

Related QRG(s)

Run the Contracts to Billing Interface process.  This prepares the billing data to move from the customer contracts module to the billing module.  

Related QRG(s)

Executed the Billing Interface process.  This moves the billing data from the customer contracts module into the billing module.  

Related QRG(s)

Review the billing worksheet to ensure all desired billing data is captured and is accurate.  

Related QRG(s)

In the billing module, generate the invoice via the Single Action invoice process.  

Related QRG(s)

If necessary, college modifies grant budget.  Budget modifications are needed if the college needs to move money between budget items (equipment, goods, salaries, benefits, etc.) or if the total budget needs to be increased or decreased.

After the grant has been completed and all accounting transactions have processed, close the project(s).  

If the project was closed before all accounting transactions were completed, the project may be reopened.  

END

Fixed Price Grants

To view inserted information, select the down facing arrow on the right of the checklist title. 

The following are major process steps and include the most common QRGs.  For assistance with additional situations, view all project QRGs or submit a service desk ticket for assistance.  

Set up basic information for the grant - name, description, activities, sponsor, grant PI, dates, location, etc.  

Related QRG(s)

Related QRG(s)

Identify the grant terms, such as fixed-price.  

Related QRG(s)

Identify the project type for each project associated with the grant.

Related QRG(s)

Finalize the budget for the grant. Add complete chart string information.  

Related QRG(s)

Set up and activate the customer contract associated with the grant.  Customer contracts manage billing parameters for the grant.  

Related QRG(s)

Related QRG(s)

College shares chart string information with applicable staff, which may include business office staff, purchasing staff, staff who will charge travel to the grant, staff supporting those overseeing the grant, etc.  

Colleges spends money as needed for the project.

Spending occurs in other modules such as Accounts Payable and may require Purchase Orders. Collaborate with other college staff as needed.

College monitors expenses and budget.  This can be done in the commitment control (KK) module or via various queries and reports, such as QFS_PC_PROJ_RESOURCE_PYMNT or BFS_KK_GRANT.  

Reconcile Project Resource data to GL data. Ensure all expenses belong in the grant and other expenses are not missing. Review with grant PI or others as applicable.

Project Resource Analysis Types ACT + GLE should equal expense lines from GL.  Suggested queries:  QFS_PC_PROJ_RESOURCE_PYMNT and QFS_GL_ACCOUNT_ANALYSIS

If applicable, do corrections in GL and/or sub-modules.

Calculate and post F&A/indirect if applicable.

Grant Billing (bill grant as often as the grantor requires)

Run the Contracts to Billing Interface process.  This prepares the billing data to move from the customer contracts module to the billing module.  

Related QRG(s)

Executed the Billing Interface process.  This moves the billing data from the customer contracts module into the billing module.  

Related QRG(s)

Review the billing worksheet to ensure all desired billing data is captured and is accurate.  

Related QRG(s)

In the billing module, generate the invoice via the Single Action invoice process.  

Related QRG(s)

If necessary, college modifies grant budget.  Budget modifications are needed if the college needs to move money between budget items (equipment, goods, salaries, benefits, etc.) or if the total budget needs to be increased or decreased.

After the grant has been completed and all accounting transactions have processed, close the project(s).  

NOTE:  If the project was closed before all accounting transactions were completed, the project may be reopened.  

END

Capital Projects

To view inserted information, select the down facing arrow on the right of the checklist title. 

The following are major process steps and include the most common QRGs.  For assistance with additional situations, view all project QRGs or submit a service desk ticket for assistance.  

Set up basic information for the project - name, description, activities, project type, dates, location, etc.  

Related QRG(s)

NOTE:  Be sure to enter your SBCTC-assigned capital project number in User Field 5.

Related QRG(s)

College shares chart string information with applicable staff, which may include business office staff, purchasing staff, staff supporting those overseeing the project, etc.  

Colleges spends money as needed for the project.

NOTE:  Spending occurs in other modules such as Accounts Payable and may require Purchase Orders.  Collaborate with other college staff as needed.

College monitors expenses and budget.  This can be done in the commitment control (KK) module or via various queries and reports, such as BFS_GL_BEROP.  

If applicable, do corrections in GL and/or sub-modules.

As applicable, create a bill to the State Treasurer.

If necessary, college modifies project budget.  Budget modifications are needed if the college needs to move money between budget items (equipment, goods, salaries, benefits, etc.) or if the total budget needs to be increased or decreased.

After the project has been completed and all accounting transactions have processed, close the project.  

NOTE: If the project was closed before all accounting transactions were completed, the project may be reopened using this same QRG.  

END

Queries
QUERY / REPORT NAME DESCRIPTION
BFS_GL_BERGN BI Publisher report for projects that shows budget, expenses, pre-encumbrance, encumbrance, and balance in several formats of varying details. Select link for instructions.
BFS_GL_BEROP Report for grants, projects, or operational departments that shows budget, expenses, encumbrances, and balances in several formats of varying details.
BFS_KK_GRANT BI Publisher report for grants that shows budget, expenses, encumbrances and balances in several formats of varying details. Includes breakdowns by period for multi-period grants.
CTC_PR_BILLABLE Shows billable data for cost-reimbursable grants.
CTC_PR_BILLABLE_SUMMARY Summary level billable data for cost-reimbursable grants. May be helpful if you need to attach a list of expenses to an invoice you send to a grant sponsor.
CTC_PR_BILLED Shows billed data from a given grant.
PGFS_KK_BUDGET_OVERVIEW_GNT_PG Pivot Grid that displays how much of a project budget was spent in each budget category in graph and chart formats.
QFS_CO_HR_ACCT_LINE_PAY_PERIOD Shows staff charged to projects for a specified period of time. Includes pay period date. Requires additional security to view due to sensitive data.
QFS_CO_HR_ACCTG_LINE_EE_DIST Shows payroll by employee by grant. Need higher level security to view this.
QFS_CO_HR_ACCTG_LINE_EE_DIST Shows staff charged to projects for a specified period of time. Requires additional security to view due to sensitive data.
QFS_GM_AWARDED_GRANTS Shows information for awarded grants - dates, sponsors, FA rates, etc.
QFS_GR_GRANT_BUDGET_EXPENSES Shows all expenses in a grant. Includes accounting period but not accounting date. Also includes grant period.
QFS_KK_BUDGET_OVERVIEW_GNT Shows budget, expense, encumbrance, and balance for each budget item in a grant by project and activity.
QFS_KK_BUDGET_OVERVIEW_GNT_DTL Shows all expenses in a grant for the date range selected. Includes supplier names when applicable. May be helpful for reconciling.
QFS_PC_PROJ_RESOURCE Shows all grant or project data from the Project Resource table. May be most helpful when filtering/sorting on analysis type and putting data into a pivot table.
QFS_PC_PROJ_RESOURCE_PYMNT Condensed version of QFS_PC_PROJ_RESOURCE that includes details on payments made to others (check/ACH, payment date, payment number, etc.) that were charged to the grant or project.
QFS_PR_PROJ_BUD_EXP Shows budgets and expense totals by account/budget item. Includes full chartstrings for each project's budget item.
QFS_PR_PROJECT_DT_VS_KK_DT Shows project type, status, and start and end dates for the project as well as commitment control.

END

Roles

Please refer to the tab Roles in the FIN Grants and Projects Checklist and Process Steps Guide

END

You are done. Great job!

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.