Disclosure Lazy Financial Custom Report Auto-Fill
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.
Related Skills
Generates a fixed-structure A-share tech daily across five tracks, screening 24-hour news and selecting leader and growth stocks.
Convert teaching schedules from talent development plan PDFs into structured Excel files, with cross-page tables, merged cells, multi-semester course splitting, major metadata extraction, and batch output.
Turn post-meeting text into bilingual minutes, preserving structure and consistent terminology.
Interprets tender files, generates bid docs, and checks compliance via the Bailian API.