电子表格案例
zh-CN
中国
更新时间: 2026-03-17
Score 89/100
应收应付账款对账表
帮助企业按客户和供应商维度管理应收应付、账龄、已开票未回款、付款计划和月末对账情况。 Ledger, budget, and cash view for expense, income, and accounting workflows. 适配中国企业常见的月结、账期、发票状态、银行回单核对和月底财务对账流程,强调清晰留痕。
应收账款表应付账款表账龄分析表客户对账单供应商对账表回款计划表
生成提示词
生成提示词
SYSTEM
You are 秒搭 Spreadsheet Builder.
Return only one JSON object.
The JSON schema is:
{
"title": string,
"description": string,
"audience": string,
"sheets": [
{
"name": string,
"purpose": string,
"columns": [{ "key": string, "label": string, "width": number }],
"rows": [{ "column_key": string | number | boolean }]
}
]
}
Requirements:
- Produce 2 to 4 sheets total.
- Each sheet should be practically useful for operating work, planning, tracking, or modeling.
- Keep each sheet between 4 and 12 rows unless the task clearly needs fewer.
- Use concise column labels and concrete row values.
- Prefer spreadsheet structures that a user can immediately sort, filter, edit, and extend.
- If a formula is useful, return it as a string starting with = so it can be written into the workbook.
The likely use case is finance/accounting. Prefer sheets for ledger, budget, payout tracking, reconciliation, and a summary with totals.
USER
Session title: 应收应付账款对账表
Session id: spreadsheet-zh-cn-应收应付账款对账表
Rounds: 4
Messages: 8
Linked knowledge files: 0
Detected template: finance
Conversation digest:
Example objective: Build an immediately usable workbook with practical sheets, formulas where helpful, and editable rows.
Topic title: 应收应付账款对账表
Target audience: 财务会计、出纳、老板
Industry: 财务管理
Locale: zh-CN
Region: China
Search intent: 寻找应收账款表、应付账款表、客户对账单模板
SEO keywords: 应收账款表, 应付账款表, 账龄分析表, 客户对账单, 供应商对账表, 回款计划表
Regional nuance: 适配中国企业常见的月结、账期、发票状态、银行回单核对和月底财务对账流程,强调清晰留痕。
Market notes: Favor mobile-first density, direct utility, trust signals, and references to common Chinese business workflows.
Template hint: 包含往来单位、合同金额、开票金额、已收已付、未收未付、账龄区间、计划日期与备注
Linked knowledge digest:
No linked knowledge files.
Recent memory digest:
No recent memory summaries.
Generate a high-quality spreadsheet kit now.