How to Build a Cost Sheet for an Import Business

You've found a supplier on Alibaba offering a product at $2.50 per unit. You do the math: 1,000 units × $2.50 = $2,500. That's your cost, right? Wrong. By the time that container lands in Lagos, Nairobi, or Accra, you'll have spent closer to $4,000–$5,000. If you don't build a proper cost sheet for your import business, you'll either price yourself out of the market or discover your 'profit' was actually a loss. This guide walks you through every line item, with real numbers, so you can price with confidence and avoid the surprises that sink first-time importers.

What Is a Cost Sheet and Why You Need One

A cost sheet is a complete breakdown of every cost involved in getting your product from the factory in China to your warehouse or store. It's not just the unit price — it's the sum of product cost, freight, insurance, duties, taxes, inspections, bank fees, and any local handling. Without it, you're guessing. With it, you can set a selling price that covers all expenses and leaves a real margin.

For example, a $2.50 unit cost might become $4.20 landed cost after freight and duties. If you sell at $6.00, you think you're making $3.50 profit, but you're actually making $1.80. That difference is your entire business. A cost sheet forces you to see the real number before you commit.

It prevents underpricing and hidden losses.
It helps you compare suppliers accurately — the cheapest unit price is rarely the cheapest landed cost.
It gives you data to negotiate with freight forwarders and suppliers.
It's essential for calculating customs value and avoiding under-declaration penalties.
It builds a baseline for future orders — once you have a template, updating it takes minutes.

The 7 Cost Categories You Must Include

Every import cost falls into one of seven buckets. Miss any, and your cost sheet is wrong. Here's what they are, with typical ranges based on importing from China to African markets like Nigeria, Kenya, Ghana, or South Africa.

1. Product Cost (Ex-Works or FOB)

This is the price you pay the factory, usually quoted as Ex-Works (EXW) or Free On Board (FOB). EXW means you pick up from the factory; FOB includes factory-to-port and loading costs in China. For first orders, get FOB quotes — it's simpler. Typical FOB prices for consumer goods range from $1 to $50 per unit depending on product. Always ask for a detailed quotation that includes packaging, not just the unit price.

Get quotes from at least 3 suppliers for the same product.
Specify FOB (e.g., FOB Shenzhen or FOB Ningbo) to avoid surprises.
Ask about MOQ (minimum order quantity) — it affects per-unit cost.
Include sample costs — usually $20–$50 per sample, plus shipping ($30–$60).

2. Freight and Logistics

Sea freight is the most common for bulk imports. A 20-foot container from China to Mombasa or Lagos costs $2,500–$4,500 depending on season and port. A 40-foot container is $4,000–$7,000. Air freight is faster but costs $4–$8 per kg — only for high-value, low-weight items. Your freight forwarder will quote you a door-to-door rate or a port-to-port rate. Use a reliable forwarder; don't just pick the cheapest on Google.

Get quotes from 3 forwarders (e.g., Flexport, DHL, or local forwarders like ASL in Kenya).
Ask for a breakdown: ocean freight, origin handling, destination handling, and customs clearance.
Budget $200–$400 for local trucking from the port to your warehouse.
Consider consolidation — if you're not filling a container, use LCL (less than container load) and pay per cubic meter.

3. Insurance

Insurance is often overlooked, but it's cheap compared to the cost of losing a shipment. Marine cargo insurance typically costs 0.3%–0.5% of the invoice value. For a $10,000 shipment, that's $30–$50. Some forwarders include it; others don't. Always get it — a container lost at sea or damaged in transit without insurance is a total loss.

Ask your forwarder for insurance options or buy directly from a provider like Marsh or Aon.
Confirm the coverage includes 'warehouse-to-warehouse' — not just port-to-port.
Keep a copy of the insurance certificate with your shipping documents.

4. Customs Duties and Taxes

Every country has its own tariff rates. In Nigeria, for example, import duties can range from 5% to 35% depending on the product, plus VAT at 7.5%. In Kenya, import duty is typically 25% for many goods, plus 16% VAT and a 3.5% IDF (Import Declaration Fee). Use a customs broker or check your country's tariff schedule online. Don't guess — under-declaring can lead to fines or seizure.

Use a licensed customs broker — fees are $150–$300 per shipment.
Check the HS code for your product — it determines the duty rate.
Budget 20%–40% of your CIF value (cost + insurance + freight) for duties and taxes in many African countries.
Ask your broker for a proforma calculation before shipping.

5. Inspection and Compliance

If your product needs to meet safety standards or you want to verify quality before shipping, inspections are essential. A pre-shipment inspection by a third-party company like QIMA, SGS, or Bureau Veritas costs $200–$500 per inspection, depending on the product and location. For electronics, you may need additional certifications like CE or FCC, which cost $500–$2,000. Skipping inspection can cost you a full container of defective goods.

For first orders, always do a pre-shipment inspection — it's worth the $300.
Use a company with local inspectors in China (QIMA, SGS, or Intertek).
Specify your quality standards clearly in the inspection checklist.
If you're importing food or cosmetics, budget for lab testing — $100–$400 per test.

6. Payment and Banking Fees

Transferring money to China isn't free. Bank wire fees are typically $30–$50 per transfer, and the exchange rate can cost you 1%–3% if you're not careful. Use services like Wise (formerly TransferWise) or Payoneer for better rates, but confirm your supplier accepts them. Also, expect to pay a deposit of 30%–50% upfront for first orders; some suppliers require 100% for custom goods.

Compare exchange rates and fees between your bank and Wise or Payoneer.
Add 2%–3% to your cost sheet for currency fluctuation.
For large orders, use a letter of credit (LC) — but note banks charge $200–$500 for LC processing.
Never pay the full amount before production starts — a 30% deposit is standard.

7. Local Delivery and Warehousing

Once your goods clear customs, you need to move them from the port to your warehouse or store. This includes trucking fees, warehousing costs if you don't have your own space, and possibly distribution costs. These are often overlooked but can add 5%–10% to your landed cost.

Trucking from port to warehouse: $100–$300 depending on distance.
Warehouse rental: $50–$200 per month for a small space in most African cities.
If you're using a third-party logistics (3PL) provider, budget $0.50–$1.00 per unit for storage and picking.
Include last-mile delivery costs if you're selling online — $1–$3 per order.

How to Build Your Cost Sheet: Step-by-Step

Now that you know the categories, here's how to put them together. Use a spreadsheet (Excel or Google Sheets) — it's free and easy to update. Create columns for each cost category and rows for each product or order. Then follow these steps.

List your product and order quantity (e.g., 1,000 units of LED lights).
Enter the FOB unit price from your supplier (e.g., $3.50).
Calculate the total product cost (1,000 × $3.50 = $3,500).
Add freight: get a quote from your forwarder (e.g., $2,000 for a 20ft container).
Add insurance: 0.4% of the CIF value (product + freight = $5,500; insurance = $22).
Add duties and taxes: estimate 25% of CIF (CIF = $5,522; duties = $1,380).
Add inspection, banking, and local delivery costs (e.g., $300 inspection + $40 bank fees + $150 trucking = $490).
Sum all costs to get your total landed cost (e.g., $5,500 + $22 + $1,380 + $490 = $7,392).
Divide by quantity to get your landed cost per unit (e.g., $7,392 ÷ 1,000 = $7.39).

That $7.39 is your break-even price. If you sell below that, you lose money. Your selling price should be at least 2–3 times your landed cost for a sustainable margin, depending on your market. For example, if your landed cost is $7.39, aim to sell at $15–$22 to cover marketing, overheads, and profit.

Tools and Templates to Make It Easy

You don't need expensive software — a simple spreadsheet works. But there are tools that can save you time and reduce errors.

Google Sheets: free, cloud-based, and easy to share with your accountant or partner.
Excel: more advanced formulas and templates available online.
Alibaba's Freight Calculator: gives rough shipping estimates for sea and air.
Freightos.com: compare freight rates from multiple forwarders.
Customs duty calculators: many African customs websites offer free online tools (e.g., Kenya's iCMS).
For a ready-made template, search 'import cost sheet template' on Google — many are free.

If you're importing regularly, consider investing in a simple inventory management system like Zoho Inventory or TradeGecko (now QuickBooks Commerce) that can track costs and margins automatically. But for your first few orders, a spreadsheet is more than enough.

Common Mistakes to Avoid

Even experienced importers slip up. Here are the most common mistakes I see with cost sheets — and how to avoid them.

Forgetting to include 'hidden' fees like port handling, container deposit, or demurrage — these can add $200–$500. Always ask your forwarder for a full list of charges.
Using the wrong exchange rate — if you quote at a rate from last month, you could lose 2%–3%. Use today's rate and add a buffer.
Not recalculating for currency fluctuations — if the dollar strengthens, your costs rise. Add a 2% contingency.
Underestimating duties — many products have duties above 30% in Africa. Check with a broker before you order.
Skipping inspection to save $300 — then receiving a container of defective goods. That mistake costs thousands.
Pricing based on product cost alone — forgetting that freight, duties, and fees eat into your margin. Always use landed cost.

Conclusion and Next Steps

Building a cost sheet isn't optional — it's the foundation of a profitable import business. The key takeaways: include all seven cost categories, use real numbers (not guesses), and update your sheet every time you order. Start by creating a simple spreadsheet with the steps above. Then, before you place your next order, fill it in completely. If your landed cost per unit is higher than you expected, renegotiate with your supplier or adjust your selling price. Don't skip this step — it's the difference between building a business and just keeping busy.