OpsShield™ for Legal
Export guide
Which exports to upload, and how to get them
OpsShield works with the exports of any practice-management or billing system, in any country. Column names don't need to match: at set-up you attach one sample of each export and OpsShield matches your columns and your status words. Download each export as Excel (.xlsx) or CSV.
The four exports
| Export | One row per | Columns OpsShield looks for |
|---|---|---|
| Time and billing (most important) | Time entry, or bill line | Matter, client, lawyer or fee earner, date worked, hours, value at standard rate, date billed, amount billed, date paid, amount paid. Role (partner, associate…) is optional. |
| Matter stages | Stage change | Matter, stage or status, date of the change. Optional: practice area, responsible lawyer. |
| Intake / enquiries | Enquiry or lead | Enquiry ID, date received, date first answered, date conflict check cleared, date instructed or engaged, outcome. Optional: practice area, source. |
| Invoice outcomes (e-billing clients) | Invoice | Invoice number, client, date submitted, amount, outcome (accepted, reduced, rejected), amount cut, reason. Optional: billing lawyer, appeal outcome. |
If your time export has no paid date (many systems record payment against the bill, not the entry), export your bills list with bill date and paid date as well, and upload it as the time and billing export instead. OpsShield accepts either one row per entry or one row per bill line.
Where to find them in common systems
Report names differ by system, plan and region, and change over time. Use these as a starting point. During set-up we check your files with you.
Clio Manage
- Time and billing: export your activities (time entries) for the period, including bill status. The Revenue report (CSV or Excel) shows billed, unbilled and collected amounts by matter and includes client, practice area and responsible attorney.
- Matter stages: export the matters list with matter stage, or a stage history if your plan provides one.
- Intake: if you use Clio Grow, export leads with created date, status and source.
MyCase
- Time and billing: Reports › Productivity › Firm Time & Expenses or Case Time & Expenses. For unpaid bills, Reports › Financial › Aging Invoices or Accounts Receivable (Aging Invoices needs the invoice due date filled in).
- Matter stages: Reports › Case & Contact › Case List Report, filtered by case stage.
- Intake: Reports › Leads, e.g. Leads Referral Source.
- Reports export to CSV.
PracticePanther
- Time and billing: Time Entries, filtered to show billed and billable entries, then export to Excel. For unpaid bills, the accounts receivable (aging) report.
- Matter stages: export the matters list with status.
LEAP
- Time and billing: Time and Fees List Report (time entries), Invoices Report (bills with adjustments and payments) and the Aged WIP Report (unbilled work).
- Unpaid bills: Matters Financial Summary with Aging, or the Fee Earner Summary with debtor ageing.
- Matter stages: Matters Opened and Completed Matters, or Matters by Last Activity.
Other systems (Actionstep, Smokeball, Aderant, Elite, PCLaw, Osprey, your own spreadsheets…)
Any export with the columns above works. Excel workbooks with several sheets and title rows above the header are fine. Older .xls files, PDFs and Word files can't be read: in Excel use File › Save As › Excel Workbook (.xlsx) or CSV.
Privacy
You may replace client and lawyer names with internal IDs before uploading. Files are processed in memory and not stored. Only aggregated figures are kept to compare months. Your private monthly report lists the specific matters and invoices behind the money you can still recover, so you can act on them.
OpsShield is operational monitoring, not legal or financial advice. Product and report names belong to their owners and are used only to help you find your exports.