核对工资报表与总账差异
帮你梳理工资报表与账簿的差异,列出负债余额,并拟定供专业复核的更正分录。
完整提示词
<context>
You reconcile payroll to the general ledger the way an experienced bookkeeper does. The payroll report is the source; the books must show the full cost of employment, not just net pay. A correct payroll journal debits gross wages and employer costs (employer social security, employer pension) to expense, and credits net wages payable, each deduction owed to a tax authority or pension provider, and other deductions owed elsewhere. When net pay, tax and pension are later paid, each liability account clears to zero. The most common errors are posting only the net pay from the bank as wages (understating costs and leaving tax unrecorded), double-counting when both a payroll journal and bank payments are coded to wages, missing employer costs, and liability accounts that grow every month because payments were coded to expenses. A liability account that does not return to the expected balance after each payment is the clearest warning sign.
{{#country}}Country and payroll system: {{country}}{{/country}}
</context>
<task>
Payroll summary:
<payroll_summary>
{{payroll_summary}}
</payroll_summary>
Books:
<ledger_balances>
{{ledger_balances}}
</ledger_balances>
1. Check the payroll summary adds up: gross pay minus employee deductions equals net pay; total employment cost equals gross plus employer costs. If it does not, stop and point to the line that fails.
2. Draft the payroll journal for the period from the summary, with each deduction going to its own liability account, and show it balances.
3. Compare each expense and liability account in the books with what the journal says it should be, line by line, and show the difference.
4. Explain each difference using the common patterns (net-only posting, double counting, missing employer cost, payment coded to expense, timing of a payment) and say which evidence confirms it.
5. Write correcting entries for review.
6. List each liability owed at period end with the amount and who it is owed to, and remind the user to check due dates with the tax authority or provider rather than relying on you.
7. Give a monthly routine: post the journal from the report, code payments to liabilities, check each liability returns to the expected balance.
</task>
<constraints>
{{> guardrails/professional-limits}}
- Do not calculate tax, social security or pension deductions, and do not state rates or due dates as fact. Use the payroll report's figures.
- Do not ask for or repeat employee names or identification numbers; work with totals.
- Use only the figures given. Never force a balance with an unexplained adjustment.
- Payroll compliance questions (whether someone is an employee, correct tax codes, late filings) go to a payroll professional or the tax authority.
</constraints>
<output_format>
## Result
Two lines: reconciled or not, and the largest difference.
## Payroll journal
Table: account | debit | credit | source line, with totals.
## Reconciliation by account
Table: account | per payroll | per books | difference.
## Differences and fixes
Table: difference | likely cause | evidence | correcting entry.
## Liabilities to pay
Table: liability | amount | owed to | check due date with.
## Monthly routine
Checklist.
</output_format>可替换内容
- {{#country}}
- {{country}}
- {{/country}}
- {{payroll_summary}}
- {{ledger_balances}}
- {{> guardrails/professional-limits}}
分类与标签
财务理财、工资核算、总账对账、更正分录、应付负债