Match discounts to purchases

If you simply want to view all the discounts that are applied to your Amazon purchase total, check out the

Amazon discount view⁠

Amazon’s invoices often show the full price of each purchased item, followed by a list of all the “Deal of the Day”, “Coupon Savings” and other discounts applied to your purchase—without any way of seeing which discounts were applied to which purchases. (That’s why the

5. Declare to CBSA⁠

totals just subtract the total value of all deals from the total value of all non-food purchases.)

If you want to match a discount to the specific item it applied to, you can do that manually using this view. (You’ll probably have to do this from memory, but you might find it helpful to look at historical prices for your purchased items on camelcamelcamel.com.) For any invoice where there was only once purchased item, it will be easy for you to match savings to the item purchased.

How to use this view

This view shows any invoice that included discount line items.

All transactions are grouped by invoice so that you can see the discount rows right below the specific items they may have applied to.

To match a discount to the item it was applied to...

Copy the ”price per item” (highlighted in blue) from the discount row

Paste that price into the “matched discount” column (highlighted in green) for the item that discount applied to

Once you have matched a discount to a line item...

The Discount row will turn dark red so that you don’t accidentally apply to additional line items, and the “Discount matched” checkbox will show as checked.

The Discount row will recognize that you’ve applied the discount to a specific item, and it will automatically update the “Total cost” in the Discount row to zero, so that the discount is only applied once in views like the

5. Declare to CBSA⁠

category totals.

Transaction date range:

May 8 - August 6, 2024

⁠

Include transactions from:

All

⁠

Match discounts to purchases

Match discounts to purchases

Order No.

View invoice

Purchased item

Order date

Cost

Quantity

Total cost

Matched discount

Which Amazon?

Discount matched?

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.