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.4license: Apache-2.05---67# Proration Schedule89Drafts a mathematically precise proration schedule allocating property expenses, income, and obligations between buyer and seller at closing.1011## Prerequisites1213Collect before drafting:14151. **Purchase agreement** — closing date, closing-date-charge convention, proration terms162. **Property tax records** — current/prior year bills, assessment notices, pending appeals173. **HOA documents** — governing docs, statements, special assessments184. **Lease agreements** (if tenant-occupied) — rent rolls, security deposits, prepaid rent195. **Utility bills** — water, sewer, trash, property-linked services206. **Title commitment** — legal description, parcel ID, encumbrances217. **Insurance policies** (if transferring) — premiums and coverage periods2223## Quick Start24251. Gather all prerequisite documents262. Set closing date and day-count convention (365-day default or 360-day if jurisdictionally required)273. Determine closing-date allocation (buyer or seller bears closing date)284. Identify all proration items from the checklist295. Calculate daily rates and allocations for each item306. Draft post-closing adjustment provision for estimated amounts317. Verify net proration ties to settlement statement / Closing Disclosure3233## Document Header3435Include: 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.3637## Proration Items Checklist3839Identify all applicable items:4041- Real property taxes (actual or estimated)42- HOA regular fees and special assessments43- Rental income and security deposit transfers44- Water/sewer, trash, other property-linked utilities45- Prepaid insurance premiums (if policy transfers)46- Improvement district / special district charges4748## Calculation Table4950For each proration item, present:5152| Column | Description |53|--------|-------------|54| Item | Description of charge |55| Total Amount | Full periodic amount |56| Period Covered | Start–end dates |57| Daily Rate | Total ÷ days in period |58| Seller Days / Amount | Days responsible × daily rate |59| Buyer Days / Amount | Days responsible × daily rate |60| Credit To | Buyer or Seller |6162### Day-Count Convention6364- **Default:** 365-day year (actual days per period)65- **Alternative:** 360-day year / 30-day months — apply local convention and document which is used6667### Closing-Date Allocation68691. Check purchase agreement for explicit allocation702. If silent, apply prevailing jurisdictional custom713. Document the convention in the schedule header7273## Property Tax Rules7475- State whether based on **actual** or **estimated** (prior-year) bill76- Disclose pending reassessments or tax appeals and explain impact77- Arrears jurisdictions: seller credited for prepayment or debited for accrued liability78- Advance-payment jurisdictions: seller credited for post-closing prepaid portion79- Always include post-closing true-up provision8081## Rental Income Rules8283- Prorate collected rent as of closing date84- Advance rent beyond closing → credit to buyer85- Security deposits: **transfer** to buyer (not prorated); seller receives corresponding debit86- Note partial-month rent calculations8788## Summary8990Net proration must appear as:9192- Total credits to seller93- Total credits to buyer94- Net proration adjustment (credit to buyer or seller)9596This net figure must tie exactly to the proration line on the settlement statement / Closing Disclosure.9798## Post-Closing Adjustment Provision99100Include clauses for:1011021. **Property taxes** — true-up if actual bill differs from estimate by more than $[threshold]; buyer obtains final bill; adjustment within [X] days1032. **Utilities** — final meter readings post-closing; seller liable through closing date; 60-day adjustment deadline1043. **Retroactive assessments** — seller liable for charges attributable to seller's ownership period1054. **Refunds** — buyer remits to seller any refund/credit for seller's ownership period1065. **Settlement method** — direct payment between parties unless otherwise agreed107108## Regulatory Compliance109110- **TILA-RESPA** (residential + federally related mortgage): proration figures must match Closing Disclosure entries; this schedule is backup documentation111- **State-specific rules:** verify jurisdiction-mandated calculation methods, required disclosures, and statutory allocation requirements112- Note applicable jurisdiction in document header113114## Execution Block115116Signature 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.117118## Pitfalls and Checks119120- Show all math — every daily rate derivation must be visible121- Match name/entity references to title documents exactly122- Number all pages; include property address and closing date in footer123- Flag estimated amounts and tie to post-closing adjustment provision124- Never assume tax amounts — use prior-year estimate if bills unavailable and label accordingly125- Add notary blocks if required by lender or local custom126- **Final check:** net proration must reconcile to settlement statement line item