Management 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 hours April 23,2014 Budget Basics and MSU Funding Sources 40
FD201 2 hours November 2014 Accounts Payable 40
FD301 2 hours February 20, 2014 Banner Finance Navigation 16
FD401 2 hours September 2014 Basic Procurement 40
FD501 2 hours December 2014 Revenue Collection 40
FD601 2 hours May 2014 Reconciliation 40
FD701 2 hours TBD Internal Control in Higher Education 40
FD801 2 hours March 19, 2014 Asset Management 40
FD901 2 hours February 12, 2014 Encumbrances 40
FD1001 2 hours January 30, 2014 Intermediate to Advanced Excel for Finances 16
FD1101 2 hours January 2015 Financial Management Hot Topics 40
FD1150 (2 hours) TBD OPTIONAL: Research Administration 40
FD1160 (2 hours) TBD OPTIONAL: Human Resources EPAF & SAIS Reports 40
FD1170 (2 hours) TBD OPTIONAL: Ag/Cat Books 40
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.