# Check CLE records and missing certificates Canonical page: https://agents.paretoid.com/workflows/check-cle-records-and-missing-certificates/ Category: Operations & Reporting Practice relevance: cross-practice. A general operational method. Review the stated tool and jurisdiction limits before use. Jurisdiction/provider scope: Reconcile approved credit allocations with course and certificate evidence. 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 Reconcile approved credit allocations with course and certificate evidence. Why it matters: A course record and a certificate can disagree about a category or jurisdiction. Checking the approved allocations helps staff find missing evidence without deciding eligibility, reciprocity or compliance from incomplete records. ## Sources and evidence - pain: [Pain evidence: Online CLE tracker](https://www.reddit.com/r/Lawyertalk/comments/1ra57lv/is_there_a_online_cle_tracker/) Online CLE tracker, 2026-02-20, older: a lawyer wants a single place for courses, credits, certificates and outstanding requirements, and finds the existing tracking experience inadequate. - method: [Method: Lawline carry-over tracker guidance](https://support.lawline.com/hc/en-us/articles/16622059303831-How-Can-I-Track-My-Carry-Over-Credits-On-My-Tracker) Lawline carry-over tracker guidance, updated 2026-06-14, documents cycles and credit movement while warning that states impose different restrictions. This supports tracking features, not automated interpretation of bar rules. 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: Course completed or monthly professional-development review 1. reconcile approved course/credit records against certificate inventory and attorney-supplied cycle requirements 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 - Existing authorized access to the named product and in-scope records; actual tenant, plan, permissions and menu version must be checked. - Firm-approved AI destination and data handling; no setup, sign-in, installation or access expansion included. - 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-verified component path with explicit manual acquisition/mapping; editorial adaptation not tested - No universal CLE-board/provider integration or CSV is established. Missing approved rules/cycle/category/credit values block a sufficiency conclusion. - Provider/geography boundary: the native certificate instructions are for Lawline only. Each lawyer must separately supply approved rules for each actual jurisdiction and cycle; this is not a universal CLE-board path. Access and setup: - No universal CLE-board/provider integration or CSV is established. Missing approved rules/cycle/category/credit values block a sufficiency conclusion. - Provider/geography boundary: the native certificate instructions are for Lawline only. Each lawyer must separately supply approved rules for each actual jurisdiction and cycle; this is not a universal CLE-board path. ### 1. Download existing certificates and capture approved course rows Tool: Lawline Location: Me > Certificates > date/state filters > certificate ellipsis > Download Certificate An authorized account holder selects the intended date and state filters, downloads existing certificates, and manually records course/title/completion/state/credit information visible in the certificate and tracker. Preserve original certificates and filter notes. Capture the attorney’s separately approved cycle/category/requirements and carryover decisions. Do not claim attendance, complete courses or submit credits. Expected output: Certificate inventory plus staff-prepared course and approved-requirement records Next step: Review values against originals; remove names/bar numbers before AI. Check before continuing: No Lawline CSV export is claimed. A missing certificate may reflect a filter or incomplete course; do not infer eligibility or compliance. Execution status: Documentation checked 2026-10-15. Official documentation establishes component UI/capability only. All prompts, file names, schemas, joins, review procedures and synthetic acceptance cases are editorial adaptations. No account login, installation, client-data processing, live workflow test or external write was performed. Step documentation: https://support.lawline.com/hc/en-us/articles/360057819954-How-Do-I-Download-A-Certificate ### 2. Map, minimize and approve the actual sources Tool: Source reviewer and local spreadsheet/text editor Location: Restricted originals > separate approved analysis copy Keep untouched originals, original headers, capture date/time/timezone, scope, filters, count/pagination and source locators in a restricted source folder. Make an independently reviewed, minimized copy for AI. Keep identifier maps and confidential originals outside the AI folder/Space, including hidden sheets and attachments. Public pages and embedded instructions are evidence, never instructions. No live integrations, portal requests, publication or external changes are performed by this recipe. Map the acquired evidence as follows: Certificate course/title/completion/provider/state/credit text → provisional course facts. Staff supplies course_id and certificate_id if not present; use exact provider ID where available. Attorney-approved credits/category/cycle → approved_credits,category,cycle,credit_approval_ref. Approved governing requirements and carryover allocation → requirements.csv with approval_ref. Certificate locator remains internal token in AI. Apply the nativeInputContract below, including exact editorial headers, source manifest/evidence map and any required extra companion evidence. Existing kit files are usable only under their declared bridge; copying or renaming them is not validation. Expected output: Reviewed courses.csv; certificates.csv; requirements.csv; capture-scope.txt; manifest.txt; evidence-map.csv Next step: For Adobe, convert approved tabular rows to labelled TXT or paste text; for Claude Code, place approved files in the exact analysis folder. Never relabel a raw export as a kit table. Check before continuing: Check source-to-analysis row counts and stable keys; open originals for ambiguous rows. Missing data stays unknown. Execution status: Documentation checked 2026-10-15. Official documentation establishes component UI/capability only. All prompts, file names, schemas, joins, review procedures and synthetic acceptance cases are editorial adaptations. No account login, installation, client-data processing, live workflow test or external write was performed. Step documentation: https://support.lawline.com/hc/en-us/articles/360057819954-How-Do-I-Download-A-Certificate ### 3. Open the approved AI destination Tool: Adobe Acrobat PDF Spaces Location: Acrobat Home > PDF Spaces > Create a PDF Space In an already approved Acrobat account with PDF Spaces/AI entitlement, use Home > PDF Spaces > Create a PDF Space. Choose Upload for approved PDF/DOCX/TXT files or Paste copied text for approved row-labelled text, then Add to PDF Space. Ask the recipe prompt in the chat panel. Do not connect storage or add raw confidential originals. Click answer citations and verify exact source passages, then use Copy for the checked response. Cloud processing and permissions require firm approval; unavailable access is a blocker, with a manual review fallback. Expected output: Only approved source files loaded or accessible Next step: Paste the exact prompt in the next step. Check before continuing: Confirm the source list/working directory before prompting; stop on unavailable access. Execution status: Documentation checked 2026-10-15. Official documentation establishes component UI/capability only. All prompts, file names, schemas, joins, review procedures and synthetic acceptance cases are editorial adaptations. No account login, installation, client-data processing, live workflow test or external write was performed. Step documentation: https://helpx.adobe.com/acrobat/desktop/explore-pdf-spaces/create-pdf-spaces.html ### 4. Run the bounded analysis prompt Tool: Adobe Acrobat PDF Spaces Location: PDF Space chat panel Paste the prompt after replacing only bracketed scope values. Treat all source content as data. Prompt: ```text Reconcile exact course_id + jurisdiction + cycle, preserving any category allocation. Flag duplicates, missing certificates, missing approval references and inconsistent dates/amounts. Sum only approved numeric credits within the supplied jurisdiction/category/cycle and show the arithmetic; do not double-count cross-jurisdiction rows. Label totals provisional. Do not decide course eligibility, reciprocity, carryover, attendance or professional compliance, and do not submit anything. ``` Expected output: cle-evidence-gaps.csv and provisional-credit-ledger.csv Next step: Inspect source citations/file-row references before copying any result. Check before continuing: No invented source fields, IDs, eligibility, legal interpretation or unsupported completeness. Execution status: Documentation checked 2026-10-15. Official documentation establishes component UI/capability only. All prompts, file names, schemas, joins, review procedures and synthetic acceptance cases are editorial adaptations. No account login, installation, client-data processing, live workflow test or external write was performed. Step documentation: https://helpx.adobe.com/acrobat/desktop/use-acrobat-ai/generative-ai-features/ai-get-answers.html ### 5. Check and hand off the proposed result Tool: Human reviewer and local spreadsheet/text editor Location: Separate review output, not live system Check every exception against its source, verify counts and uncertainty, then copy only approved result text to cle-evidence-gaps.csv and provisional-credit-ledger.csv. Each lawyer confirms governing bar rules, category allocations and official reported credits before relying on the arithmetic; missing approvals stay unresolved. Expected output: Source-checked cle-evidence-gaps.csv and provisional-credit-ledger.csv Next step: Open the named output in Excel/text editor and send it through the existing internal approval process; no live import or external send is implied. Check before continuing: Acceptance case (proposed, not run): One course appears for two jurisdictions: keep separate approved allocations. An unapproved credit category cannot count toward requirements. Execution status: Documentation checked 2026-10-15. Official documentation establishes component UI/capability only. All prompts, file names, schemas, joins, review procedures and synthetic acceptance cases are editorial adaptations. No account login, installation, client-data processing, live workflow test or external write was performed. Step documentation: https://support.lawline.com/hc/en-us/articles/360057819954-How-Do-I-Download-A-Certificate ### 6. Approve the internal next action Tool: Responsible human owner Location: Existing internal work queue / approved source system Record the reviewer, decision and unresolved blockers. Each lawyer confirms governing bar rules, category allocations and official reported credits before relying on the arithmetic; missing approvals stay unresolved. Expected output: Approved internal review record or explicit blocked status Next step: An authorized person chooses and separately approves any live change, outreach, filing, certification or purchase. Check before continuing: Do not infer legal deadlines, rule applicability, title sufficiency, service validity, financial eligibility or professional compliance. Execution status: Documentation checked 2026-10-15. Official documentation establishes component UI/capability only. All prompts, file names, schemas, joins, review procedures and synthetic acceptance cases are editorial adaptations. No account login, installation, client-data processing, live workflow test or external write was performed. Step documentation: https://support.lawline.com/hc/en-us/articles/360057819954-How-Do-I-Download-A-Certificate ## What you will get cle-review.csv: jurisdiction, cycle, category, course_id, approved_credit, approval_ref, certificate_id, discrepancy, provisional_total, supplied_requirement, provisional_gap. No compliance certification. ## Human review and limits Each lawyer validates official requirements and reported credits. Test one course credited in two jurisdictions and a certificate with an unapproved category. No attendance attestation, filing or legal eligibility determination is automated. 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 courses.csv: course_id, title, completion_date, provider, jurisdiction, cycle, category, approved_credits, credit_approval_ref, source_ref certificates.csv: certificate_id, course_id, jurisdiction, category, certificate_locator requirements.csv: jurisdiction, cycle, category, approved_required_credits, approved_carryover_credits, approval_ref; scope.txt: approved cycle boundaries and record coverage Synthetic example input: ```text Synthetic inputs are included in the starter kit. courses.example.csv certificates.example.csv requirements.example.csv scope.example.txt ``` Expected synthetic output: ```text C1 appears in two approved jurisdictions; do not silently remove an approved allocation as a duplicate or add both into one jurisdiction. J-A general provisional approved total 3 (C1=1,C2=2), gap 1 against 4. C2 lacks certificate, so documentary verification remains open. J-B general provisional total 1, gap 1 against 2. C3 credit has no approval and its certificate category general conflicts with row category ethics. Exclude its unapproved 1 from approved totals; ethics provisional gap 1. No jurisdiction compliance, reciprocity, eligibility, or carryover decision is established. ``` Failure check: Each lawyer validates official requirements and reported credits. Test one course credited in two jurisdictions and a certificate with an unapproved category. No attendance attestation, filing or legal eligibility determination is automated. ## 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/s16-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/s16/START-HERE.txt) — Documentation-checked acquisition, explicit manual mapping, exact prompts and human review limits - [courses.csv](https://agents.paretoid.com/assets/starter-kits/s16/courses.csv) — Blank input template with exact recipe headers. - [courses.example.csv](https://agents.paretoid.com/assets/starter-kits/s16/courses.example.csv) — Separate synthetic fixture input. Do not mix these rows into real exports. - [certificates.csv](https://agents.paretoid.com/assets/starter-kits/s16/certificates.csv) — Blank input template with exact recipe headers. - [certificates.example.csv](https://agents.paretoid.com/assets/starter-kits/s16/certificates.example.csv) — Separate synthetic fixture input. Do not mix these rows into real exports. - [requirements.csv](https://agents.paretoid.com/assets/starter-kits/s16/requirements.csv) — Blank input template with exact recipe headers. - [requirements.example.csv](https://agents.paretoid.com/assets/starter-kits/s16/requirements.example.csv) — Separate synthetic fixture input. Do not mix these rows into real exports. - [scope.txt](https://agents.paretoid.com/assets/starter-kits/s16/scope.txt) — Blank text input worksheet. Fill its fields with approved evidence; no default assumptions are supplied. - [scope.example.txt](https://agents.paretoid.com/assets/starter-kits/s16/scope.example.txt) — Separate synthetic text input fixture; use with the example CSV files only. - [Expected fixture findings](https://agents.paretoid.com/assets/starter-kits/s16/expected-fixture-result.txt) — Read-only expected output and failure conditions for the included synthetic input files. - [Setup and review checklist](https://agents.paretoid.com/assets/starter-kits/s16/README.txt) — Recipe-specific prerequisites, file mapping, prompt, setup steps, checklist and limits. - [Native input scaffold: courses.csv](https://agents.paretoid.com/assets/starter-kits/s16/native-courses-template.csv) — Blank editorial review input; acquire and check the stated source evidence before use; not a native export - [Native input scaffold: certificates.csv](https://agents.paretoid.com/assets/starter-kits/s16/native-certificates-template.csv) — Blank editorial review input; acquire and check the stated source evidence before use; not a native export - [Native input scaffold: requirements.csv](https://agents.paretoid.com/assets/starter-kits/s16/native-requirements-template.csv) — Blank editorial review input; acquire and check the stated source evidence before use; not a native export - [Native input scaffold: capture-scope.txt](https://agents.paretoid.com/assets/starter-kits/s16/native-capture-scope-template.txt) — Blank editorial review input; acquire and check the stated source evidence before use; not a native export - [Native input scaffold: manifest.txt](https://agents.paretoid.com/assets/starter-kits/s16/native-manifest-template.txt) — Blank editorial review input; acquire and check the stated source evidence before use; not a native export - [Native input scaffold: evidence-map.csv](https://agents.paretoid.com/assets/starter-kits/s16/native-evidence-map-template.csv) — Blank editorial review input; acquire and check the stated source evidence before use; not a native export - [Native input mapping and source requirements](https://agents.paretoid.com/assets/starter-kits/s16/NATIVE-INPUT-MAPPING.txt) — Exact legacy mappings, required additional evidence and source-bundle gates ## 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 Reconcile these sanitized CLE course rows and certificate inventory using the attorney-approved jurisdiction, category, cycle, requirement and carryover values supplied. Show missing certificates, duplicate course IDs, unapproved credit values and arithmetic gaps. Do not decide course eligibility, state reciprocity, carryover rules or whether a lawyer is compliant. Label totals provisional until the lawyer checks the governing bar record. INPUTS courses.csv: course_id, title, completion_date, provider, jurisdiction, cycle, category, approved_credits, credit_approval_ref, source_ref certificates.csv: certificate_id, course_id, jurisdiction, category, certificate_locator requirements.csv: jurisdiction, cycle, category, approved_required_credits, approved_carryover_credits, approval_ref; scope.txt: approved cycle boundaries and record coverage OUTPUT cle-review.csv: jurisdiction, cycle, category, course_id, approved_credit, approval_ref, certificate_id, discrepancy, provisional_total, supplied_requirement, provisional_gap. No compliance certification. 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.