Proration Schedule
Drafts a mathematically precise proration schedule allocating property expenses, income, and obligations between buyer and seller at closing.
Prerequisites
Collect before drafting:
- Purchase agreement — closing date, closing-date-charge convention, proration terms
- Property tax records — current/prior year bills, assessment notices, pending appeals
- HOA documents — governing docs, statements, special assessments
- Lease agreements (if tenant-occupied) — rent rolls, security deposits, prepaid rent
- Utility bills — water, sewer, trash, property-linked services
- Title commitment — legal description, parcel ID, encumbrances
- Insurance policies (if transferring) — premiums and coverage periods
Quick Start
- Gather all prerequisite documents
- Set closing date and day-count convention (365-day default or 360-day if jurisdictionally required)
- Determine closing-date allocation (buyer or seller bears closing date)
- Identify all proration items from the checklist
- Calculate daily rates and allocations for each item
- Draft post-closing adjustment provision for estimated amounts
- Verify net proration ties to settlement statement / Closing Disclosure
Document Header
Include: document title ("Proration Schedule"), preparation date, closing date, property (address + legal description + parcel ID), escrow/file number, seller(s) and buyer(s) full legal names and addresses, applicable jurisdiction, and day-count convention used.
Proration Items Checklist
Identify all applicable items:
- Real property taxes (actual or estimated)
- HOA regular fees and special assessments
- Rental income and security deposit transfers
- Water/sewer, trash, other property-linked utilities
- Prepaid insurance premiums (if policy transfers)
- Improvement district / special district charges
Calculation Table
For each proration item, present:
| Column |
Description |
| Item |
Description of charge |
| Total Amount |
Full periodic amount |
| Period Covered |
Start–end dates |
| Daily Rate |
Total ÷ days in period |
| Seller Days / Amount |
Days responsible × daily rate |
| Buyer Days / Amount |
Days responsible × daily rate |
| Credit To |
Buyer or Seller |
Day-Count Convention
- Default: 365-day year (actual days per period)
- Alternative: 360-day year / 30-day months — apply local convention and document which is used
Closing-Date Allocation
- Check purchase agreement for explicit allocation
- If silent, apply prevailing jurisdictional custom
- Document the convention in the schedule header
Property Tax Rules
- State whether based on actual or estimated (prior-year) bill
- Disclose pending reassessments or tax appeals and explain impact
- Arrears jurisdictions: seller credited for prepayment or debited for accrued liability
- Advance-payment jurisdictions: seller credited for post-closing prepaid portion
- Always include post-closing true-up provision
Rental Income Rules
- Prorate collected rent as of closing date
- Advance rent beyond closing → credit to buyer
- Security deposits: transfer to buyer (not prorated); seller receives corresponding debit
- Note partial-month rent calculations
Summary
Net proration must appear as:
- Total credits to seller
- Total credits to buyer
- Net proration adjustment (credit to buyer or seller)
This net figure must tie exactly to the proration line on the settlement statement / Closing Disclosure.
Post-Closing Adjustment Provision
Include clauses for:
- Property taxes — true-up if actual bill differs from estimate by more than $[threshold]; buyer obtains final bill; adjustment within [X] days
- Utilities — final meter readings post-closing; seller liable through closing date; 60-day adjustment deadline
- Retroactive assessments — seller liable for charges attributable to seller's ownership period
- Refunds — buyer remits to seller any refund/credit for seller's ownership period
- Settlement method — direct payment between parties unless otherwise agreed
Regulatory Compliance
- TILA-RESPA (residential + federally related mortgage): proration figures must match Closing Disclosure entries; this schedule is backup documentation
- State-specific rules: verify jurisdiction-mandated calculation methods, required disclosures, and statutory allocation requirements
- Note applicable jurisdiction in document header
Execution Block
Signature lines for all buyers and sellers: printed name, signature, date, and acknowledgment that parties reviewed calculations and agree to allocations. Label as exhibit to settlement statement / Closing Disclosure.
Pitfalls and Checks
- Show all math — every daily rate derivation must be visible
- Match name/entity references to title documents exactly
- Number all pages; include property address and closing date in footer
- Flag estimated amounts and tie to post-closing adjustment provision
- Never assume tax amounts — use prior-year estimate if bills unavailable and label accordingly
- Add notary blocks if required by lender or local custom
- Final check: net proration must reconcile to settlement statement line item
1---2name: proration-schedule3description: Drafts a legally compliant proration schedule for real estate closings, allocating taxes, HOA fees, rent, utilities, and other obligations between buyer and seller. Triggered when preparing settlement documents, closing prorations, asset purchase closings, or real estate closing statements requiring expense allocation by closing date.4---56# Proration Schedule78Drafts a mathematically precise proration schedule allocating property expenses, income, and obligations between buyer and seller at closing.910## Prerequisites1112Collect before drafting:13141. **Purchase agreement** — closing date, closing-date-charge convention, proration terms152. **Property tax records** — current/prior year bills, assessment notices, pending appeals163. **HOA documents** — governing docs, statements, special assessments174. **Lease agreements** (if tenant-occupied) — rent rolls, security deposits, prepaid rent185. **Utility bills** — water, sewer, trash, property-linked services196. **Title commitment** — legal description, parcel ID, encumbrances207. **Insurance policies** (if transferring) — premiums and coverage periods2122## Quick Start23241. Gather all prerequisite documents252. Set closing date and day-count convention (365-day default or 360-day if jurisdictionally required)263. Determine closing-date allocation (buyer or seller bears closing date)274. Identify all proration items from the checklist285. Calculate daily rates and allocations for each item296. Draft post-closing adjustment provision for estimated amounts307. Verify net proration ties to settlement statement / Closing Disclosure3132## Document Header3334Include: document title ("Proration Schedule"), preparation date, closing date, property (address + legal description + parcel ID), escrow/file number, seller(s) and buyer(s) full legal names and addresses, applicable jurisdiction, and day-count convention used.3536## Proration Items Checklist3738Identify all applicable items:3940- Real property taxes (actual or estimated)41- HOA regular fees and special assessments42- Rental income and security deposit transfers43- Water/sewer, trash, other property-linked utilities44- Prepaid insurance premiums (if policy transfers)45- Improvement district / special district charges4647## Calculation Table4849For each proration item, present:5051| Column | Description |52|--------|-------------|53| Item | Description of charge |54| Total Amount | Full periodic amount |55| Period Covered | Start–end dates |56| Daily Rate | Total ÷ days in period |57| Seller Days / Amount | Days responsible × daily rate |58| Buyer Days / Amount | Days responsible × daily rate |59| Credit To | Buyer or Seller |6061### Day-Count Convention6263- **Default:** 365-day year (actual days per period)64- **Alternative:** 360-day year / 30-day months — apply local convention and document which is used6566### Closing-Date Allocation67681. Check purchase agreement for explicit allocation692. If silent, apply prevailing jurisdictional custom703. Document the convention in the schedule header7172## Property Tax Rules7374- State whether based on **actual** or **estimated** (prior-year) bill75- Disclose pending reassessments or tax appeals and explain impact76- Arrears jurisdictions: seller credited for prepayment or debited for accrued liability77- Advance-payment jurisdictions: seller credited for post-closing prepaid portion78- Always include post-closing true-up provision7980## Rental Income Rules8182- Prorate collected rent as of closing date83- Advance rent beyond closing → credit to buyer84- Security deposits: **transfer** to buyer (not prorated); seller receives corresponding debit85- Note partial-month rent calculations8687## Summary8889Net proration must appear as:9091- Total credits to seller92- Total credits to buyer93- Net proration adjustment (credit to buyer or seller)9495This net figure must tie exactly to the proration line on the settlement statement / Closing Disclosure.9697## Post-Closing Adjustment Provision9899Include clauses for:1001011. **Property taxes** — true-up if actual bill differs from estimate by more than $[threshold]; buyer obtains final bill; adjustment within [X] days1022. **Utilities** — final meter readings post-closing; seller liable through closing date; 60-day adjustment deadline1033. **Retroactive assessments** — seller liable for charges attributable to seller's ownership period1044. **Refunds** — buyer remits to seller any refund/credit for seller's ownership period1055. **Settlement method** — direct payment between parties unless otherwise agreed106107## Regulatory Compliance108109- **TILA-RESPA** (residential + federally related mortgage): proration figures must match Closing Disclosure entries; this schedule is backup documentation110- **State-specific rules:** verify jurisdiction-mandated calculation methods, required disclosures, and statutory allocation requirements111- Note applicable jurisdiction in document header112113## Execution Block114115Signature lines for all buyers and sellers: printed name, signature, date, and acknowledgment that parties reviewed calculations and agree to allocations. Label as exhibit to settlement statement / Closing Disclosure.116117## Pitfalls and Checks118119- Show all math — every daily rate derivation must be visible120- Match name/entity references to title documents exactly121- Number all pages; include property address and closing date in footer122- Flag estimated amounts and tie to post-closing adjustment provision123- Never assume tax amounts — use prior-year estimate if bills unavailable and label accordingly124- Add notary blocks if required by lender or local custom125- **Final check:** net proration must reconcile to settlement statement line item