A batch fee does not match the number of sales

Find the unit before checking the arithmetic

Keep the invoice’s batch label beside the exact fee term, its effective period and the account it covers. Determine whether the written term identifies an event, a grouping or another billable unit. If an incorporated schedule supplies the definition, retain that schedule with the agreement. Do not fill a silent definition with a convention from another processor.

Stripe’s Services Agreement illustrates why account-specific terms matter: its agreement includes general, service and incorporated terms, regional terms depend on account country, and written fee agreements can differ from public pricing. Those facts do not establish that Stripe charges your batch fee or define another provider’s batch. Use the agreement of the company that billed the line. A public fee page is not a substitute for the applicable written terms.

Keep the sale, capture, settlement grouping and payout separate

A sales report counts the events the store calls sales. A capture record identifies a payment event. A settlement grouping and a payout record answer different questions again. Your reconciliation needs the relationship between those records, not a renamed sales total. The fee’s written unit determines which record belongs in the charge count.

For Stripe specifically, payout reconciliation matches automatic payouts to settlement batches, and those batches can include earlier transactions. Stripe also documents that a payout can contain multiple balance transactions; the payout object itself does not list the underlying transactions. A payout count therefore cannot stand in for a transaction count. Neither fact says that a payout is the billable unit under a batch-labelled fee.

Stripe does not automatically match manual payouts to transactions, and its automatic payout reconciliation report is not a universal report for every payout type. Where that automatic mapping is absent, identify the real supporting records needed for the fee unit. Do not force the automatic-payout report onto a manual payout or treat a missing match as a missing sale.

Build a count that can be traced back to events

For the invoice period, collect the provider batch references that satisfy the written definition. Preserve the event date, report date field, time zone if shown, and account scope. If the contract and report use different date bases, record that difference before comparing totals. A bank-arrival date is not automatically the batch date the fee uses.

Count each distinct billable unit according to the agreement. If a report repeats one batch reference across several underlying transactions, do not count every displayed row as a new batch unless the fee term actually uses that unit. Keep repeated references visible while explaining the count, so the provider can reproduce your grouping.

Compare that count with the invoice quantity. Where a written per-unit rate applies, reproduce the amount using that rate and only the other adjustments expressly stated for the line. If the invoice supplies an amount without a quantity, do not derive a supposedly confirmed count from the sales total. Request the billed quantity and event references.

Distinguish a matched line from an unanswered line

A matched line has a documented unit, an applicable period, traceable events and arithmetic that reproduces the billed amount. A unit that is undefined, a quantity without event references, or a date boundary that cannot be reconciled remains open even when the total looks plausible. Conversely, a difference from the store’s number of sales can be expected when the written unit counts something else.

Prepare a focused inquiry naming the invoice line, fee term, batch references, date basis and exact unmatched quantity or amount. Ask the billing provider which event or term accounts for the difference. That is a reproducible question, not a claim that the charge is unlawful or that a credit is owed.

If you want to discuss this as part of a Prism processing consultation, describe the research-only business and the specific term or record you cannot reconcile. Confirm the scope of any requested fee analysis, responsibilities, fees and terms before work begins. The billing provider supplies its charge explanation; the worksheet cannot determine enforceability or guarantee a correction.

Batch-charge unit reconciliation

Complete one sheet per invoice line and account. List only genuine provider references in your internal record. A complete match requires the same contract unit, date basis and scope on both sides; mark a missing definition or event list as unresolved rather than substituting the sales count.

Worksheet entries are not submitted by Prism’s worksheet and are not saved by the site. Use record types, availability, anonymized observations, or match/mismatch results. Do not enter government identifiers, customer names or addresses, customer messages, receipt-access links, card or bank details, passwords, or keys. Send sensitive documents only through the provider’s verified secure channel.

These are temporary notes. Leaving or reloading this page may clear them. Worksheet entries are not sent automatically. If you copy notes into the consultation message and submit the form, Prism receives them as part of your request.