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.

Prorated billing & changes

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 period and payment

YYYY-MM-DD. The first day belongs to the billing period. Dates from 1900 through 2100 are supported.

YYYY-MM-DD. This day is not charged in this period. End must follow start by 1–3,660 days.

All prices and payments use this label. Changing it does not convert money.

Separate from the original invoice. Enter zero if nothing has been paid; do not assume an invoiced amount was collected.

Choose the billing precision explicitly. Payment received must be exactly representable at this precision. This setting does not infer currency rules.

Both methods remain available for comparison. Halfway values round away from zero. Segment rounding follows each item’s dated invoice lines.

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.

Billing item 1

Use a descriptive service or plan name.

Nonnegative; zero means inactive at period start. Fractional quantities are allowed when your terms use them.

Price per unit for the whole period. Enter a confirmed zero for a free item; blank prices remain invalid.

Changes may be entered in any order; the calculation sorts dates. Duplicate dates for this item are rejected. A change on the period start replaces the starting rate for the entire period.

Item 1, change 1

YYYY-MM-DD, on or after the period start and before its exclusive end.

The complete new quantity, not an increase/decrease amount. Zero cancels this item from this date.

The complete new price per unit for the full supplied period, not a price difference.

Item 1, change 2

YYYY-MM-DD, on or after the period start and before its exclusive end.

The complete new quantity, not an increase/decrease amount. Zero cancels this item from this date.

The complete new price per unit for the full supplied period, not a price difference.

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

Revised invoice
USD 295
Each service segment rounded before summing
Original invoice
USD 290
Initial quantities and prices for the full period
Invoice adjustment
USD 5
Additional charge against original invoice
Balance after payment
USD 5
Revised invoice less USD 290 received

This is a whole-day planning convention, not a provider invoice preview, tax calculation or determination of refund entitlement.

What does rounding change?

Half away from zero, 2 minor digits. Exact values can contain fractions.
MethodOriginalRevised
Exact before roundingUSD 290USD 295
Round each item segmentUSD 290USD 295
Round invoice totalUSD 290USD 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.

Cumulative exact service charges through the periodThe cumulative charge ends at USD 295 exact. The original exact charge is USD 290. Each interval is listed in the table below.
Exact amounts in USD; fractions retain precision.
Start includedEnd excludedDaysDaily total rateInterval chargeCumulative charge
2028-02-012028-02-111010100100
2028-02-112028-02-211015150250
2028-02-212028-03-019545295

Item invoice ledger

Team seats: exact revised charge USD 295; exact adjustment USD 5. Item segment-rounded sum: USD 295.

Each segment uses the same 29-day denominator. Rounded segment values apply only to segment rounding.
Start includedEnd excludedDays / periodQuantityFull-period unit priceExact chargeRounded segment
2028-02-012028-02-1110 / 292USD 145USD 100USD 100
2028-02-112028-02-2110 / 293USD 145USD 150USD 150
2028-02-212028-03-019 / 291USD 145USD 45USD 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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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