How to check a payout export for missing refunds and fees before import
If a payout or settlement export may be missing refunds, fees, disputes, or other balance-affecting rows, check the provider’s balance-focused report first, then compare it with the narrower payout export. That order helps you separate the full balance history from the settlement file you plan to import.
TaxRouter editorial team
Start with the report that shows balance movements, not the payout file
When you suspect that a payout export is incomplete, the first check should be the report that captures balance-affecting activity in full. For PayPal, that is the Balance report, which is designed to reconcile sales, refunds, disputes, fees, and withdrawals against end-of-day balances. By contrast, the Settlement report is narrower and is used to reconcile the settlement withdrawal itself. That difference matters because a settlement export can be too narrow to tell you whether a missing refund or fee row is the reason the payout total looks wrong.
For PayPal accounts, the Balance report gives you the broader view you need before import. If the balance report shows the expected refund or fee activity and the settlement export does not, the settlement file is the one to question. If both reports line up, the missing item may be outside the payout file you are checking, or it may belong to a different period or transaction group.
Use balance activity as the reference list for the payout
For Stripe, the clearest reference point is the balance transaction list. Stripe describes balance transactions as the ledger of balance-impacting events, and that list can be filtered by payout ID. In practical terms, that means you can start from the payout and work back to the transactions that changed the balance rather than treating the payout export as the full record.
If you are comparing a payout export to the underlying balance activity, look for the refund, fee, dispute, adjustment, or transfer rows that should have contributed to that payout. A payout file alone tells you what was paid out; the balance transaction list tells you what fed into it. Using the balance ledger first is the safer way to check whether the import file is missing rows that affect the bookkeeping entry.
Use statements as a secondary control, not the first one
PayPal’s monthly and custom statements include only transactions that affect the PayPal balance. That makes them useful as a secondary control for period reconciliation when you want to confirm whether a balance-affecting transaction is present somewhere in the statement period.
That role is different from the Balance report. The statement is useful when you need a second check across a defined period, but it is not the best first report if your immediate question is whether a payout export is missing refund or fee rows before import. If the statement and the Balance report agree, you have another sign that the issue is probably in the narrower settlement export rather than in the provider’s balance history.
Watch for changing report fields when you rely on marketplace exports
Amazon’s Reports API documentation notes that Amazon periodically adds new fields and field values to reports. For an ecommerce finance lead, that is a reminder to treat marketplace exports as moving targets rather than fixed templates.
If a payout or settlement file suddenly looks different, a new field or field value may be part of the reason the export does not line up with your usual import checks. Before you post the file, compare the current export layout with the version you normally use and confirm that the rows you expect are still present. This is especially relevant when you are checking for balance-affecting rows that may be carried in fields or formats that were not in the earlier export version.
Sources: [6]
A simple decision order for the import check
Use a three-step order when you are deciding which report to check first. First, identify the provider’s balance-focused source: PayPal Balance report or Stripe balance transactions. Second, compare that source against the narrower payout or settlement export you plan to import. Third, use statements or other period reports as a secondary control if the first comparison does not explain the difference.
Hypothetical example: if a PayPal settlement export does not show a refund you expect, check the Balance report first. If the Balance report includes the refund and the settlement export does not, you have confirmed that the settlement file is the narrower view. If you are working in Stripe, filter the balance transactions by payout ID and compare the rows with the payout export. That sequence helps you answer the real question before import: is the file missing balance-affecting rows, or is it simply a settlement extract with less detail? This article provides general information and is not tax or legal advice.