Influencer Hub homeDiscuss a pilot
Menu

How to Reconcile Influencer Payouts

Reconcile influencer payouts by matching approved amounts to transfer evidence. Track partial settlements, unmatched references and the balance still due.

Two archive drawers holding rows of purple divider cards.

Reconcile influencer payouts by matching each approved amount to transfer evidence for the same payee, currency and cycle. Record partial payments and unmatched references as open items with an owner and a next check.

Which records should agree?

Reconciliation compares what was approved with what actually settled. Start with the approval register and processor or bank evidence. Use a reference shared across records where you have one. Stripe’s automatic payout reconciliation report itemizes balance transactions included in an eligible settlement batch. When reconciling creator obligations, keep your own creator-to-payment mapping. Stripe payout reconciliation

  1. Freeze the approved batch with payee IDs, payout IDs, amounts and currencies.
  2. Import transfer or settlement evidence. Keep provider fees separate and capture final status and the posting date.
  3. Match the stable reference, then validate payee, amount and currency. Use multiple transfer rows for a split payment only when the evidence supports the mapping.

How do you handle a failed match?

Work the differences row by row. Fictional example. The team reviews a USD batch with $850 approved.

Payout Approved Matched settlement Disposition
A-01 $400 $400 Closed
B-01 $300 $250 $50 still due
C-01 $150 $0 $150 still due
Unidentified transfer — $150 unallocated Lookup open

The unmatched $150 might relate to C-01. Leave it unallocated until you can confirm the payee and reference. Keep the $200 in open obligations distinct from the unidentified transfer.

What should finance sign off?

Have finance approve the matched total, the open obligations and the investigation queue. Roll open items into the next close with their original payout IDs. Verify the outcome of any failed or pending attempt before releasing a replacement transfer.

Record the outcome in the payout reconciliation worksheet. If a creator asks about a specific amount, trace their case through the payout dispute process.

Separate approval, execution and settlement

An approval is permission to release a specified amount. A payment instruction requests a transfer. Settlement provides evidence that the transfer reached its recorded terminal state. Keep each event and its source in a separate column. Identical amounts can occur across payees, so use the payout or instruction ID and payee mapping wherever possible. Include payment currency and processing fees separately. A failed instruction can still appear in a provider export.

Give reviewers one source of truth for obligation and one for transfers. Record provider identifiers next to your internal references. A check against the bank or processor settlement report may be handled by someone outside creator operations. Make the mapping understandable without knowing campaign nicknames. Save the location of the approved batch and the cutoff used for the bank or provider evidence.

Close the ledger by matching obligations
  1. Approved obligations$850
    $850
  2. Matched settlements$650
    $650
  3. Still due$200
    $200
  4. Unallocated transfer$150
    $150
Fictional USD batch. The unidentified transfer remains in a separate exception until a matching reference and payee are confirmed.

Work through partial, duplicate and delayed transfers

Fictional close. An approved $600 creator payment generates an instruction for $600, which the provider reports as failed. A resubmission is split into $400 and $200. The first part settles on Friday and the second appears pending. The approved obligation remains $600. The genuinely matched amount is $400. Open obligation is $200, and the remaining instruction stays pending.

If you see another $200 in the export, match the payee and reference before clearing the pending item. It could be a different creator or an unrelated transaction. When the real $200 settles, update the existing match and date. If it fails and is retried, retain the unsuccessful attempt and link the next instruction to the same obligation. That link helps stop duplicate payment.

Treat discrepancies as separate kinds of work

Symptom Evidence to check first Who usually closes it
Bank and provider currencies differ Source currency and documented conversion Finance or payment owner
Full instruction appears twice Provider references and terminal statuses Release operator
Same-day bank total includes several campaigns Provider batch or itemized report Reconciliation owner
Payee has one outstanding line and one failed transfer Original approval, provider failure and verified retry Payout approver and release owner

When payment fees reduce a settled amount, compare the agreement and provider records before deciding that a creator is short. Record amount sent to the recipient, provider fees and the net amount where visible. A separate exception can be appropriate when finance cannot tell which party should bear the charge.

Carry open items across the cutoff

Match and freeze the approved rows for a reporting period, then carry each unresolved line into the next period with its original identity. Add a status, reason, next reviewer and follow-up time. An open balance is distinct from adjustments that have already been reviewed and applied. Make sure the next reconciliation checks all pending references before generating any new instructions. Report matched totals, unallocated transactions and open obligations separately at close.

Check a mixed-currency batch before calling it closed

Fictional close. The team approves $650 USD and €180 EUR in one period. The transfer report shows a USD payment matching its obligation and an EUR payment pending. Keep separate totals by currency. If finance needs a consolidated reporting view, show the conversion method and timestamp separately from the actual settlement. A converted display total should remain traceable to the obligations denominated in their original currencies.

Check whether the processor first converts funds, deducts a fee or issues one grouped settlement. A bank debit alone may not identify the individual payees. Matching the payment operator’s itemized record to the approved entries can establish the reference chain. Then reconcile the batch itself to the provider statement or bank record with fees identified separately.

Prepare an unresolved-items handoff

Include the original obligation, amount, currency, latest processor state, source reference and follow-up date. Identify whether the team is waiting on a missing source record, a settlement or a verified retry. If the original $650 payment is matched, keep it in the signed-off view. The next close only needs to revisit the EUR exception and any other unresolved items. Give the new reviewer the records required to check it without re-creating the approval.

Review an obligation that settles in multiple transfers

Fictional close. Finance approves $480 for a creator under statement W-12. The payment provider reports a completed $300 transfer and a second $180 amount with a processing status. The ledger should show $300 settled and $180 outstanding at the cutoff. A settlement report may also include a $3 provider fee, which should be checked separately from the amount owed to the creator when the agreement treats it as a brand expense.

Item Amount Evidence at close
Approved obligation W-12 $480 Exact approved statement and creator identifier
Transfer P-01 $300 Completed event tied to W-12
Transfer P-02 $180 Pending event tied to W-12
Open balance $180 Reviewer records owner and next check time

If P-02 later completes, the same approved obligation can be matched to two distinct transfer references and the residual drops to zero. If P-02 fails, inspect whether any part actually moved before creating a retry. Use its status history, export and any available settlement identifier. Keep the old event associated with the statement and record the replacement separately. Matching only on amount and display name can pair the new event with another creator who earned the same total.

Hand off outstanding items with a clear owner

Write a close note that identifies the statements included, the provider export and effective time, the currency totals and exceptions that remain. For each open item retain the amount and the difference between expected and observed movement. A pending transfer and an unknown recipient reference may have the same dollar variance but need different action. In the fictional example, someone can monitor P-02 for settlement. A line with no matching transfer might need the release operator to confirm whether it was ever submitted.

When the next person opens the report, they should be able to find all the unsettled items without reading comments from the previous month. Carry those rows forward with their original obligation, amount as of the last close and current evidence. If an exception changes the amount owed, tie it to an approved correction instead of changing the transfer row. Reconcile by currency and keep cases involving conversion in view until the expected amount and actual transfer can be compared on the agreed basis. Ask the reviewer to sign off on both the settled amount and the documented unresolved balance.

Treat cash movement, settlement fees and offsets as separate evidence

Some exports contain entries for both funds sent to a creator and fees charged to the business. Match the principal amount to the agreed payout and route unrelated charges to the appropriate reconciliation. If the agreement allows a fee deduction, show the expected net to the creator as part of the approved obligation and preserve the gross and deduction. Verify the currency and scope of every entry. A bank balance difference can reflect timing rather than a short payment.

For a mixed-state file, organize the close by two questions: which obligations are in scope and which transfer events are confirmed. Retain the timestamp of each export and compare equivalent dates. Identify the reason a transfer is unmatched instead of immediately assigning it to an old payout of the same amount. If new evidence ties the transfer to an earlier obligation, link it and preserve the review note.

Measure how many unresolved items cross into the next cycle and why. A consistent delay in provider statuses can warrant shifting the export time. Multiple unknown recipients may point to a missing shared identifier in the release file. Test the change on a small historical sample and keep the existing close reproducible.

Discuss a pilot