This page answers common questions about reports, targets and work in progress (WIP) in Legalsense. For an overview of reporting, see the article ↪ Reports.
In this article
- 01How do I load the new year's targets?
- 02How do I move my saved reports from last year to this year?
- 03Why does the export differ from the filtered view?
- 04Why can a user see other leverage teams' or practice groups' data?
- 05Why is the work in progress value set to 0 or incorrect?
- 06Why isn't billed revenue visible in all reports?
How do I load the new year's targets?
Targets don't carry over to a new year, so you add them for each user yourself. Until you do, reports and dashboards count the new year's target as 0, % Realisation shows 0, and users without a target stop receiving the personal performance email.
Before you start
- Targets must be active for your firm. If you don't see a Targets tab on a user's profile, contact Legalsense Support to activate them.
- You need permission to manage users.
- If your firm's standard number of hours has changed, first update the default Total time target and Billable time target under Settings → General → System, in the Reporting section. Legalsense uses these yearly values to pre-fill new targets.
Add the same target for several users at once
- Go to Users → Users.
- Select the checkboxes of the users who get the same target.
- Click New target.
- Fill in From date and to (for example, 1 January 2027 to 31 December 2027), and the Total time target, Billable time target and Amount.
- Confirm to create the targets.
New target window opened from the user overview, showing the From date, to, Total time target, Billable time target and Amount fields.
Legalsense creates the target for every selected user and lists them in a confirmation message. If a user already has a target that overlaps the new period, Legalsense leaves that user unchanged and lists them separately.
Note: This gives every selected user exactly the same values, and Legalsense doesn't calculate the Amount for you here. If users have different targets, add or adjust them per user as described below.
Add a target for one user
- Go to Users → Users and open the user.
- Open the Targets tab and click New target.
- Check the period. Legalsense fills in From date with the day after the user's last target ends, and to with 31 December of that year.
- Enter the Billable time target. Legalsense calculates the Amount from these hours and the user's rate, but you can change it.
- Click Save.
New target form on a user's Targets tab, showing the pre-filled period and the calculated Amount.
For a description of every target field, see the article ↪ Targets.
Check which users still need a target
- Go to Users → Targets.
- Set From date and To to the new year.
- Select Include active users without target.
Targets overview with Include active users without target selected, showing users without a target for the new year.
Users without a target appear in the list, so you can see who you still need to add. Click Export to download the overview to Excel.
Note: You can't import targets from Excel yourself. Legalsense Support can import them for you from an Excel file; this is charged.
How do I move my saved reports from last year to this year?
You don't need to move them. A report doesn't belong to a year, but a report whose date filter uses fixed dates keeps showing those dates. Update the dates in the report, or switch to a relative date filter so the report moves with the calendar.
You need permission to manage reports for the steps below.
Change the period of a report
- Go to Reports → Reports and open the report.
- Click Edit structure.
- In the Filters section, change the dates of the date filter, such as Date time entries or Invoice date.
- Click Save report & refresh.
Edit structure page of a report, showing a Date time entries filter with the Between operator and its From date and to fields.
Keep last year's report and make a copy for this year
- Open the report and click Clone report.
- Change the name, which Legalsense fills in as the original name followed by "(copy)", and click Save.
- On the Edit structure page that opens, change the dates of the date filter.
- Click Save report & refresh.
Important: A cloned report doesn't include the original report's Extra conditions, subscriptions or frozen history. Add any extra conditions to the copy again. Allow filtering by viewer is also switched back on in the copy.
Make a report follow the calendar automatically
A date filter with the Between operator always uses the dates you entered. To avoid updating a report every year, use a relative filter instead. Legalsense then calculates the dates from today each time the report runs.
- This year to date: choose More recent than and enter 1, Calendar, Years.
- Last year: add two filters on the same date field: More recent than 2, Calendar, Years, and Older than 1, Calendar, Years.
Date filter in Edit structure with the More recent than operator, showing the Quantity, Kind and Units fields set to 1, Calendar, Years.
Note: Report subscriptions use the report's filters. A subscription to a report with fixed dates keeps emailing the old period until you update the report. See the article ↪ Report subscriptions.
Why does the export differ from the filtered view?
Usually because the export and the screen don't show exactly the same thing. An export always contains every row that matches your filters, across all pages, not just the rows on screen or the rows you selected. On screen, Legalsense shows 500 rows per page. Some overviews also export different columns, or limit the number of rows on screen but not in the export.
Before you export, apply your filters first (for example, click Filter report or Search), so the screen and the export use the same filters.
Advance overview
In Invoices → Advance overview, the export uses the same filters and sort order as the screen, but different columns. Some export columns are also calculated differently, so the amounts can seem to disagree.
Advance overview with filters applied, showing the Unsettled advances column and the Export button.
Rates report
In Reports → Rates, the screen shows at most 10,000 rows, but the export has no limit. Legalsense shows a message about this above the results. The screen shows the first 10,000 rows Legalsense finds, sorted, so rows can be missing on screen that are in the export. Use the filters to bring the results below 10,000 rows if you want the screen and the export to match.
The export also contains five columns that aren't shown on screen: Matter number, Client number, Employee number, Current Pricing Scheme and Price Template Name. See the article ↪ Reporting on rates.
Rates report, showing the message about the maximum of 10,000 results above the table.
Reports with a limit on the number of results
In a report you create under Reports → Reports, the limit you set in the Limit results section on the Edit structure page applies to the screen and the export alike. Leave it empty to not limit the number of rows. Legalsense applies the limit after sorting, so if you sort by clicking a column header, a different set of rows appears, and the export follows that sort. The totals only cover the rows within the limit.
Edit structure page of a report, showing the Limit results section below Sorting.
Note: A report subscription leaves out the report's pinned filters, so an emailed report can contain more rows than the report shows by default on screen.
Why can a user see other leverage teams' or practice groups' data?
Because most reports aren't limited by team. Access to a report is all or nothing: anyone who can open a report sees all the data in it, unless the report's own filters narrow it down. Legalsense doesn't automatically hide other leverage teams' or practice groups' data from a user.
Where Legalsense does limit data to the user's own team
- Practice group performance, Leverage team performance and Office performance under Reports → Performance only show the user's own practice group, leverage team or office.
- The Practice group dashboard and Leverage team dashboard show the user's own practice group or leverage team, unless the user has permission to switch to other dashboards.
Firm-wide pages, such as Firm performance, the Firm dashboard, Rates, Budgets and the advance overview, always show data for the whole firm. Which of these pages a user can open depends on the permissions of their user groups.
Limit a report to the viewer's own team
- Go to Reports → Reports, open the report and click Edit structure.
- In the Filters section, add a filter on Leverage team or Timekeeper practice group, with the value Current user leverage team or Current user practice group.
- Click Save report & refresh.
Edit structure page of a report, showing a Timekeeper practice group filter set to Current user practice group.
Each user who opens the report now only sees data for their own leverage team or practice group.
Important: Add this filter in Edit structure, not as a pinned filter on the report page. If Allow filtering by viewer is on, which it is by default, users can change a pinned filter, for example to another practice group. To stop viewers from filtering at all, turn off Allow filtering by viewer under Report properties.
Report properties page of a report, showing the Allow filtering by viewer option.
Note: Legalsense looks at the timekeeper's practice group or leverage team on the date of each time entry. A practice group report therefore includes the work of people who were members on that date, including their work on matters of other practice groups. To filter on the matter's practice group instead, use Matter practice group.
Limit who can open reports
Reports are organized in report groups. When you create or edit a report group, choose which user groups may view its reports. Users with permission to view all report groups can still open every report. See the article ↪ Reports.
Check a user's permissions
Go to Users → Groups to see which groups a user is in, and open Permissions per group to see what each group allows. You can add users to a group or remove them from it yourself. To change what a group allows, contact Legalsense Support.
Why is the work in progress value set to 0 or incorrect?
If your work in progress (WIP) shows a balance of €0, or a value that looks wrong, check the following:
Legalsense values WIP by pricing unbilled time against the price template set on the matter. For an hourly-rate template, this means hours multiplied by the set hourly rates. If the WIP balance is €0, the hourly rate set on the matter is likely incorrect.
Pricing information section of a matter's detail page, showing the Pricing scheme and the hourly rates in its Pricing list.
Note: When you change an hourly rate, for example from €0 to €200, Legalsense recalculates the WIP value of the affected time entries in the background, so the amounts update shortly after the change. On the matter page, amounts that are still being recalculated are marked with an hourglass, and Legalsense shows the message Some time entries are being updated in the background. When billing, the value is always recalculated immediately.
Time entries section of a matter's detail page, showing the message that some time entries are being updated in the background, with an hourglass next to the amounts that are still being recalculated.
Rates can also be set per period, so a time entry from last year may be linked to a different hourly rate than a more recent one.
On a fixed-fee matter, WIP is capped at the value of the fixed fee. Until that amount is reached, WIP is calculated using either the standard hourly rates of the timekeepers who logged time on the matter, or the client's rates, depending on the Scheme to calculate work in progress setting of the fixed fee.
Why isn't billed revenue visible in all reports?
Legalsense distinguishes between fee revenue and other revenue, which affects which reports show which figures.
- Fee revenue is always based on work performed, recorded through time entries. Because it's tied to a timekeeper, you can also request it per user, in a report of the Time and fee, billed and unbilled type.
- Other revenue comes from invoice lines you add manually to an invoice. It's assigned only to the matter and the debtor, not to a timekeeper, so it only appears in reports of the billed amounts type.
For more on the report types, see the article ↪ Reports.
Comments
0 comments
Please sign in to leave a comment.