Acterys Blog

Join us as we uncover the latest trends, tips, and success stories in the ever-evolving landscape of business intelligence. Ready to unlock the power of your data?

With cloud-based systems like Xero, QuickBooks, HubSpot, MYOB, Salesforce it is important to have a backup of all data. Not just as a safety precaution when the system is down but also for an easy migration to a new system. In the following step by step instructions, we demonstrate how you can achieve a backup in SQL Server with Acterys.
dashboard
In this blog we cover how you can realize a rolling forecast with Power BI (this approach works equally with Excel Pivot Tables). A rolling forecasts is a widely used concept for financial analysts that shows actual data until a cut off date and after that future assumptions like budget or forecast values. It looks something like this:
performance overview
Following the tremendous success of these solutions with now more than 1000+ companies under management we have made significant improvements to all Apps (Xero, QuickBooks, HubSpot, MYOB, Dear Inventory) in particular the Power BI related Xero Reporting and Budgeting aspects. These include nearly all of the most asked for features on our Customer Success Platform and then some more.
planning power bi
Acterys enables you to connect unlimited Xero companies within minutes to an optimal Power BI Desktop data model and an extensive set of Power BI dashboards and Power BI reports that cover all typical requirements:
acterys template
Acterys 20.1 Is Here! Acterys 20.1 introduces revolutionary, new features for analytics and planning processes setting new standards for: Versatility Ease of Data Integration and Value For Money
cosolidation xero
The Xero accounting system is getting widely accepted in larger organisations with requirements to create consolidated financial statements for multiple Xero companies. In this article I would like to explain how you can completely automate the consolidation process and add  analytics options with Power BI or create dynamically updating reports in Excel.
Rolls royce car
I have seen a lot of change in the Financial Planning & Analytics (FP&A) space over the last 20 year but one thing was constant: it’s not cheap. I just came back from a conference where I got first hand proof when asking about the required investment for specialized FP&A software. The answers I got from some of the now listed vendors (or backed by heavy VC investments – investors that likely want to see quick returns…) were in the range of $80k+ for software and then typically twice that
Illustration
Online Analytical Processing (or OLAP) is an important concept in the analytics and planning space that was introduced by solutions like Planning Analytics (TM1), Jedox, Infor Alea and others. In this article we cover a comparison between different approaches.