Prophix is a very good alternative for flexible reporting
April 10, 2020
Prophix is a very good alternative for flexible reporting
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Prophix
We use Prophix as our main Financial Reporting tool. It's being used by our entire finance and corporate accounting team. We were previously using Microsoft's FRx (which has long been unsupported by MS), and we found the combination of price and functionality of Prophix were very hard to beat. In choosing Prophix, we looked at not only a good replacement for FRx, but a product that would be able to enhance our reporting tools.
- Flexibility to include accounts that are not part of the accounting software gives us the ability to include non-financial information on our standard reports. Examples that we use in our industry are unit count and $ volume (we are in financial services, so each product has a $ amount that is not necessarily tied to revenue).
- The way the account model is set up allows us to add accounts to all reports at once - we don't need to recreate each report just because there's a new account being used.
- The ability to slice reports on any combination of account, department, company code, etc. gives us flexibility in reporting that was never possible in FRx. We sometimes need a store-by-store report, which in FRx was never practical. In Prophix, it's as simple as dragging "StoreID" into a column or row.
- We have had some difficulty in setting up the link to our general ledger. This has led to some project delays, but we have been able to resolve all of our issues to this point.
- It's not really easy to set up a report where comparative months are in columns. We do have a report set up, but it's not as intuitive as I would like to see.
- It's really hard to think of any real drawbacks or areas for improvement, especially since Prophix is continuing to provide additional functionality with new releases.
- Streamlined budgeting and planning will save us hundreds of hours per year of intensive work.
- Streamlined monthly and annual reporting already saves us 3-5 days per month of headaches.
- Prophix is very simple to use for our end users, so required training time has been near zero for each employee.
We had some initial difficulty in setting up automated data imports. But once we got the queries working, the import routine runs quite well. We set it up to run 3x a day (once overnight and twice during business hours). There is also a way to "import now". So during the month-end close, we can refresh the data on demand as many times as necessary (it usually takes 5-10 minutes to refresh).
The flexibility of on-prem and cloud is not that important to us, as we just need a cloud-based solution. The fact that it's flexible meant that we didn't need to go back to the drawing board because cloud wasn't available. We are finding that it's really nice to have the ability to see reporting from any system - really makes working remotely a much better experience!