Each month I reconcile our conversions. I take our completed (not canceled) order id's and compare against order id's from affiliate networks. It's a little time consuming but for less than an hour work per month and a few queries in my Access database, we save over $500 in commissions on orders that didn't complete.

I'd like to also compare coupon data and recommendation services driven orders by order id. Are there any good tools or services available to reconcile sales and advertising costs?