Abila MIP Fund Accounting

Abila MIP Fund Accounting and Abila MIP Advance Version 2019 Available including access to user guides, knowledge base articles, and video to assist with Year End Processing

As your local business partner and reseller for Abila MIP, we wanted to let you know that Abila has released a software update.  You will need to upgrade to Version 2019 to do your year end tax forms including your 1099’s and W-2’s from Aatrix.  Please contact us for help with your annual software upgrades or assistance to produce your year end tax forms.  Keep in mind you may need to upgrade your SQL Server 2008 as Abila will stop supporting this SQL Server Version March 31, 2019.  Our firm recommends that you upgrade to SQL Server 2014 SP1 or SQL Server 2016.

Form more information on processing W2s and 1099s, please reference the following guides:

1099 User Guide
W2 User Guide

Trending Support Topics

Below is a list of current trending support topics. You can use the links below to quickly access the associated Abila Knowledgebase Article or how-to video. You must be logged in to the Abila Knowledgebase to view KB Articles.


Year-End Topics

Download / Installation / Technical

  • Download: Abila MIP Fund Accounting version 2019.x – (Article)

If you have any questions, please contact Abila Support or Financial Technologies & Management.  You might want to contact Abila support first especially if you have an active maintenance and support agreement as we will need to charge you for our time.  However, we process quite a few W-2’s and 1099’s for our clients so you can contact us if we can provide assistance or if you would like for us to do the year end processing on your behalf.

Are you Considering Moving MIP to the Cloud? Contact FTM for help

Did you know within MIP there is more than one cloud option available?

We continue to see more of our MIP users migrate to the cloud so contact us for our help.

Some of the primary reasons our clients have moved to the cloud include the following:

  • Secure access to information and data from anywhere
  • Software updates are performed automatically
  • Fewer expenses for hardware and IT related costs.  Also, no large capital expenditures
  • SSAE 16 compliant data centers that are typically more secure and reliable than  on-premise installations
  • Data that is easily available in case of a natural disaster or emergency
  • More timely backups to avoid and minimize data loss

For more information about the MIP cloud or hosting options, please contact Jim Simpson at jsimpson@ftmllc.com or 317.819.0780 for a FREE review and quote.

Abila MIP Fund Accounting and Abila MIP Advance Version 2019. 1 Available and Current MIP Promotions includes FREE Payroll and/or HR

What’s New in Abila MIP Fund Accounting Version 2019.1

Tax Enhancements Completed:

  • New Jersey Tax Updates
  • Maryland Tax Updates
  • Illinois Tax Updates
  • MIP: Aatrix – Add Oregon State Transit Tax code #5666 to Maintain Other Taxes

Reporting Enhancements Completed:

  • MIP: Financial Statements – Includes an option to add the Unposted Transactions to the Balance Sheet and Statement of Financial Position reports to allow more flexibility and understanding of current financial state.

Security Enhancements Completed:

  • MIP: Attachments – Enhances the attachment encryption process when encrypting documents using a new, modern algorithm.
  • MIP: Added a reminder message to both Forms Designer forms when the Insert Picture (related to signatures) is selected and both ACH forms.

Administration Enhancements Completed:

  • MIP: Data Integrity Checks – The Organization Name has been added to the results message for clarification.

Payroll Enhancements Completed:

  • MIP: Employee Information – A change was made to the employee page where the Social Security Number is entered.  If not entered at this time, a warning message will be displayed but the user can continue onwards, in order to match the functionality in the HR module for increased usability.
  • MIP: Payroll – The Timesheet Reference field now flows through several parts of the application to allow tracking and reporting on large numbers of employees.  It will flow through the calculation and history processes, as well as thru the processing and historical reports. Additionally, in Forms Designer, “Add Timesheet Reference” will be made available as a Data field.
  • Changes made to address new payroll requirements in Arizona
    • MIP: Set Up Modules – Payroll – Added checkbox ‘Include Historical Pay Code Information on Stubs’ and changed Print Checks/Vouchers and Reprint Stubs to enable display of changes made for the AZ tax code payroll changes.

Resolved Issues

With the 2019.1 release, we resolved 18 outstanding defects, including three HR defects. Defects

included in DLL releases from 2018.1 to 2019.1 are also included in this list.

FA‐20024 An ARS session allows duplicate document numbers to be created. For those document numbers that are used twice in one session, AR reporting doubles the amounts on the report output

FA‐21915 Aatrix: Info in AUF not Sorted or Grouped Properly

FA‐22185 The posting process taking an excessive amount of time

FA‐22929 MIP Closes when attempting to export report to XLS using the Red Door

FA‐23145 Changing one Employee in Review/Modify for a Supplemental Payroll triggers all employees to be recorded in the Summary Organization Audit with no associated user ID

FA‐23149 Appending or Prepending to an Excel Worksheet Removes Decimals That End in 0

FA‐23201 After exporting a report to Excel, formulas create #VALUE!

FA‐23262 Hourly Rate Change on Salaried Employees Does Not Save

FA‐23281 Append to Excel files with file type XLSM Fails (macros)

FA‐23316 HR: ‘dg2_initializeLayout’ error when adding Certificates in HR 2 14 of the defects on this list were from the prioritized Support Top 25 defects list.

FA‐23320 Rename Employee is Creating New Employees Instead of Renaming

FA‐23339 HR: Payroll Check printing rather than voucher

FA‐23343 HR: Misspelling in Ethnic Drop‐Down Options

FA‐23376 Some Report Types Printed from Excel Exported from MIP are Improperly Formatted

FA‐23395 Electronic Funds files have wrong Object Count when filler rows not included on a Data File ending in a perfect 10 count

FA‐23437 Reprint Pay Stub subtracts Workers Comp from Net Pay

FA‐23445 Reprint Pay stubs Produces Incorrect YTD Earnings for Local Taxes

FA‐23605 After applying the DLL to fix FA‐23281, Running the Bank Rec report to screen causes MIP to close. It also replaces the ‘from’ field

with the name of the database rather than the email address of the user attempting to email a report.

Abila MIP Advance™

The focal point of the 2019.1 release was the debut of the MIP Advance™ Reporting module.  Extensive refinement to the UI along with the introduction of 57 previously unreleased reports are the highlight of the features included here. See below for more detailed information.

Reporting

New Reports ‐ Inclusion of 57 new reports to the Advance user interface. A list of report

categories and sub‐categories is included below.

 Aged Payables, Detail A/P Ledger, Invoices Selected for Payment, Summary A/P Ledger, Vendor 1099 Adjustments List, Vendor Activity, Vendor Information List

 Aged Receivables, Customer Activity, Customer Information List, Detailed A/R Ledger, Summary A/R Ledger

 Bank Reconciliation – Checks/Vouchers, Combined Reconciliation, Deposits, Other Cash Items, Suspense Items

 Budget – Budget Worksheet, Detail Budget/Actual Transactions, Posted Budget Transactions, Summary Budget Comparison, Unposted Budget Transactions

 Check/Voucher Register

 Financial Statement – Balance Sheet, Combining Balance Sheet, Statement of Cash Flows, Combining Statement of R&E, Statement of Activities, Statement of Cash Flows, Statement of Financial Position, Statement of R&E, Statement of Revenues and Expenditures by Period

 General Ledger Analysis – Comparative Trial Balance, Expanded GL, Normal Trial Balance, Standard GL, Working Trial Balance

 Journals – Cash Journal, Expenditure Journal, Revenue Journal

 Lists – Account Code Combinations, Attachments, Chart of Accounts, Closing Account Assignments, Distribution Codes, Email Templates, Financial Statement Format, Group Information, Offset Account Assignments, Report Group Assignments, Security, UDF Default Sources, User Defined Fields, User Information List

 Transactions – Memorize/Recurring Transactions, Unposted GL Transactions, Posted GL Transactions

Current MIP Promotions:
Prospect Promotion:
Free Payroll, HR, or both for 1 year: On Premise only pays M&S after year one; Subscription gets 12 months free
Client Promotion: Discount on HR, EWS, and/or Benefits Enrollment with 10% off one module or 20% for two or more modules; Free Module with Renewal for 12 months and choose from Forms Designer, Advance Security, Extended Support (Gold), Electronic Requisitions, Additional Users or E Requisition Users; Renewal Amnesty for clients 6 months overdue may pay only a 50% catch up fee.

Abila MIP Fund Accounting 1099 and W-2 Processing-FREE Web Cast from January, 2018

We are pleased to provide you with our recorded web cast.   Click here to view recorded web cast and video.

In this course, participants will create, review, and correct IRS Forms and 1099-MISC, INT, DIV, and R. Participants will learn to produce and print the IRS forms in paper and submit electronically via Aatrix. Helpful reports and troubleshooting tips will be covered.

In this course, participants will create, review, and correct IRS Forms (i.e. W-2’s, and W-3’s). Participants will learn to produce and print the IRS forms on paper and submit electronically via Aatrix. Participants will learn what is involved in starting a new payroll year. Helpful reports and troubleshooting tips will be covered.

The donated value of this two hour web cast is $250.

Accounts Payable and Accounts Receivable-MIP Spotlight

We will be focusing each Module of the Month on a particular software module or application that helps our clients.

We are going to focus this article on the Accounts Payable and Accounts Receivable Module. We focused on tips and tricks during the MIP User Group portion of the August 30, 2017 FTM Nonprofit Forum – you can watch the recording here.

Our module refresher will include the following topics:

  • Accounts Payable Query for Vendor Balances and Activity
  • Changing AP Invoices after posting and check production
    Voiding a Check
  • When to use Accounts Payable Invoices versus Cash Disbursements
    Setting up un-posted and posted transaction reports for Accounts Payable Invoices
  • Using the AP reports to include Accounts Payable Aging and Vendor Activity
  • Assigning Manual Checks and bank payments to Invoices
    Best Practices to enter in credit card charges
    Setting up an after the fact Accounts Receivable Invoice

Let us help you to maximize your use of the MIP Accounts Payable and Accounts Receivable Modules. Our firm and staff use MIP Fund Accounting on a daily basis so let us help you maximize the use of this powerful application.