Web: as a funder, i want the abililty to issue 1099s for the work i've had done on the platform, because tax compliance

[owocki]

User Story

as a funder, i want the abililty to issue 1099s for the work i've had done on the platform, becasue tax compliance.

Why Is this Needed

Summary:

• the last 2 years we've relied on consensys finance to issue these. after we spin out, we won't be able to rely on them.
• as we move more into enterprise funders, this will be a requirement.
• lets get ahead of this now.

Description

Type:
feature

Current Behavior

no tax year report

Expected Behavior

• in /settings/ a user should be able to set their location. this dropdown will be prepopulated with the LAST geolocation they logged in with (check out theirUserAction` Login events to build this)
• on January 15th of every year a management command will run. this management command will generate
• a CSV of every counter-party that the funder has worked with last year (Bounties, Tips, Grants all inclusive), including the following columns: date, counter-party name, counter party location (country), amount, token name, value in USD at time of transaction.
• a 1099 for any US based workers who have earned > $600 that year on the platform.
• if user has not worked with any counter parties as a funder the mgmt command will not take any action for that user.
• if the user HAS worked with counter parties as a funder, the mgmt command will send an email to them with two links: a link to the CSV generated in (1), a zip of all the 1099s for any US-based counter parties.

email copy:

Subject: Your {year} Gitcoin Tax Report:
Hi @{username},

In {year}, you did {num} transactions worth ${amount}.   This email is to help you prepare your taxes in your local jurisdiction.  

[Click to download CSV activity report]
[Click to download 1099s (US-Based Funders only)] <======== only if there are 1099s available

Definition of Done

Data Requirements

Additional Information

[owocki]

@PixelantDesign i wrote this up after yesterday when we saw that legal/compliance was important for the funder we were interviewing. any feedback?

cc @ceresstation who has asked me for this in the past too.

im thinking ill bounty this so it doesnt have to affect the core devs.

[kuhnchris]

well, I offered to work on it - you need to watch out a little bit here, especially since we're tipping our toes into legal jinx here...

[PixelantDesign]

Questions from @PumpkingWok who is interested in this bounty @owocki

1) in which /settings section do i have to include the field to set a location ?
2) does the command to generate the csv (once a year) has to develop outside the gitcoin platform code, right ?
3) can i exploit the gitcoin python client to retrieve infos from setting ?
4) do i have to develop a new API command to retrieve it or it is already implemented ?
5) is there already a service i mean to generate a custom email to send, on gitcoin backend side ?

[owocki]

1. creating a new settings/tax seems the most clean to me
2. no, you can do it as a management command, and schedule it in the crontab file
3. which gitcoin python client?
4. just use the django ORM. no new API needed IMHO
5. yes, there is precedent for management commands generating emails. just copy a send_* function from marketing/mails.py and a render_* function from retail/emails.py . you can also copy an email template that is referenced in the render_* to generate a new email template. note: one fun little hack to test emails is to put htem in urls.py ( like here https://github.com/gitcoinco/web/blob/master/app/app/urls.py#L364-L452 ) so you can preview them in browser.

[PumpkingWok]

Hi there,
Thanks a lot for the reply @owocki , I could start on it from tomorrow if it is still free.
Hi @kuhnchris have you started to develop something regard it ? I can leave it to you without problems !! Let me know.

[kuhnchris]

@PumpkingWok haven't worked on it yet - if you got spare time to fill - go ahead. :-)

[PumpkingWok]

Hi @owocki,
I'm going to start it this afternoon.
Thanks in advance.

[owocki]

great

On Fri, Aug 2, 2019 at 7:57 AM andrea zuccarini [e-mail]
wrote:

Hi @owocki https://github.com/owocki,
I'm going to start it this afternoon.
Thanks in advance.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/gitcoinco/web/issues/4806?email_source=notifications&email_token=AAD5PCODITS6EJHMBZ2L4NLQCQ4MRA5CNFSM4IERX3XKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3N2GIQ#issuecomment-517710626,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAD5PCIQ234ZWIOPRZVSSILQCQ4MRANCNFSM4IERX3XA
.

--

@owocki http://www.twitter.com/owocki

---

check out what i'm building on github http://github.com/owocki

or what i'm shooting on photoshelter http://photography.owocki.com/

or find me on twitter http://www.twitter.com/owocki, facebook
http://www.facebook.com/kevinowocki, instagram
http://instagram.com/owocki, linkedin http://www.linkedin.com/in/owocki,
and owocki.com http://www.owocki.com/?utm_source=emailsig.

see you around teh internets!

PS -- Come to the next Boulder Blockchain
https://www.meetup.com/Boulder-Blockchain/ meetup. Be there or be ^ 2.
PPS -- Have I mentioned that Gitcoin is live? More @ https://gitcoin.co

[kuhnchris]

Related: #866
@PumpkingWok any news - you already made progress on this? :-)

[PumpkingWok]

Hi @kuhnchris ,
How is doing ? I'm starting it today at the end, unfortunately i have issue with my laptop and i'm changing it.

[kuhnchris]

Hi there - thanks, I'm doing fine. It's no problem, just wanted to make sure we have a current state - if you are starting today it's fine, take your time and let us know if you have any problems. :-)

Thanks,
Chris

[kuhnchris]

@PumpkingWok got any updates on this for us? Thanks!

[PumpkingWok]

Hi @kuhnchris ,
How is doing ? Unfortunately in these days i was very busy, i'm going to open a WIP PR in max 2 days, so you can start to look into the code if you have time, and in max 5/6 days i will conclude the issue.Sorry again.

[kuhnchris]

Hey there - no problem I just need to know the status since I need to keep the team in the loop - tax time is coming soon, hence we are already excited about the change. If you happen to throw in a PR in 2 days that's absolutly OK, if you keep getting stuck let me know ;-)

Thanks,
Chris

[PumpkingWok]

Hi @kuhnchris,
I would like to ask you a question if you can help me.
I have created a new settings/tax, would you like that it is populated with the last location saved in LOGIN action events, right ? but after that if i want edit my location i should create a new field (location) in Profile model, is it ok for you ? In this way it would be prepopulated only until a user edits and saves a location.
Does it make sense for you ?

[kuhnchris]

That's be OK for me, you can continue working on this like that.

@owocki any complaints about that?

[owocki]

that makes sense to me

[PumpkingWok]

Hi there,
I'm going to open a WIP PR tomorrow, so we can look together into the code, just to understand if for you it makes sense.

[PumpkingWok]

Hi @owocki,
I would like to ask you few questions regard the part of csv creation and email sending.
1) Does the csv file has to be created for every funder with at least one work funded in the last year, right ? with the info for every counter-party that the funder has worked in. Other than the columns that you proposed on issue description i could add a worker_type column for instance to identify the type of work (bounty, tips, grants, ecc)
2) Does it has to send an email only to funder in 1), right ? with at least one job funded.
3) Both csv and email need to be created only to funders, right ? not workers. For any US worker i have to create 1099s.
Thanks in advance

[owocki]

1. yes (the worker_type) column makes sense to me
2. yes
3. funders will receive the 1099s, and they can then distribute them to workers if needed.

[PumpkingWok]

Hi there,

@owocki Do you know any template for create a 1099s form and save it in pdf for instance ?
I have take a look in it but i did not find nothing interesting.
Should the form be similar to it ?

Thanks in advance.

[owocki]

https://www.irs.gov/pub/irs-pdf/f1099msc.pdf

id use this.

for how to create a pdf; id poke around at python libararies... im sure theres one that does this already

[kuhnchris]

This would look pretty promissing:
https://bostata.com/how-to-populate-fillable-pdfs-with-python/

[owocki]

@PumpkingWok hows this going? the end of year approaches!

[PumpkingWok]

Hi @owocki,
How is doing ? How was Devcon ?
I'm so sorry for this period that i could not work on it, I was super busy unfortunately.

Finally i have started a new job position this week and i will be able to come back to it. The next Sunday i will implement the part of code to create a pdf for 1099s and i will write to you here sunday/monday.
Thanks !!

[owocki]

@PumpkingWok thanks for the update; keep me posted. the end of the year approaches and we are counting on you for this so we can deliver this functionality at end of year.

[owocki]

u still wanna do this @PumpkingWok ? no worries if not.. i just want to make sure th eball doesnt get dropped! EOY approaches..

[PumpkingWok]

Hi @owocki,
yes sure, if for you it is ok.
At the end of this week i will be able to work on it for three days and i can complete it without problems. I wrote to you this afternoon on slack, also asking info regard quests.
Thanks in advance.

[PumpkingWok]

Hi @owocki ,
I'm working on the issue, i'm following a guide to populate fillable pdf. Have you an example to what fields needs to be fill, some sort of fac-simile with fake data ? using the forms that i posted in a comment above.Thanks

[EDIT]
In link that you sent to me (https://www.irs.gov/pub/irs-pdf/f1099msc.pdf), there are 5 types of form for 1099-MISC, Copy A, Copy 1, Copy B, Copy 2 and Copy C.
If I understood correct, it seems that Copy A (the red one) of this pdf is only for informational purpose. In page 1 explains that for receive a scannable Copy A from email, it needs to fill a form in another site.
correct me if i'm wrong.

[owocki]

yes thats right!

[PumpkingWok]

Hi @owocki ,
So i will fill and create Copy 1, Copy B, Copy 2 and Copy C. Do they need to the same datas, right ? It changes only the recipient. Have you a copy of that filled with fake data ? In this way i can understand properly what i need to fill for complete the entire document.Thanks

[owocki]

yes; the same data for each Copy... unfortunately no i dont have a copy with fake data no.

[owocki]

you'll need to fill out the
payers name/address
the recipients name/address
3 - other income
18 - state income

[PumpkingWok]

Hi @owocki,
I created the methods to fill the pdfs needed (4 files), during the week i will implement it into the code, i think that i will able to finish this at the end of the week.

So i have to fill payers name/address (the square at the top left), recipient name/address 3 and 18 ? How can i retrieve the payer (funder) and recipient address ?
Do i need to add a new field other than location field for insert the recipient address, into the new location settings section that i developed ?
What i need to put in other income ?

Last question:
Do i have to create the form only for funders that have paid an individual 600$ or more during this year ? If for instance a founder paid 3 users 500$ for each one, i don't create the form for this founder, right ?
even if these individuals worked for another founders during this year, earning more than 600$.

Thanks in advance

[owocki]

since we dont have their full address; just put in their location from the settings.

other income - put in the amount they earned.

Do i have to create the form only for funders that have paid an individual 600$ or more during this year ?

yes

If for instance a founder paid 3 users 500$ for each one, i don't create the form for this founder, right ?

yes

[owocki]

shoot - was just talking to our accountant and it looks like the proposed system is using Form-1099-S, but actually the Form is Form 1099-Misc

https://www.pdffiller.com/jsfiller-desk10/?projectId=359871477&expId=5896&expBranch=2#59e3ac74be458d41e4f52293da3aede4

And the dollar amounts would go into Box 3 "Other Income"

(sorry; when i said 1099s in the title i meant 1099 (plural) not 1099-S.. is it a lot of rework to use 1099 misc instead?)

[PumpkingWok]

Hi @owocki,
I'm already using 1099-Misc, if you meant it, instead of 1099-S.
I used https://www.irs.gov/pub/irs-pdf/f1099msc.pdf for download all forms, you posted it to me in an old comment here.
I'm working on it.
Thanks

[frankchen07]

bountied this and reserved for you @PumpkingWok - looking forward to seeing your results!

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

__This issue now has a funding of 0.56 ETH (82.26 USD @ $146.89/ETH) attached to it.__

• If you would like to work on this issue you can 'start work' on the Gitcoin Issue Details page.
  
  
  
  • Want to chip in? Add your own contribution here.
  
  
  • Questions? Checkout Gitcoin Help or the Gitcoin Slack
  
  
  • $100,034.04 more funded OSS Work available on the Gitcoin Issue Explorer
  
  

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

__Work has been started__.

These users each claimed they can complete the work by 2 weeks, 5 days from now.
Please review their action plans below:

1) pumpkingwok has started work.

Hi there, i have almost finish. thanks

Learn more on the Gitcoin Issue Details page.

[frankchen07]

thanks @PumpkingWok - looking forward to seeing it!

[owocki]

@PumpkingWok how goes? im a little anxious its 20 days till the new year and we haven't seen a working PR yet.

[PumpkingWok]

Hi @owocki,
No worries, i'm going to complete it in few days. Today i will complete the part about the csv and 1099 form creation so you could start to test it. I will conclude the last part (email and crontab task) in max 2/3 days.
I'm going to write here today just after the commit.
Thanks in advance and i'm so sorry for the delay to complete this issue.

[PumpkingWok]

Hi @owocki ,
last thing: I noticed that even name and surname miss.
Are there some db properties that i could use for them ?
Would you like that i add name and surname properties into profile model and add these field inside tax settings other than location and address ?
Thanks

[PumpkingWok]

Hi @owocki,
News regard name and surname fields ?
[EDIT]
I could test the creation of a new Grant but how i can test the funding of a grant, i can use only ERC-20, right ? Unfortunately i do not have them on rinkeby.
Do you know any way to test it ? Also, How can i add a new token locally ? I can see only COLO and FOO by default.

Thanks a lot in advance

[owocki]

user first name and user last name on the django user object

On Tue, Dec 10, 2019 at 7:42 AM andrea zuccarini [e-mail]
wrote:

Hi @owocki https://github.com/owocki,
News regard name and surname fields ? Thanks a lot

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/gitcoinco/web/issues/4806?email_source=notifications&email_token=AAD5PCPS7USV7KOYFEZFGDDQX6FDLA5CNFSM4IERX3XKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEGPDDZI#issuecomment-564015589,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AAD5PCPTND4RZRXCTYM7ZGLQX6FDLANCNFSM4IERX3XA
.

--

@owocki http://www.twitter.com/owocki

---

gitcoin is live and has generated over $2.7mm for Open Source Software - see
our results https://gitcoin.co/results

[PumpkingWok]

Hi @owocki
I have just committed some changes, also it includes the creation of 1099 misc. Until now i tested with bounties and tips, i have to add the grants part. Today i ask some help to @thelostone-mc for understand properly how get all contributions between donation, contribution and subscription in grants.
Also i have added the task in crontab for the 15th of January, if i was not wrong.

You can start to test when you will have free time, i'm going to implement the method for sending email and grants in max 1/2 days, when i will have understand how manage grants.
Contact me without problems for anything.
Thanks a lot in advance.

[owocki]

hey @PumpkingWok instead of integrating tips/bounties/grants etc all seperate... have you considered just using the dashboard.model.Earnings object to populate the 1099? probably much simpler..

[owocki]

let me know how goes

[PumpkingWok]

Hi @owocki,
I have just committed the last changes, it includes the email sending for all funders, I used the Earning model as you recommended to me for retrieve grants info. Right now it retrieves bounties and tips infos in another way.

I can make changes to code without problems but in the meantime you can start to test it.
Be careful that the command at the end sends an email to all funders (with a zip attachment with everything inside). Do you know how much load can manage Sendgrid ?

You could comment the line that calls tax_report in send_tax_report, for testing initially only the creation of csv, 1099Misc and zip.

I have to improve the email text and other few things.
Let me know for any correction that i have to do.

Thanks in advance.

[owocki]

thanks @PumpkingWok i can start testing soon..

sendgrid can handle the email volume.. we send about 40k emails per week to them!

I have just committed the last changes, it includes the email sending for all funders, I used the Earning model as you recommended to me for retrieve grants info. Right now it retrieves bounties and tips infos in another way.

whats the rationale for doing this? seems like it'd be easier to just standardize on earnings

[owocki]

https://github.com/gitcoinco/web/pull/5072 is the WIP PR right?

[frankchen07]

are we assuming for this 1099 to work we have the requisite information on someone who is using it?

name
address
email address
ssn
are we missing anything else?

[PumpkingWok]

Hi @frankchen07,
How is doing ? @owocki told me to retrieve only name and address for both funder and worker to create 1099s template, and the total income during the year. @owocki correct me if i'm wrong.
Do you mean social security number for ssn ?
Thanks in advance.

[PumpkingWok]

Hi @frankchen07 @owocki ,
Any news ?
Thanks

[owocki]

we dont have the necessary PII requirements to store SSN so i left it out of this ticket scope

[PumpkingWok]

Hi @owocki ,
ah ok, understood.
Did you test the PR code ?
Tomorrow i'm going to write a recap of main code features that i implemented in it.

[owocki]

@PumpkingWok no i didnt see it (but im still digging out from after the holidays).. can you tag me with testing instructions there?

[gitcoinbot]

⚡️ A tip worth 0.56000 ETH (133.47 USD @ $238.34/ETH) has been granted to @pumpkingwok for this issue from @frankchen07. ⚡️

Nice work @pumpkingwok! Your tip has automatically been deposited in the ETH address we have on file.

• $76105.33 in Funded OSS Work Available at: https://gitcoin.co/explorer
• Incentivize contributions to your repo: Send a Tip or Fund a PR
• No Email? Get help on the Gitcoin Slack

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

__This Bounty has been completed.__

Additional Tips for this Bounty:

• frankchen07 tipped 0.5600 ETH worth 133.47 USD to pumpkingwok.

---

• Learn more on the Gitcoin Issue Details page
• Questions? Checkout Gitcoin Help or the Gitcoin Slack
• $76,105.33 more funded OSS Work available on the Gitcoin Issue Explorer