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, eleven two-hour courses (total 22 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.

LENGTH

MONTH

TITLE

Class Capacity

FD101

2 hrs

April 13, 2016

 

Budget Basics and MSU Funding Sources

40

FD201

2 hrs

Nov 5, 2015

Accounts Payable

40

FD301

2 hrs

Oct 13, 2015

Banner Finance Navigation

16

FD401

2 hrs

Sept 8, 2015

Basic Procurement

40

FD501

2 hrs

Dec 8, 2015

Revenue Collection

40

FD601

2 hrs

May 17, 2016

Reconciliation

40

FD701

2 hrs

Oct 29, 2015

Internal Control in Higher Education

40

FD801

2 hrs

March 29, 2016

Asset Management

40

FD901

2 hrs

Feb 25, 2016

Encumbrances

40

FD1001

2 hrs

Jan 6, 2016

Intermediate to Advanced Excel for Finances

16

FD1101

2 hrs

Jan 21, 2016

Financial Management Hot Topics

40

FD1150

(2 hrs)

TBD

OPTIONAL: Research Administration

 

FD1160

(2 hrs)

TBD

OPTIONAL: Human Resources EPAF & SAIS Reports

 

FD1170

(2 hrs)

TBD

OPTIONAL: Ag/Cat Books

 

TOTAL

22 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
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
  • Autofeed 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
 
  • Sales & service accounts
  • Checks
  • Filling out deposit slips
  • Grant revenues
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
 
  • The five elements of internal control as defined by the COSO model.
  • Areas where internal control processes should commonly be implemented in academic, research, outreach and administrative units and
  • 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 Intermediate to Advanced Excel for Finances
 
  • Creating PivotTables and Macros
  • Using the SUBTOTAL Function
  • Using the TEXT TO COLUMNS Function
  • Creating Formulas Using IF Functions
  • Using Logical Functions in Formulas
  • Tracing and auditing formulas
  • Working with Grouped Worksheets
  • Inserting and viewing Comments
FD1101 Financial Management Hot Topics
 
  • Topic will vary each year
FD1150 OPTIONAL: 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: Ag/Cat Books Best Practices and Tips
 
  • Data entry
  • Subaccounts and location codes
  • Using grids and exporting to Excel
  • Reports
  • Reconciling
  • Tracking cost sharing

To register, please visit HR Training, and use your GID and MyInfo PIN to enroll. Training registration will open in February.

For more information, please contact Betsy Webb at 994-4275 or elizabeth.webb@montana.edu.