Proration Schedule
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.
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
No additional documents ship with this skill.
Related Skills
Access and Indemnity Agreement
Drafts U.S. commercial real estate access and indemnity (right-of-entry) agreements for pre-closing due diligence. Covers license grants, non-invasiv…
Adverse Possession Claim
Drafts adverse possession complaints and quiet title pleadings. Structures jurisdictional foundations, legal property descriptions, and element-by-el…
ALTA Settlement Statement
Drafts a mathematically balanced ALTA Settlement Statement for U.S. real estate closings, allocating debits and credits between buyer and seller with…
Assignment and Assumption of Leases
Drafts an Assignment and Assumption of Leases transferring tenant leases from seller (Assignor) to buyer (Assignee) as a closing document to a commer…
Personal Property Bill of Sale (CRE)
Drafts a U.S. CRE personal property Bill of Sale transferring equipment, fixtures, FF&E, inventory, and other tangible assets. Handles inclusion/excl…