BudgetGridsReport
Rent & PayrollCategory: Billing

Prorate Calculator

Calculate fair partial-period billing, rent, and salary adjustments instantly.

Input Parameters

$
Day 12
Day 31
1 person
Prorated Settlement

Total Billable Prorated Cost

Partial Month
—for 1 person
Daily Rate
—
per diem cost
Active Days
0 days
out of 31 days
Occupancy Share
0.0%
of full month
Unoccupied Credit
—
deducted amount
Exact calendar mathematics • Instant sync

Monthly Calendar Timeline

Visualizing active billing days

Active Days Unoccupied

Underlying Mathematical Formula

Prorated Amount = (Monthly Base Rate ÷ Days in Period) × Active Days

The daily rate is derived by dividing the monthly rate by either the actual number of calendar days in that specific month (28, 29, 30, or 31) or an annualized 30-day standard, then multiplied by the billable days.

Spreadsheet SyntaxMicrosoft Excel & Google Sheets Formula
=(Monthly_Rent / DAY(EOMONTH(Date, 0))) * (End_Day - Start_Day + 1)

In Excel, divide monthly rent by the total days in the month using DAY(EOMONTH(Date, 0)), then multiply by the active days of tenancy.

Rent Proration Meaning & Core Mathematical Methods

Proration Methods

To prorate means to divide or distribute a fee proportionately based on the actual duration of use. In residential property management and commercial leasing, prorated rent occurs when a tenant takes possession after the first day of the calendar month or surrenders the keys prior to the last day. Standard property management platforms like TurboTenant, RentVine, and Zillow Property Manager utilize precise day-count conventions to ensure legal and fair settlement.

  • •Actual Days in Month Method (Most Common & Legally Accurate): Divides monthly rent by the exact number of days in that specific month (31 in October, 30 in November, 28/29 in February).
  • •Banker’s 30-Day Month Rule: Assumes every month has exactly 30 days (Daily Rate = Monthly Rent ÷ 30). Common in commercial contracts.
  • •Annualized 365-Day Method: Multiplies monthly rent by 12, divides by 365 days to establish a constant daily rate (Daily Rate = [Monthly Rent × 12] ÷ 365).

Move-In vs. Move-Out Rent Proration Calculations

Move-In & Move-Out

Calculating prorated rent requires clear identification of the move-in and move-out dates, including whether the transition day itself is billable.

ScenarioCalculation FormulaExample ($2,400/mo Rent, October 31 Days)Amount Due
Move-In on October 12th(Rent ÷ 31) × (31 - 12 + 1 = 20 days)($2,400 ÷ 31) × 20 days$1,548.39
Move-In on October 25th(Rent ÷ 31) × (31 - 25 + 1 = 7 days)($2,400 ÷ 31) × 7 days$541.94
Move-Out on October 15th(Rent ÷ 31) × 15 days($2,400 ÷ 31) × 15 days$1,161.29
Move-Out on June 10th (30 Days)(Rent ÷ 30) × 10 days($2,400 ÷ 30) × 10 days$800.00

Insurance Policy and Annual Proration

Insurance & Subscriptions

Beyond residential rent, prorating is fundamental in car insurance, homeowner policies, and SaaS corporate subscriptions. When an insurance policy is cancelled mid-term, the insurer computes the unearned premium returned to the policyholder using either a pro-rata refund (exact calendar days unused) or a short-rate cancellation (deducting an administrative fee). For annual subscriptions, the daily rate equals Annual Cost ÷ 365.

  • •Insurance Mid-Term Endorsement: Adding or removing coverage mid-cycle creates a prorated premium adjustment.
  • •SaaS User Licensing: Prorating seat additions mid-billing cycle ensures customers only pay for the exact days active.

Frequently Asked Questions (FAQ)

Methodological guidelines, formula variations, and practical execution details.

What does prorated mean in billing or rent?

To prorate means to allocate or divide a recurring periodic cost proportionately according to the exact duration of time used or occupied, rather than billing for the full standard cycle.

In property leasing, if a tenant takes occupancy midway through a month (for example, on the 18th of a 30-day month), prorated rent ensures they only pay for the 13 days they actually have access to the property. Proration is equally fundamental across utility billing, employee payroll, software user subscriptions, and insurance premiums.

How do you calculate prorated rent for a partial month?

To calculate prorated rent for a partial move-in or move-out month, follow this two-step formula:

Step 1: Daily Rental Rate = Monthly Rent ÷ Days in Target Month

Step 2: Prorated Rent Due = Daily Rental Rate × Billable Days of Occupancy

Note: The move-in day itself is almost universally included as a billable day because legal possession begins on that date (Billable Days = Total Days in Month - Move-In Date + 1).

Example: A tenant moves into an apartment on October 12th where monthly rent is $2,400. October has 31 days. The tenant occupies the unit for 31 - 12 + 1 = 20 billable days. The daily rate is $2,400 ÷ 31 = $77.419/day. Total prorated rent due is 20 × $77.419 = $1,548.39.

How is a prorated salary calculated for a new employee?

Under standard payroll and Department of Labor (FLSA) conventions for exempt salaried personnel, prorated compensation is calculated based on actual working days (business days) rather than total calendar days:

Daily Salary Rate = Annual Gross Salary ÷ Total Workdays in Year (typically 260 or 261 days)

Prorated Gross Pay = Daily Salary Rate × Actual Days Worked in Pay Period

Example: An employee hired at an $83,200 annual salary starts on a Wednesday and works 8 days during a standard 10-day biweekly pay period. Their daily rate is $83,200 ÷ 260 = $320.00/day. Their prorated gross pay for that initial pay cycle is 8 × $320.00 = $2,560.00.

Should prorated amounts be based on a 30-day month, 31-day month, or 365-day year?

The appropriate method depends on the contractual agreement and industry sector:

  • 1. Actual Days in Month Method (Most Common & Recommended): Divides the monthly charge by the exact number of calendar days in that specific month (28/29 in February, 30 in April/June/September/November, 31 in others). It is standard across residential leasing (Zillow, TurboTenant) and legally reflects exact calendar duration.
  • 2. Banker’s 30-Day Month Rule: Assumes every single month has exactly 30 days (Daily Rate = Monthly Rate ÷ 30). Widely utilized in commercial real estate, corporate bond accrued interest, and commercial equipment leases.
  • 3. Annualized 365-Day Method: Multiplies the monthly rate by 12, then divides by 365 (Daily Rate = [Monthly Rate × 12] ÷ 365). Often mandated by corporate payroll systems and military allowances to maintain an identical daily rate throughout the entire year.

Always review the explicit language in your lease or employment agreement.

Can you prorate an annual subscription?

Yes, annual software subscriptions (SaaS), gym memberships, and insurance policies are routinely prorated for mid-term additions, tier upgrades, or cancellations.

Common implementations include:

  • Mid-Cycle SaaS Seat Additions: When adding new employee licenses 120 days into a 365-day annual contract, providers charge only for the remaining 245 active days: Additional Cost = (Annual Seat Price ÷ 365) × 245 days.
  • Insurance Cancellations (Pro-Rata Refund): If an insured party cancels an annual auto or home policy 100 days after inception, the insurer refunds the unearned premium for the remaining 265 days: Refund = Total Premium × (265 ÷ 365), unless a specific short-rate cancellation fee applies.
Calculation link copied to clipboard.