docs-reconcile
Reconcile normalized CI/PL/BL fields and output mismatch report
When & Why to Use This Skill
The docs-reconcile skill is a specialized data integrity tool designed to automate the cross-referencing of key fields across Commercial Invoices (CI), Packing Lists (PL), and Bills of Lading (BL). It processes normalized datasets to identify discrepancies, generating a detailed mismatch report that includes error counts and field-by-field status tables to ensure consistency in trade and financial documentation.
Use Cases
- International Trade Compliance: Automatically verify that shipping details are consistent across CI, PL, and BL documents to prevent customs delays and regulatory fines.
- Financial Auditing and Reconciliation: Streamline the audit trail by identifying mismatches between invoiced amounts, packed quantities, and transport records.
- Logistics Data Quality Control: Use the automated mismatch report to detect and correct data entry errors in normalized logistics files before final submission or system integration.
| name | docs-reconcile |
|---|---|
| description | Reconcile normalized CI/PL/BL fields and output mismatch report |
Instructions:
- Inputs:
- data/ci_fields.csv (template: data/templates/ci_fields.template.csv)
- data/pl_fields.csv (template: data/templates/pl_fields.template.csv)
- data/bl_fields.csv (template: data/templates/bl_fields.template.csv)
- Run: powershell -ExecutionPolicy Bypass -File .codex/skills/docs-reconcile/scripts/run.ps1
- Output: reports/docs_reconcile.md
- Fail-safe: if inputs/columns missing, output only the 'ไปฅ๋ฌ๋' table. Evidence Required:
- Report must include mismatch count + field-by-field status table.