1099's for affiliates - or an easy way to search by affiliate?

[tarawagner]

I'm working on my 1099 forms and can't find a way in e-junkie to either:



a) get a list of total affiliate payouts (subtotaled by affiliate) to find those who have earned more than $600 last year



or



b) find any 1099 within e-junkie itself.



As this is a pretty standard need for tax purposes, I assumed it would be obvious. Can anyone tell me how I can search out and find which affiliates earned over $600?

[E-junkie_Guru]

This help page explains how to look up your history of affiliate commission earnings:

http://www.e-junkie.com/ej/trouble.affiliates.history.htm

[tarawagner]

So without a program like Microsoft Excel, I'd have to go through individually? And with the program, I'd still have to manually add up all transactions?



Can I recommend or request a change be made to make this simpler?

[E-junkie_Guru]

In a spreadsheet program like Excel, iWork Numbers, or (free) Gnumeric, you can Select All and then sort rows by the Affiliate ID column (so each affiliate's sales will be grouped in consecutive rows), then just select all the cells in the Affiliate Share column for a given affiliate, and the spreadsheet should show an instant sum of those cells somewhere, such as down in the status bar at the bottom.



For a different approach, you could just search your PayPal account history for all payments you've sent to each affiliate's PayPal Email in the past year, and sum up those amounts to see if the affiliate received more than $600 from you in that year.

[galeforce]

How do sellers typically handle collecting the tax information for the 1099s? -- the SSN, etc.

[E-junkie_Guru]

We were recently reminded that if you use PayPal to pay out commissions, PayPal should issue a 1099-K to any PayPal users who receive more than $600 through their service, and since PayPal is reporting that income for them already, you should not need to report it yourself as well.



If you're not using PayPal to pay out commissions, you would need to follow the methods I outlined above to determine which affiliates have earned over $600 from you last year, so you can email them to request they send you a Form W-9 disclosing their SSN, then you can file a form 1099-MISC to report the income you paid them.