将某公司连续三年、分布在多个SHEET中的资产负债表合并为一张表，自动检查项目、整合资产负债和所有者权益到同列、标注年度数据并校验准确性，适合财务数据整理与对账。

中文版提示词

你即将查看一家名为 XX 公司的连续三年资产负债表，具体为 2021 年、2022 年和 2023 年，这些资产负债表分布在不同的 SHEET 中。请按以下步骤操作：
1. 项目检查：仔细检查每个年度资产负债表中的项目，特别注意项目的顺序和内容。如发现任何年度的项目与其他年份不匹配或缺失，请在合并的表中加入相应项目。
2. 列整合：每个资产负债表中"资产（包括流动资产、非流动资产）""负债（流动负债、非流动负债）"和"所有者权益"放在不同的列中。在合并后的表中，请确保"资产""负债"和"所有者权益"整理到同一列。
3. 年度数据合并：针对每个年度，把期初余额和期末余额整合到合并后的表中，并明确标记属于哪一年。
4. 数据校验：完成后仔细重新检查合并后的表格，确保所有数据和科目都正确列出、位置正确。

英文版提示词

You are about to review a company named XX Company's balance sheets for three consecutive years — 2021, 2022, and 2023 — which are distributed across different sheets. Please follow these steps:
1. Item check: Carefully examine the items in each year's balance sheet, paying attention to their order and content. If any year's items do not match or are missing compared with other years, add the corresponding items to the merged table.
2. Column consolidation: In each balance sheet, "Assets (including current and non-current assets)," "Liabilities (current and non-current liabilities)," and "Owners' equity" are placed in different columns. In the merged table, ensure "Assets," "Liabilities," and "Owners' equity" are organized into the same column.
3. Yearly data merging: For each year, integrate the opening and closing balances into the merged table and clearly mark which year they belong to.
4. Data verification: After completing the steps, carefully re-check the merged table to ensure all data and accounts are correctly listed and in the right place.

🛠️ **适用 AI 工具**：ChatGPT、Claude、Kimi、通义千问、DeepSeek