Jirav vs. Quantrix

I feel that Jirav would be best suited for companies with less than 75 employees that need a more robust software than Fathom (Quickbooks Onlne integrated FP&A tool based in Australia) that is very customizable, with simple revenue modeling, few personnel changes every month, few departments, no multi currency, and need collaboration only with top-level personnel. I think Jirav is a product that is being highly recommended in the accounting industry for outsourced accounting firms, but accounting only looks at historical information and there needs to more finance industry influence, approval, and input so they can improve their product.

If you find yourself in the ocean of traditional spreadsheets, overwhelmed by broken links, errors, model audit problems, hardwiring, etc. here is a lifebuoy for you. If you want to have full flexibility in your budgeting and forecasting in contrast to ERPs with rigid structures and one-size-fits-all concept. If you are small or medium size company and do not want to invest in costly enterprise solutions. If you need a fast implementation https://youtu.be/5W_q5Xhw5fg

• Jirav integrates well with Quickbooks Online (QBO), and I like how you can easily customize the reporting presentation by combining GL accounts and showing more or less details as needed for managerial reporting
• I like that Jirav is browser-based and that I can easily share reports with internal and external parties for comments
• I feel more confident using Jirav than I do with Excel because there is more data validation, and some notifications will appear if there are errors in the model
• The sales capacity model and ramping employees schedule that their implementation / professional services team built for us works well overall (with some limitations)
• Ideally, having a direct integration into Jirav would be great for all our data. However, some of our software didn't have a direct integration, so I was glad that Jirav offered the ability to use a connected Google Sheet that lets me input data that can be imported directly into the system

• Building complex financial planning model availing of a multidimensional data structure coupled with a powerful formula language, with the immediacy and intuitiveness typical of spreadsheets
• Implement quickly model modifications (new products, new scenarios, new time periods) simply adding new "items" to "categories" (corresponding to dimensions in a multidimensional data model)
• Scale up models to very large datasets with very fast computation times
• Easily import data from text files, other Quantrix models and external databases via DataLink and DataNAV
• Save snapshots of tables computed in Quantrix to external databases via DataPush

Incentivized

• At times, I feel that Jirav is too customizable. It would be great if they could tailor the system to be more industry-specific. For example, if the system could provide standard formulas for SaaS industry metrics already within the system, then that would have saved me a ton of time with having to create the metrics myself. The formula creation for metrics is quite tedious as well because you can only do simple calculations, such as A + B or A x C. You cannot do A + B + C or A x B x C.
• I struggle with the way they have their staff planning set up because I have to reimport an Excel every month with all the changes (new hires, terminations, pay changes), and the changes appear to be retroactive on reports, which doesn't make sense if someone receives a raise or pay change during the year. It would be much easier for planning for bookings if they could add a column for quota by salesperson.
• If there are notifications of errors in the model, then the notifications will continue to present themselves after I resolve the issue. It would be nice if I could clear out notifications I know are not relevant anymore. I also still find errors in the system that I would have expected the system to notify me about, such as Assumptions that are set up but they are not included in any formulas, so I should delete that assumption to prevent anyone from thinking changing that assumption will impact the model.
• There is some functionality for sharing reports and information, but there is not enough granularity in security settings to allow me to share certain information easily. For example, if I want to share information with managers to manage their departments' budget, but also not see their boss' compensation, then it takes some work to set that up. Or, if I want to share a report with a recruiter of planned headcount and salary, then I need to export it to Excel first and delete Actual headcount and salary, so they don't see current employees' compensation (including the person's boss' salary).
• Customer and vendor names do not import, only the totals, so if you look at Actuals vs Plan, the actuals will show a total figure and the plan will show detail, creating the need for an external and manual reconciliation
• There is no multi-currency available
• Scenario analysis can be difficult to do quickly. For example, if I want to see the plan with planned hires and without planned hires, then I would need to create two separate plans, individually select and delete the planned hires in one plan and keep then in another plan, which is time-consuming
• Using Google Sign-In causes the system to time-out frequently for me, so I get kicked out of the system and have to log back in. If I have multiple tabs of Jirav open, then re-logging in sometimes doesn't bring me back to where I was originally at.
• You can export reports to Excel, but there are no formulas of the calculations, which makes it more difficult to understand how calculations are being performed unless you look in the browser and dig into the calculations. This also might make it more difficult if you decide to go to another software in the future since you may need to start from scratch in the next software
• Seasonality has been difficult to model. For example, the way our model is set up, I can use an assumption for Q1, Q2, Q3 and Q4. However, if I update Q3 for this year, then it also updates Q3 of all subsequent years, which I don't want. A more complex model and additional maintenance would be needed to accomplish more accurate seasonality planning

• Hard to be critical of the Quantrix team as I know they strive to produce the best product possible. I suppose the next thing on my wish list would be the application of the new Solver functionality to be available in the Qloud.
• A big help for new users would be a good book on transitioning from Excel or other environment into Quantrix. I know first hand it can be difficult to transition when having to learn the program through a help guide, forums and tech support. I had a lot of trial and error in my journey to producing the desired models. On one hand it was a valuable method as it taught me a lot of what not to do, but I will admit it was not the most efficient way to do things.
• Would also love to see local user groups being formed at some point in the future. Quantrix puts on a fantastic conference once a year in beautiful Maine, but it is a big journey for someone in Southern California (and limited to one or two days a year). I would like to see some local chapters formed in different areas of the country so local Quantrix users can get together more often and collaborate (maybe a quarterly or semi-annual meetup?). Our Quantrix community is still relatively small and may be a difficult task for some areas, but is also the very reason why this would be great idea.

For a newbie it can be difficult until you get the hang of the system. Quantrix is a very logical system, once you understand its underlying ideas.

Fathom was the cheapest and most basic as an add-on directly to QuickBooks Online Plus, but you lose functionality with Fathom if you use QuickBooks Online Advanced (QBOA). The main loss of functionality for me was the lack of multiple department reporting, which was absolutely necessary for my analysis. Jirav was half the price of Moscaic.tech, but I've heard Mosaic has standard metrics for the SaaS-industry, which is appealing after going through the tedious process of setting up metrics in Jirav. QBOA has additional reporting than QBO Plus, but not enough robust features for planning and modeling. PlaceCPM is Salesforce-based and a I felt having a strong Salesforce admin that can great reports made their unnecessary, and I feel like most of the time you need a Salesforce admin just to run Salesforce. Cube, Vena and OnPlan are spreadsheet-based, but I don't want to use spreadsheets. Prophix, Board and Anaplan seem outdated. Workday was more than what I needed

Overall, I was not part of the ultimate decision to purchase Quantrix. I terms of user-friendliess and robust reporting capabilities I do think Tableau has Quantrix outclassed. That being said, Quantrix does provide more in-depth analyses for our relevant data and provides better modeling for our forecasts out of the box. The accuracy of the tools output is also much better

Incentivized

• 1-3 day shortening of post-month end close analysis from integration with our accounting software
• Elimination of several manual Excels related to headcount variance, salary variance, and planning

• Capacity forecasting used to take hours to calculate with a ton of manual modifications. Quantrix has automated that so a model can be updated at any time with a click of a button
• The accuracy of the models is incredible. It took some tweaking to add in data scubbers, but now it runs almost flawlessly
• The confidence the management teams have in the output of the model is amazing. Before, people would question the output, have you rebuild it, and then compare. Now the report comes out and the output has high confidence.

Incentivized