Kelly invoice sheet
Extract invoices, receipts, credit notes, statements, PDFs, images, docs, and spreadsheet-like invoice exports into a reviewable table with field confidence, line items, approval decisions, and CSV/JSON export. Use when the user invokes /kelly-invoice-sheet or $kelly-invoice-sheet, asks for "Invoice转表格", invoice OCR, receipt-to-spreadsheet, invoice data extraction, bookkeeping import prep, or a Lido-style Extract Data workflow with a Busabase-backed App-in-Skill UI.From its SKILL.md
npx -y skills add mr-kelly/skills --skill kelly-invoice-sheetAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 5 stars5 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
8.5 KB, as published. Nobody here has run it
Kelly Invoice Sheet
Overview
Use this skill to turn invoice files or extracted invoice text into a structured batch that the user can review in a Busabase-backed spreadsheet-style UI. The skill owns extraction, reasoning, validation, and export; the AirApp only reads/writes its own Busabase Bases and records human decisions.
Default interaction mode: App UI. Unless the user explicitly asks for chat-only handling, ensure Busabase resources are provisioned (the AirApp does this lazily on first run), write extracted invoices with scripts/import_batch.mjs, and give the actual AirApp URL (or the local preview URL when local preview is explicitly requested).
App UI Screenshots
<table> <tr> <td width="33%"><img src="assets/screenshots/overview.webp" alt="Kelly Invoice Sheet spreadsheet extraction desk"></td> <td width="33%"><img src="assets/screenshots/detail.webp" alt="Kelly Invoice Sheet invoice detail review"></td> <td width="33%"><img src="assets/screenshots/extract-data.webp" alt="Kelly Invoice Sheet Extract Data upload modal"></td> </tr> <tr> <td><strong>Spreadsheet extraction desk</strong><br>Sheet-like invoice table with extracted rows, status filters, confidence flags, and human-attention counts.</td> <td><strong>Invoice detail review</strong><br>Editable invoice fields, line items, confidence notes, and approve/request-changes/block controls.</td> <td><strong>Extract Data upload</strong><br>Lido-style upload modal with local file, Google Drive, OneDrive, and email source options.</td> </tr> </table>Mandatory Dependencies
- Read and follow
$kelly-app-skill-creatorfor product behavior, visual quality, responsive layout, and the complete canonicalcontent/kelly-invoice-sheet-app/artifact. - Read and follow
$busabasefor connection, target Space, node discovery, ChangeRequests, review, and merge behavior. - Read and follow
$busabase-app-creatorfor resource modeling, AirApp runtime limits, security, validation, and deployment.
If a dependency is unavailable, preserve this skill's artifact and product contracts, stop before the unavailable Busabase operation, and report the exact missing dependency. Do not invent a second data backend.
Workflow
- Accept invoice source files or source text from the user. Supported workflow inputs include PDFs, images, Word docs, CSV/XLS/XLSX exports, OCR text, email attachments, and pasted invoice text.
- Extract invoice header fields, line items, totals, currency, dates, vendor identity, bill-to, payment terms, and source snippets. If OCR or document parsing needs another installed skill or tool, use it, then normalize the result into this skill's batch schema.
- Read
references/invoice-batch-schema.mdbefore writing a batch file. - Write a batch JSON file (an object with an
invoicesarray, or a bare array of invoice objects), keeping stableidandrefvalues such asReview #1. - Run
node scripts/import_batch.mjs --file <batch.json> --applyto validate and write the batch into Busabase'sinvoicesBase. - Give the user the AirApp URL (or start local preview with
pnpm --dir content/kelly-invoice-sheet-app devif explicitly requested). - After the user approves rows in the app, run
node scripts/export_decisions.mjs --applyto export approved invoices to CSV and JSON and mark themdone.
Use chat-only mode only when the user says "chat only", "no UI", "纯聊天", "不要打开 UI", or similar.
Boundary
- The AirApp reads and writes its own Busabase Bases only; it never mutates an external system, uploads an invoice file, pays a vendor, emails anyone, or imports into accounting software. Parent decisions (approve/request-changes/block/revise) write straight onto the invoice record through
busabase-sdk. - The skill performs extraction, reasoning, and validation, then records the result to Busabase via
scripts/import_batch.mjs. It never sends invoice files to an external service from the app itself — any external OCR/API use belongs to the skill workflow and should be explicit. - Export only happens through the trusted
scripts/export_decisions.mjsafter explicit approval in the UI or chat.
Busabase Resources
Two Bases under one application Folder (kelly-invoice-sheet), declared in content/kelly-invoice-sheet-app/app/js/config.js and the generated template sidecars under content/:
invoices: one row per extracted invoice/receipt/credit note/statement — header fields, field confidence (JSON), line items (JSON array, shares the invoice's own lifecycle), risk/warning flags (JSON arrays), and the reviewer's decision (decision-action/decision-note/decided-at) written directly onto the same row. Written byscripts/import_batch.mjswhen the agent finishes extracting a batch; status is set directly by a human decision in the app.settings: sanitized config summary (default currency, extraction preferences, review policy, export preferences — no secrets), one row keyed bykind.
Resources provision lazily through an idempotent Busabase ChangeRequest the first time the app runs in a Space; see references/invoice-batch-schema.md for exact field shapes.
Workflow Statuses
needs_review: extracted row needs human review.changes_requested: user asked the agent to revise extraction.approved: row is ready for export.done: row has been exported or intentionally completed.blocked: row cannot proceed without missing information or source correction.
Extraction Rules
- Preserve source values. Do not invent invoice numbers, dates, tax ids, vendors, totals, or payment instructions.
- Keep original currency. Do not convert currencies unless the user explicitly asks and provides rates.
- Treat money fields as high-risk: totals, tax, amount due, currency, and bank/payment hints should be reviewed when confidence is low.
- Use
field_confidenceandwarningsfor ambiguous OCR, cropped images, handwritten values, missing references, negative totals, credit notes, duplicate invoice numbers, or total/line-item mismatches. - Mark rows
blockedif required fields are missing: vendor name, invoice number, invoice date, currency, or total. - Never send invoice files to external services from the app. Any external OCR/API use belongs to the skill workflow and should be explicit.
Scripts
node scripts/import_batch.mjs --file <batch.json> [--apply]Validates a batch of extracted invoices and upserts each one into Busabase'sinvoicesBase (matched byinvoice-id, so re-running after a correction updates existing rows). Dry run by default.node scripts/export_decisions.mjs [--apply] [--out <dir>]Reads invoices with statusapprovedfrom Busabase, grouped bybatch_id, and exports each batch toexports/<batch-id>/invoices.csv,line_items.csv, andapproved_invoices.json, then marks each exported invoicedone. Dry run by default.
Local App
Default behavior is AirApp-first — give the user the clickable AirApp URL. Start pnpm --dir content/kelly-invoice-sheet-app dev only when local preview/debugging is explicitly requested.
Demo Mode
?demo=1#/invoices/all opens the deterministic offline dataset (3 invoices: 2 needs_review, 1 blocked) for screenshots and review. Demo mode never reads or writes Busabase; demo decisions are read-only.
Safety Defaults
- Treat invoice data as sensitive. Never commit a local credential file.
- The app only edits its own Busabase records. It does not upload invoices, import into accounting systems, send email, pay vendors, or mutate remote systems.
- Export only after explicit approval in the UI or chat, via
scripts/export_decisions.mjs.
Useful Commands
node skills/kelly-invoice-sheet/scripts/import_batch.mjs --file batch.json --apply
node skills/kelly-invoice-sheet/scripts/export_decisions.mjs --apply
pnpm --dir skills/kelly-invoice-sheet/content/kelly-invoice-sheet-app dev
What ships with it: 47 files
128.5 KB alongside SKILL.md, 21 of them executable
agents/
- openai.yaml236 B
app/
- app.jsruns20.2 KB
- demo-visuals.css1.4 KB
- demo-visuals.jsruns4.4 KB
- i18n/messages.jsruns1.3 KB
- index.html650 B
- server/demo-visuals.tsruns12.1 KB
- server/hono.tsruns2.1 KB
- server/index.tsruns625 B
- server/launcher.tsruns2.9 KB
- server/paths.tsruns544 B
- server/setup.tsruns6.3 KB
- setup-gate.css4.5 KB
- setup-gate.jsruns8.8 KB
- start.shruns150 B
- styles.css17.3 KB
assets/
- screenshots/detail-mobile.webp130 B
- screenshots/detail.webp130 B
- screenshots/detail-zh-CN.webp130 B
- screenshots/extract-data.webp130 B
- screenshots/extract-data-zh-CN.webp130 B
- screenshots/overview-mobile.webp130 B
- screenshots/overview.webp130 B
- screenshots/overview-zh-CN.webp130 B
- screenshots/thumbs/detail-mobile.webp130 B
- screenshots/thumbs/detail.webp130 B
- screenshots/thumbs/detail-zh-CN.webp130 B
- screenshots/thumbs/extract-data.webp130 B
- screenshots/thumbs/extract-data-zh-CN.webp130 B
- screenshots/thumbs/overview-mobile.webp130 B
- screenshots/thumbs/overview.webp130 B
- screenshots/thumbs/overview-zh-CN.webp130 B
lib/
- common.tsruns2.5 KB
- data-provider/index.tsruns1.7 KB
- data-provider/local-file-provider.tsruns7.7 KB
- data-provider/provider-interface.tsruns1.9 KB
- invoice-schema.tsruns8.0 KB
- package.json23 B
- paths.tsruns786 B
- config.example.json402 B
7 more files not listed here. See all 47 in the repository.
Gives 0 of the 12 instructions most pdf office docs skills give
Counted across 569 of the 585 authors here whose files we hold, read 2026-09-06
- Ensure every slide fits inside one viewportin 20 of 569, across 11 files
- Check for product marketing context firstin 15 of 569, across 5 files
- Ask for the minimum neededin 15 of 569, across 5 files
- Set the API key environment variablein 15 of 569, across 10 files
- Support keyboard and touch navigationin 14 of 569, across 5 files
- Match the buyer stagein 13 of 569, across 3 files
- Split overflowing content into multiple slidesin 12 of 569, across 3 files
- Set page size explicitly for consistent resultsin 12 of 569, across 5 files
- Convert documents to markdown using pandocin 12 of 569, across 6 files
- Read STYLE_PRESETS.md before generatingin 12 of 569, across 7 files
- Send multipart POST requests to the APIin 12 of 569, across 7 files
- Use smart quotes for new contentin 11 of 569, across 4 files
Said here and by no other author read
- Read references/invoice-batch-schema.md before writing a batch file
- Run node scripts/import_batch.mjs --file <batch.json> --apply
- Give the user the AirApp URL
- Run node scripts/export_decisions.mjs --apply to export approved invoices
- Preserve source values without inventing invoice data
- Keep original currency without converting
Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once.