How to detect missing refund and fee rows in payout exports
If you need to check whether refunds, fees, chargebacks, or adjustments are missing before import, start with the report built for reconciliation rather than the payout export alone. Shopify points teams to the activity report, PayPal offers both a Balance report and a Settlement report for different reconciliation views, and Stripe balance transactions give you the underlying ledger of balance-impacting events.
TaxRouter editorial team
Choose the report that matches the reconciliation question
If your question is whether a payout export is missing refund or fee rows, the first decision is which report is designed to show the full movement behind the payout. On Shopify, payout details can include transactions, fees, refunds, chargebacks, and adjustments, and Shopify’s guidance for lower or missing payouts points teams to the activity report.
The activity report is the better starting point when you want to compare all of those event types across a date range. It is intended to reconcile transactions, fees, refunds, chargebacks, adjustments, and payouts over that range. That makes it more useful than a narrow payout export when you are checking whether a row is absent or only appears in a different report view.
PayPal splits the same problem into two different reports. The Balance report is intended to reconcile sales, refunds, disputes, fees, and withdrawals against end-of-day balances. The Settlement report, by contrast, reconciles to the settlement withdrawal, so it answers a narrower question about the withdrawal itself rather than the full balance history.
Read the report by event type, not by payout alone
When you compare exports, treat refunds, fees, chargebacks, and adjustments as event types that may appear in different places depending on the report. A payout file can show the payout movement, but the reconciliation report is what helps you see whether the underlying rows are present in the period you are checking.
On Stripe, balance transactions are the ledger of balance-impacting events. They include charges, refunds, payouts, and fee-related transaction types. For a reconciliation review, that structure matters because you are not just looking for a payout amount; you are looking for each event that changes the balance.
A practical reading order is to start with the reconciliation report, then compare it with the payout export. If the payout export shows a payment movement but you do not see a matching refund, fee, or adjustment row, the reconciliation report is the place to confirm whether the event is present under a different transaction type or a different date in the range.
- Shopify: activity report for transactions, fees, refunds, chargebacks, adjustments, and payouts.
- PayPal: Balance report for sales, refunds, disputes, fees, and withdrawals against end-of-day balances.
- Stripe: balance transactions as the ledger of balance-impacting events.
Use the narrower report only when you need the settlement view
The Settlement report is useful when your question is specifically about the settlement withdrawal. PayPal says it reconciles to the settlement withdrawal, which makes it a narrower view than the Balance report.
That narrower scope also explains why it may omit fee fields when no fees are involved. If you are checking for missing fee rows, that is a useful difference to keep in mind: the Settlement report is not trying to behave like a full balance reconciliation report.
So the choice is not simply which export looks cleaner. It is whether you need a settlement-focused view or a balance-focused one. For missing fees, refunds, disputes, or withdrawals, the Balance report gives you the broader reconciliation frame; for matching the settlement withdrawal itself, the Settlement report is the tighter fit.
A simple review sequence before bookkeeping import
Before you import marketplace payout data into bookkeeping, review the report that is meant to reconcile the full set of balance-impacting events, then compare the payout export against it. This helps you spot whether a refund, fee, chargeback, or adjustment is missing from the export or simply appears in a different reconciliation view.
For Shopify, that means checking the activity report alongside the payout details. For PayPal, it means using the Balance report when you need the broader reconciliation picture and the Settlement report when you are checking a settlement withdrawal specifically. For Stripe, it means using balance transactions as the underlying ledger rather than relying on a payout row alone.
Hypothetical example: if a payout export shows the withdrawal amount but you cannot find the fee row you expected, look first in the report that is intended to reconcile fees with the other balance events for that period. If the fee still does not appear there, you at least know the gap is not just a mismatch between report views.
What each provider’s report is good for
Each provider frames the same reconciliation problem a little differently, but the pattern is consistent. Shopify’s activity report is the reconciliation view for transactions, fees, refunds, chargebacks, adjustments, and payouts. PayPal’s Balance report is the reconciliation view for sales, refunds, disputes, fees, and withdrawals against end-of-day balances. Stripe’s balance transactions are the event ledger for charges, refunds, payouts, and fee-related transaction types.
That means the report choice should follow the question you are trying to answer. If you want to know whether a refund or fee row is missing before import, use the report that is built to show the event set around the payout, not only the payout itself. If you want to check the settlement withdrawal only, use the narrower settlement view.
This is general information for reconciliation planning and is not tax or legal advice.