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.
  • FA228 – MIP Fund Accounting Fixed Assets Management

    Course Level: Intermediate
    Prerequisite: General Ledger Transaction Entry
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 2
    Two-Hour Class
    Published: 01/2018

    In this course, participants learn how to create asset codes to track individual assets, depreciation and warranty information. Participants also learn how to enter assets during transaction entry of accounts payable invoices or while entering cash disbursements; transferring depreciation calculations to the general ledger; and disposal of assets. The course concludes with a discussion of various fixed asset reports.

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

    • Set up the Fixed Assets module.
    • Create and modify assets.
    • Use the Fixed Assets quick entry form.
    • Calculate, review, adjust, dispose, and transfer depreciation.
    • Generate reports on Fixed Assets.

    FA208 – MIP Fund Accounting Accounts Receivable Billing

    Course Level: Basic
    Prerequisite: General Ledger Transaction Entry, MIP Fund Accounting Accounts Receivable Processing
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 2
    Two-Hour Class

    Attend this class to learn how to take advantage of advanced receivable features. This course focuses on using the Accounts Receivable Billing module. The Accounts Receivable Billing module seamlessly integrates with the Accounts Receivable Reporting module providing more options for reducing costs and improving service. Learn how to set up sales taxes, generate and print customer invoices, and prepare customer statements.

    For additional training, and to learn more about daily processing tasks in the Accounts Receivable Reporting module, attend the “FA207 – MIP Fund Accounting Accounts Receivable Processing” course. To learn how to create your own customer statement formats attend the “FA226 – MIP Fund Accounting Forms Designer” course.

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

    • Create sales tax authorities and sales tax codes
    • Apply sales taxes to taxable customers
    • Print accounts receivable invoices
    • Edit printed but unposted accounts receivable invoices
    • Void posted accounts receivable invoices

    MIPC301 – MIP Cloud System Administration: Recorded Session

    Course Level: Basic
    Prerequisite: Participants must have access to the web component of MIP Cloud prior to class.
    Recommended Prerequisite: None
    Instructional Method: Recorded Session
    Recommended CPE Credits: Not Eligible for CPE
    Access Period: One Year from Purchase
    Estimated Time to Complete: Two Hour

    This recorded sesssion will discuss creating an organization’s accounting database, and performing general application housekeeping and administration. You will receive an overview of the structure and design of the components of the database and in-depth information on the utilities that control the database itself and the integrity of the data entry process for the database.

    For additional training, and to learn more about daily processing tasks in the Accounts Payable module, attend the “MIPC302 – MIP Cloud Accounting Administration and Setup” course.

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

    • Navigate within both MIP Cloud interfaces: the modern user interface and the classic user interface.
    • Create a new organization database and modify organization settings.
    • Attach encrypted documents in the cloud and manage categories
    • View available activity and audit logs
    • Initiate data integrity checks and review the default table structure

    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.

    MIPC303 – MIP Cloud Basic Transactions: Recorded Session

    Course Level: Basic
    Prerequisite: Participants must have access to the web component of MIP Cloud prior to class.
    Recommended Prerequisite: None
    Instructional Method: Recorded Session
    Recommended CPE Credits: Not Eligible for CPE
    Access Period: One Year from Purchase
    Estimated Time to Complete: One Hour

    This recorded session will discuss entering simple transactions in the general ledger such as journal vouchers, cash disbursements, cash receipts, write checks, and write receipts.

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

    • Create, edit, view and post basic general ledger transctions.
    • Discuss the auto-increment feature in the product
    • Cite considerations for creating session IDs
    • Produce a receipt of deposit or a write check in the application.

    MIPC304 – MIP Cloud Correcting Transactions: Recorded Session

    Course Level: Basic
    Prerequisite: Participants must have access to the web component of MIP Cloud prior to class.
    Recommended Prerequisite: MIPC305 – MIP Cloud Accounts Payable Processing
    Instructional Method: Recorded Session
    Recommended CPE Credits: Not Eligible for CPE
    Access Period: One Year from Purchase
    Estimated Time to Complete: One Hour

    This recorded session will discuss correcting transactions in the general ledger, using the Accounts Payable module as an example. In this course, we will learn how to correct documents at the session level, or document level, as well as making corrections to the general ledger such as voiding checks or recording check spoilage. These concepts can be applied to multiple modules in the product.

    For additional training, and to learn more about daily processing tasks in the Accounts Payable module, attend the “MIPC305 – MIP Cloud Accounts Payable Processing” course.

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

    • Reverse and copy entire sessions of documents.
    • Reverse and copy individual documents within sessions.
    • Void checks or vouchers, and record check spoilage.

    MIPC302 – MIP Cloud Accounting Admin and Setup: Self-Study

    Course Level: Basic
    Prerequisite: Participants must have access to the web component of MIP Cloud prior to class.
    Recommended Prerequisite: 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: Two Hours

    This self-study course tours the available setup items in your MIP Cloud database as it pertains to your general ledger and reporting. You will learn how to set up chart of account codes and use the model account feature. This is followed by a discussion on features critical to reporting with closing account assignments and offset account assignments. We also include a section on expediting data entry and preventing errors with lessons on distribution codes and account code combinations. Finally, you’ll learn how to attach documents to the available transaction types in the application

    For additional training, and to learn more about administrative setup of the application, attend the “FA201 – System Administration” course.

    After completing this course, you will be able to:

    • Create chart of accounts codes, and use model accounts.
    • Create offset account assignments, closing account assignments, account code combinations and distribution codes.
    • Distinguish between valid and invalid account code combinations.
    • List which forms the attachments feature is available for in the application, and demonstrate how to attach documents.