Acterys Apps Archives

How to implement account mappings and sub group consolidation in Dynamics, Xero, QuickBooks, MYOB, etc.

February 12, 2021

A typical need for finance professionals is mapping accounts or other system entities (companies, products, contacts, etc.) in a different way than they are structured in their source system. Acterys provides a very simple way to do this either in Excel using the Acterys Excel Add-on or in the Acterys Modeller. Excel is typically the easiest option as you have all Excel features like copy/paste, drag and drop, validate, etc. at your disposal.

Collaboration in the Planning Process

January 21, 2021

Microsoft Team(s) and Power BI Enable Better Planning Planning in larger organisations is almost always a team effort. In this blog I am covering how

How to Back Up Data For Xero, HubSpot, QuickBooks, MYOB, Salesforce, Dear Inventory

December 27, 2020

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.

How To Connect Xero to Power BI Desktop

August 17, 2020

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:

Xero Consolidation Reporting Multiple Accounts into Power BI and Excel

June 10, 2020

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.

Acterys 2019: A Year in Review

December 30, 2019

In 2019 we continued to execute on our vision end to end performance management for Power BI and Excel: handling 3-digit new customer numbers and a growth of 400% YOY meant dealing with a variety of real-life requirements that none of us could have originally predicted. In this context we would like to thank all of our customers who made it possible and embarked with us on this adventure of taking analytics and planning processes “to the next level”.

How Acterys Compares to Spotlight, Datadear, Futrli

July 29, 2019

Acterys, Spotlight, DataDear and Futrli Compare With cloud based accounting systems like Xero, QuickBooks and Myob data analysis and reporting is typically limited for that

Financial Reporting in Excel: Best Tips for Success

July 13, 2019

In this article I will cover a few helpful tips & tricks to improve your financial reporting and planning with Excel. In more than 20 years in the BI industry I still have yet to see a more versatile solution. All of us are still likely only using a fraction of what this tool can do and often -particular with all the game changing features added in the last few years- not up to its current capabilities.

Acterys 2019.2 Planning, Performance Management & Consolidation

July 12, 2019

End to End Performance Management on a Unified Platform For Power BI, Excel and Power Platform Despite adding a 3-figure number of companies to the

Interview with our CEO

January 4, 2019

At the beginning of January 2019 we met with Martin Kratky, the CEO of Managility and the FP&A Software Group, in our development centre in Byron

LOGIN

LOGIN

Announcements:

Category: Acterys Apps