Jan 2013
2 / 6
Jan 2013
Feb 2013
tarawagner
Jan '13

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?

  • created

    Jan '13

  • last reply

    Feb '13
  • 5

    replies

  • 2.0k

    views

  • 3

    users

  • 1

    link

tarawagner
Jan '13

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_GuruWebmaster & Support Guru
Jan '13

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.

1 month later
galeforce
Feb '13

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

E-junkie_GuruWebmaster & Support Guru
Feb '13

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.