报表数据溯源核对与差异排查
逐项核对报表与源系统数值,计算差异并整理原因、待办及复核签署记录。
完整提示词
<context>
Tying out means proving that each number in a report comes from the system of record, figure by figure, and leaving a trail a reviewer or auditor can follow. It is different from checking that a report adds up internally: a report can be perfectly consistent and still wrong against the ledger. Experienced preparers tie the totals first, then drill into the components only where totals differ. The differences are rarely mysterious. Timing and cut-off: posting date against transaction date, a different timezone, an extract taken before late postings or a restatement. Filters: test or internal accounts, cancelled orders, intercompany lines. Definitions: gross against net of returns, discounts or tax. Currency: a different rate or rate date. Joins in the report query that drop unmatched rows or duplicate them. Rounding. A difference is "explained" only when its amount is accounted for, not when a plausible cause is named. Each line ends in a status, and the preparer and reviewer are recorded.
</context>
<task>
<report_figures>
{{report_figures}}
</report_figures>
<source_figures>
{{source_figures}}
</source_figures>
{{#tolerance}}
Tolerance: {{tolerance}}
{{/tolerance}}
1. Pair each report figure with its source figure. List report figures with no source given as "no source provided".
2. Tie the totals first, then each component. For each line compute the difference and the difference as a percentage of the source.
3. Give each line a status: tied, tied within rounding, explained difference, or open. Use the tolerance given, or rounding only if none.
4. For each difference, test the usual causes against the evidence: cut-off and timing (compare extract times and date fields), filters, definitions, currency, joins (row counts, duplicates) and rounding. Mark a difference explained only when the explanation accounts for its amount; otherwise keep it open with the most likely cause and the check that would confirm it.
5. List fixes: corrections to the report, changes to the query or process so the difference does not recur, and any figure that must not be published until resolved.
6. Write the evidence and sign-off block: the source reference and timestamp per line, preparer, reviewer and date fields to fill.
</task>
<constraints>
- Never mark a line tied or explained without the arithmetic to show it.
- Do not invent source figures, extract times or causes; ask for what is missing.
- Show amounts with their units and currencies; never compare figures in different units without converting and saying so.
- Separate verified facts from inferred causes.
{{> output/uncertainty}}
</constraints>
<output_format>
## Summary
Lines tied, explained and open, with the total unexplained difference and whether the report can go out.
## Tie-out sheet
Table: ref | report figure | location | report value | source | source value | difference | difference % | status.
## Differences explained
Per difference: amount, cause, arithmetic, evidence.
## Open items
Table: ref | amount | most likely cause | check to confirm | owner role.
## Fixes
## Evidence and sign-off
Source references and timestamps, then preparer, reviewer and date lines to fill.
</output_format>可替换内容
- {{report_figures}}
- {{source_figures}}
- {{#tolerance}}
- {{tolerance}}
- {{/tolerance}}
- {{> output/uncertainty}}
分类与标签
办公效率、报表核对、数据溯源、差异排查、复核留痕