loader image

Share:

Share on facebook
Share on twitter
Share on linkedin

Reporting & Planning Redefined: Xero | QuickBooks | HubSpot | Dear | MYOB

New Features in Acterys Apps

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.

Here are the details:

Improvement relevant to all Apps

New Currency Wizard

Acterys-Currency-Wizard-
Acterys-Currency-Wizard-

This wizard enables users to choose an unlimited number of currencies that are then loaded in a currency data model that is automatically updated with the latest foreign exchange rates. In all relevant ledgers (e.g. GL, invoices, etc.) new views enable users to retrieve their data in local currency and the group currency.

Improvements For Xero Reporting & Budgeting

Significantly Improved Xero Power BI Reporting Template

The completely overhauled Power BI Xero report now includes budgets and the new variance visual with “small multiples” analysis support:

Power-BI-Desktop-Xero-Dashboard
Power-BI-Desktop-Xero-Dashboard

Management Dashboard with Actual Budget Comparisons

Acterys now automatically loads Xero budget numbers that can be updated with all Acterys planning options.

Consolidate Group Performance Power BI Tool tip
Consolidated Group Performance Power BI with Tool tip
Acterys Xero Template - Power BI - Debtor - Creditor
Acterys Xero Template – Power BI – Debtor – Creditor
Power-BI-Xero-Repeating-Invoices
Power-BI-Xero-Repeating-Invoices

New “Repeating Invoices” table supporting better forecasting

Repeating invoice details that enable precise forecasting for future revenues are now available in the Xero App.

Trial-Balance-Acterys Xero Template - Power BI Desktop
Trial-Balance-Acterys Xero Template – Power BI Desktop

New “Trial Balance Report”

A new table and related reports are now available in the Acterys Xero App that include “unrealised currency gains” and other items that are not available via the conventional Journals API endpoint.

Cash Flow Planning
Cash Flow Planning

New Xero Cashflow Forecasting Template

This template includes fully customizable, indirect cash flow report structures where users can amend/update future projections with all Acterys features.

New Tables for Xero Reporting

  • Xero Summary Budget Table and reports
  • “Repeating Invoices”
  • Repeating Invoice details
  • “Trial Balance Report”
  • New “Users” table
    This table includes all details of all user across all Xero companies that are connected with Acterys
  • New “Quotes” table for Xero
    This table includes all details of quote in all companies that you have connected to Acterys.
  • New “Assets” table for Xero

Xero Invoice Cube Deprecated

Due to very limited use we are no longer automatically creating/updating the xero cube. The detailed Xero invoices table that’s for most analytical requirements the better choice is of course still available.

Upgrading To The New Template

Existing customers that use an older version of the Acterys Apps please contact support to discuss the best upgrade options.

Start Your Trial Now!

Recent Posts

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

The Acterys Modeller is cloud based service (with on-premise installation option) that allows enables business users to automatically create optimal analysis models (star schema data warehouse) from a variety to ERP. accounting and SaaS systems. The created models are write and planning enabled and can be edited and extended as needed by business users e.g. for adding new products/attributes, account mappings, new scenarios etc.

Tags