🎉 Black Friday: off every tracker · Or get all 8 for $49.99 → 🎉 Get all 8 spreadsheets for $49.99, save $109.93 vs buying separately →

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.

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

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.

⚠ Important: please readA planning tool for information only. It is not tax, legal, accounting, lending, investment or financial advice, and it doesn't replace a qualified professional. Results depend on the figures you enter; lenders, platforms and tax authorities apply their own rules. Check important decisions with a professional. Images show the real workbook with sample data.

You might also like