Datarails Reviews & Product Details

It is manipulatable and allows for quick data consolidation once you are in place with correct accounting and querying that all business's likely have to perform before consolidating multiple business enterprise systems into a common ground in Datarails. Review collected by and hosted on G2.com.

One thing that we've found to be a bit of a pain is creating custom columns with more than one function and or condition in the same column. Found that Datarails does not like IF statements with multiple conditions on them, for example saying if blank return value then if not value return "Other" we had to parse this out between two custom columns which makes things a bit convoluted. Review collected by and hosted on G2.com.

The data mapping functionality is a really great way to get your data into a structured table setup that you can access anywhere in Datarails or Excel. We were able to update our GL posting processes to include more detailed descriptions and map those descriptions split by delimiter to the fields we wanted in datarails. We now can instantaneously report on all of our expenses by vendor when that could not easily be done before because of the data being segregated and in different formats. Review collected by and hosted on G2.com.

There should be a simpler way to ensure that signage remains consistent across different data sources. Datarails ought to provide a clear standard for signage conventions when importing data, and it should notify users if the inputs do not follow this standard during the setup of a new data source. Additionally, Datarails should make it straightforward to adjust signage in outputs, such as reports and dashboards, as needed. For example, we wanted all our reports to display Revenues as positive numbers and Expenses as negative. Although we standardized our data mappings, we still encountered issues because working with multiple data sources with inconsistent signage required extra effort to correct and align the signs. Furthermore, when building dashboards, there was no simple way to toggle graphs so that expenses would increase from left to right above the axis. The current workaround is to create an additional amount field that converts expenses to positive values, but this approach is not ideal. Review collected by and hosted on G2.com.

- Saves Time – Automates manual spreadsheet tasks, reducing time spent on data consolidation and reporting.

- Improves Accuracy – Minimises human error by centralising data and standardising financial models.

- Better Visibility – Gives real‑time access to financial performance, trends, and KPIs.

- Enhanced Collaboration – Teams can work from one version of the truth rather than sending spreadsheets around.

- Fast Reporting – Produces management reports and dashboards quickly and consistently.

- Scenario Planning – Makes forecasting and what‑if analysis easier and faster. Review collected by and hosted on G2.com.

- Slow Refresh Times – Large datasets or complex models can cause delays when syncing or refreshing.

- Dependent on Excel – Because it layers on top of Excel, issues in spreadsheets can still cause problems Review collected by and hosted on G2.com.

It’s a centralized FP&A system that’s very flexible and offers a wide range of features. Review collected by and hosted on G2.com.

The setup is significant, and there’s a somewhat steep learning curve. Review collected by and hosted on G2.com.

The best thing about Datarails is that I can keep all my budget numbers in a single worksheet, which is easy to share with others Review collected by and hosted on G2.com.

I like having all my numbers in one worksheet, but I don’t like that every time I update budget numbers I have to download and then resubmit the worksheet. It would be really helpful if there were a way to enter my updated numbers directly in Datarails, without needing to download and submit the file each time. Review collected by and hosted on G2.com.

I use Datarails to analyze data at my company, which has over $4B in Assets Under Management. I appreciate how it helps me quickly pull data from different buildings into one Excel file. If I didn't have Datarails, I wouldn't be able to pull financial data from over a hundred buildings in a single file. What stands out to me is the ability to have multiple data sources and connect them all together. It's especially nice for us when dealing with Nursing Home Provider data, which we can link to financial data from our nursing homes through the same ID. Being able to connect multiple data sources quickly is extremely valuable as it saves a lot of time. Review collected by and hosted on G2.com.

The main room for improvement at Datarails is the dashboards. We have created multiple dashboards in Excel, which we have pushed to the web environment. However, it takes way too long to refresh once you filter to different portfolios or facilities. We have brought this up to the Customer Success Manager, and it appears that Datarails is working on a fix. Review collected by and hosted on G2.com.

- Automating the aggregation of ERP data between different systems.

- Provides useful pre-built financial templates.

- Allows user to work within familiar Excel environment and manually manipulate data. Review collected by and hosted on G2.com.

- Online environment feels complex at first, especially with locating and navigating data sources.

- Relinquish a bit of autonomy by no longer keeping aggregation and calculation of data fully in-house.

- Can be dependent of buy-in and acumen of IT team, creating a stakeholder that needs to help but does not see a lot of benefit. Review collected by and hosted on G2.com.

The dynamic reporting. Being able to just refresh a report and have the figures update and new accounts appear. Review collected by and hosted on G2.com.

The manual syncing with Xero. Due to the limitations of how much data can be synced a day with Xero, we can always sync on demand for our main entity. Review collected by and hosted on G2.com.

I like that it is intuitive, I understand how the data flows, and it speeds up our month end reporting and budgeting processes Review collected by and hosted on G2.com.

There are some items that would be helpful if data rails could do

For example:

-Writing formulas in the data mapper: Why can't these be made to be consistent with excel formulas. It makes it hard to teach the whole team how to map in data when there are nuances like having two equal signs on an IF statement

- When using DR.GET formulas to pull data into workbooks, I wish there was the ability to exclude a certain field similar to the DR.Include parameter Review collected by and hosted on G2.com.

The Excel integration is a big one for me it didn't force us to abandon the way we already work, it just made it better. Consolidating data from multiple sources used to eat up so much time, and now reporting feels a lot more manageable. The dashboards are also a nice touch when presenting to stakeholders. On top of that, the customer support has been amazing. Jodat in particular was fantastic incredibly patient and walked us through the entire process without making us feel rushed at any point. Review collected by and hosted on G2.com.

Some of the widgets are a bit restrictive when it comes to formatting things like font size and style aren't always customizable the way you'd expect. The KPI widgets in particular can be frustrating to get looking consistent across a dashboard. It's not a dealbreaker, but for something client-facing or exec-level, those small visual details do matter. Review collected by and hosted on G2.com.