START WITH THE PRODUCT STEPS Read START-HERE.txt first. It states the actual source acquisition, access/privacy limits, manual field mapping and exact next prompt. The original file templates and synthetic examples below are supporting review aids. Some paths need separately supplied documents or source text; a blank worksheet is not a native export or completed integration. S18: Reconcile software licenses with assigned users and approved purposes Starter kit Status: Proposed / not tested PURPOSE Monthly billing review or scheduled renewal review → reconcile purchased seats, assigned seats and administrator-approved account purposes → unexplained-seat and invoice-plan mismatch queue. PREREQUISITES 1. Sanitized purchase/invoice rows (SKU, quantity, period, approved cost), assigned-license export keyed to pseudonymous account IDs, employee/vendor/service-account status supplied by the administrator, required capabilities and owner. Excel exact joins and arithmetic; account purpose may remain unknown. 2. Synthetic files first. Real use requires firm-approved access, privacy, processing terms, retention controls, export coverage and a named reviewer. 3. Prepare any required original files or rendered evidence separately. This kit does not configure accounts, connectors or live actions. FILES AND FORMATS purchases.csv: purchase_id, sku, quantity, period_start, period_end, approved_cost, currency, approval_ref assignments.csv: account_alias, sku, assigned_at, source_ref account-purposes.csv: account_alias, account_type, approved_purpose, required_capabilities, owner_alias, approval_ref scope.txt: export cutoff, coverage and approved SKU mappings Files without .example are blank input worksheets; CSV templates contain headers only. .example files contain invented records for the dry run. Text input .txt files contain blank labeled fields. Use the original base filename when supplying an example to the prompt, or explicitly map the example filename to that input. CSV files are UTF-8 with comma delimiters, quoted fields where needed, and CRLF row endings. Preserve identifiers as text when importing into Excel. Blank means missing or unresolved, never a zero or a pass. Multi-value fields use a pipe only where the fixture scope says so. SETUP AND DRY RUN 1. Copy this kit to an approved working folder. Keep examples separate from any real exports. Do not upload client, privileged, personal, credential or financial-account data to an unapproved service. 2. Read the .example text policy/scope files and all .example.csv inputs together. They define this fixture only. For a real pilot, fill the blank templates from approved exports without changing headers and obtain approved policy values. 3. Use native read-only exports, exact joins and arithmetic for deterministic checks. This kit includes no executable automation, OAuth setup, live-action instructions or importable Make blueprint. 4. Give only the approved prepared inputs to a firm-approved text assistant and use the recipe prompt below. Keep source IDs, source row numbers and unresolved evidence visible. 5. Compare the proposed result with expected-fixture-result.txt. Verify every listed issue and that the prompt invents no missing evidence. The expected file describes assertions, not a performed workflow run. 6. Have the named reviewer check source evidence and record remaining questions before any separately authorized action. RECIPE PROMPT Compare purchased-license quantities with assigned-license rows and the supplied account-purpose inventory. Show unassigned capacity, assignments without a documented purpose, SKU mismatches and missing evidence. Do not treat shared or service accounts as waste, infer employment status, recommend removing required security features, cancel subscriptions or change access. Present questions and reconciled counts for the administrator. INPUTS purchases.csv: purchase_id, sku, quantity, period_start, period_end, approved_cost, currency, approval_ref assignments.csv: account_alias, sku, assigned_at, source_ref account-purposes.csv: account_alias, account_type, approved_purpose, required_capabilities, owner_alias, approval_ref; scope.txt: export cutoff, coverage and approved SKU mappings OUTPUT license-review.csv: sku, purchased_quantity, assigned_quantity, unassigned_capacity, account_alias, approved_purpose, source_ref, missing_evidence, reviewer_question. Do not call a spare or service account waste or cancel access. 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. REVIEW CHECKLIST [ ] Headers match the exact input schema and the export covers the stated scope [ ] Synthetic example files were used alone for the first dry run [ ] Every output finding retains its original source ID/row/page reference [ ] Missing keys, contradictions, unavailable originals and ambiguous dates remain unresolved [ ] Every expected fixture finding is present; no live action or unsupported result is claimed [ ] Responsible reviewer checks the original records before a real deployment RECIPE-SPECIFIC REVIEW IT and billing owner check purpose, contract terms and feature requirements. Test a legitimate service account, prepaid spare capacity and a renamed SKU. No cancellation, purchase or permission change is made. VALIDATION Exact CSV header order, field counts, serialized round-trip values and fixture semantics were checked during kit preparation. This does not test OCR, a vendor integration, a model response or end-to-end reliability. All data and identifiers are synthetic. Dates are fixed fixture dates, not current monitoring results.