# Reconcile operating cash and trapped cash without losing transfers

Canonical: https://commercialdebtadvisory.com/templates/cash-management-and-sweep-reconciliation/
Status: Published
Publisher: Jaken Finance Group

Reconcile cash movement before deciding what can be distributed. The operating account, reserve accounts and trapped-cash account can all belong to the same transaction while having different permitted uses. A transfer changes location and control without necessarily changing total cash or principal.

A [historical SEC-filed agreement](https://www.sec.gov/Archives/edgar/data/1795851/000166357726000199/ex10_30.htm) provides a concrete example of contract-specific allocation and default provisions in section 6.16. The workbook below does not reproduce that agreement’s waterfall. It reconciles a separate hypothetical set of account movements.

## Establish account boundaries

Identify each account, owner, controller and permitted use from the actual documents and bank records. Use a common cutoff date and match transfers by amount and date. A transfer in transit can explain a temporary difference but still needs evidence.

Classify external receipts separately from internal transfers. Likewise, distinguish operating payments, debt service, reserve funding and cash trapping. A sweep into collateral cash is not automatically a principal payment; confirm how the servicer actually applied it.

## Blank operating-account reconciliation

```csv
period_end,opening_operating_cash_usd,external_receipts_usd,operating_payments_usd,debt_service_usd,reserve_transfers_usd,sweep_transfers_usd,calculated_ending_cash_usd,observed_ending_cash_usd,unexplained_difference_usd,evidence_ref
,,,,,,,,,,
```

## Field instructions

| Field | Record | Common error |
|---|---|---|
| external_receipts | Cash entering from outside the account group | Counting the return of a reserve as new property revenue |
| operating_payments | Actual external operating disbursements | Using accrued expenses without a cash bridge |
| debt_service | Actual payment allocation from the statement | Treating trapped cash as principal reduction |
| reserve / sweep transfers | Transfers to identified destination accounts | Deducting them again in consolidated cash |
| observed_ending_cash | Actual bank balance on the same cutoff | Replacing it with the expected number |
| unexplained_difference | Observed less calculated balance | Hiding a residual in miscellaneous expense |

## Completed hypothetical reconciliation

```csv
period_end,opening_operating_cash_usd,external_receipts_usd,operating_payments_usd,debt_service_usd,reserve_transfers_usd,sweep_transfers_usd,calculated_ending_cash_usd,observed_ending_cash_usd,unexplained_difference_usd,evidence_ref
2026-09-30,100000,200000,80000,50000,20000,40000,110000,111000,1000,BANK-OP-SEP;BANK-RES-SEP;BANK-TRAP-SEP;SERVICER-SEP
```

The operating account begins with $100,000 and receives $200,000. It pays $80,000 operating costs and $50,000 debt service, then transfers $20,000 to reserves and $40,000 to trapped cash. Calculated ending operating cash is **$110,000**. The observed $111,000 balance leaves a **$1,000 unexplained difference**.

Assume trapped cash began at $30,000 and reserves at $10,000, with no other movements. Their calculated endings are $70,000 and $30,000. Across all three accounts, expected cash is **$210,000**: $140,000 combined opening cash + $200,000 external receipts − $130,000 external payments.

The $60,000 of internal transfers cancels in that consolidated equation. Subtracting it again would incorrectly reduce expected total cash to $150,000.

## Resolve the residual before certifying the package

Investigate bank timing, interest credits, fees, omitted receipts and transfer cutoffs. Record the cause and supporting statement. Do not presume the unexplained $1,000 is distributable income.

Reconcile any servicer principal reduction to the debt schedule. If funds were applied to debt, show the external cash payment and principal effect; if they remain collateral cash, preserve the restricted balance. The distinction changes future interest, payoff and liquidity.

## Separate cash reconciliation from permission

Even an accurate $110,000 operating balance does not establish the amount owners may withdraw. Apply the actual distribution, budget, default and reserve conditions separately. A covenant passing today may not automatically release a prior trapped balance.

Retain the account statements, transfer matches, servicer allocation and unresolved-items log. The reconciliation should show where cash went and what remains controlled, while leaving contractual permissions to the governing documents and appropriate review.


## Source references
- [SEC exhibit — Block 40 Property loan agreement](https://www.sec.gov/Archives/edgar/data/1795851/000166357726000199/ex10_30.htm) — Sections 6.16.1–6.16.3: Property Cash Flow Allocation · Checked 2026-10-21 · Agreement dated June 1, 2022; historical negotiated example only. Its terms do not govern the reader’s loan.