skills.rest
hzlawliet
hzlawlietCOMMUNITY
Explore all skills by this author →
GitHub

family-bookkeeping

Convert natural-language entries and WeChat/Alipay exports into canonical ledger records for Feishu Bitable.

Updated Apr 16, 2026
Search Tags:#bookkeeping#deduplication#feishu#expense-tracking#normalize#bitable#bill-import
One-click install
npx skills add https://github.com/hzlawliet/family-bookkeeping --skill family-bookkeeping
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: family-bookkeeping
Source: https://github.com/hzlawliet/family-bookkeeping/tree/main
Command: npx skills add https://github.com/hzlawliet/family-bookkeeping --skill family-bookkeeping

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Make shared household bookkeeping simple and consistent by turning natural-language notes and exported WeChat/Alipay statements into a canonical ledger that can be reviewed, summarized, and imported into Feishu Bitable. This removes manual spreadsheet cleanup, reduces duplicate imports, and provides quick month/year reporting for family finances.

Core Features & Use Cases

  • Natural-language single-entry bookkeeping: add income or expense rows from casual phrases such as "今天午饭 32" with auto date and basic category inference.
  • Bill normalization and import pipeline: convert WeChat (.xlsx) and Alipay (.csv) exports into a canonical JSON/CSV schema, run dedupe prechecks, and produce a Feishu-importable CSV.
  • Live queries and lightweight updates: summary reporting (monthly/yearly), recent-record lookup, and single-record update when match is unambiguous.
  • Safe import rules: prefers transaction-id dedupe, skips zero-amount rows, preserves original source, and requires explicit confirmation for destructive actions.

Quick Start

Tell the assistant a natural-language entry like "今天午饭 32" to add a record or provide an exported WeChat/Alipay bill file to normalize and prepare a Feishu-importable CSV.

Frequently Asked Questions about family-bookkeeping

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I import WeChat and Alipay bill files into Feishu Bitable for shared household bookkeeping?▼

You can import WeChat and Alipay bills into Feishu Bitable by converting exported .xlsx and .csv statements into a canonical ledger schema, running dedupe prechecks by transaction id, and producing a Feishu-importable CSV file.

Can I add family expense records using natural language inputs like "今天午饭 32"?▼

Yes, you can add family expense records using natural language inputs like "今天午饭 32". The system automatically parses casual phrases into canonical ledger entries with auto date and basic category inference for single-entry bookkeeping.

What is the best way to prevent duplicate entries when importing Alipay or WeChat statements into a ledger?▼

The best way to prevent duplicate entries during bill import is using transaction-id deduplication. The pipeline skips zero-amount rows, preserves original source data, and requires explicit confirmation for destructive actions to ensure safe imports.

Do I need specific environment variables or credentials to write bookkeeping records directly into Feishu Bitable?▼

Yes, you need Feishu credentials configured via environment variables to enable direct write into Feishu Bitable. This setup allows the normalized JSON and CSV outputs to be pushed into your shared household bookkeeping workflow.

Does this bookkeeping approach support generating monthly and yearly financial summaries?▼

Yes, this bookkeeping approach supports generating monthly and yearly financial summaries. You can perform live queries for summary reporting and recent-record lookups, alongside lightweight single-record updates when the match is unambiguous.

What happens to zero-amount rows when normalizing exported bill files for household expense tracking?▼

Zero-amount rows are automatically skipped when normalizing exported bill files for household expense tracking. This safe import rule ensures your canonical ledger records remain clean and accurate during the batch import pipeline.

Related Skills

Explore More Finance & Accounting Skills→
wuzeyouwuzeyou
13

moneywiz

Convert Alipay and WeChat bills into MoneyWiz-compatible CSV with categorization.

Community
Advanced
ARCASSystemsARCASSystems
2

finance-import

Parse CSV financial data and output a normalized markdown summary.

Community
Intermediate
wensiawensia
2

uploading-images-to-feishu

Uploads generated poster images to Feishu Bitable attachments via drive API.

Community
Intermediate
QingHeYangQingHeYang
4

easyaccounts

Manage EasyAccounts finances conversationally, including transactions, queries, reports, and status checks.

Community
Intermediate