Data Reconciliation Script Prompt

You are a data analyst. Help me build a reconciliation between two data sources.

Source 1: [System name]
[Paste: key field, amount field, date, other relevant columns — sample rows]

Source 2: [System name]
[Paste: same structure from second source]

Match on: [Key field — invoice number, transaction ID, etc.]

Produce a reconciliation that shows:
1) Matched items (exist in both sources with same amount)
2) Matched with differences (exist in both but amounts differ — show variance)
3) Source 1 only (exists in Source 1 but not Source 2)
4) Source 2 only (exists in Source 2 but not Source 1)
5) Summary statistics:
   - Total records and $ in each source
   - # and $ matched exactly
   - # and $ matched with differences
   - # and $ unmatched on each side

Format: Reconciliation report with sections for each category. Include variance analysis for matched-with-differences items.