How to Reconcile Payment Processor Payouts Against Invoices
Match gross client receipts to invoice allocations, then reconcile fees, refunds and batch adjustments with the net bank payout.
Free text file with blank fields and a filled example. No signup required.
InvoiceAgent includes a 7-day free trial. No credit card required.
At a glance
Match gross client receipts to invoice allocations, then reconcile fees, refunds and batch adjustments with the net bank payout.
Best for
Service businesses checking why a processor's bank settlement differs from invoice payment totals.
Evaluation method
Reviewed 2026-10-02
Original service-billing worksheet and fictional worked example. Workflow reviewed October 2, 2026; not a claim about measured customer outcomes. Approvals, payment allocation, client portals, and tax decisions remain separate from scheduled delivery.
Using InvoiceAgent
After approvals and amounts are checked, use InvoiceAgent to prepare and schedule invoice delivery.
Illustrative example
Two receipts settle as one smaller bank amount
- Confirmed gross receipts
- USD 1,000 + USD 500 = USD 1,500
- Reported fees
- USD 45.50
- Reported refund
- USD 100
- Other adjustments
- USD 0
- Net payout to reconcile
- USD 1,354.50
Fictional settlement batch and fee amounts. The refund and each gross receipt need their own document references.
See the recorded product workflowDecisions to make before billing
A bank payout is not necessarily one client payment. It can settle several gross receipts after fees, refunds and other adjustments. Starting from the bank amount alone can make fully paid invoices appear short or lead to an unexplained write-off.
Use two linked checks: allocate confirmed gross client receipts to invoice records, then reconcile the processor's settlement batch to the bank amount. Keep the transaction IDs, payout reference and currency visible. An estimated fee calculator is useful for a rough check, but the actual report supplies the settlement evidence.
Stripe's payout reconciliation documentation describes matching automatic payouts to their underlying transaction batches. Manual or instant payout reconciliation can require a different approach. Follow the report that fits your provider and payout type; this guide does not claim InvoiceAgent imports those reports or posts accounting entries automatically.
Quick context
Section
Practical guides to scheduling invoices, writing reminders, and managing recurring client billing.
Best for
Service businesses checking why a processor's bank settlement differs from invoice payment totals.
Outcome
Use this page to move from general research into a calmer, more repeatable invoicing process.
Work through the billing decision
Identify the payout and transaction set
Find the payout reference, currency and relevant report period. Use the provider's itemized records to identify included receipts and adjustments. Allow for a bank posting date that differs from the provider's reported timing.
Allocate gross receipts to invoices
Match each confirmed client payment to its invoice or advance using transaction references and remittance details. Keep allocation separate from the processor fee deduction, and review refunds against their own authorized records.
Reconcile net and investigate differences
Add the gross receipts, subtract the reported fees and refund amounts, and include other signed adjustments in the same currency. Compare the result with the actual payout. Assign unexplained amounts rather than forcing them into a client balance.
Preview the review checklist
Replace the bracketed fields with your client’s details. The download also includes the filled example shown on this page.
PROCESSOR PAYOUT RECONCILIATION Payout ID / provider / currency / report period: [details] Bank amount / posting date / reference: [details] Transaction ID | type | gross | fee | signed adjustment | net | invoice or approval reference [rows] Confirmed gross receipt total: [amount] Reported fees / refunds / other signed adjustments: [amounts] Calculated net / actual payout / difference: [amounts] Gross invoice allocations verified: [references] Unexplained difference / owner / next check: [details] Failed, pending or FX records (separate): [details] Reviewed by / date / report evidence: [details]
Sources and further reading
Free resource
Keep the review checklist
Download the blank worksheet and filled example, then adapt them to your client agreement.
Download text fileWhere teams usually lose momentum.
Avoid this
Treating net settlement as partial payment
A fee-deducted payout can be smaller than the gross receipt even when the client paid the invoice in full. Verify both records before following up on a supposed shortage.
Avoid this
Mixing batch boundaries
A receipt or refund can belong to a different settlement batch than expected. Use payout and transaction references, not only a matching calendar date or round total.
Move from reading about the workflow to running it.
InvoiceAgent is designed for the last mile of getting paid: scheduled invoice delivery, reminder timing, professional PDFs, and send-time FX conversion when global billing is involved.
Related topics
Find more guides and practical tools in the resources below.
Questions people usually have before changing the workflow.
Can I use estimated fees to close the reconciliation?
Use the actual fee and adjustment report to close it. An estimate can flag a likely explanation but is not confirmation of what was deducted.
What if the payout includes two currencies?
Reconcile each currency and any documented conversion separately. Do not add nominal amounts across currencies.
What if a payout fails?
Track the failed or pending payout separately from confirmed client receipts. Investigate the provider's actual status and any later settlement before treating the bank transfer as received.
Related pages
Useful tools
Browse the free tools for help with dates, totals, and reminder planning.
Decision pages
Compare software by the delivery, payment, and follow-up features you need.