Costco Membership Upgrade Calculator
Executive or Gold Star? The Executive tier costs $65 more a year and pays a reward of about 2% on pre-tax eligible merchandise, capped at $1,250. Put in what you actually spend at the till, and this works out whether the reward beats the fee for you.
Net benefit as your spending changes
Reward minus the extra fee, per year, across a range of monthly till spends at your province and cart mix. The curve crosses zero at your break-even, and flattens once the reward hits its annual cap.
The dollar walk-through
Till spend, then the tax backed out, then the reward base, then 2%, then the fee difference.
Break-even cheat sheet
| Eligible spend / yr | 2% reward | vs extra fee | vs full fee |
|---|
vs extra fee is the reward against the $65 upgrade gap; vs full fee is it against the entire Executive fee, the point where the membership has paid for itself. Both include the sales tax charged on the fee itself at your province's rate, and positive means the reward has covered that bar. Highlighted rows are the two break-even points and the spend where the reward hits its annual cap.
What earns the 2%, and what does not
Straight from Costco's Annual 2% Reward terms and exclusions list. Gas, prescriptions and the food court are the big ones people assume count, and they do not, so leave them out of the spend you enter above.
Earns the reward
Earns nothing
How this is calculated
The comparison
Gold Star costs $65 a year and Executive costs $130, so the upgrade has to earn back a $65 fee difference. Executive pays an annual reward of approximately 2% on eligible merchandise, and Costco caps the calculation of that reward at $1,250 in any 12-month period. Membership fees are themselves taxable, so the bar the reward has to clear is that $65 gap plus the sales tax charged on it in your province. The headline number is net benefit = reward − (Executive fee − Gold Star fee) × (1 + fee tax rate).
Why the tax comes out first
Costco's terms say the reward is calculated on pre-tax purchases, and that taxes, levies, deposits and miscellaneous fees are excluded. Your till total is not pre-tax, so the calculator converts it. Basic groceries are zero-rated for GST/HST across Canada, so that share of the cart carries no tax and passes through untouched. The rest is grossed up by your province's combined rate, so it is divided back down: reward base = grocery share × spend + (1 − grocery share) × spend ÷ (1 + combined rate). Then annual reward = min(2% × base × 12, $1,250).
The pre-tax rule
If you already know your pre-tax spend, tick "I entered pre-tax amounts". That switches the back-out off completely: the number you type is used as the reward base as it stands, the province and grocery share stop affecting the result, and break-even becomes the tax-included fee difference divided by 2%, then by 12 (in Ontario that is $73.45 ÷ 2% ÷ 12 = $306.04 a month). At the till you always need more than that, because tax is stripped out before the 2% is applied.
Break-even and the cap ceiling
Break-even solves net benefit = 0 for your own province and cart mix, so it moves when either changes: an all-grocery cart in Alberta breaks even sooner than an all-taxable cart in Quebec. The cap ceiling is the monthly spend where 2% × base × 12 first reaches $1,250, about $62,500 of eligible pre-tax spend a year. Above it, more spending adds nothing.
What the reward actually is
It is not cash back. The reward arrives as an annual coupon mailed to the Primary member with the renewal notice, roughly two months before the membership expires, and covers purchases up to about three months before renewal (later purchases roll into next year's coupon). It can be redeemed only by the Primary member, only on merchandise at the front-end registers of Costco warehouses in Canada, and never for cash. Upgrading mid-year is prorated by the months left on your current membership, and earning starts as soon as the upgrade is paid.
What earns nothing
Costco's exclusion list is long, and none of it is modelled here: gas, all tobacco, the food court, prescription drugs, all Costco Services (including auto), gift certificates and Shop Cards, membership fees, taxes and levies, bottle deposits, eye exams, tire and oil disposal fees, delivery and administration charges, charitable donations, third-party insurance, stamps, and environmental fees. Liquid milk and cream are excluded in Quebec and Nova Scotia, and all pharmacy and optical items are excluded in Quebec. If a chunk of your monthly total is gas or prescriptions, enter only the merchandise part.
What this does not model
Executive-only coupons and member perks (real, but they vary by month and by member, so putting a number on them would be invented). The exact prorated refund if you downgrade mid-year: Costco's Canadian pages state that a member who downgrades or takes a refund does not receive a Reward, but they do not publish a refund formula, so no credit for that is applied here. Whether Instacart, Uber Eats, Same-Day or Business Centre orders earn the reward, which Costco's Canadian pages do not settle. And PST food edge cases: snack foods, carbonated and sweetened drinks and prepared food are taxed, and BC, Saskatchewan and Manitoba each draw that line differently, so treat the grocery share as your own estimate rather than a receipt-accurate split.
Sources and dates
Fees, the 2% rate, the $1,250 cap, the exclusion list and the coupon rules come from costco.ca Executive Rewards, costco.ca Membership Conditions and Regulations and the Costco Canada Membership FAQ, read on August 21, 2026. Sales-tax rates are the 2026 combined GST/HST/PST/QST rates by province, including Nova Scotia's cut to 14% on April 1, 2025; grocery zero-rating follows CRA Memorandum 4-3, Basic Groceries. This calculator is not affiliated with or endorsed by Costco Wholesale.
Common questions
Is the Costco 2% Executive reward calculated before or after tax?
Before tax. Costco's Canadian terms say the Reward is approximately 2% of pre-tax purchases of most merchandise, and that miscellaneous fees, deposits and taxes, including applicable sales tax and GST, are excluded from the calculation. That is why this calculator backs the sales tax out of your till total first: basic groceries are zero-rated so no tax comes off that share, and the taxable rest is divided by 1 plus your province's combined rate.
What is the cap on the Costco Executive 2% reward in Canada?
Costco caps the calculation of a Reward at $1,250 for any 12-month period. Because the cap is on the reward and not on the spend, it is reached at roughly $62,500 of eligible pre-tax purchases in a year. Spending beyond that earns nothing more, which is what the cap ceiling figure in this calculator shows.
Can you cash out the Costco Executive reward?
No. The reward arrives as an annual coupon mailed to the Primary member with the renewal notice, about two months before the membership expires, and Costco's FAQ says the Reward coupon cannot be redeemed for cash. It can only be used by the Primary member on merchandise at the front-end registers of Costco warehouses in Canada, not on Costco.ca, at gas stations, at the food court, at the pharmacy, or for services.
How much do you need to spend for Costco Executive to be worth it?
There are two bars, and both include the sales tax Costco charges on the membership fee itself. To cover the $65 upgrade gap in Ontario ($73.45 with 13% HST) you need about $3,673 of eligible pre-tax spend a year, roughly $306 a month, or about $325 a month at the till once tax is stripped out of a half-grocery cart. To make the reward pay for the entire $130 Executive fee ($146.90 with HST) you need about $7,345 of eligible pre-tax spend a year, roughly $612 a month. Both bars are lower in Alberta and higher in Quebec, and the calculator solves them for your own province and cart.