MIP Fund Accounting™ is a configurable fund accounting solution. The solution includes functionality for fund accounting, procurement, budgeting, payroll, human resources, timekeeping, fixed asset management, grant management, and dashboards for nonprofits and government agencies.
N/A
Power BI For Office 365 (discontinued)
Score 7.9 out of 10
N/A
Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.
I do like the check register, it is easy to access. It is also easy to access information for bank reconciliations but some entries are difficult and I have had ongoing issues with duplicated entries. Those situations coming at times when I am not really sure how I have duplicated an entry and they are somewhat intimidating. It is also somewhat difficult to delete or void erroneous entries or those that need to be otherwise corrected. I do understand that it is accounting software, but feel again that it could be a little bit more user friendly, at least from a fairly "new" user's standpoint!
If you're already using Office 365, Power BI for O365 is an easy choice. Start playing around with the free version and then easily add individual Pro licenses with little risk. However, if you anticipate using this with many users, it can get expensive quickly.
General Ledger processing, including journal entries and reports
Ability to download all reports directly to Excel and PDF formats
Use of Grant codes to enable grant reporting by month/quarter/year
Ability to have multiple departments and consolidate into groups for reporting
Accounts Payable and Accounts Receivable cannot be out of balance
Multiple ways to use the product including Cloud and Classic options, Visual menu or Standard (Top of screen) menus to select processes, many options we are not using in our simple organization
Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that.
Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem.
Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard.
Ability to show data but also export the data, if permitted.
Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code.
With the payroll process, if there is an error in sending the stubs through email, there is no option to resend without a restore. That really needs to change.
Being able to void encumbrance at the same time as a PO would be an incredible time saver.
Licensing: Currently, Microsoft has a fixed pricing model for Office 365 users, regardless of role/function of the user. Most organizations have a small number of "power users" that create usable content and many more "consumers" that simply view/run reports created by power users. Microsoft does not differentiate between these users, and thus the pricing limits organizations from large deployments of the software.
Version incompatibility: Excel 2010 and 2013 workbooks are compatible with each other. However, workbooks created in 2010 that include PowerPivot databases must be upgraded to 2013 format to run in 2013. Subsequently, you cannot open these upgraded PowerPivot workbooks in 2010. This requires ALL users to be on the same version.
Visualization: Excel charting with PowerPivot workbooks is adequate for many users. Power View also contains a number of GREAT visualizations, including animated bubble charts and a very flexible dashboard/report design canvas. However, compared to some of the other self-service BI solutions, it is still limited in its visualization capabilities.
My company is pretty dug into our current day-to-day systems that serve our operations (ServTracker, Kantime, MicroMD). Without MIP Fund Accounting, we would have no choice but to figure out a way to consolidate those three accounting/operations programs into (ideally) one program, which is basically impossible if we want to salvage any historical data. MIP Fund Accounting is a great hub to bring all those pieces together in a palatable form.
I will continue to recommend this suite to folks looking for a reporting and analytics solution, as I find in MOST cases, it's great at meeting almost every requirement I've been given by a multitude of clients across a range of industries. I've built Capacity Planning solutions that allowed end user input which was then submitted to SharePoint, Executive Dashboards, custom applications, simple analytical tools for teams to easily slice and dice data, and super simple reports as well as some very complicated ones. If you haven't seen the demos online, do a search, and see for yourself - this is a great BI suite! (I do not work for Microsoft, although I do consult out there from time to time. I do occasionally make a recommendation for a different BI reporting tool, but in general, find Excel can accomplish quite a bit for less money and in less time.)
I have used this system for about 12 years now and I still learning how to use it. It always surprises me how there is another report to learn to achieve my data reporting goals. It is great to have a system that you have used long enough to feel comfortable with but also a system that allows you to learn new ways to report and enter data into the system
We are satisfied with the functionality and capabilities of Power BI. Product is cost effective and full-fill the reporting requirements of the organization. You can perform most of the report level complex analysis with the help of DAX which makes Power BI very powerful analytic tool. Power BI for Office 365 has gone away and Power BI is the next evolution of it. Power BI comes with your Office 365 E5 subscription or you can purchase licensing for it separately.
I have rarely encountered any issues accessing MIP Fund Accounting over the years. On the rare occasions when availability was interrupted, the reasons were always found in-house when using the on-premises version. Since we have migrated to the MIP cloud, we have had no issues with availability. Any maintenance or updates are always communicated to us and are usually done outside of business hours.
This software is really good as you can run reports for various funds by Revenue Code or Grant code to capture all the data you need for specific revenue streams. Like I said before, this software is amazing for the tracking of grants if you set up your chart of accounts up correctly.
I have not reached out to MIP for technical support; however, their website offers great help resources so I can solve an issue on my own. Another team member reached out to MIP for support and was helped quickly. The transition process took longer than expected due to a lag in communication.
as of now there is strong community for Power BI, you can get solution for most of your problems from there. Also you can send your error to Microsoft as well. After every 15 days they release updates to overcome all the issues of defects.
There are no specifics on what happens if you make one choice or another to know which is the best selection. This is true for JVs and AP. In training we were not given specifics of what happens when one possibility is selected over another.
Denise O'Malley provided training for the HR module when we added it to our system. Denise also gave us a demo of the EWS module which we were able to see that it would not meet our needs. She was very kind about and understanding regarding the functions we needed with a time clock system.
Don't waste your time with MIP. There are plenty of other softwares out there that will do the job better. Do your homework. Get references from actual users. Make sure that what you choose will truly integrate. Make sure that there is local support. Get training. You will be glad that you passed this one by. Trust me.
The HRA used RealPage (I'm not sure if it is actually the one listed above), and it did not work well. I'm not sure if it wasn't set up well, designed for larger property management companies, or just not good software, but it did not suit our needs at all. We chose a different property management software and MIP for our accounting. We used Quickbooks for Heartland Lakes, but as our business is expanding and we needed a better true fund accounting software, we chose AccuFund to start with, but it was difficult to get set up how we needed. We did not trust the information we were getting out of it, and it wasn't easily customizable to what we needed. We canceled that software and chose MIP.
Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports. Salesforce is good; remote access is good however their support is terrible
The flexibility to create certain features are helpful and are designed to be easier on MIP Accounting Cloud. It has been easier than the MIP Accounting classic version. I may have not fully utilized the software to deploy across multiple departments other than generating revenue reports or expenses. As well as developing budget worksheets for our departments. Which are great as it is, but have not gone farther than that.
As a Microsoft Partner implementing Business Intelligence solutions, Power BI has removed the barrier for our clients to begin the "BI journey". So often, projects get hung up in that early phase of procuring and installing/configuring expensive hardware and software. Just simply getting started and designing a beginning solution has allowed our clients to see results in 1-2 weeks using their data that might have taken months to achieve otherwise.
One significant ROI example is process improvement. In many cases, individuals or teams are spending days each month gathering data from multiple sources for reporting to their constituents. We are reducing these times to minutes by automating many of the data collection and integration processes that were previously manual.
