Abila MIP Fund Accounting

2019 Review of Non Profit Accounting Systems

CPA Practice Advisor, Mary Girsch-Bock, April 16, 2019

According to the National Center for Charitable Statistics (NCCS), there are currently more than 1.5 million nonprofit organizations registered in the U.S. While the vast majority of these organizations are registered as public charities, the number also includes private foundations, chambers of commerce, and civic leagues.

While their missions may vary greatly, one thing these organizations share is the need to manage funds properly. This can include everything from applying for and managing grant funding, to tracking both donors and donations adequately. Membership driven organizations need to be able to track members, invoice members when membership fees are due, and maintain an accurate member list. Those that run programs regularly need to be able to handle event registration and keep track of everyone who has registered.

If that isn’t enough, these same organizations also have to be able to do the things that for-profit organizations do such as process journal entries, pay vendors, record payments, send out invoices, pay employees, and reconcile bank statements.

Many smaller nonprofit organizations make the mistake of thinking that regular accounting software is adequate. And while it’s possible to make it work, the more a nonprofit grows, the greater the need for a system that is designed to track the information that needs to be tracked.

Of course, finding the nonprofit software that is best for your client’s organization can take some time. If the organization has a large number of donors, they’d likely want that capability in any product that they choose. Likewise, if their organizational funding source is primarily from grants, they should be looking for a program that includes the ability to manage multiple grants.

Another issue to look at is deployment options. While some nonprofit software applications can be accessed from anywhere, others are designed to be installed on a desktop or network system. . Of course, cost can also be an issue, particularly for smaller nonprofit organizations with a limited budget.

All of these issues will need to be considered when looking for a software product that will work best for your client’s needs. And the best place to start is by taking a look at the nonprofit reviews that are included in this issue:

Abila MIP Advance

 AccuFund for Nonprofits

 Aplos Fund Accounting

 Araize Fast Fund

Blackbaud Financial Edge NXT

 Cougar Mountain Denali FUND

Fund E-Z Nonprofit Accounting  

GMS Grants Management Systems

QuickBooks for Nonprofits

Serenic Navigator

Tangicloud for Nonprofits & Government

 Xero Nonprofit Accounting

The reviewed products vary widely in both cost and functionality, with some of the products best suited for smaller nonprofits that have less stringent needs, while others provide just about every feature and functionality possible.

To make it easier, we looked at specific features and functionality in each of the products listed above, including chart of accounts structure and customization, grant management capability, fundraising and donor management capability, and even whether a mobile app was available. A Features chart accompanies the reviews, allows you to quickly view which features and functionality are found in each product. We also advise readers if a free demo is available, since trying out the product can be extremely useful when in the market for a new software system. Finally, pricing considerations come into play for most nonprofit organizations, since many have a limited budget available, so we’ve made every effort to include product costs in the review.

The bottom line is that nonprofit software can help an organization work more efficiently while they continue their mission to make this world a better place. We hope that the reviews included in this issue help in some way towards finding your client’s organization the product that works best for them.

Financial Technologies & Management provides our software evaluation to help you select the best nonprofit accounting system for you.  Also, we sell and implement the industry leading solutions which include MIP Fund Accounting, MIP Advance, AccuFund,  and Araize.  I would suggest you review our article “why your Nonprofit should consider using Nonprofit Accounting Software?” to start your review.  Please contact us before you contact any software vendors for us to best serve your review of Nonprofit Accounting Systems and Software.

MIP Fund Accounting 2019.3 Product Release

The MIP product release is ready for download!!  Please feel free to contact Abila support or us to help with upgrade and software installation.

Please be advised that future releases of MIP will no longer be supported on Windows Server 2008 or 2008R2 and SQL 2008R2.  Let us know if we can help to upgrade you to a more current copy of SQL like 2012, 2014, or 2016. This release contains quality updates, as well as several customer-driven improvements.

  • Application improvements:
    • Upgraded budget worksheet to allow saving of in-progress work at any point
    • Financial Statements – Statement of Activities – added option ‘Include Unposted Transactions’ in the report.
    • Additional filtering options to including payee, receipient, and name on Cash, Revenues, and Expense Journals which is typically used to proof 1099 information
    • Vendor activity reporting – additional report highlighting vendors with no recent activity
    • Vendor Activity – Added filter ‘Zero Activity’ to get vendors with no activity.
    • Form 1099 updates for 2019
    • Financial Statement List Report – addition of Account Type column and filter to see what account types have been assigned to report
    • Payroll – Added additional columns for more flexibility in reporting within the payroll module.
    • Added feature to Payroll, so the ACH file can be regenerated and resent as needed in case of error.  You now have option to reset direct deposit to regenerate direct deposit file.
    • Organization – Data Integrity Checks – Removed exclusive access requirement and replaced with a system lock search(disallowed when posting or closing the year is in progress).
    • Enhanced audit trail – Activities – Reconcile Cash Accounts – added logging to the Summary Organization Audit when an existing Reconciliation ID is deleted.
    • Improved Help experience – changed Help to be accessable via the web, enabling us to update documentaton between releases.
  • Quality improvements across MIP

Microsoft Support Changes
Please note the MIP v19.3 workstation installation will take up to 20 minutes or longer due to Microsoft .Net 4.8 framework installation being required so it is normal for it to remain on this screen for some time. If your machine already has .Net 4.8 installed or your IT professional installs .Net 4.8 prior to the MIP workstation installation, please disregard this message.

Windows Versions of MIP released after January 31, 2020 will no longer be supported on Windows 7 SP1.

MIP CLIENT PROMOTION

Get 20% off all  Tax Forms from MIP Checks and Forms that are 100% guaranteed to be compatible with MIP software. They can order online at abilachecks.com or by calling 1-844-857-2898. Be sure to give them discount code 19XABL59. Or, they can receive 20% off of their entire order when they add checks, envelopes, deposit tickets and more by using discount code 19XABL59.  For on premise clients, you can receive 3 months free with 15 month contract to convert or migrate to the MIP Cloud though December, 2019. You can still sign up for Xperience 2019 User Conference on November 10 to 13 in Orlando Florida by clicking here.

READY TO CHECK OUT THE NEW MIP CLOUD?

Even if you haven’t joined the group of cloud adopters, you’ve probably considered it, researched it, or discussed it with your peers. If your organization is ready for a deep dive, now is a good time to check out the newly improved MIP Cloud – request a presentation by contacting us

MIP Subscription Pricing and Contract Changes effective October 1, 2019

MIP Cloud – Multi-Tenant or Single Tenant
1-user bundle $200 per month
3-user bundle $475 per month
Add-ons (modules, users, etc.) as-is/current MIP Cloud subscription pricing
Premium technology fee $150/org/mo. for Single Tenant

SUPPORT AND TRAINING TRENDING TOPICS:

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.