AI Agent Hub
Back to skills
Disclosure Lazy Financial Custom Report Auto-Fill icon

Disclosure Lazy Financial Custom Report Auto-Fill

Office Efficiency Updated 2026.08.29

Paste the following prompt into your AI chat to install this skill:

Please install @user_1002ca6a/report-auto-fill according to https://skillhub.cn/install/skillhub.md.

About this skill

Problem

Financial custom reports often mix trial balance sheets, business data, scanned PDFs, and Excel templates. Fillers must repeatedly confirm field sources, debit/credit directions, totals, and period conventions. Manual copying is slow, and the mapping rules often remain in chat history or sheet notes, so similar reports require re-derivation later.

How It Works

The skill constrains the workflow with a report signature + rule base model:
- Identify the report first: read reference docs, extract source fields and template fields, and match an existing report signature.
- Solidify rules next: infer mappings from field names and accounting knowledge, then store confirmed rules with rule_store.py in ~/.workbuddy/report_rules/rules_db.json.
- Validate before filling: run a rule coverage check, preview extracted values, and generate the output with fill_report.py; direct cell edits that bypass the rule base are not allowed.

Boundaries

It fits structured financial templates with recognizable fields, such as balance sheets, income statements, and trial balances. If data is fully unstructured or template fields cannot be identified, manual field cleanup is needed first. The skill enforces rules first: stop and complete rules when coverage is missing, rules are not stored, or preview is not confirmed.

Use Cases

  • Month-end: extract ending balances from a trial balance sheet and fill balance sheet asset, liability, and equity fields.
  • Given an Excel income statement template and expense data, generate operating profit and net income rules, then preview and fill.
  • Recognize table fields in a scanned PDF revenue file and map them to a custom report template with stored rules.
  • Match an existing report signature from last month and reuse its rule base to refill a similar current-month report.

Best For

  • Finance specialists who need to fill balance sheet templates from trial balance data.
  • Accountants who prepare monthly income statements and check debit/credit and profit formulas.
  • Financial analysts who consolidate business spreadsheets into custom report templates.
  • Process owners who maintain reusable report-filling rules and reduce repeated manual mappings.