A sweep moves cash between accounts; it does not automatically repay debt or create an expense. Reconcile each account, then eliminate internal transfers when testing total cash conservation.
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 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
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
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-SEPThe 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.
Sources and evidence
- SEC exhibit — Block 40 Property loan agreementSections 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.
Source dates and applicability matter. Report an error or a changed source.