Beginner

Vendor statement reconciliation and duplicate payment scan

Reconciles vendor statements to AP subledger and identifies duplicates/credits. Produces a clear recon with recovery actions for AP and treasury.

Reconcile vendor statements to the AP subledger and scan for duplicates.

Inputs:
- Vendor statement(s): {vendor_statements}
- AP subledger detail for vendor(s): {ap_subledger_detail}
- Payment register: {payment_register}
- Matching keys and tolerance: {matching_rules}

Output:
1) Reconciliation summary by vendor: Statement balance vs AP balance with recon items.
2) Duplicate payment candidates list (criteria, evidence needed).
3) Unapplied credits and recommended actions (claim credit, request refund, apply to future invoices).
4) Control suggestions to prevent recurrence.

Provide the recon items in a table with owners and due dates.

Related Prompts