Online Workspaces are now ready. Some new reports and report template fields, better Xero budget import and general fixes and improvements.


Calxa Online Workspaces are now ready. You can now choose to store your data in our cloud servers enabling access from anywhere with Calxa installed. Additionally we have some new financial statement templates and an improved Xero budget import.


Note: Version 3.0.16 replaces recent release 3.0.14


Planned Release Date: Tuesday, 8 December 2015.


Download Calxa Software


New: Online Workspace Public Beta

The first phase of Calxa Online is officially ready allowing you to setup an Online Workspace. You can use this workspace to save your data in our cloud servers (well, actually they are Microsoft cloud servers, located in Sydney). You’ll then be able to access your budgets and reports from any computer, anywhere with Calxa installed. Check out the Calxa Online Workspace help note for details on how you can start using online workspaces. 


New: Profit and Loss with Last Year Actual

A new financial statement that displays the actual income and expenses over a given date range and compares that to the same date range last year.


New: Profit and Loss Statement now supports KPIs

You can now include the default or your own custom KPIs in the standard Profit and Loss Statement and Profit and Loss with Last Year Actuals templates. 


New: Balance Sheet with Last Year Actual

A new financial statement that displays the actual Asset, Liabilities and Equity at the end of the given month and compares them to the same period last year.


New: Trial Balance with Month and YTD

A new financial statement that displays the debits and credits for all accounts on the selected month and the balances at the end of the same month.


New: Cashflows with Last Year Actual (Indirect)

A new financial statement that shows how changes in net profit and balance sheet accounts affect cashflows over a given date range. It breaks the cashflow analysis down to operating, investing and financing activities and compares that to the same date range last year.


New: Binding Fields for Report Customisation

Over 20 new report template binding fields have been added and made available for report customisation purposes. A full list of new fields is available below, and a comprehensive list is available in the Report Designer: General Concepts help note


Improved: Xero Budget Import

When first connecting to a Xero company there is an option to import the overall budgets. Previously some limitations in the Xero API meant these budgets were only partially imported. Now the primary Xero budget version is imported for all available years. The Xero API does not support tracking category budgets so these are still not available. We are also planning to introduce a separate Xero budget import option so you can import budgets from Xero at any time.


Improved: Chart Number Formatting

The number values on chart labels are now formatted with thousand separators. Previously they did not contain thousand separators so large numbers could be difficult to read.


Improved: AccountRight Live Integration

When performing an import or update from AccountRight Live Calxa can detect if changes are made to a table that is currently being read. In previous version of Calxa this would cause the organization update to fail. We have improved this process to include retry or ignore logic where appropriate. There should now be less occasions where this type of problem causes an organization update failure.


Fix: AccountRight Live Budget Import

In the previous update we introduced a problem associated with creating a new AccountRight Live organisation and choosing the option to import budgets. The problem arose by trying to save budget to header accounts. This has been resolved by ignoring header accounts since they are just the sum of the detail accounts.


Fix: AccountRight Live Purging Historical Data

When starting a new financial year in MYOB AccountRight Live and subsequently updating Calxa it would purge the historical actual data in Calxa. This was not the intended behavior and all historical data is now retained for historical reporting purposes. 


Fix: Advanced Business Unit Selection by Manager

In the previous update the option to select Business Units by manager was broken. This has been resolved.


New Report Template Fields


Budget Summary – 1 Budget Versions

LastPeriodActuals: 

  • Equals actuals for the month or quarter prior to the selected period in the report criteria.

LastPeriodBudgets: 

  • Equals budgets for the month or quarter prior to the selected period in the report criteria.

LastPeriodActualsVariance: 

  • Variance between the selected period and last period actuals.

LastPeriodBudgetVariance:

  • Variance between the selected period and last period budgets.

NextYearBudget: 

  • Equals the annual budget for the next financial year.

Budget Summary – 2 Budget Versions

FullYearReforecast:

  • Equals YTD Actuals plus Forecast Budgets for remainder of the year or more formally YTD Actuals + (Full Year Forecast Budget – YTD Forecast Budgets).

ReforecastVariance: 

  • Variance between FullYearReforecast and the AlternateVersionFullYearBudget.

BudgetVersionsVariance: 

  • Variance between the two budget versions CurrentVersionFullYearBudget and AlternateVersionFullYearBudget.

AlternateSelectedPeriodBudget: 

  • Equals the selected periods approved budget version value. 

NextYearForecastBudget: 

  • Equals the annual budget value for the next financial year on the Current Version budget.


Spreadsheet – 1 Budget Version

YTDActuals: 

  • Equals the sum of the monthly values up to the period where actuals replace budgets. 

Month2Cumulative, Month3Cumulative etc.:

  • This is a series of cumulative values where they equal the YTD value according to the position in the report.

Q5Amount, Q6Amount, Q7Amount, Q8Amount: 

  • Quarterly values for a second year.


Spreadsheet – 2 Budget Versions

BudgetVersionsVariance: 

  • The variance between both budget versions.

YTDActuals: 

  • Equals the sum of the monthly values up to the period where actuals replace budgets.


Cost Centre Variance

 FullYearBudget: 

  • Equals the annual financial year total budget.

UnspentBudget: 

  • Unspent or unearned portion of the budget equals Full Year Budget – YTD Actuals.

SpentPercent: 

  • How much of the annual budget has been spent or earned as a percentage.

RelativeVariance: 

  • The current relative variance field breaks the templates if included
  • This should be a percentage variance field = Variance / Budgets
  • Please include string value with N/A for divide by zero as well as decimal value.

 YTDRelativeVariance:

  • Same as RelativeVariance except using YTD values


Notes

BudgetValue:

  • The budget value associated with the given note. Previously only Month and Note were available.


All Applicable Templates

 AccountTypeId:

Identifies the type of account. Now you can create custom fields or formatting rules with conditional logic that identifies the account type.