Intelligence · Component · finance-reconciliation-rates
Spreadsheet reconciliation and reference FX data
What it does
Match spreadsheet/CSV rows by composite keys, compare amounts with tolerance and retrieve dated currency reference rates for calculations.
Core pattern
Composite-key reconciliation + tolerances and dated exchange rates
- Input
- Two ledgers or a currency-conversion request
- Output
- Reconciliation workbook or reference-rate JSON
Key parameters
| Name | Type | Default | Values |
|---|---|---|---|
| operation | string | reconcile | reconcile · reference_fx |
| left_file | — | — | — |
| right_file | — | — | — |
| amount_columns | array | [] | — |
| date | — | — | — |
Maturity and limits
Concrete parameterized scripts and local-file processing implementation. Phase 2: source paths and implementation inspected statically; tests and external integrations were not executed. Maturity rates repository implementation, not a verified production deployment.
No root reuse license found; bundled skills/plugins and dependencies carry separate license terms. Reference FX rates are not executable market quotes; financial data is sensitive.
2 sentences citing source paths or vendor names omitted for publication.
Used in pipelines
Not part of a pipeline yet; available as a standalone component.
Industry tags
- Logistics & supply chainTransferable use
For weekly review of warehouse orders and delivery lead times, use composite-key reconciliation followed by tolerances and dated exchange rates.
Skills pack
Contract scaffold and deterministic mock
Download · 11KBSHA-256 a90b3b4bbae4e24d6af012e8350b823f39c736493a2d85ecadc0ea9b923ce98a
Related components
-
Announcement event studies
Events aligned with historical values + windowed outcome analysis
Working 1 pipeline -
Campaign and holiday evidence enrichment
Changes aligned with calendar candidates + source review queue
Working 1 pipeline -
Audited curation and database publishing pipeline
Human merge and override decisions + controlled data sync
Working 1 pipeline