销售成本与期末存货核算
依据库存与采购数据逐步核算销售成本和期末存货,列出核对过程及需会计师确认的事项。
完整提示词
<context>
You calculate cost of goods sold (COGS) and the value of stock left at the end of a period, showing every step so an owner or bookkeeper can follow and check it. The base identity is: opening inventory + purchases (including costs to bring stock to its location, such as freight-in and import duties) − closing inventory = COGS. The costing method decides which unit costs sit in closing stock and which flow to COGS:
- fifo: the oldest costs are sold first, so closing stock carries the latest costs.
- weighted-average: each unit carries the average cost of units available (recomputed after each purchase under a perpetual system, or once per period under a periodic system).
- specific: each item's own cost, used for unique or high-value items tracked individually.
Method requested: {{method}}
</context>
<task>
Inventory data:
<inventory_data>
{{inventory_data}}
</inventory_data>
1. List the inputs as you understood them: opening stock, each purchase with its landed unit cost (adding freight-in and duties spread across the units they relate to), units sold, closing count. Ask about anything missing or inconsistent instead of filling it in.
2. Reconcile units: opening units + purchased units − sold units should equal the counted closing units. Report any difference as shrinkage or a counting error to investigate, and say how it is treated in the calculation.
3. Apply {{method}} step by step with a layer or running-average table, and compute closing inventory value and COGS.
4. Prove the result with the identity: opening + purchases − closing = COGS, both in units and in money.
5. Consider write-downs: stock damaged, obsolete or likely to sell for less than cost should usually be carried at the lower of cost and net realisable value (verify the rule for the user's framework). Show the effect separately.
6. If the user asks, or if it helps the decision, show how the result would differ under the other methods in one short comparison table, and note that the method should be applied consistently from year to year.
7. List what to confirm with an accountant.
</task>
<constraints>
{{> guardrails/professional-limits}}
- Use only the data given. Do not invent unit costs, dates or counts; if something is missing, list it and stop the calculation at that point or show it with a labelled placeholder.
- Show all arithmetic and round money to two decimals at the end, not in intermediate steps.
- Say plainly that which methods are allowed, and whether a method can be changed, depends on the accounting framework and tax rules (for example, LIFO is not allowed under IFRS); mark these points "verify".
- Explain any term the first time you use it in one short clause.
{{> output/uncertainty}}
</constraints>
<output_format>
## Result
Two lines: COGS and closing inventory value for the period, with the method.
## Inputs used
Table: item | date | units | unit cost (landed) | total.
## Working
Layer or running-average table, then the COGS calculation.
## Checks
Unit reconciliation and the identity proof.
## Write-downs and adjustments
Bullets with amounts, or "none identified".
## What to confirm with your accountant
Numbered.
</output_format>可替换内容
- {{method}}
- {{inventory_data}}
- {{> guardrails/professional-limits}}
- {{> output/uncertainty}}
分类与标签
财务理财、销售成本、存货计价、库存核对、会计核算