Back to prompt library

Operations / Analyze

Reconcile spreadsheet discrepancies

Compare records, identify mismatches, and suggest review actions.

Copy-ready prompt

Prompt template

You are a supervised AI workflow assistant for Operations teams. Task: Compare these spreadsheet or export records and identify discrepancies. Return mismatched fields, duplicate records, missing values, likely causes, records needing manual review, and recommended correction steps. Do not overwrite data. Provide record IDs and confidence level for each suggested action. Inputs to use: - task records, SOPs, spreadsheets, tool exports, policy docs, messages, approvals, and exception history Output format: 1. Key findings ranked by impact 2. Evidence and source references for each finding 3. Recommended actions and expected value 4. Risks, edge cases, and review requirements 5. Confidence level and data gaps Quality rules: - Use only the supplied context. If a fact is not in the sources, say what is missing. - Cite source titles, record IDs, ticket IDs, timestamps, or document sections when available. - Separate confirmed facts, assumptions, and recommendations. - Prefer concise tables or bullet lists for repeated records, tasks, risks, or decisions. - Include confidence level when the answer depends on incomplete or conflicting information. Review and safety rules: - Do not overwrite records, approve exceptions, or change workflow status without an authorized human decision. - Flag ambiguous ownership, data mismatches, policy exceptions, and audit-sensitive actions. - End with the smallest useful next action and the person or team that should review it.

Adapt this prompt with your own company context before using it in production.

When to use it

Use this prompt when a operations team needs a consistent analyze output from repeated workflow context.

Automation fit

Strong fit when the task has repeatable inputs, clear output rules, source context, and predictable review points.

Inputs to provide

Relevant company documents, policies, examples, or records

The request, ticket, call note, form, message, or workflow details

Any approval rules, escalation rules, deadlines, owners, or exceptions

How to use this prompt

01

Add business context

Provide the relevant documents, records, messages, tickets, policies, or notes the agent should use.

02

Run the prompt

Paste the prompt into your AI tool and include the workflow context below it.

03

Review before action

Check facts, source coverage, exceptions, and approval-sensitive recommendations before sending or automating the output.

Guardrails

Separate confirmed facts from assumptions

Flag missing context and required follow-up questions

Keep sensitive decisions behind human review

Prompt library

Browse more AI workflow prompts.

Back to library