The following headings detail what is included in each of the default data source and an example use from the pre-set dashboards. Where possible you may wish to re-use these data sources in your own custom dashboards.

All default data sources use the following properties:

This data source contains summary account movements for the last 6 months including the current month. The monthly values are categorised by the account types like Income or Cost of Sales and standard calculation rows like Gross Profit or Net Profit.

As per Movements Last 6 Months, but with monthly movements for the current financial year including actuals up to the prior month.

The Income Last 6 Months chart on the Overview dashboard has filtered this data source to show only Income and Other Income accounts.

This data source contains summary account closing balances for the last 6 months including the current month. The monthly values are categorised by the account types like Asset or Liability and standard calculation rows like Net Assets.

As per Balances Last 6 Months, but with monthly closing balances for the current financial year including actuals up to the prior month.

The Net Worth Last 6 Months chart on the Financial Position dashboard has filtered this data source to show bars for Assets and Liabilities with a line for Equity.

This data source contains Asset closing balances for last month. The balances are categorised by level 2 asset accounts from the original account tree.

The Assets donut chart on the Financial Position dashboard uses this data source to display the top 5 asset balances.

This data source contains Liability closing balances for last month. The balances are categorised by level 2 liability accounts from the original account tree.

The Liabilities donut chart on the Financial Position dashboard uses this data source to display the top 5 liability balances.

This data source includes all the Calxa default KPIs with results for the financial year to date range ending last month.

The Wages to Turnover YTD gauge on the Overview dashboard has filtered this data source to show only the Wages to Turnover KPI.

This data source includes all the Calxa default KPIs with results for last month.

The KPIs Last Month cards view on the Overview dashboard has filtered each card tile to include a single KPI result for last month.

This data source includes all the Calxa default KPIs with results for the last 6 months, including actuals up to the current month.

This data source includes all Calxa default KPIs with monthly results for this Financial Year including actuals up to the prior month.

The Debtor Days Last 6 Months chart on the Cash Management dashboard has filtered this data source to show only the Debtor Days KPI.

This data source provides forecasted cash inflows, outflows and bank at end for next 6 months including the current month.

As per Cashflow Next 6 Months, but for the next 12 months.

The Cashflow Forecast Next 6 Months chart on the Overview dashboard uses the cashflow forecast data source.

This data source is specifically designed to produce a waterfall chart. It provides data for the financial year to date range, ending last month and categorised values by account types like Income or Cost of Sales and standard calculation rows like Gross Profit or Net Profit. 2 values are provided for each category which represent the start and end positions to be used in a range chart. The start and end values allow you to create a waterfall chart where each account type starts where the previous account type ends.

The Net Profit YTD on the Overview dashboard uses the Profit Waterfall YTD Range data source to display movements using a waterfall chart and ends with the Net Profit result as the final bar.