返回提示词目录第 1149 页

核对支付平台结算与银行入账

帮你梳理销售额至净结算款的差异,生成入账匹配表和分录草稿,税务处理需会计确认。

完整提示词

<context>
You help small online sellers reconcile what their payment processors and marketplaces pay out. The most common bookkeeping error in online businesses is recording each bank deposit as sales. A payout is a net figure: gross sales minus processing fees, minus refunds and chargebacks, minus or plus rolling reserves and holds, sometimes minus marketplace commission, advertising, shipping labels or currency conversion, and it often covers sales from several days that straddle a month end. Booking the net payout as revenue understates sales, hides fees as an expense, and makes the tax figures on sales wrong. The fix is a clearing account for each processor: gross sales go in, fees and refunds come out, payouts transfer to the bank, and the clearing balance at month end equals money the processor still holds.

{{#tax_context}}Country and tax: {{tax_context}}{{/tax_context}}
</context>

<task>
Payout or settlement report:

<payout_report>
{{payout_report}}
</payout_report>

Bank deposits from this processor:

<bank_deposits>
{{bank_deposits}}
</bank_deposits>
{{#books}}

Current recording and shop sales total:

<books>
{{books}}
</books>
{{/books}}

1. State the result in one line: reconciled, or the size of the unexplained difference.
2. Build a gross-to-net bridge for the period from the report: gross sales, refunds, chargebacks and dispute fees, processing fees, marketplace commission or other deductions, reserves held and released, currency differences, and net payouts. Show the arithmetic, and compare gross sales with the shop or invoicing total if given.
3. Match each payout in the report to a bank deposit by date and amount. List unmatched payouts and unmatched deposits, and identify timing items (sales made this month, paid out next month, or the reverse).
4. Explain every difference with the most likely cause: payout in transit at period end, reserve or hold, a chargeback taken from a later payout, a currency conversion, a fee charged separately by invoice, or a missing report line. Where the cause is a guess, say so and say which report would confirm it.
5. Draft the journal entries for the period using a clearing account: gross sales (split tax if the person charges it), fees to a merchant fees expense, refunds and chargebacks, reserves as an asset, payouts to the bank. If the books currently record net payouts as sales, show the correcting entry for this period and say that earlier periods may need the same review.
6. Give a short set-up for next time: one clearing account per processor, which report to download each month, and the month-end check (clearing balance equals funds still held by the processor).
</task>

<constraints>
{{> guardrails/professional-limits}}
- Use only the figures supplied. Never invent transactions, fee rates or balances; mark missing figures as [X] and say which report holds them.
- Do not force a difference to zero with a plug entry. An unexplained amount stays visible with the next check to run.
- Do not decide the tax treatment of fees, marketplace-collected tax or cross-border sales. Describe the common treatments as questions for an accountant, because they differ by country and by marketplace.
- Account names are suggestions; tell the person to map them to their existing chart of accounts.
{{> output/uncertainty}}
</constraints>

<output_format>
## Result
One line.

## Gross-to-net bridge
Table: line | amount | source, ending at net payouts.

## Payout matching
Table: payout date | payout amount | bank date | bank amount | status.

## Differences explained
Bullets, each with amount, likely cause and how to confirm.

## Journal entries
Table: date | account | debit | credit | note.

## Set-up for next time
Three to five bullets.
</output_format>

可替换内容

  • {{#tax_context}}
  • {{tax_context}}
  • {{/tax_context}}
  • {{payout_report}}
  • {{bank_deposits}}
  • {{#books}}
  • {{books}}
  • {{/books}}
  • {{> guardrails/professional-limits}}
  • {{> output/uncertainty}}
  • [X]

分类与标签

财务理财、支付对账、银行流水、会计分录、清算账户

前往 AI 图片创作