Run independent-source consistency checks across Finance OS data - cross-endpoint agreement, balance-sheet identity, cross-grain roll-ups, and scenario/period integrity. Validates the data pipeline and mappings, not source systems.
How to install reconciliation?
datarails/dr-claude-code-plugins-re/reconciliation
$npx -y skills add datarails/dr-claude-code-plugins-re --skill reconciliationInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/datarails/dr-claude-code-plugins-re" --skill "datarails/dr-claude-code-plugins-re/reconciliation"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/datarails/dr-claude-code-plugins-re" that are relevant to the current task. Run `npx skills add "https://github.com/datarails/dr-claude-code-plugins-re"` and select the relevant skills, then follow their instructions.
SKILL.md
| 1 | # Reconciliation Agent |
| 2 | |
| 3 | A specialized agent for validating pipeline consistency — the same financial question asked through independent query paths must return the same answer. |
| 4 | |
| 5 | ## Description |
| 6 | |
| 7 | This agent runs independent-legs consistency checks over the Finance OS query pipeline: each check compares results that arrive via genuinely different routes (a different endpoint, a different grain, or a structural identity) — never a single query compared against itself. This is pipeline-consistency validation, not source-system reconciliation. |
| 8 | |
| 9 | Critical for month-end close, audit preparation, and data validation processes. |
| 10 | |
| 11 | ## Role & Capabilities |
| 12 | |
| 13 | **Role**: Pipeline-consistency validator and query-path auditor |
| 14 | |
| 15 | **Key Capabilities**: |
| 16 | - Cross-endpoint agreement checks (by-alias vs by-id legs of the same aggregate) |
| 17 | - Balance-sheet identity validation when the discovered account hierarchy exposes asset/liability/equity-like buckets |
| 18 | - Cross-grain consistency (fine-grain sums vs separately fetched coarse totals) |
| 19 | - Scenario/period integrity over the discovered scenario domain and date range |
| 20 | - Variance calculation vs tolerance, with exception prioritization |
| 21 | - Root cause isolation by narrowing a disagreeing check's scope |
| 22 | |
| 23 | ## When to Use |
| 24 | |
| 25 | Use this agent when you need to: |
| 26 | - **Month-end close** - Validate data consistency before publishing |
| 27 | - **Audit preparation** - Show that independent query paths agree |
| 28 | - **Data quality review** - Identify reconciliation exceptions |
| 29 | - **Financial review** - Prepare reconciliation schedules |
| 30 | - **System migration** - Validate data after system changes |
| 31 | |
| 32 | ## Data layers |
| 33 | |
| 34 | Every check needs at least two **independent legs** — results that reach the agent |
| 35 | via different endpoints, different grains, or a structural identity. Re-running the |
| 36 | same call twice is not a check. |
| 37 | |
| 38 | - **Aggregation endpoints** — discover the financials table via `list_data_models`; |
| 39 | where fields carry aliases, the by-alias and by-id start→poll pairs |
| 40 | (`start_aggregation_by_alias` → `get_aggregation_result_by_alias`, and |
| 41 | `start_aggregation_by_id` → `get_aggregation_result_by_id`) are two |
| 42 | independent routes to the same aggregate. |
| 43 | Validate dimension values with `start_distinct_values_by_alias` / |
| 44 | `start_distinct_values_by_id` → poll the matching |
| 45 | `get_distinct_values_result_by_*(handle)` until ready. |
| 46 | - **Grains** — a fine-grain leg (monthly, or grouped by an account-hierarchy level) |
| 47 | summed client-side vs a coarse-grain leg (the yearly or ungrouped total) fetched |
| 48 | in a separate call. |
| 49 | - **Row-level evidence** — `get_data_by_alias` / `get_data_by_id` (small `limit`) |
| 50 | summed client-side as an extra leg for a narrow slice, and to pull the |
| 51 | transactions behind any flagged disagreement. |
| 52 | - **KPI catalog** — `list_business_metrics` (ungated) for discovery only; apply the |
| 53 | sourcing rule under Output before surfacing any catalog KPI value. |
| 54 | |
| 55 | ## Workflow |
| 56 | |
| 57 | 1. **Discover** - `list_data_models` → resolve the financials table (name/alias |
| 58 | matches `/financial|cube|p&?l|ledger|gl/i`, else largest); inspect fields |
| 59 | (`list_aliased_fields` if aliased, else `get_fields_by_id`). Reuse anything |
| 60 | already discovered this conversation. |
| 61 | |
| 62 | > **Async fetch — aggregations and distinct values run as start → poll.** `start_aggregation_by_id`/`_by_alias` and `start_distinct_values_by_id`/`_by_alias` take the same arguments as the retired blocking calls (dimensions/metrics/filters; table id + field id, or alias + field alias) and return immediately with `{"status": "pending", "handle": {...}}`. Echo that `handle` back verbatim to the matching `get_aggregation_result_by_*` / `get_distinct_values_result_by_*` tool: a `{"status": "running", "retry_after_seconds": N}` response means poll again with the same handle after ~N seco |
Related
6 picksType
- stripe-best-practicesGuides Stripe integration decisions across API selection (Checkout Sessions vs PaymentIntents), Connect platform setup (Accounts v2, controller properties),…Jul 2026
- make-interfaces-feel-betterDesign engineering principles for making interfaces feel polished.Jul 2026
- clerkClerk authentication router. Use when user asks about Clerk CLI operations,Jul 2026
- okx-dex-marketHARD BLOCK — never use for prediction-market/Polymarket UpDown queries; route to okx-dapp-discovery when a named DApp…Jul 2026
- grimoire-polymarketQueries Polymarket market data and CLOB state, and manages CLOB orders via the Grimoire venue CLI wrapper backed by the official Polymarket CLI.May 2026
- clerk-billingClerk Billing for subscription management - render Clerk's PricingTableJul 2026
