The Activity Stats insight gives a breakdown of the key trading statistics of a company, with a focus on volume, e.g. number of bank transactions for the period. Designed for accountancy firms utilising proposal tools such as GoProposal to quickly calculate pricing when a client is up for renewal.
This article is relevant to the Activity stats insight on the client level. You can access the article for the Activity insight on the practice level here.
By default, the activity stats insight calculates statistics for a rolling 12 month period, starting from the last complete month, and working back from there. However, you can select a date range and Data Health & Insights will do its best to segment your date range into monthly slots.
You can access the Activity Stats insight by:
- In the client’s account, go to Insights in the sidebar, Activity stats.
The insight gives you an overview of the following data:
Bank Transactions
Xero: Bank Transactions are the number of bank statement line items. So reconciled or unreconciled.
QuickBooks Online: Bank Transactions that are categorised in QuickBooks Online as a ‘bank type’.
Sales, Bills & Credit Notes
We are tracking invoices posted to the sales and purchase ledger. We don’t include ‘spend’ or ‘receive’ money transactions which are posted directly to the general ledger from the bank.
Manual Journals
This is the total number of manual journals posted in the period run.
Turnover
The Activity Stats insight uses the following logic to determine the Turnover calculation:
The NET value of all transactions in the selected date range that have an Account Type of either Revenue or Sales.
TIP: Note that the Account Type Other Income is not included in this calculation.
This gives you some flexibility in determining this Turnover figure, as the Account Type can be modified for each account in Xero.