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.4tags:5 - agreement6 - drafting7 - transactional8---910# Proration Schedule1112Drafts a mathematically precise proration schedule allocating property expenses, income, and obligations between buyer and seller at closing.1314## Prerequisites1516Collect before drafting:17181. **Purchase agreement** — closing date, closing-date-charge convention, proration terms192. **Property tax records** — current/prior year bills, assessment notices, pending appeals203. **HOA documents** — governing docs, statements, special assessments214. **Lease agreements** (if tenant-occupied) — rent rolls, security deposits, prepaid rent225. **Utility bills** — water, sewer, trash, property-linked services236. **Title commitment** — legal description, parcel ID, encumbrances247. **Insurance policies** (if transferring) — premiums and coverage periods2526## Quick Start27281. Gather all prerequisite documents292. Set closing date and day-count convention (365-day default or 360-day if jurisdictionally required)303. Determine closing-date allocation (buyer or seller bears closing date)314. Identify all proration items from the checklist325. Calculate daily rates and allocations for each item336. Draft post-closing adjustment provision for estimated amounts347. Verify net proration ties to settlement statement / Closing Disclosure3536## Document Header3738Include: 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.3940## Proration Items Checklist4142Identify all applicable items:4344- Real property taxes (actual or estimated)45- HOA regular fees and special assessments46- Rental income and security deposit transfers47- Water/sewer, trash, other property-linked utilities48- Prepaid insurance premiums (if policy transfers)49- Improvement district / special district charges5051## Calculation Table5253For each proration item, present:5455| Column | Description |56|--------|-------------|57| Item | Description of charge |58| Total Amount | Full periodic amount |59| Period Covered | Start–end dates |60| Daily Rate | Total ÷ days in period |61| Seller Days / Amount | Days responsible × daily rate |62| Buyer Days / Amount | Days responsible × daily rate |63| Credit To | Buyer or Seller |6465### Day-Count Convention6667- **Default:** 365-day year (actual days per period)68- **Alternative:** 360-day year / 30-day months — apply local convention and document which is used6970### Closing-Date Allocation71721. Check purchase agreement for explicit allocation732. If silent, apply prevailing jurisdictional custom743. Document the convention in the schedule header7576## Property Tax Rules7778- State whether based on **actual** or **estimated** (prior-year) bill79- Disclose pending reassessments or tax appeals and explain impact80- Arrears jurisdictions: seller credited for prepayment or debited for accrued liability81- Advance-payment jurisdictions: seller credited for post-closing prepaid portion82- Always include post-closing true-up provision8384## Rental Income Rules8586- Prorate collected rent as of closing date87- Advance rent beyond closing → credit to buyer88- Security deposits: **transfer** to buyer (not prorated); seller receives corresponding debit89- Note partial-month rent calculations9091## Summary9293Net proration must appear as:9495- Total credits to seller96- Total credits to buyer97- Net proration adjustment (credit to buyer or seller)9899This net figure must tie exactly to the proration line on the settlement statement / Closing Disclosure.100101## Post-Closing Adjustment Provision102103Include clauses for:1041051. **Property taxes** — true-up if actual bill differs from estimate by more than $[threshold]; buyer obtains final bill; adjustment within [X] days1062. **Utilities** — final meter readings post-closing; seller liable through closing date; 60-day adjustment deadline1073. **Retroactive assessments** — seller liable for charges attributable to seller's ownership period1084. **Refunds** — buyer remits to seller any refund/credit for seller's ownership period1095. **Settlement method** — direct payment between parties unless otherwise agreed110111## Regulatory Compliance112113- **TILA-RESPA** (residential + federally related mortgage): proration figures must match Closing Disclosure entries; this schedule is backup documentation114- **State-specific rules:** verify jurisdiction-mandated calculation methods, required disclosures, and statutory allocation requirements115- Note applicable jurisdiction in document header116117## Execution Block118119Signature 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.120121## Pitfalls and Checks122123- Show all math — every daily rate derivation must be visible124- Match name/entity references to title documents exactly125- Number all pages; include property address and closing date in footer126- Flag estimated amounts and tie to post-closing adjustment provision127- Never assume tax amounts — use prior-year estimate if bills unavailable and label accordingly128- Add notary blocks if required by lender or local custom129- **Final check:** net proration must reconcile to settlement statement line item