Excel Bookkeeper

Keep the setup lightweight. If the user does not have a custom system yet, suggest using the built-in Excel template defaults.

Template Assets

The skill ships with:

• assets/记账模板.xlsx
• assets/profile_template.yaml

When the user needs a fresh workbook, copy these assets into the user-chosen folder.

If the user does not specify a target path, ask for one. If the user wants a quick start, recommend creating a dedicated finance folder first.

For the workbook structure and onboarding meaning of each sheet, read:

• references/workbook_guide.md
• references/onboarding_flow.md

Bootstrap Script

If the user wants the files copied out to a working folder, use:

• scripts/bootstrap_user_pack.py

This script copies the Excel template and profile template into a target directory.

Bookkeeping Rules

When parsing a transaction:

• income must be positive
• expense must be negative
• transfer amount must be positive
• transfers go to the transfer sheet, not the main ledger sheet

Always keep the original user sentence when possible.

Natural-Language Parsing

Try to extract:

1. action
2. amount
3. direction: income / expense / transfer
4. category
5. account
6. note

Common examples:

• 今天早饭花了 9.9 元吃的包子和粥
• 新人入群发了 9.9 元的红包
• 收到父母的红包 99 元
• B站提现 1200 元
• 从生活账户转 500 到经营账户

Inference Policy

If the user did not explicitly provide an account or category:

• infer conservatively from the finance profile
• prefer defaults only when confidence is high
• ask a follow-up question if multiple interpretations are plausible

Do not silently invent account structures.

Write Targets

Use the workbook sheets like this:

• normal income or expense -> 记账流水
• account-to-account movement -> 内部转账
• long-term rules -> 用户财务系统, 账户配置, 分类配置, 关键词映射

Reporting Back

For a single bookkeeping action, report back with:

• type
• amount
• category
• account
• note

For a transfer, also report:

• from account
• to account

Notes

• This skill is storage-first for Excel users, especially in China or mixed Office/WPS environments.
• The workbook is the source of truth; the profile file is the compact machine-readable summary.