A personal deal-tracker spreadsheet turns scattered prices, coupon codes, shipping fees, taxes, and return notes into one practical comparison. This guide provides a ready-to-copy template, simple formulas, a weekly workflow, and worked examples to help you choose the lowest total-cost retailer rather than the lowest advertised price.
Overview
Online shopping deals are easy to compare badly. One retailer may show a lower sale price, while another offers free shipping, a usable promo code, or a more flexible return policy. A deal tracker helps you evaluate the complete purchase before you check out.
The goal is not to record every coupon or daily deal you see. It is to create a repeatable decision sheet for products you genuinely plan to buy. Use one row for each retailer or listing, then compare the final estimated cost and the practical conditions attached to it.
You can build the sheet in Google Sheets, Excel, or another spreadsheet app. Create these columns in order:
- Product: Include the exact model, size, color, quantity, or pack count.
- Retailer: Record the store, marketplace seller, or local location.
- List price: The regular or displayed reference price, if shown.
- Sale price: The current price before coupons.
- Coupon or promo code: Include the code, offer description, and expiration date when available.
- Coupon discount: Enter the dollar amount or calculate the percentage discount.
- Shipping: Add the actual shipping charge, or mark it as conditional if the amount depends on cart value.
- Tax estimate: Use an estimate unless the checkout page provides the final amount.
- Estimated total: The amount used for the main comparison.
- Return notes: Record important conditions, such as final-sale status, marketplace seller rules, or return shipping responsibility.
- Checked on: Add the date and time of the last price check.
- Link: Save the product or offer page so you can verify it later.
For a reusable template, paste those column headings into the first row of a blank sheet. Add filters to the header row, freeze it while scrolling, and use a separate tab called “Rules and Sources” for retailer shipping thresholds, coupon-stacking notes, and links to trusted coupon sources.
How to estimate
Start by comparing equivalent items. A different size, quantity, bundle, warranty, or seller can make a price comparison misleading. Confirm the product details before entering a number.
A simple estimated-total formula is:
Estimated total = sale price − coupon discount + shipping + estimated tax
If your coupon is a percentage, calculate the discount from the price to which the code applies. For example, a 15% coupon on a $40 eligible subtotal produces a $6 discount, assuming the offer has no cap or exclusion. If the coupon has a maximum discount, minimum spend, brand restriction, or one-time-use condition, record that in the notes rather than assuming it will apply.
In a spreadsheet, suppose sale price is in column D, coupon discount is in column F, shipping is in column G, and tax estimate is in column H. The estimated total in column I could use:
=D2-F2+G2+H2
For a percentage coupon, you might calculate the discount in column F with a formula such as =D2*15%. Replace the percentage with the actual offer and adjust the formula if the coupon applies only to selected items. Do not subtract a coupon twice: once as a discount and again by entering a reduced sale price.
When you do not know the final tax, use a clearly labeled estimate. One basic approach is:
Estimated tax = taxable subtotal × assumed tax rate
Tax rules can vary by location, product type, retailer, and shipping treatment. Treat the result as a planning number and replace it with the checkout total before buying. If the difference between two retailers is small, the retailer showing the final checkout total should receive more weight than a rough estimate.
For a more useful comparison, add two optional fields: effective savings and confidence. Effective savings can be measured against the lowest comparable regular price, while confidence can be marked high, medium, or low depending on whether shipping, tax, inventory, and coupon eligibility have been confirmed.
Inputs and assumptions
A spreadsheet is only as reliable as its inputs. Capture the details that commonly change between the product page and checkout.
Coupon and promo-code assumptions
Record whether the offer is a verified coupon code, an automatic promotion, a new-customer offer, a loyalty benefit, or a credit-card-linked discount. Note whether it can be combined with free shipping, cashback, another coupon, or a sale price. Retailer rules change, so do not treat a code found on an old page as guaranteed to work.
If a code fails, check the expiration date, minimum purchase, eligible products, account requirements, seller restrictions, and exclusions. The promo code troubleshooting guide can help you isolate the reason before removing a valid discount from your comparison.
Shipping and tax assumptions
Enter shipping based on the cart you actually intend to purchase. A free-shipping threshold may require adding an item that you do not need, which is not automatically a saving. If you include such a threshold, record the extra item and its cost separately.
For local store deals, include travel or pickup costs only when they materially affect the decision. Also record whether pickup inventory was confirmed. For online marketplace listings, compare the seller, fulfillment method, delivery estimate, and return terms—not just the displayed price.
Value and return assumptions
The lowest numerical total is not always the lowest-cost choice if the item is the wrong size, arrives too late, or has restrictive return conditions. Use the return-notes column for final-sale warnings, restocking charges, return windows, and whether return shipping is paid by the shopper. These notes do not need to be converted into a dollar value to improve the decision.
For categories with different package sizes, add unit price as another column. The unit price shopping guide explains how to compare groceries, household goods, and bulk packs without mistaking a larger package for a better deal.
Worked examples
Assume you are comparing the same item from three retailers. The figures below are illustrative inputs, not current offers.
| Retailer | Sale price | Coupon | Shipping | Tax estimate | Estimated total |
|---|---|---|---|---|---|
| Retailer A | $52.00 | $5.00 | $7.00 | $4.32 | $58.32 |
| Retailer B | $55.00 | $0.00 | $0.00 | $4.40 | $59.40 |
| Retailer C | $49.00 | $2.00 | $9.00 | $4.23 | $60.23 |
Retailer C has the lowest advertised sale price, but Retailer A has the lowest estimated checkout total. Retailer B is close enough that its return policy, delivery timing, or product availability could affect the final decision. Before purchasing, open each retailer’s checkout and replace the estimates with confirmed shipping, tax, and coupon results.
For a more complex example, suppose a free-shipping coupon cannot be combined with a percentage promo code. Add two scenarios for the same retailer: one row for the percentage code plus paid shipping, and another for free shipping without the percentage code. The spreadsheet should compare both scenarios rather than assuming every offer can be stacked. For additional guidance, see how to stack coupons, cashback, and free shipping.
Use the same method for electronics, seasonal purchases, clearance deals, and local store offers. For electronics, capture model numbers and included accessories; a lower price for a different configuration is not a like-for-like bargain. You can also use the electronics comparison checklist alongside the spreadsheet.
When to recalculate
Recalculate immediately before buying and whenever one of the important inputs changes. Prices, inventory, shipping thresholds, coupon eligibility, and estimated tax can all change between the first search and checkout.
Use this weekly workflow:
- Review products you expect to buy in the next few weeks.
- Check current prices across the retailers in your sheet.
- Test or verify relevant coupon codes without assuming older codes still work.
- Update shipping, tax, stock status, return notes, and the checked-on date.
- Sort by estimated total, then review confidence and return conditions.
- Check price history or a sale calendar before deciding whether to buy or wait.
Refresh retailer coupon-stacking rules, typical shipping thresholds, tax-estimate assumptions, and trusted coupon-source links at least quarterly. Refresh example rows and retailer notes monthly. Before major shopping periods such as back-to-school, Black Friday, or other retailer-specific sale events, review the sheet early and update expected timing without treating a predicted sale as guaranteed.
Finally, set a personal buying rule. For example: buy when the confirmed total is below your target, the item is needed within the required time, and the return terms are acceptable; otherwise, add a price-drop alert and revisit the row later. A deal-alert workflow can reduce the need for constant manual checking. The spreadsheet then becomes more than a record of deals: it becomes a consistent way to compare total cost, document assumptions, and make calmer shopping decisions.