Vendor Margin Calculator

Import vendor pricing from PDF, Excel, paste, or manual entry. Set margins (with per-UOM overrides), edit as needed, then export an internal sheet or customer-ready quote.

1 Import pricing data

Start with a blank table and add rows manually.

★ Pick a sheet

This file has multiple sheets with pricing. Pick the one you want to use for this quote.

★ Central States Price Catalog — Select a section

Multiple sections detected. Select the one you'd like to use for this price sheet. Each section has its own price columns — run the tool again to build a sheet for a different section.

★ Brava Roof Tile — Non-Stocking Pricing

Select the product line you'd like to build a price sheet for. Stocking pricing is not included.

Each section uses color/quantity tiers as price columns — run the tool again for a different product line.

★ Review extracted data

Found a price table

—

0Products found
0Price columns
—Header row

First 10 products that will be imported:

Manual column mapping

For each column, pick what it is. Multiple columns marked SKU or Description will be combined. UOM and Cost columns pair up by position — the first UOM with the cost(s) that follow it, etc.
If detection picked the wrong row, change it here.

2 Quote details

3 Margin & line items

How margins work The default applies to every UOM column. Override any cell to use a different margin for one product/UOM.
Products0
Price columns0
Total cost$0.00
Total price$0.00
Blended margin0.0%

4 Export

Internal use

Customer-ready

MENU