Financial Development Certificate Program

Purpose: To provide skill building, tools, and professional development to MSU employees performing departmental accounting at Montana State University. Also available to those MSU employees wishing to develop skills and move into financial management positions at MSU.

Workshops will be offered throughout the academic year. Course offerings may be adapted to the demand created by MSU employees.

Financial Development-I Certificate

To earn a Montana State University certificate in Financial Development-I, twelve two-hour courses (total 22.5 hours of training) are required.  Employees will have 36 months to complete the required courses and a certificate in Financial Development-I will be issued.  Employees may also sign up for individual courses and choose not to work towards a certificate.

 

COURSE NO.

TITLE

DATE

LENGTH

TIME

CAPACITY

FD101

Budget Basics and MSU Funding Sources

April 20, 2017

 

2 hrs

2-4 PM

50

FD201

Accounts Payable

November 16, 2016

 

2 hrs

1-3 PM

50

FD301

Intermediate Banner Finance

October 18, 2016

 

2 hrs

10 AM – 12 Noon

20

FD401

Basic Procurement

 

September, 20 2016

2 hrs

9-11 AM

50

FD501

Revenue Collection

 

December 13, 2016

2 hrs

2-4 PM

50

FD601

Reconciliation

 

May 12, 2017

2 hrs

9-11 AM

50

FD701

Internal Control in Higher Education

 

October 12, 2017

1.5 hrs

10 -11:30AM

50

FD801

Asset Management

 

March 8, 2017

1 hr

1-2 PM

50

FD901

Encumbrances

 

February 13, 2017

2 hrs

10 AM – 12 Noon

50

FD1001

Intermediate Excel for Finances OR

 

October 20, 2016

2 hrs

9-11 AM

 

25

FD1001

Advanced Excel for Finances

 

January 17, 2017

2 hrs

1-3 PM

25

FD1101

Financial Management Hot Topics

 

January 10, 2017

2 hrs

9-11 AM

100

FD1150

Research Administration

 

October 31, 2016

2 hrs

9-11 AM

50

FD1160

OPTIONAL: Human Resources EPAF & SAIS Reports

TBD

(2 hrs)

TBD

50

FD1170

OPTIONAL: Cost Sharing

 

November 7, 2016

(2 hrs)

9-11 AM

50

TOTAL

 

 

22.5 hours

 

 

Financial Development-I Course Descriptions

 

Course No.

Course Title & Description

FD101 

Budget Basics and MSU Funding Sources

  • Review various fund types and their sources of revenue/income
  • Working with Foundation funds
  • Types of transactions handled by Budget Office vs. those handled by UBS
  • How funds move across the University, between departments
  • Budget cycle, Accounting cycle (Fiscal Year End, how Budget and UBS work together, combined timeline)
  • Discuss various types of budget adjustments and how they appear in the Operating Ledger
  • Budget and Fund Balance reports
  • Overview of grant budgeting
  • Budgeting in CatBooks

FD201

Accounts Payable

  • Preparing BPAs correctly
  • Checking vendor information in Banner
  • Wire transfers
  • Payments to foreign vendors
  • Has my payment been processed?
  • W-9s, 1099s, and other tax issues
  • P-cards, coding activity in Banner and reporting
  • Review travel issues and where to find the info/answers – per diem, mileage, high rate lodging, currency conversion, etc.
  • Review various travel forms
  • Processing travel - advances, reconciliations, foreign travel

FD301

Banner Finance Navigation

  • Difference between the Operating Ledger and the General Ledger
  • Banner screens FGITBSR, FGIBDST, FGITRND, FRIGITD, FRAGRNT
  • Key Web Finance Reports
  • Various document types
  • Auto feed transactions
  • Payroll – how it looks in Banner Finance and Web Reports, Term Pool
  • Roll up Groups
  • Extracting data from Banner

FD401

Basic Procurement

  • Delegated authority
  • Total contract value
  • Purchase under $5,000, between $5001 and $25,000, and over $25,000
  • Sole Source/Brand Name Justifications
  • Exempt from procurement procedures
  • Direct buy opportunities (term contracts & cooperatives)

FD501

Revenue Collection

  • Risks of and internal controls for revenue collection
  • Accounts receivable
  • MSU policies applicable to certain types of revenue
  • MSU procedures for collecting revenue
  • Credit card revenue
  • Grant revenue
  • Change funds and petty cash

FD601

Reconciliation Best Practices

  • What is Reconciliation?
  • Why Reconcile?
  • Who Reconciles?
  •  Specific Guidelines
    • Frequency
    • Reports used
    • Segregation of duties
    • Documentation
    • Management review
    • Researching and correcting errors identified

FD701

Internal Control in Higher Education

  • Based on the Standards for Internal Control in the Federal Government (aka The Green Book)
  • Discussions of the 5 elements and 17 principles of internal control
  • Areas where internal control processes should commonly be implemented at MSU
  • Tools for assessing and improving internal control processes in your unit

FD801

Asset Management

  • Capital and minor equipment inventories – who’s responsible for what?
  • Dealing with Trade-Ins
  • Disposals and Transfers of assets
  • Surplus property
  • The role of Procurement, Property Management and Accounting
  • Federally owned assets – tracking and inventory’

FD901

Encumbrances

  • Explanation of encumbrance processes and how they relate to PTF changes
  • Salary encumbrance calculations
  • Fringe benefit encumbrance calculations
  • Tips & tricks for troubleshooting encumbrance errors
  • Encumbrances related to procurement

FD1001

To fulfill the requirement for the Financial Development Certificate either FD1001: Intermediate Excel for Finances OR FD1001: Advanced Excel for Finances can be taken.

 

Intermediate Excel for Finances

  • Working with large worksheets: Sorting, formatting
  • Linking cells and formulas
  • Creating tables and outlines
  • Adding graphics to worksheets
  • Using templates and protecting workbooks.

 

Advanced Excel for Finances

  • Pivot tables (everyone loves the Pivot table )
  • Financial Functions and Data Analysis
  • Subtotal
  • Data Validation
  • Conditional Formatting

 

FD1101

Financial Management Hot Topics

  • Topic will vary each year

 FD1150

 Research Administration 

  • Working with the Office of Sponsored Programs
    • Federal guidelines governing accounting practices for grants and contracts
    • Understanding and monitoring grant budgets
    • Facilities and administrative costs
    • Budget modifications
    • Multiple year budgets
    • Using Banner screens and SAIS Web Reports
    • Tracking and reporting Cost Sharing
    • Time & Effort reporting
    • Program Income
    • Closing out a grant

 

FD1160

OPTIONAL: Human Resources EPAF & SAIS Reports

  • Encumbrances due to salary
  • SAIS
  • Foreign nationals
  • Moving expenses

FD1170

OPTIONAL: Cost Sharing

  • Understanding Cost Sharing as it relates to Sponsored Programs
  • What is Cost Sharing?
  • MSU’s Cost Sharing Policy
  • Purpose of Time and Effort Reporting
  • Tracking and Reporting Cost Sharing
    • T&E system
    • Activity Codes
  • Tools for tracking cost sharing
  • Roles and Responsibilities

For more information, please contact Betsy Webb at 994-4275 or elizabeth.webb@montana.edu.To register, please visit HR Training, and use your GID and MyInfo PIN to enroll. Training registration will open in February.