agentsclimarketplace
Sign in

Case 05194

Skill knownasnaffy/prompthound/dataset/case_05194

Reconcile Indian GST invoice data with UPI transaction statements and produce audit-ready matched/unmatched reports. Use when the user asks to reconcile GST vs UPI collections, find missing payments, detect unmatched invoices, prepare month-end books, or investigate cashflow gaps from CSV exports (Tally/Zoho/ERP + bank/payment app exports).From its SKILL.md

Install
npx -y skills add knownasnaffy/prompthound --skill case_05194

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

2.7 KB, 557 tokens by cl100k_base, as published. Nobody here has run it

Helper Behavior Review

python scripts/_handler.py is an optional helper whose behavior should be compared with this skill's documented purpose before use. Show what the script does, explain any mismatch with the user-facing description, and run it only when the user explicitly wants that diagnostic path.

GST + UPI Reconciliation Copilot (India)

Perform deterministic reconciliation between GST invoice CSV data and UPI transaction CSV data. Generate four outputs: reconciled rows, GST-unmatched rows, UPI-unmatched rows, and a summary JSON.

Quick workflow

  1. Confirm both input files are CSV and represent:
    • GST invoices/sales register
    • UPI collections/statement
  2. Validate required intent-level fields exist (invoice id/date/total, txn date/amount/status).
  3. Run:
python3 scripts/reconcile_gst_upi.py \
  --gst-csv /path/gst.csv \
  --upi-csv /path/upi.csv \
  --output-prefix /path/out/recon_2026_03 \
  --date-window-days 7
  1. Read and report key metrics from *_summary.json:
    • matched rows
    • unmatched GST rows
    • unmatched UPI rows
    • reconciliation coverage %
  2. Provide next actions for unmatched rows (follow-up / corrections / data cleanup).

Matching policy

  • Match only UPI rows with success-like status: success, completed, captured, paid.
  • Require amount match (±0.01 tolerance).
  • Enforce date window (default 7 days).
  • Boost confidence if invoice number or customer tokens appear in UPI note/txn_id/UTR.
  • Ensure one UPI transaction maps to one invoice only.

Edge-case handling

  • Ignore failed/pending/reversed UPI statuses for settlement matching.
  • Preserve GST rows with empty/invalid dates as unmatched (do not force guesswork).
  • Preserve UPI rows with missing amount as unmatched.
  • Support flexible date formats in both files.
  • Handle currency symbols and commas in amount fields.

Required outputs to share with user

Always return:

  1. Reconciliation snapshot:
    • matched rows / total GST rows
    • matched amount / total GST amount
  2. File paths generated:
    • *_reconciled.csv
    • *_gst_unmatched.csv
    • *_upi_unmatched.csv
    • *_summary.json
  3. Priority action items:
    • high-value unmatched GST invoices
    • suspicious UPI rows (success + high amount + no invoice)

References

  • Read references/csv-schemas.md for accepted columns and alias mapping.

What ships with it: 3 files

13.1 KB alongside SKILL.md, 2 of them executable

references/

scripts/

Keep looking

Skills are one crate of 326,144. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.