Research indicates that the number of accounting firms looking to diversify their services from traditional bookkeeping and tax preparation to financial planning and advisory is
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.
Microsoft Team(s) and Power BI Enable Better Planning Planning in larger organizations is almost always a team effort. In this blog, I am covering how
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.
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:
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.
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”.
With cloud based accounting systems like Xero, QuickBooks and MYOB data analysis and reporting is typically limited for that reason a variety of add-ons like
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.
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
