FA234 – MIP Fund Accounting Data Import/Export

Course Level: Advanced
Instructional Method: Group Internet Based
Training Guide Format: Digital PDF
Recommended CPE Credits: 3
Three-Hour Class
Published: 11/2020

Have you ever wanted to transfer vendors, customers, employees, or even a chart of accounts into MIP Fund Accounting? Are you tired of entering the same transaction data twice? The Import/Export module gives you the power to import data directly into Accounting or Payroll. Learn how to import vendors, customers, and even accounting transactions!

This demonstration course follows the import process from start to finish, thoroughly covering the most commonly used import and export options. After the presentation participants complete practice exercises and correspond with the session leader via e-mail.

By the end of the class, you will be able to:

  • Identify the different types of data formats available.
  • Identify the sections of a definition file and understand how they are used.
  • Apply transaction specific formatting statements.
  • “Match” a definition file to a data file using format statements.
  • Read and troubleshoot import error reports.
  • Select the export options that work best for reports and financial statements.
  • MIPC330 – MIP Cloud User Defined Fields: Self-Study

    Course Level: Advanced
    Prerequisite: Participants must have access to the web component of MIP Cloud prior to class.
    Instructional Method: Self-Study (virtual trainer plus comprehensive training guide)
    Recommended CPE Credits: Not Eligible for CPE
    Access Period: One Year from Purchase
    Estimated Time to Complete: One Hour

    This self-study course will show you how to unlock the potential of User Defined Fields and enhance your ability to gather and report customized
    organizational data. You will also learn how to create different types of user defined fields and practice applying them to the sample data. How to
    easily configure the data type, associated record types, or various characteristics of the UDF will also be covered.

    After completing this course, you will be able to:

    • Identify which UDF categories and types are available.
    • Identify which field type characteristics can be assigned to user defined fields.
    • Set up master-type, document-type, and transaction-type UDFs.
    • Enter transactions with UDF values.
    • Return UDF values in a report.

    FA275 – MIP Fund Accounting Core LW

    Course Level: Basic

    Prerequisites: We recommend a general understanding of product navigation.

    Advanced Preparation: None

    Instructional Method: Group Internet Based

    Training Guide Format: Digital Online/Offline

    Recommended CPE Credits: 19

    Three Day Class

    Published: 8/2020

    This intensive 3-day Live Webcast course focuses on primary financial activities, providing a strong foundation for new customers and a broad understanding for more experienced customers. This course is ideal for accounts payable professionals, staff accountants, and the hands-on Chief Financial Officer.

    You will learn core features of the general ledger, accounts payable, bank reconciliation, budget, and reporting modules. Study topics include creating and maintaining chart of account codes, processing and correcting accounts payable and general ledger transactions, creating and monitoring budgets, and reconciling bank accounts. You will also learn how to use the powerful built-in reporting tools to create reports and perform analysis.

    By the end of the class, you will be able to:

    • Set up accounting administration (chart of accounts, auto-functions, organization preferences, etc.).
    • Setup, process and troubleshoot accounts payable.
    • Enter general ledger transactions, close fiscal years and adjust closed year balances.
    • Reconcile cash accounts.
    • Enter and adjust budgets.
    • Understand basic reporting functions

    Registration for this course includes a full featured digital guide. You will be provided instructions and a key to your digital guide prior to class. Please consider the environment before printing your digital guide.

    Class is held each day from 9:00 AM – 4:30 PM CT. A one hour lunch break is included.

    MIPC206 – MIP Cloud Accounts Payable Analysis

    Course Level: Basic
    Prerequisites: MIPC305 – MIP Cloud Accounts Payable Processing or FA205 – MIP Fund Accounting Accounts Payable Processing
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 2
    Two Hour Class

    In this course, we will practice analyzing errors found in the Accounts Payable module. We begin with a discussion of available report categories, then a review of the corrections toolkit. Afterward, we will review three common accounts payable issues and the resolutions to each. Lastly, we’ll discover what features in the software can be used to prevent data entry errors.

    This course covers topics related to the following modules:

    Accounts Payable

    By the end of the session, you will be able to:

    • Create reports for vendor information, payments, and analysis.
    • Access the vendor balances form and use Accounts Payable Analysis reports to review vendor balances.
    • List three common accounts payable issues and their solutions including methods to troubleshoot to find a resolution.
    • What features in the software can be used to prevent data entry errors with memorize documents, user defaults, and organization specified entry date controls.

    MIPC305 – MIP Cloud Accounts Payable Processing: Self-Study

    Course Level: Basic
    Prerequisite: Participants must have access to the web component of MIP Cloud prior to class.
    Recommended Prerequisite: MIPC303 – MIP Cloud Basic Transactions: Recorded Session
    Instructional Method: Self-Study (virtual trainer plus comprehensive training guide)
    Recommended CPE Credits: Not Eligible for CPE
    Access Period: One Year from Purchase
    Estimated Time to Complete: Two Hours

    This self-study course covers learn time-saving techniques for processing and reporting accounts payable transactions in MIP Cloud. Working through a series of real world lessons, you will learn each step in the accounts payable cycle from creating vendors, to entering invoices, to printing checks. You will also explore reporting options and how to use the Accounts Payable dashboard to assess your organization’s complete payables picture.

    After completing this course, you will be able to:

    • Create and edit vendor records
    • Create accounts payable invoice sessions
    • Use techniques to streamline invoice entry
    • Post accounts payable invoice sessions
    • Select invoices for payment
    • Identify accounts payable reporting options
    • Use the Accounts payable dashboard to evaluate payable performance

    FA326 – MIP Fund Accounting Forms Designer: Self-Study

    Course Level: Basic
    Prerequisites: None
    Instructional Method: Self-Study (virtual trainer plus comprehensive training guide)
    Recommended CPE Credits: Not Eligible for CPE
    Access Period: One Year from Purchase
    Estimated Time to Complete: One Hour

    This self-study course covers how to create custom forms that add a personal touch to communications and reduce costs. Using a check as an example, you will learn all the tools available for customizing forms. These tools can be applied to invoices, customer statements, purchase orders and more.

    By the end of the session, you will be able to:

    • Select the appropriate Forms Designer template
    • Add custom text, signatures, and logos to a custom format
    • Modify the data displayed on a custom format
    • Add or modify a MICR field on a check
    • Import a custom layout

    FA205 – MIP Fund Accounting Accounts Payable Processing

    Course Level: Basic
    Prerequisite: General Ledger Transaction Entry
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 3
    Three-Hour Class

    Attend this class to learn processing skills that improve accuracy and save valuable time throughout the accounts payable cycle. Learn how to create vendors, enter invoices and credit memos, process payments, and view vendor balances. This course focuses on daily processing tasks in the Accounts Payable module. 

    For additional accounts payable training, and to learn more about distributing payments via electronic funds transfer and creating your own check formats, attend the following courses.

    • FA210 – MIP Fund Accounting Accounts Payable Reporting and Troubleshooting
    • FA372 – MIP Fund Accounting EFT for AP: Recorded Session
    • FA326 – MIP Fund Accounting Forms Designer: Self-Study

    By the end of the session, you will be able to:

    • Create a vendor
    • Set up vendor 1099 information and enter 1099 adjustments
    • Rename or merge vendors
    • Create accounts payable invoices and apply credit memos, manual payments, and system generated payments
    • Use advanced coding reduction tools to reduce data entry
    • Review and edit unposted system generated payments
    • Review vendor balances and transaction history
    • Evaluate accounts payable balances using aging, summary, and detailed reports

    FA224 – MIP Fund Accounting Purchase Orders

    Course Level: Intermediate
    Prerequisite: Encumbrances attendance or encumbrances proficiency
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 3
    Three-Hour Class

    In this course, students will explore the complete purchase cycle, from adding item codes, to issuing a purchase order, to creating an accounts payable invoice. Students will also be shown how to create a purchase order with encumbrances, receive the items, adjust the receipt if necessary, and then apply it to an invoice. Canceling purchase order items, voiding a purchase order, and a discussion of relevant reports are also covered in this class.

    For additional training, and to learn more about working with encumbrances and processing accounts payable, attend the “FA223 – MIP Fund Accounting Encumbrances” and “FA205 MIP Fund Accounting Accounts Payable Processing” courses.

    By the end of the session, you will be able to:

    • Create item codes for frequently purchased goods and services
    • Categorize items for easy application to purchase orders
    • Define shipping and billing locations
    • Print a purchase order
    • Automatically create encumbrances with a purchase order
    • Save time by applying a purchase order to an accounts payable invoice
    • Cancel and void purchase order items
    • Research and review purchase order history

    FA225 – MIP Fund Accounting Electronic Requisitions

    Course Level: Basic
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 2
    Two-Hour Class

    Electronic Requisitions allows organization employees to submit requests for goods and services electronically and route the requests through multiple approval levels. Processing requisitions electronically saves time and resources.

    Course participants will learn how to set up users and security as well as apply item and category codes (used in Purchase Orders) to requisitions. The course will also cover the submission, approval, or rejection process, as well as requisition management. Applying approved requisitions to Purchase Orders and relevant reports are also discussed. 

    For additional training, and to learn more about creating purchase orders and processing accounts payable, attend the FA224 – MIP Fund Accounting Purchase Orders and FA205 – MIP Fund Accounting Accounts Payable Processing courses.

    By the end of the session, you will be able to:

    • Set up requisition users and security rights
    • Create approver hierarchies
    • Create, submit, approve, and reject requisitions
    • Manage requisitions
    • Apply final approved requisitions to purchase orders
    • Research and review requisition history

    FA230 – MIP Fund Accounting User Defined Fields

    Course Level: Advanced
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 2
    Two-Hour Class

    Unlock the potential of User Defined Fields and enhance your ability to gather and report customized organizational data. Create different types of user defined fields and practice applying them to the sample data. Create reports with user defined fields. Understand the way UDF’s interact with your standard data tables and how to avoid common pitfalls and discouraged practices.