How to replace spreadsheet case management in legal and immigration teams

Signs the spreadsheet has become the risk

Spreadsheets are a reasonable way to start tracking cases. They become a risk gradually, usually when the team grows or the caseload rises. These are the signs we see most often:

• Several people edit the same file, and nobody is sure which copy is current.
• Deadlines live in a column someone has to remember to filter, plus individual calendars.
• Documents sit in shared folders and email threads, named inconsistently.
• A manager cannot see, without asking, how many active cases each caseworker holds.
• Clients email for updates because they have nowhere to check progress.
• When something goes wrong, there is no reliable record of who changed what, and when.

What a case management system needs to do

Deadlines that cannot be missed quietly

Every date that matters belongs to a case as structured data, not as text in a cell: hearing and filing dates, submission and appointment dates, visa or permission expiry dates, and internal milestones. The system should remind the owner in advance, escalate to a manager when a task is overdue, and keep a record that the reminder was sent.

Clear ownership

Each case has one responsible person at any moment, and reassignment is a recorded event rather than an edit to a name column. That makes handovers during leave or staff changes safe, and it makes workload visible.

Documents attached to the case

Documents should be stored against the case they belong to, with a checklist of what is required for that case type and what has been received or rejected. Access follows the case permissions, so a sensitive document is not visible simply because someone can open a shared folder.

Audit history

An audit log records who created, viewed or changed a case, a date or a document, and when. It answers the questions a manager or a complaint will eventually ask, and it should be impossible for ordinary users to edit.

Permissions that match your structure

Caseworkers see their cases, supervisors see their team, and partners or directors see everything. Some firms also need separation between offices or between client groups. These rules are designed up front, because adding them later means retesting the whole system.

Client communication

A secure client portal lets clients see status, upload documents against a checklist and reply to requests, which removes a large share of "any update?" emails. It is often the second phase, once the internal workflow is settled.

Reporting

With structured data, the weekly reports stop being a manual exercise: cases by stage and owner, approaching deadlines, overdue tasks, and how long each stage takes.

A practical way to make the move

1. Map the lifecycle of each case type: stages, the documents needed at each stage, and the dates that matter.
2. Agree roles and permissions, including who can reassign, close or delete a case.
3. Decide which deadlines trigger reminders and escalations, and to whom.
4. Build and test the core: cases, owners, tasks, deadlines, documents and the audit log.
5. Migrate live cases first. Keep closed cases in a read-only archive until there is time to import them properly.
6. Run the old spreadsheet in parallel for a short, fixed period, then retire it.
7. Add client access and management reporting once the team relies on the system.

Off-the-shelf or custom?

Specialist practice-management and immigration case software exists and suits many firms, particularly where the work matches the product’s case types and forms. A custom case management system makes sense when your case types, approval steps or reporting do not fit those products, when you combine casework with other services such as education or recruitment, or when you need one system across several business lines. Our guide to custom and off-the-shelf CRMs covers the same trade-offs in more detail.

As a guide, AM-IT case management systems start from £10,000 (GBP, excluding VAT), with data migration from £800, after a paid discovery from £750. More on how we approach this sector is on our legal and advisory page.