Rolling Reserve Reconciliation - Track Held and Released Funds
How to reconcile payment processor rolling reserves, withheld funds, releases and bank deposits without hiding timing gaps.
Try with sample files | View sample report
Problem statement
Payment processors may hold part of a payout as a reserve and release it later. If reserve movements are not separated, the payout can look short even when the funds are only delayed.
Reserve timing example
| Line item | Amount |
|---|
| Gross payout support | $5,420.00 |
| Rolling reserve hold | -$540.00 |
| Current payout to bank | $4,880.00 |
| Later reserve release | $320.00 |
| Unreleased reserve carry-forward | $220.00 |
What makes reserves hard to reconcile
- Held funds reduce current payouts but may be released later.
- Reserve releases can arrive without the original sale context.
- Negative balances and disputes may be recovered from later payouts.
- Month-end reporting can split held and released funds across periods.
- A payout mismatch can look like an unexplained fee or adjustment until the reserve history is separated cleanly.
- Bank deposits only show the net cash movement.
Files to collect
- Processor balance export with reserve holds, releases, disputes, balance movements, and payout IDs.
- Payout report with net payout amount, arrival date, and payout status for the affected cycle.
- Bank statement export with deposit rows to match against current payouts or later reserve releases.
- Optional month-end review schedule when held and released funds cross periods.
Reconciliation workflow
- Identify reserve hold rows separately from processor fees.
- Track reserve releases as their own row type instead of treating them as fresh income.
- Match the current payout net amount to the bank deposit and keep reserve timing visible alongside it.
- Keep unresolved shortfalls as amount differences until the export proves a reserve hold, release, dispute recovery, or another exact cause.
- Carry unreleased reserve balances forward into a month-end reserve schedule.
- Review old reserve releases against prior held amounts.
- Check whether a later deposit is a reserve release, a normal payout, or a mixed processor movement.
- Avoid treating held funds as permanent fees until confirmed.
Review checks
- Reserve hold was classified as a fee.
- Reserve release was treated as unknown income.
- Dispute recovery reduced a later payout.
- Held funds span month-end and need a carry-forward schedule.
- Reserve release was matched to current-period sales instead of the earlier held balance.
How Reconcile Locally helps
- Keeps reserve holds, releases, payout support, and bank rows visible in one payout-first review flow.
- Shows whether the short deposit looks like a current reserve hold, a later release, or an open amount difference that still needs review.
- Exports a carry-forward-friendly report for month-end review and accounting handoff.
- Makes it easier to move from a generic payout-mismatch page into a reserve-specific explanation when the processor export proves held funds.
What still needs manual review
- Reserve labels vary by processor, so another export may still be needed to prove the exact reserve history.
- Month-end cutoffs and grouped releases can keep part of the balance in review even when the payout mostly makes sense.
- Final accounting classification and posting still require reviewer judgment.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Is a rolling reserve the same as a fee?
No. A fee is usually permanent. A reserve is withheld cash that may be released later, so it should be tracked separately.
Why does the bank deposit look short?
The payout may be reduced by reserve holds, disputes, negative balance recovery, refunds or normal processing fees.
How should I handle reserve balances at month-end?
Keep unreleased reserve amounts as carry-forward review items instead of forcing them into the current month. Match later reserve releases back to the earlier held balance when the support is strong enough.
When should I move from a payout mismatch workflow into reserve review?
Move into reserve review when the processor balance or payout export shows held-funds rows, reserve releases, or delayed balance movements that explain why the bank deposit is smaller than the gross payout support.