Rolling Reserves: Settlement and Release Calculations

Write down the reserve contract

Record the eligible base, percentage or fixed requirement, withholding start, holding period, release trigger and treatment of refunds or disputes. A rolling percentage reserve differs from a fixed security deposit, an account balance hold or a processor's discretionary adjustment. Do not apply one calculation to all of them merely because the report uses the word reserve.

Adyen's report distinguishes reserve adjustments and deposit corrections from transaction settlement and merchant payout. Those journal names demonstrate why a separate reconciliation category is useful; they do not establish a standard reserve rate or release term. The actual provider agreement and statement determine those values.

Keep cohorts and cash movements

Create a cohort for each contractual withholding period. Store gross eligible receipts, the applied rule version, amount withheld, scheduled release date and amounts actually released. This makes an overdue release visible and allows a later adjustment to be traced to the affected cohort.

Use decimal arithmetic and specify when rounding occurs. Rounding every transaction can produce a different total from calculating on a period aggregate. Either can be part of a contract, but the reconciliation must use the same convention as the provider. Keep full calculation precision until the agreed rounding point, then preserve both the calculated and reported amounts.

Separate expected, released and received

A schedule forecasts when a reserve may become due for release. A provider entry confirms an adjustment to the reserve account. A bank record confirms resulting cash, which may be combined with new settlements. Give these separate fields rather than marking all three complete on the scheduled date.

When a release differs from expectation, investigate whether there is a dispute hold, changed reserve requirement, offset or calendar convention before posting a correction. A new commercial term should have an effective date and owner. Recalculate affected future cohorts explicitly; do not silently apply today's percentage to old withholdings. The schedule should also show which assumptions remain unconfirmed.

Worked example: three fictional periods

Assume a contract withholds 8% of eligible receipts and releases each cohort after two completed periods. Receipts are $10,000, $15,000 and $12,000. Withholding is $800, $1,200 and $960. If the first $800 is actually released in period 3, the closing reserve is $2,160. Period 3 cash attributable to its new receipts and that release is $12,000 − $960 + $800 = $11,840 before any other fees or adjustments.