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.
  • 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

    FA229 – MIP Fund Accounting Introduction to Allocations Management

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

    In this course participants will learn how to create and process allocation codes and print pre-allocation financial reports. Participants will also learn how to utilize the multiple calculation methods available and how to create sequential allocation calculations. Various allocation reports will be discussed.

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

    • Create an Allocation code.
    • Create an Allocation calculation.
    • Process an Allocation calculation.
    • Check the Allocation by running appropriate reports.

    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.

    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.

    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

    FA223 – MIP Fund Accounting Encumbrances

    Course Level: Intermediate
    Prerequisite: General Ledger Transaction Entry attendance or general ledger transaction entry proficiency
    Instructional Method: Group Internet Based
    Recommended CPE Credits: 2
    Two-Hour Class

    Encumbrances help you manage expenditures and control your budget. This course covers how to encumber funds, review balances, and liquidate encumbrances. You will learn the process of creating a manual encumbrance, checking available budget balances, and liquidating encumbrances manually and with an accounts payable invoice. You will also learn about important encumbrance reports.

    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:

    • Enter manual encumbrances
    • Check encumbrance and budget balances while entering expenditure transactions
    • Manually liquidate outstanding encumbrances
    • Liquidate encumbrances while entering accounts payable invoices and cash disbursements

    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

    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

    FA207 – MIP Fund Accounting Accounts Receivable 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 receivable cycle. Learn how to create customers, enter invoices and credit memos, and process cash receipts and prepayments.

    This course focuses on daily processing tasks in the Accounts Receivable Reporting module. For additional training, and to learn more about creating invoices and personalizing customer statements, attend the “FA208 MIP Fund Accounting Accounts Receivable Billing” course.

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

    • Set up default customer discount and prepayment information
    • Create a customer
    • Rename or merge customers
    • Enter accounts receivable invoices and apply credit memos and receipts
    • Enter and apply prepayments
    • Discuss options for correcting errors
    • Review customer balances and transaction history
    • Evaluate accounts receivable balances using aging, summary, and detailed reports