Keep the refund event date and original payment date in separate fields. Match each refund to its actual payment, then distinguish refunds of payments inside the requested period, refunds of earlier payments and refunds whose original reference is unresolved. Follow the requesting provider’s definition when preparing the figure it asked for. Do not silently move a refund to the earlier period, subtract every current refund from current-period sales, or rewrite the original report to make the figures agree.
For: A research-only merchant preparing historical processing figures where current-period refunds refer to payments made before the period began.
Copy the wording of the request before calculating a number. Processing activity during a date range and the later refund history of payments originally taken during that range describe different sets of events. A request for gross payment volume also differs from one for a net activity figure. If the request leaves that distinction open, preserve both dates in your working record and ask which basis the provider requires.
Record the period boundaries, account, legal entity, currency and the date field used by the source report. Keep the report’s time reference visible where stated. Do not convert an unstated cutoff into an assumed calendar month. The purpose is a traceable answer to this request, not a universal definition of revenue.
Preserve the ledger event and connect it to the earlier payment
Stripe’s balance report covers a selected period in the settlement currency and offers itemized transactions. Its gross, fee and net components describe the report’s balance activity. The report does not associate payouts with payment transactions, so a bank deposit is not the missing original-payment link.
A card refund has its own Stripe balance transaction. Preserve that event alongside the original payment instead of replacing the payment with a reduced figure. Stripe describes the balance-transaction type as the movement and the source as the originating object; reporting_category is its recommended grouping field. Use those distinctions to identify actual refund movements rather than classifying every debit as a refund.
For each refund, follow the reference available in the provider’s records to the refund and original payment. Record the payment date from that payment record. Equal amounts or nearby dates are not a reliable substitute for the link. If a file does not expose enough information, mark the original reference unresolved and retain the refund in the activity record; do not invent the original sale month.
Build the bridge without counting a refund twice
Group the verified refund events into three sets: original payment inside the requested period, original payment before the period, and original payment not yet matched. Retain individual refund references, amounts, currencies and statuses underneath each set. Multiple partial refunds can point to one payment; they remain separate refund events and do not create extra original sales.
Within the same account, currency and chosen refund-event scope, the amounts in those three sets should account for the refund total you are explaining. If they do not, keep the unmatched difference visible and locate the omitted, repeated or differently classified records. Do not add a balancing amount. If the report uses signed amounts, preserve that convention and state it in the bridge.
A history view organized by original payment date must also say which refund observation period it covers. A current-period refund export cannot establish that a payment has never been refunded outside that export’s dates. Conversely, refunds of earlier payments can be genuine current balance activity without belonging to the current period’s original-payment group. Keep both facts rather than choosing the more flattering presentation.
Submit the defined figure with its timing explanation
When the provider specifies an event-period basis, use the events and inclusion rules it requests and attach a separate explanation of refunds tied to earlier payments. When it requests a view tied to original sales, group by the verified original dates and disclose the refund observation cutoff. Neither presentation requires changing a provider-issued statement. Keep the original export and label the bridge as your preparation worksheet.
If the definition is still unresolved, identify the available gross payment figure, refund event figure and timing split separately without presenting a guessed net figure as the answer. The remaining question is which definition the requester wants, or which refund lacks an original reference. A Prism processing consultation can help organize that description; confirm scope, fees and terms before work. The provider decides what evidence satisfies its request.
Cross-period refund bridge
Complete this privately for one requested account, period and currency. Repeat the event rows for each actual refund. The dated refund record stays intact; the bridge explains its link to an original payment and does not amend a statement.
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.
Cross-period refund bridge. The last column is for temporary notes.
Bridge component
Record to retain
How to interpret it
Your entry
Requested period definition
Record to retainExact request wording, date boundaries and whether gross activity, net activity or original-payment history is requested.
How to interpret itAn undefined basis remains a clarification question before a single summary figure is supplied.
Report scope
Record to retainProvider report name, account label, date field, time reference and settlement currency.
How to interpret itOnly compare totals drawn from the same stated scope.
Refund event date
Record to retainRefund reference, event date and corresponding provider movement.
How to interpret itThis locates refund activity without redating the original payment.
Original payment date
Record to retainThe linked payment reference and the date on that provider record.
How to interpret itAssign inside-period or earlier-payment status only from a verified link.
Refund amount record
Record to retainAmount, currency, sign convention and actual status for each distinct refund.
How to interpret itKeep partial refunds distinct; do not count a refund again when grouping it under its payment.
Unmatched original reference
Record to retainRefunds whose original payment cannot yet be located and the exact missing link.
How to interpret itRetain them as unresolved; do not assume they belong to the current or prior period.
Period bridge total
Record to retainSame-scope totals for inside-period originals, earlier originals and unmatched originals.
How to interpret itTogether these should explain the refund activity being reconciled, without a balancing entry.
Provider clarification
Record to retainWritten answer about the reporting basis and any requested observation cutoff.
How to interpret itUse the confirmed definition and preserve the bridge beside the unchanged originals.
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.
Limits
This worksheet organizes a processing-history response; it does not set accounting recognition or tax treatment.
Stripe report fields describe Stripe. Another provider’s files require that provider’s definitions, and currencies must remain separate.
Do not place statements, customer records, full bank details or payment credentials in the public consultation form.
Stripe balance transaction types — checked 2026-09-29. A card refund is a separate balance movement. Type describes the movement, source identifies its originating object and reporting_category is recommended for grouping; these labels do not set revenue recognition.
Stripe balance summary report — checked 2026-09-21. The report covers a selected period in settlement currency, separates gross, fee and net activity and exports itemized transactions. It does not associate payouts with payment transactions.
Prism solutions — checked 2026-09-21. Prism offers storefront review and processing preparation within an agreed scope. Scope, fees and terms are discussed before work; the provider decides eligibility and account terms.
Discuss my processing options
Want to talk through your own processing situation?