Colocation Rack, Power & 95th Percentile Bandwidth Bill Calculator

Reconcile traffic samples, contracted bandwidth and rack, power and service fees against your actual invoice.

Billing inputs

Enter paired inbound,outbound Mbps, one timestamp per row. Two columns only: no header, timestamp column or thousands separators. Do not fill missing samples with zero.

Verify the expected count from the actual period and sampling interval. It is not fixed at 30 days or 8,640 samples. Maximum 100,000 samples.

Bill reconciliation

Paste your traffic samples or load the worked example to begin. Unconfirmed costs are not counted as zero.

Related calculators

Reconcile a colocation invoice against the contract

A colocation bill can include rack space, electricity, internet access, remote hands, and one-time work.
Checking only the rack rental can miss bandwidth overage, separate power charges, installation, or removal costs.
Use this calculator with the actual contract, a traffic export for the same billing period, and the supplier invoice to reconstruct the line items and identify differences.
Prices are entered from your documents; the calculator does not embed a provider tariff or estimate a market price.

The decision the result supports

Determine the billable Mbps, the amount above the included commitment, and the contribution of each confirmed charge.
If you have an actual alternative commitment quote, apply it to the same traffic record and compare the cost.
An invoice difference is a prompt to reconcile the sampling period, contract rules, taxes, and work orders with the supplier; it does not establish improper billing.

For an equipment-based rack count and the power or cooling constraints of your own facility, use the Server Rack Count, Power, Cooling & Cost Calculator.
Here, rack quantities represent the units billed under an external colocation contract, rather than a facility construction estimate or an electrical safety assessment.

Average throughput is not percentile bandwidth

The average adds the measured rates and divides by the number of samples.
The percentile method implemented here removes the contractually specified number of highest observations and selects the highest observation remaining.
A service with a low average can still have a larger billable rate when higher traffic persists across enough intervals.
One average or a monthly transfer total cannot reproduce the underlying distribution, so you need the measured sample record.

Use the actual sample count

A simplified 30-day period sampled every five minutes contains 8,640 observations, but that is not a universal billing denominator.
Check the actual period, interval, service start, and treatment of missing data against the supplier report.
Do not replace gaps with invented zero observations; doing so can change the result.

Keep Mbps and GB separate

Mbps describes a transfer rate, while GB describes accumulated transferred data.
A contract billed per monthly GB uses a different charging model.
Converting monthly GB to an average Mbps and entering that average as percentile traffic cannot reconstruct the original billing samples.

Prepare the inputs and distinguish unknown from zero

Match inbound and outbound observations from the same timestamps and measurement intervals before preparing the input.
Paste one pair of numeric Mbps values per line in in,out format.
Remove headers, timestamp columns, unit labels, and thousands separators inside the sample values; use a point for decimals.
Preserve the timestamps and evidence of missing intervals in the original export, and record the billing-period identifier and time zone in the calculator.

Copy these items from the documents

  • Billing-period identifier, time zone, sample interval, expected sample count, and confirmation that the export covers the entire period
  • Inbound/outbound combination rule, exclusion percentage, floor or ceiling for the discarded sample count, and billable-Mbps rounding increment
  • Included Mbps, base fee, and overage price per Mbps for the current commitment and any actual alternative quote
  • Total equipment U, U per contract unit, number of billed contract units, and monthly price per rack unit of contract
  • The flat power fee, or confirmed reserved kW or metered kWh and the corresponding unit price
  • Remote-hands and other recurring charges, current-period installation and removal, agreed tax or discount adjustment, and actual invoice amount

A blank means that the amount is still unknown; zero means you have confirmed that no separate charge applies.
Even in a period without installation, enter a confirmed zero to close that part of the cost scope.
If rack rental already includes power or remote hands, do not enter the same amount again as a separate item.
Where the included scope is unclear, leave the item unknown and ask for a breakdown instead of assuming it is free.

Sample exclusion and direction order

Determine the discarded count first

For N observations and exclusion percentage p, the discarded count is either floor(N × p / 100) or ceil(N × p / 100), as specified in the contract.
Sort the relevant series from highest to lowest, discard that many observations from the beginning, and select the highest value remaining.
This method does not interpolate between observations, and a rule that discards every sample is invalid.
With N=21 and p=5%, floor discards one sample whereas ceiling discards two, which can produce a different billable rate.

Higher of the two directional percentiles

Calculate the inbound and outbound percentile values separately, then take the larger result.
Do not combine each pair of observations before sorting when this is the agreed method.

Percentile of the interval maximum or sum

First construct max(in,out) or in+out for each matching interval, then apply the exclusion rule to that resulting series.
When inbound and outbound peaks occur at different times, this can differ from calculating each direction separately and taking the larger percentile.

Outbound-only billing

Apply the exclusion rule only to the outbound column.
The presence of inbound data does not add an inbound charge automatically.
A method described for one supplier product should not be assumed to govern another connection.

Finally, apply the contractual Mbps increment q to the raw percentile value b.
When q is positive, use ceil(b / q) × q; q=0 means no additional Mbps rounding.
This is separate from rounding the number of discarded samples, so both rules must be confirmed before treating the bandwidth as final.

Rack, power, network, and period-cost formulas

Network fee

Overage Mbps = max(0, billable Mbps − included Mbps)
Network fee = base fee + overage Mbps × overage rate
The entered base fee still applies below the commitment; the calculator does not invent a commitment discount.

Rack cost and U reference

Rack fee = billed contract units × monthly unit price
U-based required units = ceil(equipment U / U per unit)
A larger reference requirement does not silently change the billed quantity; confirm the expansion arrangement separately.

Power fee

For flat billing, use the confirmed monthly fee.
Reserved-capacity billing uses kW × monthly price per kW; metered-energy billing uses kWh × price per kWh.
The calculator does not convert between power and energy, or automatically convert kVA or amperes.

Recurring and period totals

Recurring cost adds rack, power, network, remote hands, and other monthly charges.
Add installation, removal, and the agreed adjustment for the current period to obtain the reconstructed period amount.
Subtract that amount from the actual invoice to calculate the invoice difference.

All amounts use one selected currency, without automatic foreign-exchange conversion.
No statutory VAT rate is embedded, so use a consistent tax basis and avoid adding tax twice to tax-inclusive quotations.
Enter documented discounts or credits as an agreed adjustment, and use the agreed period amount for any partial-month service.
Displayed money is a reconciliation figure shown to two decimal places; record any confirmed supplier-specific invoice rounding as an adjustment rather than assuming every supplier rounds the same way.

Work through the form and review partial results

  1. Paste the paired traffic export for the same period.
    If a row is rejected, check the units, headers, column order, and numeric format against the original file.
  2. Enter the period, time zone, measurement interval, and expected sample count, then confirm full-period coverage.
    An equal row count alone cannot prove that the source contains no duplicate or missing interval.
  3. Confirm the direction rule, exclusion percentage, discarded-count rounding, and Mbps increment from the contract.
    Do not assume that an initial editable setting matches your supplier.
  4. Enter the current commitment and confirmed rack, power, and work charges.
    Read the confirmed subtotal separately from unresolved items, and enter zero only where no charge has been verified.
  5. Add the actual invoice and any quoted alternative commitment, then reconcile the difference.
    Save the TXT record and retain the source export and contract version alongside it.

Loading the worked example preserves the values and input stage you were editing.
Check the example indicator; returning to your original input restores the saved values and stage.
Before using the result for your contract, replace the example traffic and prices with your own documents.
A confirmed subtotal on a partially completed form is not a final invoice amount and does not treat unknown items as free.

Worked example with 20 observations

This short test period demonstrates the calculation; it is not a complete calendar-month export.
Use 20 observations with inbound values 1 through 20 and matching outbound values 2 through 40 in steps of two.
Select a 5% exclusion, floor for the discarded count, the higher of the directional percentiles, and a 1 Mbps rounding increment.
One observation is removed from each direction, leaving inbound 19 and outbound 38, so billable bandwidth is 38 Mbps.

KRW worked example showing the reconstructed invoice line items
ItemInput or calculationAmount KRW
Network100,000 base + 8 Mbps overage × 2,000116,000
Rack1 contract unit × 300,000300,000
PowerConfirmed flat monthly fee200,000
Remote handsConfirmed period charge30,000
Recurring totalIncluding zero other recurring charges646,000
Period installationRemoval and adjustment both zero50,000
Reconstructed period amountRecurring total + installation696,000
Actual invoiceEntered supplier total700,000
Invoice differenceActual − reconstructed amount+4,000

The current commitment includes 30 Mbps, leaving 8 Mbps of overage.
With 20U of equipment and a 42U contract unit, the U-only reference is one required unit, and the example assumes one billed unit.
An alternative with 40 Mbps included, a KRW 110,000 base fee, and KRW 2,000 per excess Mbps has no overage at the same measured 38 Mbps.
Keeping all other charges equal gives an alternative period amount of KRW 690,000, which is KRW 6,000 lower; verify any separate installation, change, or termination charge before switching.

Interpret the result and use it in a supplier review

Review the commitment before renewal

Applying two actual quotations to one historical sample set shows how a higher base fee trades off against lower overage.
It does not forecast next month; run separate exports for peak periods or other observed operating conditions.

Reconcile the monthly invoice

A positive difference means the actual invoice exceeds the entered reconstruction; a negative difference means it is lower.
Check IP options, out-of-hours work, credits, tax, billed contract units, and the supplier rounding sequence before drawing a conclusion.

Do not substitute kW and kWh when the power charging unit is unclear.
A kVA draw cap, circuit capacity, power factor, and usable load during a power-path failure are separate engineering conditions.
Adequate U space alone does not establish sufficient power, cooling, floor loading, or cabling, and a cost reconciliation does not approve an additional equipment installation.
To compare operating labor, licenses, migration, and the broader hosting choice, also use the Cloud Server vs Managed Hosting TCO Calculator.

Frequently asked questions

Does excluding 5% mean that traffic is always free?

The method removes a specified number of observations from the entered charging calculation.
It does not grant a free time window or waive all traffic charges; port speed, minimum fees, and other terms still need to be checked in the contract.

Can I start with only part of the sample record?

You can inspect the input format and summary of the observations entered, but a partial export cannot establish the final bill for the whole period.
Match the expected count and verify the complete source record with consistent timestamps and intervals before relying on the period amount.

Should the discarded count use floor or ceiling?

Select the rule in your supplier agreement.
When the percentage produces a fractional count, the two choices leave different observations; ask for an official worked calculation and source billing record if the term is unclear.

How do I enter power included in rack rental?

If you have confirmed there is no separate power charge, enter zero for flat power and the agreed combined amount under rack rental.
If exceeding the included power creates a separate fee, use the confirmed additional amount and scope for that period.

Are tax and partial-month proration automatic?

The calculator does not apply a country-specific tax rate or a proration convention.
Use a consistent tax basis, record agreed tax, discounts, or credits in the adjustment, and enter the actual agreed fee for the billing period.

Is a cheaper alternative enough reason to switch?

The comparison uses the same historical observations and the cost scope you entered.
Check port speed, SLA, IP space, installation, termination, change fees, commitment duration, and future traffic before accepting the final quotation.

Primary references and terms to recheck

Sources were checked on 2026-11-21.
These provider documents support the charging concepts and export workflow, rather than a common market price or a standard agreement for every data center.

A statement that one particular product has no installation or termination fee must not be carried over to another supplier agreement.
Recheck prices, the billing period, complete samples, direction and rounding rules, included scope, and tax for each contract and period.
Review public documentation quarterly or when the agreement changes.

Align the export and quotation to one period

Start with the sample record and complete the contract rules one by one.
Use the billable rate, line-item costs, and unresolved-item list to ask the supplier specific reconciliation questions.
Keep the saved calculation with its period, currency, conditions, original invoice, and traffic export so the result can be reproduced later.