The Activity Insight

Use the Activity insight to create reports that will help you analyse the number of transactions across all your clients and the % of change month on month (MoM) and year on year (YoY).

Note: You’ll need to be on our Advanced plan with the Data Health & Insights Add-on in order for data to populate in the Activity insight. If you’re an existing Precision user, you’ll also have access to this insight.

This article is relevant to the Activity insight on the practice level. You can access the article for the Activity stats insight on the client level here.

The Activity insight defaults to the data from the last complete month and works backwards from there.

You are not able to customise the reporting period at this time.


What the Activity Insight Does

The Activity insight is a practice level insight that gives you an overview of the data drawn from the Activity Stats Insight in each client’s account, month-by-month for the last year. This includes MoM and YoY changes, so you can check which of your clients are under – or over – performing.

There are benefits for your practice:

  • Use the information to conduct more informed pricing reviews regularly not just once a year.
  • Due to the visibility you will have to conduct these pricing reviews you may find some opportunities to increase your prices.
  • We do all the calculations for you for all clients so you don’t have to manually run this transaction activity in your G/L one client at a time.
  • Integrate with Go Proposal and create data driven pricing experience for your clients.

The Activity insight has spreadsheet-like functionality. You can choose the columns you want to see and filter the information specific to the purpose of the report, such as by a Client Tag for specific Pricing Package, ie 1-100 transactions, 101 – 200 etc.

For example you can create a report that shows activity for a client tag you have created called 101-200 (transactions). This will enable you to check that the group of clients that pay for 101-200 transactions per month are still operating at that transaction level or have gone over to the next pricing bracket which will require a pricing review meeting and price increase.

Under Custom Insights we have created a template report that you can use called ‘Client Activity Stats Review’.

Let’s take a look how you can build this type of report yourself below.

You can access the Activity Stats insight by going to the client’s Dext account, then Insights in the sidebar >Activity stats.

To build this report I selected the following:

Under Columns (to the far right of the report)

  • Client Name – (which I pinned to the left so so I could scroll the report to see all other columns. To pin a column select the 3 lines at the top of the column and choose Pin Column – Pin Left)
  • Last Sync – important to know when the last time the clients file was synced with Xero/QuickBooks Online
  • Health Score – helps to get an understanding of how healthy the client is and what support may be needed
  • Year End – this will help priortise client work if preparing a bookkeeping for a year end
  • Account Manager 1 – informs you who is responsible for this client for any queries you may have
  • Tags – ensure you have added tags to your clients then this will allow you to filter the report by 101 -200 tag. (see screenshot below showing how to do this)
  • Annual – this will pull in the current period, annual turnover, annual view of Sales, Bills, Credit Notes, Bank Transactions and Annual Total. UntickManual Journals in this section if you don’t want to include it in your report for transaction purposes. (Note: if your client has not been synced to Xero recently it will show the last period that was synced this may be why your periods are different in the report and not all the current period)
  • Average – this will pull the data for Average monthly – Last 12 months for Turnover, Sales, Bills, Credit Notes, Bank Transactions and Total Average Monthly. UntickManual Journals in this section if you don’t want to include it in your report for transaction purposes.
  • Ensure the rest of the columns are unticked Month 1 – Month 12. You could build a different report if you want to review by month activity but for the purpose of this report example these sections have been unticked.

Using Filters

We mentioned above that you may want to use filtering to show the data for Client Tag called 101-200. To do this select Filters to the far right of the report under Columns and choose Tag then type in 101-200. This will change the report to only show activity stats for that cohort of clients.


Saving and Exporting Reports

You can save or export your configurations to Excel, using the buttons in the secondary navigation at the top right.

You can save these configurations in your Activity insight by selecting save. You’ll need to give your insight a name, then decide whether to keep this report configuration private, or share it with the rest of your team. Saved insights can be accessed by selecting Custom insights in the sidebar. Just like custom reports, they can then be edited, favourited, or deleted from this view.


Next Steps:

Take a look at Practice insight to learn how you can create reports that will help you analyse the Health across all your clients enabling you to identify possible issues which will assist you to make improvements to the quality of their bookkeeping.