Prorate Calculator — Split Any Amount Day-Exact
Free, instant, browser-based. Splits amounts across fiscal years, quarters, or months by exact day count. Built for accountants, auditors, and finance teams who need proration that reconciles to the cent.
What a prorate calculator does
Proration is the accounting technique of dividing a single amount across a period of time based on usage, delivery, or presence. If a service spans more than one accounting period — say, a subscription running from February 15, 2024 to January 15, 2025 — you can't recognize the full revenue in one period. You must allocate it day-exact to each period the service was actually rendered.
A prorate calculator does this math. Enter the service period dates and the total amount. The calculator returns the proportional share for each fiscal period the service covers. For a CHF 12,000 invoice covering 336 days in 2024 and 30 days in 2025, you'd get CHF 11,013.70 in 2024 and CHF 986.30 in 2025 — summing to the original amount with no rounding error.
How proration works (the formula)
The base formula is simple:
Pro rata amount = (days in period / total days in service) × total amount
The complexity is never the formula — it's the calendar. Fiscal years have different lengths (365 or 366 days). Quarters have different day counts (Q1 2024 had 91 days, Q2 had 91, Q3 had 92, Q4 had 92). Leap years shift everything by a day. A naïve divide-by-12 approach gets the right answer ±1% of the time, which is the wrong answer for accrual accounting.
A worked example
Assume a consulting firm invoices a client for a retainer covering February 15, 2024 through January 15, 2025. Total amount: CHF 12,000. The service period is 366 days (2024 is a leap year and the period crosses it).
- Days in 2024: 336 (Feb 15 to Dec 31 inclusive)
- Days in 2025: 30 (Jan 1 to Jan 15 inclusive)
- Total: 366 days ✓
Applying the formula:
- 2024 share = (336 / 366) × 12,000 = CHF 11,013.70
- 2025 share = (30 / 366) × 12,000 = CHF 983.61
- Raw total: CHF 11,997.31 — doesn't match the invoice.
That CHF 2.69 gap is the rounding problem. BillSplitter handles this by adjusting the last (or configured) period so the total always matches the original amount exactly. In the above case, the 2025 share becomes CHF 986.30 and the total CHF 12,000.00.
When accountants use a prorate calculator
- Deferred revenue — an annual SaaS contract invoiced at year start but recognized over 12 months
- Prepaid expenses — an insurance premium paid in full covering a policy year that crosses a fiscal boundary
- Service fees — consulting, licensing, or maintenance contracts invoiced as a single line item
- Rent accruals — long-term leases where the payment schedule doesn't match the accounting period
- Mid-year terminations — calculating the amount to credit/debit when a contract ends early
- Mid-period upgrades — SaaS customers moving from Standard to Pro mid-cycle where the proration credit has to be computed
Why day-exact matters
Auditors reject "rough splits". IFRS 15 requires revenue to be recognized in proportion to progress toward satisfying the performance obligation — when the obligation is time-based, that means day-exact allocation. German HGB §252 Abs. 1 Nr. 4 requires period-appropriate allocation (Realisationsprinzip). Swiss OR Art. 958b is explicit: income is recognized in the period it accrues.
A 1-2% rounding error on a CHF 50,000 invoice is CHF 500-1,000 in misstatement. Multiply across a company's annual contract base and that becomes a material audit finding. Day-exact proration removes the discrepancy.
Try the calculator
The full BillSplitter tool handles the math, exports to PDF and Excel, and works offline. Nothing is sent to a server. No signup.
Also available: IFRS 15 calculator, revenue recognition calculator, fiscal year allocation tool.
Frequently asked questions
What does a prorate calculator actually do?
It splits a single amount across a period proportionally by time — usually by exact day count. If a 12-month service costs CHF 12,000 and you're only using it for 3 months, a prorate calculator tells you the fair share is CHF 3,000. Real tools go further and handle leap years, fiscal year boundaries, and non-calendar billing cycles.
What's the formula for prorating?
The standard proration formula is (days used / total days in period) × total amount. For a CHF 12,000 annual fee where you only consumed 92 days, the calculation is (92 / 365) × 12,000 = CHF 3,024.66. BillSplitter extends this to multi-period splits — when one invoice spans fiscal years, it produces a day-exact allocation per fiscal period that sums to the cent.
How is this different from a simple percentage calculator?
A percentage calculator assumes uniform distribution. A proper prorate calculator handles irregular periods: fiscal years of different lengths, leap days, months with 28-31 days, and fiscal year boundaries that don't align with calendar years. For accrual accounting the difference matters — an incorrect split of CHF 50,000 over two fiscal years could mean you're off by hundreds at year-end closing.
Is prorating the same as amortization?
They're related but different. Prorating typically refers to splitting one-time or fixed amounts across time based on usage or delivery. Amortization is the accounting method of systematically writing off an amount over multiple periods. Many accrual entries use prorated allocations as input — a prepaid expense is prorated across its benefit period, and that month-by-month piece becomes the amortization schedule.
Can I use this for SaaS subscription proration?
Yes. The same day-exact math works for SaaS upgrades mid-cycle, annual plan refunds, usage-based billing that straddles months, and mid-month plan changes. BillSplitter doesn't integrate directly with your billing system (Stripe, Chargebee, etc.), but the calculated amounts match what those systems should produce — useful for audit reconciliation or manual ledger adjustments.
Does BillSplitter store my data?
No. All calculations run in your browser. Nothing is sent to a server. No signup, no cookies except the essentials, no analytics on your input values. The tool works offline after the first load. That's a deliberate design choice for a finance tool — your invoice data stays yours.
Is it free?
Yes, fully free, no signup. Operated by Siempi AG (Swiss company, Canton of Zug). You can bookmark the calculator and use it as often as you need.