Who is this guide for?

Accounts Users and Accounts Supervisors

This report is designed to provide a variance analysis of your average case cost over time. It includes archived matters only. When run in Summary format, each column gives the average case cost between the specified months, so for example, the column headed 0-12 months will give the average case cost for matters archived between 0 and 12 months ago. 5-17 months column will give the average case cost for matters archived between 5 and 17 months ago. The report therefore produces a rolling average that will help to even out any discrepancies caused by particularly high cost cases. The Variance and Percentage variance columns calculate the variance and percentage variance on the two most recent 12 month periods.

Filter options

Fee Earner – Tick this box if you want to show only one or a selection of fee earners. Once the box is ticked all fee earners marked as In Use will appear. You can then tick each one that you want to report on. If you want to see all fee earners, do not tick the fee earner box and it will produce all fee earners.

Franchise – Tick this box if you want to show only one or a selection of franchise categories. Once the box is ticked all franchise categories marked as In Use will appear. You can then tick each one that you want to report on. If you want to see all franchises, do not tick the box and it will produce all franchise categories.

Private or LA – Choose here whether you want to show Private matters only, Legal Aid matters only or All matters.

Branch – Leave set to All for all branches, or select the branch you wish to report on.

Currency – select the currency you wish to report on.

Report Type – Choose from List or Summary (see description above and column produced below for details of differences).


List of columns produced

List Report TypeSummary Report Type
Franchise Category CodeWork Type Code
Work Type CodeMonth 5-17 Case Cost Total
Client No / Matter NoMonth 4-16 Case Cost Total
Fee Earner CodeMonth 3-15 Case Cost Total
WIP ValueMonth 2-14 Case Cost Total
Time Billed ValueMonth 1-13 Case Cost Total
Disbursements Incurred ValueMonth 0-12 Case Cost Total
Total CostVariance
Date ArchivedPercentage Variance