Agent skill

Data Reconciliation Exceptions

by sundial-org in sundial-org/awesome-openclaw-skills

Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks.

No licenceAuto-check passedBusiness, Finance & HR

Install Data Reconciliation Exceptions

skills CLI
$ npx skills add sundial-org/awesome-openclaw-skills --skill data-reconciliation-exceptions -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install sundial-org/awesome-openclaw-skills data-reconciliation-exceptions --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/sundial-org/awesome-openclaw-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/data-reconciliation-exceptions .claude/skills/data-reconciliation-exceptions && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
data-reconciliation-exceptions
GitHub stars
663
Token cost
~880 tokens
SKILL.md length
388 words
Files
3 (incl. references, assets)
Skills in repo
353
Repo updated
First seen
Licence
None found

At a glance

Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks.

  • Works in 7 steps: Confirm sources and key priority (Pay… → Normalize columns → Validate keys → …
  • You need weekly matching with explicit reasons for non-joins and mismatches
  • SKILL.md covers PURPOSE, WHEN TO USE, INPUTS and OUTPUTS, plus 4 more sections
  • Needs DUPLICATE_KEY and INVALID_KEY

What it does

Data Reconciliation Exceptions is an agent skill from sundial-org/awesome-openclaw-skills. Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks. Use when you need weekly matching with explicit reasons for non-joins and mismatches.

Its SKILL.md is about 880 tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including reference files and assets (for example `references/matching-rules.md`).

It sits in Business, Finance & HR, covering Accounting and bookkeeping. The repository describes itself as: Top OpenClaw skills, with the most popular and useful ones.

When your agent uses it

  • You need weekly matching with explicit reasons for non-joins and mismatches
  • Tasks that involve Accounting and bookkeeping

Example prompts

  • “no silent failure”
  • “Use the data-reconciliation-exceptions skill to reconcile data sources using stable identifiers (Pay Number, driving licence, driver card, and…”
  • “/data-reconciliation-exceptions”

Requirements

  • A credential in DUPLICATE_KEY
  • A credential in INVALID_KEY

Workflow steps

7 steps, taken from the first numbered list in SKILL.md.

  1. Confirm sources and key priority (Pay Number → Driver Card → Driving Licence → DQC).
  2. Normalize columns
  3. Validate keys
  4. Join
  5. Produce exception categories with reasons
  6. “No silent failure” gates
  7. STOP AND ASK THE USER if

What it can do on your machine

Read from SKILL.md and the folder at commit b80cde2. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are csv).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names these keys or tokens, usually read from environment variables:

    • DUPLICATE_KEY
    • INVALID_KEY

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Data Reconciliation Exceptions loads about 880 tokens when it runs, and up to ~984 if it reads all its reference files. Until then it costs about 77 tokens; SKILL.md has 388 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~77
When it runs · the whole SKILL.md, loaded when a task matches
~880
With references · SKILL.md plus every file in references/, read only if the agent opens them
~984

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 388 words (~880 tokens).

“Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks.”

— opening of SKILL.md by sundial-org
name
data-reconciliation-exceptions

Read the full SKILL.md on GitHub

Files

SKILL.md and 2 other files (references, assets) in skills/data-reconciliation-exceptions of sundial-org/awesome-openclaw-skills.

  • SKILL.md
  • assets/exceptions-report-template.csv
  • references/matching-rules.md

Open the folder on GitHubat commit b80cde2

Compare with similar skills

Data Reconciliation Exceptions next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Data Reconciliation Exceptions compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Data Reconciliation Exceptions this skillsundial-org/awesome-openclaw-skills663—~880Automated safety check: PassNone
Sync Upstreamnyaruka/phonenumbers1.6k—~2.8kAutomated safety check: PassMIT
Longbridge Value Investinghelsome/folio2692 repos~1.2kAutomated safety check: PassMIT
Radiology Tablehuang-sir1/radiology-skills1.9k—~1.3kAutomated safety check: PassCustom licence
Odoo Agency Fleet Reviewerpipe-org/mcp-odoo420—~699Automated safety check: PassMIT
Beancount Closebex-co/beancount-io295—~1.4kAutomated safety check: PassMIT

Similar skills

  • Sync Upstream

    nyaruka/phonenumbers

    Sync this Go port with a new upstream google/libphonenumber release — regenerate the embedded metadata and reconcile the ported Java logic.

    1.6k GitHub stars~2.8k tokensUpdated 6 days ago
    Business, Finance & HRAuto-check passed
  • Value investing analysis using Graham (NCAV/net-net/defensive-investor) and Buffett (economic moat/ROE/FCF) methodologies.

    269 GitHub starsUsed in 2 repos~1.2k tokens
    Business, Finance & HRAuto-check passed
  • Radiology Table

    huang-sir1/radiology-skills

    Create/audit editable publication tables with source reconciliation; not figures or statistical inference.

    1.9k GitHub stars~1.3k tokensUpdated 17 days ago
    Business, Finance & HRAuto-check passed
  • Odoo Agency Fleet Review

    erpipe-org/mcp-odoo

    Review many client Odoo databases at once through odoo-mcp's cross-instance tools — fleet-wide accounting health, per-client aging, partial-failure triage — for agencies and partners managing 5–50…

    420 GitHub stars~699 tokensUpdated 1 mo ago
    Business, Finance & HRAuto-check passed
  • Beancount Close

    bex-co/beancount-io

    Close an accounting period in a Beancount ledger by reconciling each active account through beancount-reconcile, checking assertions and recurring gaps, reviewing flags, then proposing a commit with…

    295 GitHub stars~1.4k tokensUpdated yesterday
    Business, Finance & HRAuto-check passed
  • ERPClaw ERP Controller

    avansaber/erpclaw

    Operates the ERPClaw self-hosted ERP in plain language: accounting, invoicing, inventory, purchasing, tax, HR, payroll and reports, treating the ERP as the single source of truth.

    114 GitHub stars~15k tokensUpdated 2 days ago
    Business, Finance & HRAuto-check passed

More from sundial-org/awesome-openclaw-skills

All 353 skills in this repo
  • UI UX Pro Max

    sundial-org/awesome-openclaw-skills

    UI/UX design intelligence and implementation guidance for building polished interfaces.

    663 GitHub starsUsed in 2 repos~657 tokens
    Auto-check passed
  • Web Deploy GitHub

    sundial-org/awesome-openclaw-skills

    Create and deploy single-page static websites to GitHub Pages with autonomous workflow.

    663 GitHub starsUsed in 1 repo~1.1k tokens
    Auto-check passed
  • Clawd Modifier

    sundial-org/awesome-openclaw-skills

    Modify Clawd, the Claude Code mascot. An agent skill from sundial-org/awesome-openclaw-skills.

    663 GitHub stars~625 tokensUpdated 7 mo ago
    Auto-check passed
  • Figma

    sundial-org/awesome-openclaw-skills

    Professional Figma design analysis and asset export. An agent skill from sundial-org/awesome-openclaw-skills.

    663 GitHub stars~1.7k tokensUpdated 7 mo ago
    Auto-check: notes
  • Edge Tts

    sundial-org/awesome-openclaw-skills

    Text-to-speech conversion using node-edge-tts npm package for generating audio from text.

    663 GitHub starsUsed in 1 repo~1.8k tokens
    Auto-check passed
  • Habit Flow

    sundial-org/awesome-openclaw-skills

    AI-powered atomic habit tracker with natural language logging, streak tracking, smart reminders, and coaching.

    663 GitHub stars~3.1k tokensUpdated 7 mo ago
    Auto-check passed

Questions about Data Reconciliation Exceptions

What does Data Reconciliation Exceptions do?

Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks. Data Reconciliation Exceptions is an agent skill from sundial-org/awesome-openclaw-skills. Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks.

When should I use Data Reconciliation Exceptions?

Data Reconciliation Exceptions fits situations like: you need weekly matching with explicit reasons for non-joins and mismatches; tasks that involve Accounting and bookkeeping.

How do I install Data Reconciliation Exceptions in Claude Code?

Run `npx skills add sundial-org/awesome-openclaw-skills --skill data-reconciliation-exceptions -a claude-code`. Or copy the skill folder (skills/data-reconciliation-exceptions in sundial-org/awesome-openclaw-skills) into .claude/skills/data-reconciliation-exceptions in your project. Claude Code loads it when a task matches its description.

How do I install Data Reconciliation Exceptions in Codex?

Run `npx skills add sundial-org/awesome-openclaw-skills --skill data-reconciliation-exceptions -a codex`. Or copy the skill folder (skills/data-reconciliation-exceptions in sundial-org/awesome-openclaw-skills) into .agents/skills/data-reconciliation-exceptions in your project. Codex loads it when a task matches its description.

Can I use Data Reconciliation Exceptions in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add sundial-org/awesome-openclaw-skills --skill data-reconciliation-exceptions -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/data-reconciliation-exceptions, .gemini/skills/data-reconciliation-exceptions, .github/skills/data-reconciliation-exceptions and .opencode/skills/data-reconciliation-exceptions in your project.

What does Data Reconciliation Exceptions need to run?

Going by SKILL.md and its folder, Data Reconciliation Exceptions needs credentials named DUPLICATE_KEY and INVALID_KEY. Our summary lists: A credential in DUPLICATE_KEY; A credential in INVALID_KEY.

Does Data Reconciliation Exceptions access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Data Reconciliation Exceptions safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Data Reconciliation Exceptions use?

No licence was found for Data Reconciliation Exceptions or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Data Reconciliation Exceptions use?

About 880 tokens (SKILL.md is roughly 3.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 104 tokens, read only when the agent opens those files.

What are the alternatives to Data Reconciliation Exceptions?

Skills that share tags, products or a category with Data Reconciliation Exceptions: Sync Upstream (nyaruka/phonenumbers, 1.6k stars), Longbridge Value Investing (helsome/folio, 269 stars), Radiology Table (huang-sir1/radiology-skills, 1.9k stars) and Odoo Agency Fleet Review (erpipe-org/mcp-odoo, 420 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Data Reconciliation Exceptions?

sundial-org (a GitHub organization) maintains it in sundial-org/awesome-openclaw-skills, which has 663 GitHub stars. The repository holds 353 skills in this directory. The repository was last updated on March 7, 2026.

Source: sundial-org/awesome-openclaw-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.