A steel processor sends an RFQ for 24 tonnes of three sheet sizes. The base rates come from its annual agreement. Sales then adds four charges: alloy adjustment, energy surcharge, packing and freight.
The first draft shows one line called “surcharge” for £2,460.
The buyer cannot tell which parts scale with weight, which apply once per shipment, or which may change before delivery. The pricing manager cannot tell whether the base metal rate already includes the alloy movement. NetSuite includes the £2,460 in revenue, so the estimate appears to gain margin even though £2,280 merely recovers added cost.
A surcharge is a pricing rule. Treat it with the same discipline as the product price.
Decide whether to change base price or add a separate charge
Use base price when the cost now belongs to the normal product economics and the customer does not need a separate formula. Use a surcharge when the adjustment remains temporary, variable, contractually distinct or useful for the buyer to audit.
| Situation | Better representation | Reason |
|---|---|---|
| Permanent conversion-cost increase | Update base price | Every future unit carries the cost |
| Monthly alloy movement | Separate material adjustment | Rate and period can change |
| One expedited production request | Rush charge | Customer chose a specific service |
| One export crate | Packing charge | Charge applies once to the shipment |
| Seller-paid project freight | Freight line or shipping charge | Route and shipment plan drive cost |
| Standard domestic delivery included in list price | Base price | Separate recovery would duplicate price |
The commercial owner must decide where each cost lives. A system cannot detect double recovery when the base-price build-up sits in a spreadsheet and the surcharge enters NetSuite as a separate item.
For every charge, record one of these states:
- excluded from base price and recovered separately
- included in base price and not charged again
- partly included, with the remaining basis stated
- absorbed by the seller under an approved exception
- paid directly by the customer or a third party
That state should follow the quote revision.
Choose the NetSuite representation for the calculation
NetSuite offers several transaction constructs. They have different calculation and reporting behavior.
Markup item
Oracle’s Markup Items guide says a markup item adds a flat or percentage charge to the line immediately before it. If a subtotal precedes the markup, the percentage applies to that subtotal. Line order therefore changes the result.
A markup can work for a rush fee equal to 5% of selected work. It is a poor fit when the adjustment uses tonnes, an index formula or a shipment count that the transaction cannot show.
Other Charge for Sale item
An Other Charge item can represent a named revenue line such as alloy adjustment, certification or export packing. It gives the transaction a clear item, description, account and amount. Use separate items when finance needs separate reporting or tax treatment.
Shipping item or shipping cost
NetSuite shipping items can charge a flat amount, by weight, by item, by percentage or through a table. Oracle lists those choices in Creating Shipping Items. Shipping behavior can also depend on carrier integration, location, destination and package data.
Use a shipping item when the charge truly follows the shipping method. A raw-material adjustment should not hide inside shipping because someone found a convenient field.
Base item price
If the cost belongs in the product price, update the relevant customer, price level or quantity schedule through the pricing process. Do not leave an expired surcharge beside a base price that already absorbed it.
Custom fields and calculation records
Complex formulas often need a calculation record outside the printed transaction line. Store source series, periods, unit conversions and intermediate values there; write the approved result to the NetSuite estimate. The customer document can show the concise formula and amount while the internal record preserves the evidence.
Build a reproducible surcharge calculation
Every calculation needs these inputs:
| Input | Example |
|---|---|
| Charge type | Alloy adjustment |
| Affected lines | CR-1250 and CR-1500 |
| Quantity basis | 21 tonnes |
| Rate | £35 per tonne |
| Source | Supplier notice WM-2026-09 |
| Source period | September 2026 |
| Effective rule | Quote date from 1 Sep through 30 Sep |
| Currency | GBP |
| Rounding | Extend each line to 2 decimals, then sum |
| Base-price treatment | Excluded |
| Customer rule | Annual agreement section 4.2 |
The formula should be visible:
applicable quantity × rate = charge
For 21 tonnes at £35 per tonne, the alloy adjustment equals £735. The remaining 3 tonnes use a grade outside the supplier notice and should not enter the calculation.
Do not multiply the full order weight because the quote happens to total 24 tonnes. Scope belongs in the formula.
Calculate several charge types on one quote
Consider this 24-tonne order:
| Charge | Basis | Calculation | Customer amount |
|---|---|---|---|
| Alloy adjustment | 21 t of affected grades | 21 × £35/t | £735 |
| Energy surcharge | 24 t processed | 24 × £22/t | £528 |
| Export packing | 6 crates | 6 × £85 | £510 |
| Freight | One delivery to Birmingham | Carrier quote | £687 |
| Total charges | £2,460 |
The £2,460 total now has four rules. If the customer removes 8 tonnes, each rule responds differently.
| Change to 16 tonnes | New treatment |
|---|---|
| Alloy adjustment | Recalculate affected-grade weight, not total weight |
| Energy surcharge | 16 × £22 if the same process applies |
| Export packing | Recalculate the crate plan; do not reduce by one-third automatically |
| Freight | Obtain or recalculate the route and package rate |
The new freight could stay at £687 because the truck, distance and stop did not change. The crate count might fall from six to five. Quantity changes should trigger each dependency, not a blanket ratio.
Define an index formula completely
“Steel surcharge follows the market” is not a formula. An index-linked adjustment needs:
- the publisher
- the full series name and identifier
- the material component subject to adjustment
- the base index period and value
- the comparison period and value
- publication lag
- calculation frequency
- threshold or collar
- rounding rule
- treatment of preliminary and revised values
- replacement rule if the publisher ends the series
The US Bureau of Labor Statistics gives similar guidance in its price-adjustment guide for contracting parties. BLS also warns that parties should choose a series that reflects the costs involved and specify the index unambiguously.
Suppose the agreed formula adjusts only the £200 material component of one assembly. The base index equals 150.0 and the comparison index equals 159.0.
adjusted component = £200 × 159.0 ÷ 150.0 = £212
The adjustment equals £12 per assembly. For 40 assemblies, the quote line equals £480.
It does not equal 6% of the full finished-product price. If the assembly sells for £1,000, applying 6% to revenue would charge £60 per unit and recover five times the agreed material change.
Store the two observations and downloaded source beside the calculation. If the index later revises 159.0 to 158.4, follow the customer agreement’s revision rule. Do not silently change an accepted quote.
Resolve unit, currency and rounding before approval
Unit basis
The customer may order each, the BOM may hold kilograms, and the supplier may publish dollars per short ton. Convert all three through governed item or engineering data.
For a 40-piece line where each piece contains 18.5 kg of affected alloy:
40 EA × 18.5 kg/EA = 740 kg
At £42 per metric tonne:
740 kg ÷ 1,000 × £42/t = £31.08
The NetSuite units-of-measure guide explains how to anchor quote, inventory and supplier units to one physical quantity. Do not use a product-family average weight when the selected configuration changes material content.
Currency basis
State the source currency, quote currency, exchange rate source and rate date. Decide whether the customer charge fixes at quote, order, purchase or shipment. A GBP quote tied to a USD supplier index can change because of the index, exchange rate or both. Show those effects separately.
Rounding
Applying a rounded unit adjustment to each line can produce a different total from calculating on the full quantity and rounding once. Pick one method and test it against the customer agreement.
For 333 units at an exact adjustment of £0.1246:
| Method | Result |
|---|---|
| Round unit to £0.12, then extend | £39.96 |
| Extend exact rate, then round total | £41.49 |
The £1.53 difference will repeat across orders if two systems use different rules.
Separate customer recovery from cost and margin
A surcharge adds revenue. It may also recover cost. The quote margin review must show both sides.
| Charge | Customer revenue | Expected cost | Contribution effect |
|---|---|---|---|
| Alloy adjustment | £735 | £735 | £0 |
| Energy surcharge | £528 | £480 | £48 |
| Export packing | £510 | £430 | £80 |
| Freight | £687 | £705 | −£18 |
| Total | £2,460 | £2,350 | £110 |
If NetSuite reports the £2,460 as extra revenue while its estimated costs omit £2,350, displayed gross profit rises by almost the whole charge. The commercial contribution view corrects that distortion.
The opposite can happen when the base price already includes the cost and sales adds a surcharge again. The system needs an inclusion check alongside the arithmetic check.
Tax treatment depends on jurisdiction, item configuration, transaction facts and company policy. Finance should approve the item and tax setup. A generic miscellaneous item can post to the wrong account or receive the wrong tax treatment even when the total looks right.
Make the quote explain the charge
The customer document should answer four questions:
- What cost does the charge cover?
- What quantity or value drives it?
- Which rate or formula applies?
- Is the amount fixed for the quote validity period or recalculated later?
Weak line:
Surcharge: £2,460
Useful lines:
Alloy adjustment: 21 metric tonnes × £35/t = £735. Fixed through 30 September 2026.
Energy surcharge: 24 metric tonnes × £22/t = £528. Applies to the quoted production quantity.
Freight: one delivery to Birmingham, £687. Additional releases quoted separately.
Do not expose internal supplier names or confidential costs unless the commercial agreement calls for them. Give the buyer enough information to understand and reproduce the amount under their terms.
The quote template guide should test zero, one and several adjustments. A zero-valued section should disappear cleanly. Several charges should not bury product lines or terms.
Recalculate the right charges when the quote changes
Map each input to its dependent charges:
| Changed input | Charges to revisit |
|---|---|
| Item or configuration | Material, energy, outside processing, packing |
| Quantity | Per-unit, weight, tier and lot charges |
| Unit | Every quantity-based charge |
| Delivery destination | Freight, duty, handling, insurance |
| Shipment count | Freight, packing, handling, minimum fees |
| Required date | Expediting, supplier validity, carrier rate |
| Quote date | Effective surcharge period and index observation |
| Currency | Converted rate and margin |
| Customer agreement | Eligibility, cap, threshold and formula |
Do not ask a rep to remember this matrix. Run the dependencies when they edit the quote. Show which calculations changed and which source became stale.
If the customer accepts only part of the offer, create a new quote or order basis for the accepted quantity. Preserve the earlier revision. If the accepted terms allow a shipment-date formula, calculate it through the agreed process and retain the observation used.
Connect supplier changes to open quotes
When purchasing receives a new material, energy or freight rate, the supplier cost change workflow should find open quotes that use the earlier source. The response depends on customer state:
| Customer state | Surcharge action |
|---|---|
| Draft | Recalculate before release |
| Sent and still valid | Review the offered terms and supplier hold |
| Expired | Reprice through a new revision |
| Accepted | Follow the accepted rule; do not add a new charge silently |
| Ordered | Use change control and the order terms |
Changing a NetSuite surcharge item rate does not prove existing estimates, copied transactions or external quote drafts now use the right amount. Trace and test each transaction path.
Build approval around the real exceptions
Routine charges can calculate automatically after the team governs the formula. Route review when:
- source data is missing or expired
- a unit conversion lacks approval
- the customer agreement differs from standard policy
- the charge exceeds a cap or threshold
- the base price may already include the cost
- the seller absorbs part of the cost
- margin falls below policy after cost and recovery
- a quote change affects a previously approved calculation
The approval packet should show customer amount, expected cost, contribution effect, source, formula and quote revision. A manager should not approve a line named “miscellaneous.”
Test before using the rule on live quotes
| Test | Expected result |
|---|---|
| Charge applies to selected lines | Unaffected items do not enter the basis |
| Markup follows one line | NetSuite applies it only to the preceding line |
| Markup follows subtotal | Percentage applies to the intended subtotal |
| Quantity changes | Per-unit and weight charges recalculate |
| Split shipment | Fixed and per-shipment charges update separately |
| Unit changes | Physical quantity and total remain correct |
| Currency changes | Rate source and date remain visible |
| Index revision | Accepted transactions follow the agreed revision rule |
| Base price updated | Duplicate recovery check blocks the old surcharge |
| Zero charge | Customer document removes the empty line cleanly |
| Tax treatment | Finance-approved item produces expected result |
| Estimate to sales order | Approved amount and source follow or recalculate by policy |
| Partial fulfillment | Shipping and handling do not duplicate across invoices |
Oracle notes in Charging for Shipping and Handling per Item that the full charge can appear on the first fulfillment while later fulfillments carry none. Multiple Shipping Routes can calculate at shipment level. Include those cases if freight appears on your industrial quotes.
Metrics that expose weak surcharge control
Track:
- surcharge revenue and related cost by type
- contribution gained or lost on pass-through charges
- percentage of charges with current source evidence
- quote revisions triggered by rate or index changes
- duplicate-recovery exceptions
- manual override frequency and value
- disputes or credits tied to unclear charges
- freight recovery versus actual carrier cost
- time from source-rate change to affected-quote review
- rounding or unit discrepancies between quoting and NetSuite
High surcharge revenue is not automatically good. It may reflect volatile inputs, weak base pricing or charges that customers dispute. The useful result is correct recovery with a clear customer explanation and an auditable margin view.
Frequently asked questions
Should a surcharge use a NetSuite markup item?
Use a markup item when a flat or percentage charge should apply to the preceding line or subtotal. Use a named Other Charge, shipping item or custom calculation when the basis uses weight, an index, a shipment count or other data the markup cannot show clearly.
Can a markup apply to the whole estimate?
Yes, by placing a subtotal before the markup. Oracle says the markup then applies to the subtotal. Test line ordering because a markup without the intended subtotal affects only the line immediately before it.
Should freight use the shipping field or a transaction line?
Use the shipping setup when the charge follows a shipping method and its rate logic. A separate named line can fit project freight that needs explicit customer explanation or distinct approval. Finance and the NetSuite administrator should approve the accounting and tax setup.
Does a surcharge improve quote margin?
Only the part above its related cost improves contribution. Add both revenue and cost to the margin review. A pass-through charge can leave contribution unchanged, while under-recovered freight can reduce it.
Can we change a surcharge after quote acceptance?
Follow the accepted formula and commercial terms. If the customer accepted a fixed amount, a later supplier increase does not authorize a unilateral change. Route the exposure through commercial approval.
How should an index-linked surcharge work?
Name the exact series, adjusted component, base and comparison periods, formula, timing, rounding and treatment of revised or discontinued data. Store the source observations so another reviewer can reproduce the number.
What happens when the customer changes quantity?
Recalculate each dependent charge. Weight and per-unit adjustments usually scale. Packing, freight, minimum and lot charges may not. Update the shipment plan and quote revision before release.
Can Bourne calculate and maintain the surcharge?
Yes. Bourne can read source notices and indexes, apply the customer rule, convert units and currencies, detect duplicate recovery, write the approved result to the quote and rerun affected calculations after a change. The authorized pricing and finance owners still control the policy and exceptions.
Further reading
BLS: price adjustment guide
Selecting and specifying price indexes for commercial adjustments.
Buğra Gündüz
Buğra Gündüz is the co-founder and CEO of Bourne and co-founder of HockeyStack. He built HockeyStack into an eight-figure AI business. At Bourne, he works with entrepreneurs and established companies to create AI products and services.