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---5
6# Proration Schedule
7
8Drafts a mathematically precise proration schedule allocating property expenses, income, and obligations between buyer and seller at closing.
9
10## Prerequisites
11
12Collect before drafting:
13
141. **Purchase agreement** — closing date, closing-date-charge convention, proration terms
152. **Property tax records** — current/prior year bills, assessment notices, pending appeals
163. **HOA documents** — governing docs, statements, special assessments
174. **Lease agreements** (if tenant-occupied) — rent rolls, security deposits, prepaid rent
185. **Utility bills** — water, sewer, trash, property-linked services
196. **Title commitment** — legal description, parcel ID, encumbrances
207. **Insurance policies** (if transferring) — premiums and coverage periods
21
22## Quick Start
23
241. Gather all prerequisite documents
252. 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 checklist
285. Calculate daily rates and allocations for each item
296. Draft post-closing adjustment provision for estimated amounts
307. Verify net proration ties to settlement statement / Closing Disclosure
31
32## Document Header
33
34Include: 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.
35
36## Proration Items Checklist
37
38Identify all applicable items:
39
40- Real property taxes (actual or estimated)
41- HOA regular fees and special assessments
42- Rental income and security deposit transfers
43- Water/sewer, trash, other property-linked utilities
44- Prepaid insurance premiums (if policy transfers)
45- Improvement district / special district charges
46
47## Calculation Table
48
49For each proration item, present:
50
51| 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 |
60
61### Day-Count Convention
62
63- **Default:** 365-day year (actual days per period)
64- **Alternative:** 360-day year / 30-day months — apply local convention and document which is used
65
66### Closing-Date Allocation
67
681. Check purchase agreement for explicit allocation
692. If silent, apply prevailing jurisdictional custom
703. Document the convention in the schedule header
71
72## Property Tax Rules
73
74- State whether based on **actual** or **estimated** (prior-year) bill
75- Disclose pending reassessments or tax appeals and explain impact
76- Arrears jurisdictions: seller credited for prepayment or debited for accrued liability
77- Advance-payment jurisdictions: seller credited for post-closing prepaid portion
78- Always include post-closing true-up provision
79
80## Rental Income Rules
81
82- Prorate collected rent as of closing date
83- Advance rent beyond closing → credit to buyer
84- Security deposits: **transfer** to buyer (not prorated); seller receives corresponding debit
85- Note partial-month rent calculations
86
87## Summary
88
89Net proration must appear as:
90
91- Total credits to seller
92- Total credits to buyer
93- Net proration adjustment (credit to buyer or seller)
94
95This net figure must tie exactly to the proration line on the settlement statement / Closing Disclosure.
96
97## Post-Closing Adjustment Provision
98
99Include clauses for:
100
1011. **Property taxes** — true-up if actual bill differs from estimate by more than $[threshold]; buyer obtains final bill; adjustment within [X] days
1022. **Utilities** — final meter readings post-closing; seller liable through closing date; 60-day adjustment deadline
1033. **Retroactive assessments** — seller liable for charges attributable to seller's ownership period
1044. **Refunds** — buyer remits to seller any refund/credit for seller's ownership period
1055. **Settlement method** — direct payment between parties unless otherwise agreed
106
107## Regulatory Compliance
108
109- **TILA-RESPA** (residential + federally related mortgage): proration figures must match Closing Disclosure entries; this schedule is backup documentation
110- **State-specific rules:** verify jurisdiction-mandated calculation methods, required disclosures, and statutory allocation requirements
111- Note applicable jurisdiction in document header
112
113## Execution Block
114
115Signature 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.
116
117## Pitfalls and Checks
118
119- Show all math — every daily rate derivation must be visible
120- Match name/entity references to title documents exactly
121- Number all pages; include property address and closing date in footer
122- Flag estimated amounts and tie to post-closing adjustment provision
123- Never assume tax amounts — use prior-year estimate if bills unavailable and label accordingly
124- Add notary blocks if required by lender or local custom
125- **Final check:** net proration must reconcile to settlement statement line item