The lowest advertised price is not always the lowest cost. This worksheet shows how to compare marketplace offers by adding item price, shipping, tax or VAT, visible fees, discounts, and a realistic allowance for return risk. Use the comparison table for two to five offers, then save it so you can revisit the decision if the price, delivery option, or marketplace policy changes.
Overview
Total landed cost is the amount you expect to spend to receive an item, adjusted for costs that may arise if the purchase goes wrong. It is more useful than comparing listing prices alone because marketplaces can present the same product with different shipping charges, coupons, taxes, service fees, seller conditions, or return arrangements.
A simple comparison should answer four questions:
- What will I pay at checkout?
- What will I receive, and when will it arrive?
- What costs are refundable if I cancel or return it?
- Is the cheaper offer worth any additional seller, condition, or delivery risk?
For a basic purchase, use this formula:
Estimated total cost = item price + shipping + tax or VAT + buyer-visible fees − discounts
For a higher-value, used, fragile, or condition-sensitive purchase, add an optional risk allowance:
Decision cost = estimated total cost + estimated return or problem cost
The risk allowance is not a guaranteed charge. It is a planning tool that helps prevent a small price advantage from outweighing an inconvenient return, non-refundable delivery charge, inspection cost, or disputed refund. For guidance on assessing the seller behind each offer, see our seller ratings trust scorecard.
How to estimate total landed cost
Compare matching offers rather than simply copying the first visible price. Confirm the exact model, size, quantity, condition, included accessories, warranty, and seller location before entering figures.
- Record the item price. Enter the current price for the exact listing. If the marketplace displays a range, open the listing and use the price for the version you would actually buy.
- Add the delivery option you would choose. Record standard, expedited, pickup, or international shipping separately. Include per-item shipping and any additional delivery charge shown at checkout.
- Estimate tax or VAT. Use the amount shown at checkout when available. If it is not shown, mark the figure as an estimate and note which rate or rule you used. Do not treat a tax estimate as final if the marketplace calculates it only after entering a delivery address.
- Enter buyer-visible fees. Include service, processing, handling, import, authentication, or other charges that the buyer is required to pay. Do not add a seller fee unless the marketplace explicitly passes it to the buyer.
- Subtract discounts that actually apply. Enter a valid coupon, automatic promotion, credit, or cashback amount only if you meet its conditions. For cashback, consider recording it in a separate column because it may arrive later and may have eligibility or redemption requirements.
- Check the return and refund terms. Note the return window, who pays return shipping, whether original shipping is refundable, and whether the listing has special exclusions. These details help you estimate the cost of a problem, not just the cost of a successful delivery.
- Compare the result with the delivery and seller evidence. A small saving may not justify materially weaker seller ratings, unclear condition details, a short return period, or delivery uncertainty. Price comparison works best when price and trust signals are reviewed together.
For a broader check of the advertised price, pair this worksheet with a marketplace price history review. A discount is easier to judge when you know whether the current price is unusual or simply presented as a temporary promotion.
Inputs and assumptions
Use the following reusable table in a spreadsheet, notes app, or printed worksheet. Keep the marketplace and seller names visible so you can return to the original listing later.
| Input | Offer A | Offer B | Offer C | Notes |
|---|---|---|---|---|
| Marketplace and seller | Record seller name and listing URL | |||
| Exact item and condition | New, used, refurbished, open-box, or other | |||
| Item price | Match quantity and variant | |||
| Shipping | Record service and estimated delivery | |||
| Tax or VAT | Mark as confirmed or estimated | |||
| Buyer-visible fees | Include required checkout charges | |||
| Coupon or discount | Record conditions and expiry | |||
| Estimated total cost | Price + shipping + tax + fees − discount | |||
| Return or problem allowance | Optional planning estimate | |||
| Decision cost | Total cost + allowance | |||
| Seller and policy notes | Ratings, warranty, returns, delivery, condition |
Separate confirmed figures from assumptions. For example, label shipping as “confirmed at checkout” or “estimated from listing.” This prevents an uncertain number from appearing as precise as a final charge. If you are comparing currencies, convert all offers using the same method and note whether your card provider or payment service may apply a conversion charge.
For used, refurbished, or open-box items, add condition and warranty to the notes rather than treating them as minor details. A lower price may reflect missing accessories, cosmetic wear, limited coverage, or a different return process. These are reasons to compare value, not just arithmetic; the refurbished versus open-box comparison guide can help structure that review.
Worked examples
Consider three hypothetical offers for the same item. The figures below are examples for demonstrating the method, not current marketplace prices or fee rules.
| Cost component | Offer A | Offer B | Offer C |
|---|---|---|---|
| Item price | $82 | $77 | $86 |
| Shipping | $8 | $15 | $0 |
| Tax estimate | $7 | $7 | $8 |
| Buyer-visible fee | $3 | $4 | $2 |
| Coupon | -$5 | $0 | -$10 |
| Estimated total cost | $95 | $103 | $86 |
Offer B has the lowest item price, but it is not the cheapest delivered option. Offer C has the highest starting price and no shipping charge, yet its discount makes the estimated total lower. Before choosing C, check whether the coupon applies to the exact item, whether the condition matches, and whether the seller’s return terms are acceptable.
Now suppose Offer C has an uncertain return process while Offer A comes from a seller with clearer terms and a more suitable warranty. You might add a planning allowance to each offer based on your own tolerance and the likely cost of a return. For example, an allowance could include outbound shipping that is not refundable, return postage, packaging, inspection, or the time and effort required to resolve a problem. It should not be presented as a statistical probability unless you have reliable data; use it as a transparent decision assumption.
When offers are close, the result should prompt a qualitative check rather than a false sense of precision. Review seller trust signals, delivery promises, product authenticity indicators, and the marketplace return policy. For high-value purchases, use the more detailed process in how to compare sellers for expensive marketplace purchases.
When to recalculate
Recalculate immediately before purchase if the comparison was made earlier. Prices, inventory, coupons, shipping options, tax estimates, seller terms, and return policies can change independently. A saved worksheet is useful only when its inputs still describe the checkout you are about to complete.
Revisit the comparison when:
- the item price or promotion changes;
- a coupon expires, reaches a usage limit, or applies only to selected sellers;
- you switch shipping speed, delivery address, or fulfillment method;
- the marketplace adds or removes a buyer-visible fee;
- tax, VAT, import, or currency-conversion assumptions change;
- the seller, item condition, warranty, stock status, or estimated delivery changes;
- the return window or refund terms are updated; or
- you find a materially different offer through another marketplace or classifieds site.
As a practical routine, shortlist two to five matching offers, complete the table, verify the totals at checkout, and save the final figures with the date and listing links. Then choose the lowest decision cost that also meets your requirements for condition, delivery, seller reliability, and returns. This approach makes a marketplace price comparison repeatable and helps answer the question that matters most: not which listing looks cheapest, but where the purchase is most likely to cost the least overall.