Why does a payment-processor payout differ from my sales?

A payment-processor payout can differ from sales because it covers a different set of transactions and dates, after fees, refunds and other adjustments. Some money may remain with the provider or be in transit. Reconcile the original payments to the provider's balance and transfer records, then match actual bank receipts at the same cutoff.

I would avoid starting with the question “which fee explains the gap?” The difference may not be a fee at all. If the report includes cash payments the processor never handled, or a transfer has not arrived, inventing a processing expense would make the books less accurate while producing a reassuring total.

Give each record a job

The order or payment record identifies what customers paid and by which method. The provider's transaction record shows the payments it handled and associated adjustments. Its balance and transfer records explain what remains there and what was sent. The bank establishes what reached the specified account.

Use matching currencies and cutoffs. A transaction date, batch cutoff, transfer initiation date and bank posting date can differ. Preserve those dates instead of forcing every report into the date on the sales screen.

Confirm the account and entity too. A business with several shops, payment channels or bank destinations can accidentally compare one site's report with a group transfer. A repeated amount is not enough to prove the match.

The bank-reconciliation guide handles the bank account's complete statement-to-books process. This earlier bridge establishes the provider activity and transfers that the bank reconciliation will need.

Recover the complete record

Obtain the opening provider balance, successful processed payments, refunds, fees, other actual adjustments, ending balance and transfer details. Keep the references that connect individual events to their batches and bank receipts. Record any restricted or held portion separately from an amount available to transfer.

Check actual refund treatment. For a primary provider example, Square's refund guidance explains that processing fees are not returned and describes funds being taken from the balance or linked bank account. Those are Square's stated arrangements, not a universal rule for every payment service.

Use the agreement and actual record for your provider. A refund may relate to a payment from an earlier period, and an adjustment may affect the bank separately. Preserve that relationship rather than reducing this week's payments without identifying which event changed.

If a dispute exists, use its own case record and instructions. The payout reconciliation should reflect the supported funds movement; it does not decide whether the merchant will win the case or whether the customer deserves a remedy.

Build a bounded example

Consider a completely fictional business reviewing March 1–7, 2027, with every report using the same UTC cutoff. All amounts are U.S. dollars. The provider opens with a $500 balance from earlier processed customer payments. There are no opening transfers in transit.

The week's completed-order payment report totals $12,000: $10,000 of successful card payments handled by this provider and $2,000 of cash collected directly by the business. No tax, tips, gift-card issuance, financing or other payment category appears in this limited case.

During the week, the provider completes $400 of refunds against identified payments included in the $10,000 card total. It charges $300 in complete fees, including the actual refund treatment assumed for this fiction. There are no disputes, additional adjustments or currency conversions.

The provider's closing statement shows $900 remaining after removing initiated transfers. Of that amount, $800 is held under the supplied arrangement and $100 is currently available to transfer. A hold is not a processing expense or proof that the money has reached the bank.

Reconcile the provider balance

Start with $500, add $10,000 of new card payments, subtract $400 of refunds and $300 of fees. That gives $9,800 to account for. The provider initiated transfers totaling $8,900 and retained a closing balance of $900. Together those also total $9,800.

Scroll horizontally if needed. The opening balance and closing retained funds both matter.

This assumes the fictional statement removes an initiated transfer from its displayed balance. Actual providers may display states differently. Establish the definitions before using the same bridge on a real report.

The closing $900 is not all currently transferable. The $800 hold plus $100 available explains its composition. Nor is the $500 opening balance another sale this week. It carries money from an earlier period into this week's movement.

Match transfers to the bank

The fictional provider initiated three transfers: $5,300, $3,300 and $300. The first two reached the bank by the March 7 cutoff. The third remains in transit, supported by its own reference and initiation record.

Actual bank receipts from this provider therefore total $8,600: $5,300 plus $3,300. Adding the $300 transfer in transit reconciles them to the $8,900 initiated total. The bank has not received that last $300 merely because the provider marked it sent.

Check each reference and destination, not only the totals. Two identical transfers on different dates can be allocated incorrectly while leaving the sum unchanged. Preserve enough detail that another person can follow the match.

If the bank shows an amount with no provider match, investigate the actual source. If the provider shows a transfer that never arrives, follow its status through the appropriate established support process. Keep the discrepancy assigned and open; do not invent a miscellaneous expense to close it.

Explain the whole gap

The $12,000 completed-order payment total exceeds the $8,600 provider bank receipts by $3,400. The first $2,000 is cash received directly, outside this provider. That cash has its own custody and deposit record and is not missing from the provider's payout.

For the remaining $1,400 difference between card payments and bank receipts, identify four components: $400 refunds, $300 fees, a $400 increase in the provider balance and $300 in transit. They total $1,400.

The balance increase is $900 closing less $500 opening, not the whole $900. Deducting all closing funds without adding the opening balance would misstate the bridge. Likewise, the $800 held portion is already inside the closing balance; subtracting it again would count the hold twice.

The complete check is $12,000 − $2,000 − $400 − $300 − $400 − $300 = $8,600. Each deduction has a different meaning. Only the identified fees are fees. A refund, retained funds and an outstanding transfer should not all become one expense called the payout difference.

These are payment and movement records. They do not establish full business profit. Fulfillment, acquisition, staff, premises and other operating costs sit outside this bounded settlement bridge.

Follow the next period without creating a second sale

Suppose the $300 in-transit transfer arrives on March 9, with no correction to its amount. Match it to the existing transfer and close that outstanding item. Provider-related bank receipts from these three transfers now total $8,900.

That March 9 receipt is not another $300 customer sale. The original customer payments have already been identified. The cash has changed location and completed its transfer.

In a separate later event, assume the provider releases the $800 hold without making any bank transfer. The retained balance remains $900, now all available under the supplied terms. Bank cash has not risen by $800. A release of restriction and an actual payout are different events.

If the business requests the $900, track that request through the real process. A requested transfer should not enter the bank balance as received until the actual evidence supports it. Its timing may matter to an upcoming bill even when the eventual total is clear.

Resource the reconciliation

The fictional business assigns two paid hours at an all-in $36 to retrieve reports, check matches, investigate and document the result. That costs $72. The hours are available within the planned work, and a separate $200 administration allocation funds them, leaving $128.

That administration is outside the provider's $300 fee total. Do not alter the provider bridge to include an internal wage payment it never deducted. Record and fund the company's work through its proper process.

If exports omit a needed reference, identify the actual retrieval route or additional work. A reconciliation that depends on manual matching should say so. Repeated friction may affect the suitability of the service, but it does not make an uninvestigated difference a fee.

Keep the original files, cutoffs, transaction matches and explanations. Record who prepared and reviewed the bridge and which items remain unresolved. Use appropriate access and retention for sensitive payment data; do not copy unnecessary card information into a general working sheet.

Check errors that can still balance

A duplicated customer sale and an invented offset can make a report appear reconciled. So can allocating one customer's refund to another transaction. Trace original references and actual events rather than accepting agreement of totals as proof that every entry is correct.

Confirm that a bank feed has not recorded the payout as new sales after the underlying customer charges were already entered. The appropriate accounting workflow depends on the books, but the same customer event should not produce two sales merely because money later reached the bank.

Do not delete a transfer in transit just because it crosses month end. Carry it forward with evidence and follow-up. An old outstanding transfer needs investigation, not an automatic write-off or a fresh sale entry when it arrives.

The processing-quote comparison helps assess stated pricing. This reconciliation supplies the different answer of what actually happened to a defined payment record and its money.

Keep the settlement checklist

1. Choose the provider, entity, currency and common cutoff.
2. Separate provider-handled payments from cash and other tender.
3. Reconcile opening balance, processed payments, supported adjustments, transfers and closing balance.
4. Match initiated transfers to bank receipts and identify transit items.
5. Keep holds, fees, refunds and new sales in their proper categories.
6. Carry unresolved items forward with an owner and next action.
7. Record later transfers without creating another customer sale.