Moving a law firm from spreadsheets and paper files to practice management software
By the ChamberOne teamUpdated 7 minute read
Most small firms run on a matter register in a spreadsheet, a diary, a folder of Word templates and an accounts package that does not know what a matter is. It works, until two people need the same information at once. Moving to practice management software is less about the software than about deciding what to bring across and in what order. This is a plan a firm can carry out alongside normal work.
Decide what problem you are solving
Write down the two or three things that go wrong today. Typical answers: nobody can see all upcoming dates in one place; time is recorded late or not at all; a file cannot be found when its lawyer is out; invoices go out weeks after the work. These become the test of whether the move worked, and they decide which parts of the software you switch on first.
Take stock of what you hold
- The client list: where it lives, and how many duplicates it has.
- The matter register: open matters, closed matters, and how each is numbered.
- Dates: hearings, deadlines and renewals, and whose diary they are in.
- Documents: shared drive, email attachments, paper.
- Unbilled time and unpaid invoices.
- Templates and precedents the firm actually uses.
Clean before you move
Software will faithfully import a mess. An afternoon spent on the spreadsheet first saves weeks later.
- Merge duplicate clients and settle on one spelling of each name.
- Give every open matter a client, a responsible lawyer, a type and a status.
- Decide on one matter-numbering scheme and whether old numbers are kept.
- Mark closed matters as closed. You may decide not to import them at all.
Move in this order
- Clients and contacts.
- Open matters, each linked to its client and its lawyer.
- Every future date: hearings, deadlines, limitation dates, renewals. This is the step that must be complete on day one.
- Templates the firm uses weekly.
- Documents for open matters, starting with the active ones. Closed files can stay where they are, with a note of where that is.
- Billing: opening balances for unpaid invoices and unbilled time, from an agreed cut-off date.
Pick a cut-over date and run both for a short time
Choose a date, ideally the first of a month, from which new matters are opened only in the new system and time is recorded only there. For two to four weeks keep the old diary alongside and compare the two every Friday. Any date that is in one and not the other is found while it is still harmless. Then retire the old diary formally, so nobody keeps using it out of habit.
Bring people with you
The system only works if the whole firm uses it, including the most senior lawyer. Start with the habits that pay back immediately: entering the next date after every appearance, and recording time the same day. Give one person in the firm the job of answering questions for the first month. Leave the more advanced features until the basics are routine.
Questions to settle with any supplier before you start
- Can we import our client and matter lists from Excel or CSV ourselves, or does the supplier do it, and at what cost?
- Can we export all our data, in a usable format, if we leave?
- Where is the data held, and who can access it?
- What does it cost per person per month once the trial ends, and what is not included?
- What does the product not do? A supplier who cannot answer this has not been asked often enough.
How ChamberOne handles this
- Clients and matters can be brought in from Excel or CSV, and lists and reports can be exported to Excel.
- A new trial firm starts with a labelled sample client and matter, and a short Get started checklist that ticks itself off as you add real records.
- The free trial lasts 60 days, which is long enough to run the old and new systems side by side.
- Your own templates are kept as firm templates with merge fields filled from the matter, and exported to Word.
What it does not do
- Import covers clients and matters from Excel or CSV. Moving data out of another practice management system in other formats is assessed case by case.
- ChamberOne does not replace your accounting package for the firm's own books, and bulk import of historic documents is not automatic: files are uploaded to their matters.
This guide is general information about running a practice. It is not legal advice and does not describe what any statute, court rule or professional rule requires of you. Check the rules that apply to your practice.