How Distributors Can Keep Supplier Price Changes From Eroding Margin
Load supplier costs one way, reprice before the next quote, and set the margin floor after state B&O tax and any Seattle or Bellevue city tax.
In this guide
The short answer: if you run pricing or purchasing at a distributor in Seattle, Bellevue or elsewhere in Washington, put a supplier's new cost into your ERP the same way every time, recalculate the affected sell prices before the next quote goes out, and route the few lines that touch a contract, a mismatched item code, or an unclear cost basis to a named person. In Washington, also set the margin floor after B&O tax, because the state taxes gross receipts and Seattle adds its own rate.
For a merchant wholesaler, gross margin is total sales less cost of goods sold, and cost of goods sold is beginning inventory plus purchases of goods for resale minus ending inventory (U.S. Census Bureau, Annual Wholesale Trade Survey Glossary). A supplier increase you have not entered is margin the order desk gives away one quote at a time. Our distribution implementation work sets up that routine.
Why a stale supplier cost quietly costs you margin
A cost that is a week old does not announce itself; it just lowers the margin on every quote that uses the item. Take a half-inch copper coupling that costs you $0.82 and sells at a $1.48 list. That is a 44.6% margin ($0.66 ÷ $1.48). If the supplier raises the cost to $0.94, a 14.6% increase, and nobody moves the sell price, the margin on that line falls to 36.5% ($0.54 ÷ $1.48), an eight-point drop, until someone notices.
See how we help distributors implement this
Restoring the margin is arithmetic: at the new $0.94 cost, holding roughly the same margin means selling near $1.70 ($0.94 ÷ 0.554), which returns a 44.7% margin ($0.76 ÷ $1.70). The hard part is doing it for every affected item, on the day the cost changes, without breaking a contract or misreading the file.
What your ERP can already do
More than most order desks use, so price the "configure" option before you shop. Oracle NetSuite imports a vendor price list from a comma-delimited file, mapping item name, vendor code, purchase price, an optional price schedule, and currency, and its documentation states that "the items listed in the file must already exist in your NetSuite account and the names must exactly match those in your account" (Oracle NetSuite, Importing a Vendor Price List). Microsoft Dynamics 365 Business Central keeps separate purchase and sales price lists; its Suggest Lines action creates price-list lines in bulk with an adjustment factor, and Edit in Excel lets you change many lines and publish them back (Microsoft, Set up prices and discounts in Business Central).
So the configure path is real: both systems can apply a cleaned cost file in one batch. Neither turns a supplier's idiosyncratic spreadsheet or PDF into that clean, exactly matched file, or decides which increases to pass through.
Where the real work hides
The effort lives in the gap between the supplier's file and the ERP's import. Three problems recur:
- Format variety. One supplier sends a tidy spreadsheet, the next a PDF letter, a third a portal export with its own column names, and each must be reshaped to the fields your ERP expects.
- Identity. Suppliers rename and renumber items. When their code no longer matches your item master, the row updates the wrong item or fails; NetSuite's exact-name requirement is the rule, not an edge case.
- Cost basis. The "price" column may be list rather than your net cost after a rebate, and may or may not include freight. Load the wrong basis and you raise prices you should not.
Configure, buy, or bring in help?
Choose by how varied your supplier files and pricing rules are, not by vendor promises; many distributors combine the three options.
| Approach | What it is | Handles messy supplier files? | Best fit |
|---|---|---|---|
| Configure the ERP you own | Vendor price-list import and bulk price tools already in NetSuite or Business Central | No; you must reshape each file and match items yourself | Predictable file formats, a manageable SKU count, basic margin rules |
| Buy dedicated pricing software | A price-management platform that recalculates, applies margin rules, and syncs prices to the ERP | Partly; strong on rules and recalculation, still needs clean cost inputs | Many suppliers, complex or account-specific pricing, frequent changes |
| Add extraction or implementation help | Software or a team that reads varied files and encodes your exception rules, keeping the ERP as the system of record | Yes; built for the messy-file-to-clean-import gap, with human approval | High file variety (PDFs, portals) when you want to keep your current ERP |
Dedicated pricing platforms describe real capabilities, such as automated recalculation, margin rules and syncing prices to the ERP, and publish customer results such as a roughly 70% shorter quote cycle, but those figures are vendor-reported and not independently verified (Pricefx, pricing automation for distributors).
A worked example: one supplier increase
Northline and Kesterline Supply are illustrative names and every figure below is hypothetical; the arithmetic is shown so you can check it. Northline sends Kesterline Supply a 240-line increase effective the first of next month. Most lines are clean, but four show the pattern that decides your routine.
| Line | What is going on | What has to happen |
|---|---|---|
| Copper coupling, cost $0.82 → $0.94 | Exact match, cost-only change, margin stays healthy | Update cost and recalculated sell price in one batch; log it |
| Same item on a national-account contract at $1.35 through Dec 31 | Contract margin falls from 39.3% to 30.4%; you cannot raise the fixed price | Honor the contract, flag it for the next renewal |
| Supplier code CU-050-CP renumbered to CU-050-CPX | The code no longer matches your item master | Fix the mapping before any update, or the row hits the wrong item |
| "Price" column is list, not your net of a 12% rebate | Loading it as cost overstates cost and triggers a needless increase | Apply the correct net basis before the number is trusted |
The clean line is the majority; the other three are why a person still belongs in the loop.
An exception ladder you can hand to the desk
This exception ladder is a proposed operating method, not a product feature or a guaranteed outcome. Sort each incoming line into one of five rungs:
- Exact item match, cost-only change, margin stays in band → a rule updates the cost and recalculated sell price automatically, with a log entry.
- Exact match but the new margin falls below your floor → update the cost automatically, hold the sell price for a pricing decision.
- A contract or customer-agreement price is affected → a person owns it: honor the agreement and flag it for renewal.
- Item code, pack, or unit of measure does not match the master → fix the mapping before any update.
- The cost basis is ambiguous (list versus net, freight in or out, unclear effective date) → a person resolves the basis before the number is trusted.
The line counts and minutes in this paragraph are an illustration with stated assumptions, not a measured benchmark or a promised time saving. If about 180 of the 240 lines land on rung one and roughly 60 across rungs two through five, a configured import can post the 180 in a batch while a person spends, say, four minutes each on the 60 exceptions: about four hours of concentrated judgment instead of re-keying 240 lines by hand.
In Washington, set the margin floor after B&O tax
Washington's business and occupation tax is a gross receipts tax: a business cannot deduct labor, materials or other costs of doing business, as the Department of Revenue explains. The state wholesaling rate is 0.484 percent of gross proceeds of sales until January 1, 2027, when RCW 82.04.270 raises it to 0.5 percent. Seattle levies its own B&O tax on top: the city's wholesaling rate for 2026 through 2032 is 0.342 percent, and under the Seattle Shield changes a business with less than $2 million of Seattle taxable revenue in a year owes none, while one above that threshold deducts $2 million before the rate applies.
Seattle is not the only city with its own B&O tax: many Washington cities levy one on top of the state's, which the Department of Revenue does not collect, and the rates differ. Bellevue, for example, charges 0.1596 percent on every gross receipts classification, including wholesaling. If you sell from a warehouse outside Seattle, check that city's own rate and thresholds rather than assuming Seattle's.
Because the tax follows the sell price rather than the margin, it belongs inside rung two. Take the contract line: at $1.35 and a $0.94 cost, gross margin is $0.41, or 30.4%. State and Seattle wholesaling B&O together take 0.826% of $1.35, about $0.011, leaving roughly $0.399, or 29.5%. A 30% floor that passes the line on paper fails it for a distributor paying both taxes on that sale. With Bellevue's rate in place of Seattle's (0.644% combined), it lands at about 29.7%, still under the floor. The contract also renews after December 31, so its next price will apply in a year with the higher state rate. Have whoever prepares your excise and city returns confirm which sales each city taxes before you build its rate into the rule.
Who owns the exceptions
Name the owners before you automate anything. Pricing or category management owns the margin-floor and contract calls on rungs two and three; the item master, usually purchasing or data administration, owns the code and unit-of-measure fixes on rung four; and supplier onboarding owns the cost-basis rules on rung five. Put the effective date on the price list and keep a log of what changed and who approved it, and the routine survives a busy week and a staff change. Turning inbound orders into reviewed ERP drafts depends on the same discipline: clean master data and a clear owner for every exception.
Quick answers
How fast should a distributor enter a supplier price change?
Before the next quote or order that uses the item. A cost that is a week old lowers the margin on every line that uses it, because gross margin is sales less cost of goods sold.
Does Washington B&O tax change a distributor's margin floor?
Yes. The state wholesaling rate is 0.484 percent of gross proceeds until January 1, 2027 and 0.5 percent after, and Seattle, Bellevue and many other cities add their own rates, so measure the floor after those taxes.
What should stay a human decision?
Contract prices, margin-floor breaches, item-code and unit-of-measure mismatches, and any line where the cost basis is unclear. Automate the clean, in-band cost changes and route the rest to a named owner.
Sources
- U.S. Census Bureau, Annual Wholesale Trade Survey Glossary (accessed 2026-09-25).
- Oracle NetSuite, Importing a Vendor Price List (accessed 2026-09-25).
- Microsoft, Set up prices and discounts in Business Central (accessed 2026-09-25).
- Pricefx, pricing automation for distributors (vendor page; results not independently verified).
- Washington Department of Revenue, Business & occupation tax (accessed 2026-10-05).
- RCW 82.04.270, Tax on wholesalers (accessed 2026-10-05).
- City of Seattle, Tax Rates and Classifications and Seattle Shield B&O Tax Changes (accessed 2026-10-05).
- Washington Department of Revenue, City B&O tax and City of Bellevue, Gross Receipts B&O Tax (accessed 2026-10-05).
Revision note · October 6, 2026: Headline simplified; the article body is unchanged.
How we research and review these guides
Put the ideas to work in your business.
We provide AI consulting and implementation for distributors and wholesalers. Bring us the process that is slowing your team down and the systems involved. We can assess the problem with you and discuss a practical implementation.
Discuss your project →Still exploring? Explore the Workflow Opportunity Workbook →