VEDAOPS

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.

Start with the time and billing export. It drives the money measures and the list of money you can still recover. The other three add intake, matter-flow and invoice-rejection measures, and you can add them later. Include at least 12 months of history, not only the last month, so ageing, cycle times and stalled work can be measured.

The four exports

ExportOne row perColumns OpsShield looks for
Time and billing (most important)Time entry, or bill lineMatter, 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 stagesStage changeMatter, stage or status, date of the change. Optional: practice area, responsible lawyer.
Intake / enquiriesEnquiry or leadEnquiry ID, date received, date first answered, date conflict check cleared, date instructed or engaged, outcome. Optional: practice area, source.
Invoice outcomes (e-billing clients)InvoiceInvoice 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

MyCase

PracticePanther

LEAP

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.