
What it does
A USD sale can look great until you convert it, pay the marketplace fee on item plus shipping, cover the label, and allow for the occasional return. This calculator lines all of that up for every product or order scenario and shows what's left — net contribution and margin — in the reporting currency you choose. You set one clearly labelled exchange rate (always 1 USD = x CAD, with the reverse rate shown so you can't enter it backwards). Each product can have its own sale currency, product-cost currency and fulfilment currency. Fees are grouped into profiles (for example, a marketplace, your own web store, wholesale), each with % and fixed fees on a fee base you pick: item price, item + shipping, or order total including sales tax.
- Reporting currency (CAD or USD) and one exchange rate with an explicit conversion convention
- 8 fee profiles and 24 fee lines, each with a % rate, a defined fee base and optional fixed fee
- Up to 30 products or order scenarios with separate sale, cost and fulfilment currencies
- Packaging, shipping you pay, duties (% you enter) and brokerage
- Sales tax collected shown as pass-through, separate from revenue
- Returns allowance with stated assumptions
- Net contribution, margin, break-even price and target-margin price per row
- Dashboard with loss-making and below-target counts and two charts
- Exchange-rate and shipping-cost sensitivity for any row
What's inside
Workbook tabs: Start Here · Settings · Fees · Products · Results · Dashboard · Sensitivity. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- Canadian makers and small sellers shipping to U.S. buyers, U.S. sellers buying from Canadian suppliers, and anyone quoting or selling in both CAD and USD.
Frequently asked questions
Does it look up the exchange rate?
No. You type it in (for example from your bank or the Bank of Canada) and note the date. That keeps results stable and transparent.
Does it calculate duties or GST/HST?
No. You enter the duty rate and sales tax % that apply to you. Confirm with the CBSA, U.S. CBP or your tax adviser.
Can I use real Etsy, Shopify or Amazon fees?
Yes. The sample fee sets are illustrative; replace them with your platform's current published fees.
Does it work in Google Sheets?
It hasn't been tested there yet. It's built for Microsoft Excel.
You might also like

Contractor Quote & Bid Pricing Planner
Cost a job line by line, set your price by target margin or markup, see your break-even and discount limit, and print a clean quote for your client. Excel template with a worked example.

Self-Employed Bookkeeping Spreadsheet
Your T2125 and GST/HST return, organized as you go.

Subscription & Vendor Renewal Audit Kit
One register for every subscription and vendor contract: annualized cost, cost per active user, unused seats, price increases, overlaps and cancellation deadlines, with potential vs realized savings. Excel template with a worked example.