返回提示词目录第 1542 页

试算表生成管理财务报表

将试算表账户映射至损益表和资产负债表,检查借贷平衡、列示未入账调整并输出管理报表。

完整提示词

<context>
You prepare management statements from a trial balance the way an experienced accountant does. Every account maps to one line: income statement accounts to revenue, cost of sales, overheads by type, other income and finance costs; balance sheet accounts to non-current assets, current assets, current liabilities, non-current liabilities and equity. Before year-end close, the trial balance still holds the period's income and expense accounts, so the profit for the period must be carried into equity for the balance sheet to balance. Common traps: owner drawings or dividends shown as expenses, loan repayments in overheads, a suspense balance hidden in other debtors, tax control accounts netted wrongly, credit card balances treated as bank, and the current portion of loans not split out. These are management statements; statutory accounts follow a framework, format and disclosures that an accountant prepares.

Business: {{business}}
</context>

<task>
Trial balance:

<trial_balance>
{{trial_balance}}
</trial_balance>

1. Check that total debits equal total credits. If they do not, stop and report the difference and the likely causes.
2. Map every account to a statement line, showing the mapping in a table. Flag any account whose balance is on the unexpected side or whose name suggests it belongs elsewhere.
3. Build the profit and loss: revenue, cost of sales, gross profit and margin, overheads grouped by type, operating profit, finance costs, profit before tax. Use comparatives if given.
4. Build the balance sheet: non-current assets at net book value, current assets, current liabilities, net current assets, non-current liabilities, net assets, and equity including the profit for the period and drawings or dividends. Show that net assets equal equity.
5. List adjustments not yet made that commonly change the figures (depreciation, accruals, prepayments, stock count, bad debts, tax provision, splitting the loan current portion) and whether the trial balance suggests they are missing.
6. Write a short commentary: three to five points an owner should notice.
7. Recompute every subtotal before answering.
</task>

<constraints>
{{> guardrails/professional-limits}}
- Use only the balances given. Do not invent adjustments; list them as "not yet made" with why they matter.
- Label the output as management statements, not statutory or filed accounts, and do not compute tax.
- If the statements do not balance after mapping, show the difference; never plug it.
- Keep account names as given in the mapping so the user can trace every figure.
</constraints>

<output_format>
## Checks on the trial balance
Bullets with totals.

## Account mapping
Table: account | balance | statement | line | flag.

## Profit and loss
Table with subtotals (and comparatives if given).

## Balance sheet
Table with subtotals; final line shows net assets equal to equity.

## Notes and adjustments not yet made
Bullets, then the short commentary.

## Questions
Bullets.
</output_format>

可替换内容

  • {{business}}
  • {{trial_balance}}
  • {{> guardrails/professional-limits}}

分类与标签

财务理财、财务报表、试算表、会计核算、报表检查

前往 AI 图片创作