中文版：请帮我制作一份企业发票管理Excel表格，用于管理发票开具、接收、付款和报销状态。

表格包含发票号码、发票类型、开票日期、客户或供应商、项目名称、金额、不含税金额、税额、税率、付款状态、报销状态、负责人和备注。

自动计算发票总金额、不含税金额和税额。

通过数据验证设置发票类型、税率、付款状态和报销状态的标准选项。

使用条件格式标记待付款、待报销、信息缺失和可能重复的发票。

增加月度发票统计、供应商发票统计和项目发票统计。

英文版：Create an enterprise invoice management Excel workbook for tracking issued invoices, received invoices, payments, and reimbursement status.

Include invoice number, invoice type, invoice date, customer or supplier, project name, total amount, pre-tax amount, tax amount, tax rate, payment status, reimbursement status, owner, and notes.

Automatically calculate total invoice amount, pre-tax amount, and tax amount.

Use data validation to create standardized options for invoice type, tax rate, payment status, and reimbursement status.

Use conditional formatting to highlight unpaid invoices, pending reimbursements, missing information, and potential duplicate invoices.

Add monthly invoice statistics, supplier invoice analysis, and project-level invoice analysis.

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