Debt enforcement
-
2
 min read

Reconcile a cross-border collection payout

Match principal, receipts, fees, exchange and the bank credit in a worked creditor-side reconciliation.

By Lars Holdgaard, Founder & CEO of Debitura

Reconcile a cross-border collection payout

Reconcile a cross-border payout in the collection currency first, then match the converted settlement to your bank. Keep the amount the debtor paid and the amount the creditor received on separate lines. Investigate any difference using the applicable statement and supporting references.

Worked example

In this fictional example, the original principal is €10,000. The partner recorded two receipts allocated entirely to principal and supplied a separate settlement note. The money is sent to a creditor’s GBP account. All rates and charges below come from the example’s records.

Illustrative workflow
StepReference and evidenceAmountResult
Match principal receiptsCase C-610 · receipt R1 (€4,000) and R2 (€2,500), both matched to cleared receipts.€6,500 paid toward principal.€10,000 - €6,500 = €3,500 principal open.
Match what is available for payoutSettlement SET-29 shows €650 withheld in this example. The amount is illustrative and is not a fee rate; the pricing page has the published schedule.€6,500 - €650 = €5,850.€5,850 net in the collection currency. Keep the fee on its own row.
Verify the FX conversionSettlement SET-29 records GBP 0.86 per euro for that transfer.€5,850 × 0.86 = £5,031.00.£5,031.00 shown as sent to creditor.
Match the bank creditBank reference B-70 shows £5,016.00 credited and a separate £15.00 bank charge.£5,031.00 - £15.00 = £5,016.00.Expected and actual bank credits match. Unexplained difference £0.00.

Which record to use

Use the individual case and exported case data to confirm case references and reported amounts where available. Use the settlement record for the fee, actual conversion and transfer reference. Use the receiving bank record for value date, charges and cleared cash. The calculation is your reconciliation.

If the number still differs

Compare receipt, value and reporting dates. Check that the payment and payout relate to the same case, recipient and currency. Record an owner, amount and next check for each unexplained item.

Copy the worksheet

Case IDInvoice referenceOriginal principalCollection currencyCleared receipts to principalOpen principalSettlement referenceFee withheldNet sent in source currencyRate and sourceExpected bank creditBank chargeActual bank creditDifference and owner

If you have a separate eligible overdue B2B invoice to assess, Start a collection case.

References

Debitura client case reporting · Debitura billing and who receives payment

Subscription

Sign up to our newsletter

Get updated on best practices, tips and tricks about international debt collection and accounts receivable management.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.