# Prepare a coverage handoff before leave Canonical page: https://agents.paretoid.com/workflows/prepare-a-coverage-handoff-before-leave/ Category: Operations & Reporting Practice relevance: cross-practice. A general operational method. Review the stated tool and jurisdiction limits before use. Jurisdiction/provider scope: List upcoming work, assigned coverage and missing acknowledgments. Status: Proposed / not tested. The public source describes the problem. Documentation supports only the stated method components; no result from this recipe has been verified. Verification: Source methods and reported problems have been reviewed. We have not run the adapted workflow. The sample below describes expected behavior on synthetic data, not a customer result. ## The problem List upcoming work, assigned coverage and missing acknowledgments. Why it matters: Work can be missed when the original owner is away and coverage has not been accepted. A clear handoff shows who has actually agreed to each task and where a supervisor still needs to decide. ## Sources and evidence - pain: [Pain evidence: I shouldn’t be surprised](https://www.reddit.com/r/paralegal/comments/1u9gzbe/i_shouldnt_be_surprised/) I shouldn’t be surprised, 2026-06-18, older. OP and comments describe last-minute assignments and handoffs immediately before leave despite earlier planning. - method: [Method: Clio task filtering/export](https://help.clio.com/hc/en-150/articles/9204982812699-Filter-and-Export-Tasks) Clio task filtering/export supports task exports and owner/date filters. This is a prepared-file workflow, not an automatic cross-calendar integration. Source checked: October 15, 2026. Pain accounts are self-reported. Documentation supports components; this adapted recipe and prompt have not been tested. ## Suggested approach Start when: Approved leave starts within the firm's review interval 1. consolidate open tasks, explicit dates and blockers 2. Keep source references and report unknowns instead of filling gaps. 3. The responsible reviewer checks the report before any separately approved action. ## What you need - Clio Manage task access and a defined absence window with timezone. - Actual, explicit cover assignments and acknowledgment records; a role label alone is not acceptance of responsibility. - Firm-approved Excel; optional Copilot entitlement and tenant approval for the exact minimized data. Native Excel analysis can be done manually if Copilot is absent. - Keep raw exports and identifying source pointers in a separate restricted location. The AI workbook contains only approved alias-based tables and visible policy/scope text, never raw client records on another tab. - Use synthetic inputs first. Keep real data in firm-approved accounts and processing, with appropriate access, confidentiality and retention controls. Aliases alone do not anonymize records. Never paste credentials, API keys or unnecessary client details. ## How to use Documentation-checked proposed route; source collection and human approval required - Task export does not supply a complete coverage rota or prove that a cover lawyer accepted a task. Off-system work and private tasks need separate review. - This route prepares a handoff; it never reassigns tasks or recalculates deadlines. Access and setup: - Actual account access, plan and source-data completeness have not been tested. ### 1. Collect the actual task list Tool: Clio Manage Location: Tasks > Outstanding (then Completed if required) > Filters > Apply filters > bottom Export > CSV > Export Choose the authorized users, matters and date range for the absence handoff, including overdue and undated outstanding work. Include undated tasks when the scope requires them. Export Outstanding and Completed separately; note filters, capture time and visible record count. Use Expand rows or Print task from the task row menu to inspect full instructions where necessary. Expected output: Native task CSV file(s), plus a scope note. Exact CSV headers must be inspected; the kit headers are not promised native fields. Next step: Keep the raw files restricted; prepare the alias-based input in the next step. Check before continuing: Private tasks may be invisible. Task export is only the selected scope; exporting does not prove all review requests or off-system obligations exist here. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://help.clio.com/hc/en-us/articles/9204982812699-Filter-and-Export-Tasks https://help.clio.com/hc/en-us/articles/9204917906971-Manage-Tasks-in-Clio-Manage ### 2. Map the observed records to the starter input Tool: Excel and authorized staff Location: Separate analysis workbook > Home > Format as Table Map each actual task to task_id and matter_alias; preserve observed status and owner_role. Copy next_explicit_action, blocker and approved_due_datetime from the task/request after staff verification. Record a secure_internal_link_id that resolves only in a separate restricted crosswalk. From the approved rota and actual replies enter absence_start, absence_end, task_id, explicitly_assigned_cover_role and acknowledgment_status into Coverage. Date-only deadlines remain date-only with timezone/precision noted in Scope; do not fabricate midnight. Create named tables for Tasks and Coverage. Put the policy and review scope in visible worksheets or paste them into the next prompt. Expected output: tasks.csv and coverage.csv; both editorial mapped inputs. Next step: Check the mapping against each original source before using AI. Check before continuing: Aliases and missing policy fields are staff-created; do not relabel a native export as the kit schema. Unknown stays blank/unknown, not false or zero. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://support.microsoft.com/en-us/excel/tutorial-import-data-into-excel-and-create-a-data-model ### 3. Review the bounded evidence with Copilot Tool: Excel Copilot, optional Location: Approved analysis workbook > Copilot icon at lower right > Chat only Use Chat only and submit the prompt. Without Copilot: filter by the absence window and inspect each task against its coverage record. Prompt: ```text Read Tasks, Coverage and Scope. Build a coverage handoff grouped by explicitly_assigned_cover_role, listing task_id, matter_alias, exact next action, supplied due date/time, blocker, acknowledgment status and secure_internal_link_id. Flag unassigned cover, missing acknowledgment, conflicting assignments, undated items and tasks due before/during the absence. Cite input rows. Do not infer legal deadlines or assign responsibility. Unknown cover is uncovered, not delegated. Do not send or edit. ``` Expected output: Handoff draft plus an uncovered/unacknowledged-task checklist. Next step: Copy the draft exception list to the reviewer; retain row references. Check before continuing: Check every flagged row and the scope. A fluent answer is not evidence of completeness; no automatic workbook or source-system edits. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel https://support.microsoft.com/en-us/excel/copilot/frequently-asked-questions-about-copilot-in-excel ### 4. Approve the review result Tool: Responsible staff reviewer Location: Reviewed local worksheet The outgoing owner and supervising lawyer confirm the scope, inspect original task instructions and obtain explicit acceptance through the firm’s normal process. Mark the handoff approved only when the actual acknowledgments are checked. Expected output: Reviewed handoff and unresolved coverage exceptions. Next step: Any external message, source change, payment or deletion requires its own authorized process. Check before continuing: Keep missing acknowledgment visible. The draft itself is not notice, acceptance or a reassignment. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://support.microsoft.com/en-us/excel/tutorial-import-data-into-excel-and-create-a-data-model ## What you will get Approved assistant workspace; coverage-handoff.md and unanswered-ownership.csv. Human reviewers acknowledge in their existing tool. ## Human review and limits Departing staff and cover owner review and acknowledge; supervisor resolves gaps. Test a task with no owner and a new item arriving after packet creation. The assistant drafts or reports only. Check source records and review the output before a human performs any separately approved send or change. No automatic legal decision, money movement, account connection or publication is included. What to measure: In a synthetic pilot, count correctly found exceptions, false alarms, and unresolved inputs. No time or cost saving is assumed. ## Original prepared-input schema tasks.csv: task_id, matter_alias, status, next_explicit_action, approved_due_datetime, owner_role, blocker, secure_internal_link_id. coverage.csv: absence_start, absence_end, task_id, explicitly_assigned_cover_role, acknowledgment_status. Synthetic example input: ```text Synthetic inputs are included in the starter kit. tasks-example.csv coverage-example.csv ``` Expected synthetic output: ```text Task T3 falls within leave and has no assigned cover → owner gap highlighted. Do not nominate an available colleague as if assignment were authorized. ``` Failure check: Departing staff and cover owner review and acknowledge; supervisor resolves gaps. Test a task with no owner and a new item arriving after packet creation. ## Starter files Native blank scaffolds and original synthetic examples may use different schemas. Follow NATIVE-INPUT-MAPPING where supplied. These files do not connect accounts or install automation. - [Download starter kit](https://agents.paretoid.com/assets/starter-kits/a15-starter-kit.zip) — All inputs, synthetic examples and review notes in one ZIP. No automation is installed. - [Start here: get the sources and prepare the review](https://agents.paretoid.com/assets/starter-kits/a15/START-HERE.txt) — Documentation-checked acquisition, explicit manual mapping, exact prompts and human review limits - [Setup and review checklist](https://agents.paretoid.com/assets/starter-kits/a15/README.txt) — Required inputs, file use, review steps and limits - [Tasks blank CSV](https://agents.paretoid.com/assets/starter-kits/a15/tasks-template.csv) — Blank input headers for tasks.csv - [Tasks synthetic example](https://agents.paretoid.com/assets/starter-kits/a15/tasks-example.csv) — Synthetic test records for tasks.csv - [Coverage blank CSV](https://agents.paretoid.com/assets/starter-kits/a15/coverage-template.csv) — Blank input headers for coverage.csv - [Coverage synthetic example](https://agents.paretoid.com/assets/starter-kits/a15/coverage-example.csv) — Synthetic test records for coverage.csv - [Synthetic example expected results](https://agents.paretoid.com/assets/starter-kits/a15/expected-results.txt) — Compare a pilot result with the planted exceptions ## Optional original prepared-input prompt Destination: Your firm-approved AI assistant · prepared files This original prompt uses its own prepared-input schema. Do not mix it with native-step tables without the supplied mapping. ```text Create a coverage handoff for this supplied absence period. For each open matter include task ID, latest approved status, next explicit action, approved due date, named cover owner and missing information. Separate tasks due during leave from later work. Do not assign new responsibility, infer legal deadlines or mark anything handed off without acknowledgment. INPUTS tasks.csv: task_id, matter_alias, status, next_explicit_action, approved_due_datetime, owner_role, blocker, secure_internal_link_id. coverage.csv: absence_start, absence_end, task_id, explicitly_assigned_cover_role, acknowledgment_status. OUTPUT Approved assistant workspace; coverage-handoff.md and unanswered-ownership.csv. Human reviewers acknowledge in their existing tool. Use only these synthetic or firm-approved inputs and preserve source row/page IDs. Keep missing or conflicting evidence unresolved. Return a draft for the named reviewer. Do not send messages, connect accounts, change records or permissions, move money, or make legal decisions. Keep source files unchanged. List missing prerequisites before continuing. ``` Proposed / not tested · editorial prompt Published by Law Firm Agents. Proposed adaptation; not tested. Not legal advice.