First Blood

Read sap-ledger-export.xlsx and bank-statement.xlsx.
Match by Transaction_Reference. Flag: posting date differences > 2 business days, amount mismatches > 0.01 (decimal shift pattern), entries in bank missing from SAP, duplicate postings.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Use EUR formatting. Separate suspense account items into their own tab.

Read scheme-report.xlsx and internal-tracker.xlsx.
Match by ARN. Flag: amount mismatches > 100, status conflicts between scheme decision and internal tracker, currency mismatches, approaching deadlines.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Highlight any case where scheme and tracker disagree on outcome.

Read screening-export.xlsx and internal-notes.xlsx.
Match by Alert_ID. Flag: disposition disagreements, high-risk geography alerts with low similarity scores, alerts missing internal review.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Escalate any alert where geography risk overrides low similarity score.

Read country-performance.xlsx and central-report.xlsx.
Match by Country_Code and Metric_Name. Flag: value differences > 5%, metrics present in local but missing from central, date range misalignments between sources.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Group discrepancies by country. Highlight any metric where local reports a higher number than central.

Read ticket-volumes.xlsx and staffing-levels.xlsx.
Match by date. Flag: SLA breaches, understaffed days, overstaffed days, Monday volume spikes.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Highlight any day where ticket-to-agent ratio exceeds 15:1.

Read snowflake-output.xlsx and tableau-totals.xlsx.
Match by Report_Name and Date. Flag: row count differences, sum mismatches > 0.01, reports present in pipeline but missing from dashboard, stale dashboards not refreshed in > 24 hours.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Note any discrepancy that could indicate a broken DBT model or failed Airbyte sync.

Read bank-statement.xlsx and internal-ledger.xlsx.
Match by Reference_Number. Flag: amount differences > 500, timing gaps > 3 days, unreconciled items.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Use EUR currency formatting. Highlight decimal shift patterns.

Read sardine-alerts.xlsx and jira-dispositions.xlsx.
Match by Alert_ID. Flag: alerts in fraud monitoring tool with no Jira case, disposition mismatches (e.g. fraud monitoring tool says high-severity but Jira closed as false positive), cases open > 48 hours without disposition.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Flag any merchant appearing in 3+ unresolved alerts — potential BIN attack or velocity spike.

Read pipeline-deals.xlsx and crm-records.xlsx.
Match by Deal_ID. Flag: value discrepancies, deals marked Closed Won in pipeline but Stale in CRM, name mismatches that might be the same company.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Calculate total pipeline inflation vs reality.

Read okta-users.xlsx and hibob-directory.xlsx.
Match by Employee_ID. Flag: active HiBob employees missing Okta accounts, departed employees still active in Okta, group assignment mismatches vs role, MFA not enabled.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Highlight any departed employee with Okta access still active — security risk.

Read contract-tracker.xlsx and docusign-export.xlsx.
Match by Contract_ID. Flag: contracts marked Executed in tracker but still Pending in DocuSign, agreements past signature deadline, contracts in DocuSign with no tracker entry.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Separate NDAs from commercial agreements. Flag any contract > 30 days without signature.

Read zuper-dispatch.xlsx and courier-confirmations.xlsx.
Match by Order_ID. Flag: dispatched but unconfirmed deliveries > 3 days, delivery date mismatches, terminals dispatched to wrong address, failed deliveries not rebooked.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Group by country. Flag any terminal with 2+ failed delivery attempts for escalation.

Read campaign-tracker.xlsx and braze-performance.xlsx.
Match by Campaign_ID. Flag: campaigns in tracker not found in Braze, send count discrepancies > 10%, campaigns marked Live in tracker but Paused in Braze, missing UTM parameters.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Break out by channel (email, push, in-app, SMS). Highlight campaigns with 0 sends.

Read application-tracker.xlsx and cdd-status.xlsx.
Match by Application_ID. Flag: applications approved in CDD but blocked in operations, stuck applications > 14 days, missing CDD records.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Flag the top 5 longest-waiting applications.

Read workato-bot-logs.xlsx and slack-request-outcomes.xlsx.
Match by Request_ID. Flag: bot executions that failed silently (no Slack confirmation), requests completed in Slack but no workflow automation platform log, recipe errors requiring manual reprocessing.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Group failures by workflow automation platform recipe name. Flag recipes with > 5% failure rate.

Read partner-claims.xlsx and internal-commissions.xlsx.
Match by Partner_ID and Reporting_Week. Flag: amount differences > 1%, merchants claimed by partner but not in internal records, clawback-eligible transactions missing from claims, duplicate payments across countries.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Exclude eCommerce services per commission model rules. Flag any duplicate ISA across multiple countries.

Read hibob-export.xlsx and opsgenie-schedule.xlsx.
Match by Employee_ID and date. Flag: hours differences (scheduled vs logged may be incident callouts, not errors), missing entries in either source.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Distinguish scheduled overtime from unscheduled incident callouts.

Read activation-tracker.xlsx and transaction-records.xlsx.
Match by Merchant_ID. Flag: merchants marked Activated but with zero transactions, merchants transacting but not marked Activated, activation date vs first transaction date gap > 7 days.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Segment by product type (POS vs eCommerce). Flag merchants onboarded > 30 days ago with no first transaction.

Read sprint-plan.xlsx and jira-sprint-report.xlsx.
Match by Ticket_ID. Flag: tickets committed but not started, scope changes (tickets added mid-sprint), story point mismatches between plan and Jira, tickets marked Done in plan but still In Progress in Jira.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Calculate planned vs actual velocity. Flag any ticket reassigned mid-sprint.

Read tier2-escalations.xlsx and resolution-records.xlsx.
Match by Ticket_ID. Flag: escalations with no resolution record, resolution times > SLA, tickets resolved in Tier 2 but still open in Zendesk, duplicate escalations for the same merchant issue.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Group by escalation category. Flag recurring merchant issues (same Merchant_ID appearing 3+ times).

Read cancellation-requests.xlsx and save-outcomes.xlsx.
Match by Merchant_ID. Flag: cancellations with no save attempt, merchants marked Saved but still showing as Cancelled, repricing offers made but not applied, outcome recorded but no call log.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Exclude business-closure cancellations (handled by CR). Calculate save rate by reason code.

Read risk-model-scores.xlsx and merchant-reviews.xlsx.
Match by Merchant_ID. Flag: high-risk scores with no review scheduled, review outcome disagrees with model score (e.g. model says high-risk but review cleared), merchants exceeding chargeback thresholds without restriction, reviews overdue > 30 days.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Flag any merchant with MOTO or manual-entry ratios above guardrail thresholds.

Read scheme-fee-statement.xlsx and internal-fee-calc.xlsx.
Match by Merchant_ID and Fee_Type. Flag: amount differences > 0.50, fee categories billed by scheme but not in internal model, interchange rate mismatches, MCC-driven fee discrepancies.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Separate by scheme (Visa, Mastercard, AMEX). Total the revenue leakage from unmatched fees.

Read sweep-records.xlsx and bank-balances.xlsx.
Match by Sweep_Date and Bank_Account. Flag: sweep amounts not reflected in bank balance, timing differences > 1 business day, partner bank A vs partner bank B split deviating from 80/20 target, balance corrections not reconciled.
Produce a reconciliation workbook (.xlsx) with matched, discrepancy, and summary sheets.
Calculate net safeguarding position per bank. Flag any day where sweep total and bank movement differ by > 1000.