Pallets, freight and landed cost, worked out in the quote
Your carton, pallet and freight spreadsheet as a block in the order: cells set the freight line's description and price, and the total comes back for a delivered cost.
- 5/5 on G2
- 4.2 on Capterra
- Building QuoteCloud since 2013
QuoteCloud's Spreadsheet block, on Essentials and up, is a full spreadsheet inside the quote: formulas, tabs and .xlsx import. Build your carton-to-pallet and freight maths on it, connect any cell to a price line's description and unit price, and bring the price table total back into a cell for a landed cost per carton. A Zapier step can write the carton counts.
Last reviewed by the QuoteCloud team
A formula bar stepping through a fictional wholesaler's Freight tab: B2, 40 cartons of TT-CUP12; D2 =B2/C2, 0.67 of a pallet; D6 =ROUNDUP(SUM(D2:D5),0), 1.59 pallets to 2; D9 =D6*D7+D8, 2 × $68 + $35 drop = $171.00. Below, a drawing of two 1,200 by 1,000 millimetre pallets with each product's share of a pallet as a block, 1,200 millimetres high when full: pallet 1 full, pallet 2 part filled with the rest dashed. The card: the freight line 'Delivery: 2 pallets to Riverside (Zone B)', $171.00, its description from B9 and unit price from D9; the order total $5,273.95 back in D10; $54.37 per carton delivered in D11.
The Freight tab, cell by cell
Pinecrest's order holds a Spreadsheet block with Tanbark's freight maths. The cartons for each SKU sit in B2:B5, written by a Zapier step or typed. Column C looks up cartons per pallet on the Rates tab, column D works out each SKU's share of a pallet, and D6 rounds the total up to whole pallets.
D9 prices the delivery: pallets × the zone rate + the drop fee. B9 and D9 are connected to the freight line's description and unit price, and the price table total comes back into D10, so D11 shows the delivered cost per carton. Click a cell to see its formula.
- Cell → a line's description and unit price
- Price table total → a cell
- Quantities stay on the price lines
Spreadsheet block and Zapier: Essentials and up
How the cartons get thereFreight tab
=ROUNDUP(SUM(D2:D5),0)| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | SKU | Cartons | Per pallet | Pallets |
| 2 | TT-CUP12 | 40 | 60 | 0.67 |
| 3 | TT-LID90 | 20 | 80 | 0.25 |
| 4 | TT-BOXM | 25 | 50 | 0.50 |
| 5 | TT-BAG12 | 12 | 70 | 0.17 |
| 6 | Pallets, rounded up | 2 | ||
| 7 | Zone | B · Riverside | Per pallet | $68.00 |
| 8 | Drop fee | $35.00 | ||
| 9 | Freight line | Delivery: 2 pallets to Riverside (Zone B) | $171.00 | |
| 10 | Order total | From the price table total:$5,273.95 | ||
| 11 | Per carton, delivered | $54.37 | ||
- Written by Zapier or typed
- Your rate
- Connected to the price table (description, unit price or total)
The order, as your team sees it in the editor
- Subtotal
- $4,794.50
- Tax (10%)
- $479.45
- Total Total → Freight!D10
- $5,273.95
- Payment
- On account, 30 days
Landed cost for an indent order
For a full container shipped from the factory to order, Tanbark prices from landed cost: the factory price, freight per carton, clearance and insurance, and duty at its own rate. The target margin turns the landed cost into the unit price, and B11 and B12 set the indent line's unit price and description.
The order total comes back into B13 and B14 checks the margin on the whole order. The costing sits in a section set to Hide from Recipient, so Sofia sees the line and the price, never the build-up.
- Your rates: freight, clearance, duty, margin
- B11 → unit price, B12 → description
- The costing hidden from the recipient
Spreadsheet block: Essentials and up
Landed tab · hidden from the recipient
=ROUND(B9/(1-B10),2)| Row | A | B | C |
|---|---|---|---|
| 1 | Per carton | Value | Basis |
| 2 | Factory price | $18.40 | Factory quote, 300 bowls |
| 3 | Container freight | $3,600.00 | Your rate, 40 ft |
| 4 | Cartons per container | 400 | Your figure |
| 5 | Freight per carton | $9.00 | |
| 6 | Clearance & insurance | $1.20 | Your estimate |
| 7 | Duty rate | 5% | Your rate for this item |
| 8 | Duty per carton | $0.92 | |
| 9 | Landed cost | $29.52 | |
| 10 | Target margin | 32% | Your rate |
| 11 | Unit price | $43.41 | → the line's unit price |
| 12 | Description | 16 oz soup bowl, indent | |
| 13 | Order total | From the price table total:$19,100.40 | inc tax |
| 14 | Margin on the order | 32.0% | |
- Written by Zapier or typed
- Your rate
- Connected to the price table (description, unit price or total)
Your indent order
- Subtotal
- $17,364.00
- Tax (10%)
- $1,736.40
- Total Total → Landed!B13
- $19,100.40
- Payment
- On account, 30 days from delivery
The spreadsheet you already trust, inside the quote
A full spreadsheet block: formulas, tabs and .xlsx import, like the one on your desktop.
ROUNDUP
Pallet shares rounded up to whole pallets, cartons to full cartons.
XLOOKUP
Cartons per pallet and zone rates looked up on your Rates tab.
IF
A drop fee only under a pallet count, a surcharge for a tail-lift.
Tabs and .xlsx import
Bring in your freight workbook and keep the rates on their own tab.
Bring your freight spreadsheet into the quote
Free for 14 days, no credit card required. Send us your pallet and freight workbook and we'll build it into an order template during the trial.
Delivered cost, per carton
The number buyers compare
Pinecrest's order total, brought back into the Freight tab and divided by the cartons: what each carton costs at the kitchen door.
Build a freight calculator into your quote in five steps
From your freight workbook to a freight line that's right on every order.
Import your workbook
Add a Spreadsheet block to the template and import your .xlsx.
Label inputs and rates
Cartons per SKU as inputs; cartons per pallet, zone rates and drop fees on a Rates tab.
Connect the freight line
Connect a cell to the line's description and another to its unit price.
Bring the total back
The price table total into a cell, for delivered cost per carton or margin.
Fill the cartons
Typed by your team, or written into the cells by a Zapier step.
Questions about pallet and freight calculators
Can QuoteCloud calculate freight?
Your own maths can. Build the calculator in a Spreadsheet block inside the quote with your rates: cartons per pallet, zone rates and drop fees. QuoteCloud doesn't fetch carrier rates or book freight; it runs the formulas you build.
How does a cell get into the price table?
Any cell can be connected to a price table line's description and unit price, so the freight line reads, for example, “Delivery: 2 pallets to Riverside” at $171.00. Quantities stay on the line as usual. The price table total can also be brought back into a cell.
Can Zapier fill in the cartons?
Yes. Zapier can write values into Spreadsheet block cells, so the carton counts from your website or order system can land in the Freight tab and the sheet recalculates. Writing cells through the API isn't confirmed; use Zapier.
Can we keep our costing away from the buyer?
Yes. Put the costing tab in a section set to Hide from Recipient: your team sees it in the editor, and the buyer sees only the line and its price. Product costs in the catalogue are hidden from buyers too.
Which plan includes the Spreadsheet block?
The Spreadsheet block is on Essentials and up, with price tables, the product catalogue and Zapier. It supports formulas such as SUM, ROUNDUP, IF and XLOOKUP, several tabs and .xlsx import.
More of QuoteCloud for wholesale and B2B
Each page shows one part of the job in a Tanbark document.
-
Volume quotes from a website enquiryA bulk-buy enquiry from your website becomes a priced quote with pack sizes, carton quantities and freight, ready for your rep to check.Explore
-
Quotes and sales orders from an AI assistant (MCP)Your website or AI assistant, connected through QuoteCloud's MCP service, prepares the order at the account's pricing: a draft to review, or sent where you allow it.Explore
-
Sales orders signed and paid on signingAn order form the buyer completes: quantities they set, Order Now, a signature and a card payment or deposit through Stripe or PayPal.Explore
- Repeat orders on account pricingLast month's order duplicated, quantities adjusted by the buyer, agreed prices kept, signed in a minute.
- Account-specific price listsOne catalogue, each trade account's agreed discount on the line, costs and margins hidden from the buyer.
- Quantity breaks, bundles & discount approvalsProduct discounts and bundles on Business, break pricing the buyer can see, and big discounts sent for approval first.
- Trade account applicationsNew trade customers apply inside a document: business details, delivery and accounts contacts in form fields, your terms, their signature.
- Distributor & reseller agreementsTerritory, price list, minimums and terms in one agreement both directors sign, with an expiry date you can see coming.
- Product catalogue, CRM, accounting & order systemsYour price file imported by CSV, then QuoteCloud connected to your CRM, accounting and order systems the way each one really connects.
- Wholesale & sales templatesReal QuoteCloud product sales, price quote, sales quote, distributor and customer registration templates.
- QuoteCloud implementation for wholesalersCatalogue and account pricing loaded, order templates built, your website or assistant connected, and the sales desk trained.
- FAQAnswers to the questions wholesalers, distributors and B2B online stores ask most.
Put your freight maths in the quote
Start free for 14 days with your own catalogue and order template. No credit card required.