Immigration practice software

Spreadsheets vs a case management system for a small immigration practice

Spreadsheets work for the first few cases. Here is where they start to fail an immigration practice, and how to tell when it is time to move on.

5 min read BeYou4U Team

Spreadsheets are a sensible way to start tracking immigration cases: they are free, familiar and flexible. They become a risk when the practice grows past what one person can hold in their head. The usual breaking points are deadlines hidden in cells nobody checks, several versions of the same file, no record of who changed what, and sensitive client documents scattered across email. If your team regularly asks “where is this case?”, you have probably reached that point.

This article compares the two honestly, so you can decide based on your own practice rather than a sales pitch.

What spreadsheets do well

  • No cost and no setup. You can start tracking cases today.
  • Total flexibility. Add a column whenever you need one.
  • Everyone knows how to use them. No training required.

For a sole adviser with a handful of open cases, a well-kept spreadsheet can be perfectly adequate. The problems are not about the tool being bad; they are about what happens as the number of cases and people grows.

Where spreadsheets start to fail

Deadlines that nobody sees

A date in a cell does nothing on its own. Unless someone opens the file and scans the right column, a submission deadline or an expiring document passes silently. Conditional formatting helps, but only for the person who looks.

Version chaos

“Cases_final_v3_JS.xlsx” is a familiar sight. When files are copied, emailed or edited offline, nobody is certain which version is current, and updates get lost.

No audit trail

If a decision is questioned months later, can you show who changed a case’s status and when? Most spreadsheets cannot, or only partially. A dedicated system records every change automatically.

Documents live somewhere else

The spreadsheet tracks the case, but the passports and statements sit in inboxes, chat apps and shared folders. Matching documents to cases is manual, and sensitive files end up copied in many places. Our guide on how to stop chasing clients for visa documents explains what changes when documents are tracked per case instead.

Clients cannot see anything

A spreadsheet is internal by nature, so every status question becomes a phone call or an email. A client portal answers those questions without staff involvement, as we describe in why every immigration consultancy needs a client portal.

Data protection is the hidden risk

A spreadsheet of client names, nationalities, passport numbers and case details is personal data, and much of it is sensitive. Spreadsheets are easy to email, download and copy to personal devices, and hard to restrict to the people who need them. Whatever you use, it should support your obligations under UK data protection law; the ICO guidance for organisations is the starting point.

Signs it is time to switch

  1. More than one person updates the case list.
  2. You have missed, or nearly missed, a deadline.
  3. Clients call regularly to ask about progress.
  4. You spend time each week matching documents to cases.
  5. You could not easily show the full history of a case if asked.
  6. Sensitive documents arrive by email or messaging apps.

Two or more of these usually mean the time lost to workarounds already costs more than a system would.

What a case management system changes

A system built for immigration work gives each case type its own stages and document checklist, attaches deadlines to cases with reminders to the right person, records every change, and gives clients a portal for uploads and status. The point is not more software; it is fewer things that depend on someone remembering to check. Our buyer’s guide to immigration case management software lists the features to compare.

Making the move without disruption

  • Start with new cases in the new system, and move open cases across in batches.
  • Use your spreadsheet columns as a guide to which fields you need.
  • Define your case types and document checklists before importing anything.
  • Keep the old spreadsheet read-only for reference, then archive it securely.
  • Ask the supplier whether they will import your existing cases for you.

What it costs to stay on spreadsheets

The spreadsheet itself is free, but the time around it is not. Add up the hours spent each week answering status calls, chasing and matching documents, and double-checking dates, then multiply by your hourly cost. Add the risk of a missed deadline or a data breach. For many small practices, that total is higher than a monthly subscription, and it grows with every new case.

Try it on your own cases

CaseDesk is the case management system we built for immigration and visa advisers, with stages, document checklists, deadline reminders and a client portal. See how it would handle your own case types on CaseDesk for immigration advisers, or contact us to talk through your current spreadsheet.

Frequently asked questions

Can we keep using spreadsheets for reports?

Yes. Most systems let you export data, so you can keep any reports you rely on.

Is a shared online spreadsheet good enough?

It solves version chaos but not missed deadlines, audit trails, document tracking or client access.

How long does switching take?

Setting up case types and checklists usually takes days, not months. Moving open cases can happen gradually.

Keep reading

All articles