Costco Membership Upgrade Calculator
The Executive tier costs $65 more a year and pays a reward of about 2% on pre-tax eligible merchandise, capped at $1,250. Enter your monthly till total and your province to see the reward, the fee difference with the sales tax on it, and the spend where the two cross.
What your reward pays for
Your estimated reward against the upgrade cost (the tick) and the full Executive fee (the end of the bar), both with tax: past the tick, the upgrade pays for itself.
Net benefit as your spending changes
Reward minus the extra fee with tax, per year, across a range of monthly till spends at your province and cart mix: red where Gold Star is cheaper, green past your break-even, and flat 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: 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.
Reading the two charts
What your reward pays for sets your estimated annual reward against both bars at once. The bar runs from $0 to the full Executive fee with your province's fee tax ($130 × 1.13 = $146.90 in Ontario), and the tick marks the upgrade's extra fee with tax ($65 × 1.13 = $73.45). Below the tick the bar is red and Gold Star is cheaper; past it the bar turns green and the upgrade pays for itself. A full bar means the reward covers the whole membership, and the dollar figure keeps counting past that point. Net benefit as your spending changes runs the same calculation as the headline at round monthly spends from $0 to about twice yours (at least $600, and always far enough to show your break-even). Below the cap the reward is a straight 2% of the reward base, so the net benefit is a straight line in spend and the chart joins the points with straight segments. It crosses the dashed Gold Star line (the $0 of not upgrading) exactly at your break-even, is shaded red where Gold Star is cheaper and green where Executive comes out ahead, and goes flat at $1,250 − the fee with tax ($1,176.55 in Ontario) once the reward hits its cap; when your range reaches the cap, a dashed line marks that ceiling. The CSV download includes every point on the chart.
What the reward is
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
Nothing on Costco's exclusion list above comes off your spend automatically. The calculator treats every dollar you enter as eligible, so 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.
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.