Prorated Billing & Change Planner
Trace a billing period day by day without losing the distinction between service charges, invoice adjustments and actual payments. Enter multiple items and dated quantity or price changes, then inspect their service intervals, cumulative exact charge and invoice ledger. Compare rounding each item segment with rounding the invoice total. The planner uses explicitly supplied civil dates and actual whole days, including weekends and leap days. It does not emulate a billing provider, infer tax or statutory payroll or rent rules, or issue refunds. All items share one supplied period, and unit prices are net prices for that full period. Examples are illustrative.
Trace every day. Reconcile every charge.
See how dated quantity and price changes affect service charges, invoice rounding and the balance after payment.
Revised invoice USD 295. Invoice adjustment USD 5. Balance after payment USD 5.
Edit billing period, items and changes
Plan charges over one shared billing period using actual whole calendar days. This does not reproduce provider-specific timestamp rules, tax calculations, statutory entitlements or automatic refunds.
Billing items and dated changes
Unit prices are net prices for the entire supplied period, not daily rates. A change replaces quantity and unit price from that date onward. All days count, including weekends and leap days.
Repeated same-value changes still split invoice segments and can affect segment rounding. Chart intervals never create additional invoice lines. A negative balance after payment represents an overpayment or credit balance, not a refund instruction.
2028-02-01 included → 2028-03-01 excluded · 29 actual days
This is a whole-day planning convention, not a provider invoice preview, tax calculation or determination of refund entitlement.
What does rounding change?
| Method | Original | Revised |
|---|---|---|
| Exact before rounding | USD 290 | USD 295 |
| Round each item segment | USD 290 | USD 295 |
| Round invoice total | USD 290 | USD 295 |
Segment-rounded minus invoice-rounded revised charge: USD 0. Repeated same-value changes still split invoice lines; that can change segment rounding. Chart partitions never add invoice lines.
Charges, credits and payment balance
Common signed scale: USD 0 to USD 295. Dashed line marks zero. Left of zero is a credit or overpayment; right is a positive amount.
Original invoiceUSD 290
Revised invoiceUSD 295
Invoice adjustmentUSD 5
Balance after paymentUSD 5
Service timeline by item
Every row spans 2028-02-01 to 2028-03-01, excluding the final date. Solid intervals have positive quantity; outlined intervals have zero quantity. Interval widths represent actual calendar days, not cost.
Team seats
- 2028-02-01 → 2028-02-11 excluded: 10 days, quantity 2, full-period unit price USD 145; active.
- 2028-02-11 → 2028-02-21 excluded: 10 days, quantity 3, full-period unit price USD 145; active.
- 2028-02-21 → 2028-03-01 excluded: 9 days, quantity 1, full-period unit price USD 145; active.
Cumulative exact service charge
Horizontal: 2028-02-01 to 2028-03-01. Vertical: 0 to USD 295. Solid blue is cumulative exact charge; dashed purple is the original full-period exact charge. This is service allocation, not payment timing or accounting recognition.
| Start included | End excluded | Days | Daily total rate | Interval charge | Cumulative charge |
|---|---|---|---|---|---|
| 2028-02-01 | 2028-02-11 | 10 | 10 | 100 | 100 |
| 2028-02-11 | 2028-02-21 | 10 | 15 | 150 | 250 |
| 2028-02-21 | 2028-03-01 | 9 | 5 | 45 | 295 |
Item invoice ledger
Team seats: exact revised charge USD 295; exact adjustment USD 5. Item segment-rounded sum: USD 295.
| Start included | End excluded | Days / period | Quantity | Full-period unit price | Exact charge | Rounded segment |
|---|---|---|---|---|---|---|
| 2028-02-01 | 2028-02-11 | 10 / 29 | 2 | USD 145 | USD 100 | USD 100 |
| 2028-02-11 | 2028-02-21 | 10 / 29 | 3 | USD 145 | USD 150 | USD 150 |
| 2028-02-21 | 2028-03-01 | 9 / 29 | 1 | USD 145 | USD 45 | USD 45 |
Save the billing record
Export dates, quantities, full-period prices, exact charges, both rounding alternatives and payment balance. Currency is a supplied label. No refund or invoice is sent.
How to use this calculator
- Load Leap-month changes example or Rounding difference example, then open Edit billing period, items and changes. Enter the included start date and excluded end date as YYYY-MM-DD.
- Enter the currency label, minor-digit precision and actual payment received. Payment is separate from the original invoice; enter zero when nothing has been collected.
- Add each billing item with its initial quantity and net full-period unit price. Use quantity zero for an item that is inactive at the start.
- Add dated changes with the complete replacement quantity and full-period unit price. Dates may be entered in any order but must be unique per item and before the exclusive end. Use zero quantity to cancel from a given date.
- Compare rounding methods, inspect the service timeline and item ledger, then download the CSV or show its selectable copy. Verify the chosen convention against your billing terms; a calculated credit does not execute a refund.
The Formula
The mathematical logic powering this calculation is:
The billing period is [start, end): start is included and end is excluded. Let D be its actual Gregorian civil-day count. Count all days, including weekends and leap days; no timezone or daylight-saving adjustment is applied. Each item starts at its entered quantity q and full-period unit price p. Sort its dated changes and replace q and p from each change date onward. A change on start replaces the initial state for the whole period; changes on end are outside the period and rejected.
For a service segment lasting d days, exact charge C = q × p × d / D. Sum its segments for the item charge, then sum items for the exact revised charge. Exact original charge = sum of initial q × p. Exact adjustment = exact revised − exact original. A zero quantity represents inactive service; later nonzero quantity can activate it. Rates are full-period unit prices, not daily rates or price differences.
For a chosen precision k, rounding is half away from zero to 10^−k currency units. Segment policy: sum rounded item-segment charges; original invoice sums rounded initial item charges. Invoice policy: sum exact charges and round once for each invoice. Selected invoice adjustment = selected revised invoice − selected original invoice. Balance after payment = selected revised invoice − actual payment received. Negative balances are overpayments or credits, not automatic refunds. Payment must be representable at the chosen precision.
Repeated same-value changes still split invoice segments and can affect segment rounding. The chart uses common intervals at every item change, but those chart boundaries never create invoice lines or affect billing rounding. For each common interval, daily exact rate = sum of the active q × p / D, and cumulative exact charge adds rate × interval days. Exact fractions remain available in tables and exports.
Supports 1–20 items, up to 30 changes per item, dates from 1900 through 2100, periods of 1–3,660 days, nonnegative quantities up to 1,000,000 and unit prices up to 1,000,000,000 with six decimal places. Minor digits are explicitly chosen from 0–4; currency labels do not convert money. No taxes, discounts, metered usage, provider timestamp rules, billing-anchor resets, statutory entitlement or revenue recognition is inferred.Worked Example
If you input:
- Period: 2028-02-01 included through 2028-03-01 excluded: 29 days
- Initial item: 2 seats at USD 145 per seat for the full period
- First change: 2028-02-11: replace quantity with 3, unit price remains USD 145
- Second change: 2028-02-21: replace quantity with 1, unit price remains USD 145
- Payment: USD 290 received; 2 minor digits; segment rounding
Result:
The original invoice is 2 × USD 145 = USD 290. The first 10 days cost 2 × 145 × 10/29 = USD 100. The next 10 days cost 3 × 145 × 10/29 = USD 150. The final 9 days cost 1 × 145 × 9/29 = USD 45. Revised charge is USD 295, an additional USD 5 against the original invoice. After the supplied USD 290 payment, the balance is USD 5. Both rounding methods agree for this example. In the separate three-day rounding example, three exact charges of USD 1/300 each round to USD 0 individually, while the invoice-rounded total is USD 0.01.
Frequently Asked Questions
Which dates are included in the prorated charge?
The start date is included; the end date is excluded. A change applies from its effective date onward. All calendar days count, including weekends and leap days. No time of day or timezone is modeled.
Do I enter a daily price or a monthly price?
Enter the net unit price for the entire supplied period. If the period is a monthly billing term, use the full-term unit price. The planner divides by the actual day count of that period; it does not assume every month has 30 days.
Can I model an upgrade, downgrade, activation or cancellation?
Yes. A change replaces both quantity and unit price from its date. Zero quantity cancels that item from the date onward; initial zero followed by a positive quantity represents activation. Enter replacement values rather than signed differences.
Why can segment rounding differ from invoice rounding?
Several small fractions can round differently when rounded individually rather than after summing. For example, three one-third-cent charges each round to zero at two decimals, while their exact total rounds to one cent. Both alternatives are shown.
Does a negative balance mean a refund has been sent?
No. It means the supplied payment exceeds the selected revised invoice. How that credit is handled depends on the agreement and billing system. This planner does not send invoices, collect payments or issue refunds.
Does this exactly reproduce Stripe or Chargebee invoices?
No. Providers support different timing, billing modes and credit behavior. This planner uses an explicit whole-day convention and supplied prices, with no provider API connection or timestamp-level emulation.
Why are identical repeated changes retained?
They are explicit invoice-segment boundaries in this planning model. Under segment rounding, extra boundaries can change the final billed sum even when the exact service charge is unchanged. Chart-only boundaries never alter invoice segments.
Can I use this to establish salary, rent or tax entitlements?
No. It is a general billing worksheet. Employment, rental and tax rules can require different day counts, inclusions and legal treatment. No such rules or entitlements are inferred.
Similar Calculators
ERP Cost & Quote Comparison Calculator
Compare ERP quotes across users, modules, implementation and renewals. Visualize annual versus monthly payments, discounted cash and exact cost schedules.
Date Difference Calculator
Calculate the exact number of days, weeks, months, and years between two dates.
Payment Processing Fee Calculator
Compare processing quotes across payment groups, refunds, fee caps and monthly minimums. Visualize fees and net proceeds, find a target-net charge and export exact ledgers.
Invoice Tax & Rounding Reconciliation
Reverse tax-inclusive prices, add tax to net prices, and reconcile invoice discounts and credits. Compare line and group rounding with exact audit ledgers.
