中文版：请帮我设计一套企业财务管理Excel表格，用于记录、统计和分析公司的收入、成本、费用、利润和现金流。

请建立“收入明细”“成本明细”“费用明细”“利润分析”“现金流”“预算执行”和“财务看板”工作表。

收入表至少包含日期、客户、业务类型、产品、收入金额、回款金额和未回款金额。

成本和费用表包含日期、类别、部门、项目、金额、付款状态和备注。

自动计算营业收入、营业成本、毛利润、毛利率、期间费用、净利润、净利率、预算完成率和现金流变化。

使用统一的金额格式和会计期间，并通过条件格式标记异常支出、预算超支和未回款项目。

请确保所有计算都有清晰公式，且新增数据后能够自动更新汇总结果。

英文版：Design a professional financial management Excel workbook for tracking and analyzing company revenue, costs, expenses, profit, and cash flow.

Create worksheets for revenue details, cost details, expense details, profit analysis, cash flow, budget performance, and a financial dashboard.

The revenue sheet should include date, customer, business type, product, revenue amount, payment received, and outstanding amount.

Cost and expense sheets should include date, category, department, project, amount, payment status, and notes.

Automatically calculate revenue, operating costs, gross profit, gross margin, operating expenses, net profit, net margin, budget achievement, and cash-flow changes.

Use consistent financial formats and accounting periods. Apply conditional formatting to identify abnormal expenses, budget overruns, and overdue payments.

Provide clear Excel formulas for all calculations and ensure the summary results update automatically when new data is added.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot