POS Transaction Log Deduplication and Outlier Audit

Role: Lead Retail Analytics Engineer specializing in store-level point-of-sale data pipelines and transactional anomaly detection.

Context

• Commercial Brand: {{brand_name}}
• POS Hardware/Software Fleet: {{pos_system_variants}}
• Physical Store Footprint: {{store_network_scope}}
• Data Processing Interval: {{transaction_window_period}}
• Extreme Outlier Threshold: {{anomaly_value_threshold}}
• Applicable Tax Jurisdictions: {{tax_jurisdiction_rules}}

Task

Generate a rigorous operational checklist to inspect, clean, and deduplicate raw POS transaction dumps across {{store_network_scope}} for the {{transaction_window_period}} window.

Method

1. Check timestamp consistency across {{pos_system_variants}}, standardizing UTC offsets and correcting daylight saving drift.
2. Isolate and quarantine duplicate receipt IDs generated by offline register caching or network retries.
3. Audit line-item quantity and unit price multipliers against {{anomaly_value_threshold}} to detect phantom scans and register keying errors.
4. Reconcile return and exchange line items against original purchase receipt references to flag orphan returns.
5. Verify that basket-level tax calculations match the corresponding rules in {{tax_jurisdiction_rules}} down to the cent level.
6. Scrub and mask sensitive payment gateway tokens, PAN fragments, and cashier identification fields according to compliance baselines.
7. Validate basket total parity where sum of item prices minus item discounts plus tax equals total collected amount.

Constraints

• Every checklist task MUST define the specific SQL or regex validation logic needed.
• Financial adjustment items MUST NOT overwrite raw transaction tables; all cleaning actions must produce remediated audit tables.
• Explicitly cover handling of voided transactions and zero-dollar promotional baskets.
• Restrict total checklist length to under 25 actionable audit points.

Output format

Provide a structured checklist divided into: 1. Ingestion & Timestamp Hygiene, 2. Anomaly & Duplicate Detection, 3. Tax & Tender Reconciliation, and 4. Downstream Pipeline Release. Each entry must follow - [ ] [ID] Step Name: Specific audit instruction | Remediation Rule.

Self-review

• Ensure all variables ({{brand_name}}, {{pos_system_variants}}, {{store_network_scope}}, {{transaction_window_period}}, {{anomaly_value_threshold}}, {{tax_jurisdiction_rules}}) are embedded.
• Validate that every validation step provides concrete handling for edge cases like negative values or voids.
• Verify adherence to the prescribed markdown checklist formatting.