CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • IRS Tax Letter
Pages: [1]

Author Topic: IRS Tax Letter  (Read 1126 times)

questions

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 2
  • CiviCRM version: 4.4.6
  • CMS version: Durpal, 7
  • MySQL version: 5.1
  • PHP version: 5.3
IRS Tax Letter
January 05, 2011, 07:18:37 pm
Maybe I'm stupid and my searching didn't find things on this so please excuse me if there are topics on this already.

I work for a non profit.  We converted to CiviCRM recently.  It's time to send out our annual this is how much you gave to us IRS letter.

The question is what is the best way to do this.

Create a report that has all the donations and the letter?
Export the data and do a mail merge?
Some other solution?

What are other people doing?

Thanks
« Last Edit: December 12, 2011, 03:11:02 pm by questions »

Rajan Mayekar

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 20
    • Rajan's Blogs
Re: IRA Tax Letter
January 05, 2011, 08:53:17 pm
CiviReport support email delivery, which can be configured through cron :)

This may be best way to start
http://en.flossmanuals.net/CiviCRM/CiviReportConfigure

Rajan

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: IRA Tax Letter
January 06, 2011, 11:56:03 am

I think for now, doing a csv dump of the yearly summary report and then a mail merge is probably your best bet. However i did find a bug in the reports where the above does not seem to work (will check and file an issue)

In the long run, i think it would be good if we can add actions to reports, so we can send email / print receipts etc for each selected row in a report

If you/your org can help make this happen that would be great. Please contact us offline or on IRC

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

questions

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 2
  • CiviCRM version: 4.4.6
  • CMS version: Durpal, 7
  • MySQL version: 5.1
  • PHP version: 5.3
Re: IRS Tax Letter
December 12, 2011, 03:47:12 pm
We've got a resource that can work on this.

First, I should put down what I envision to see if there are desires by others that could be included.  (I guess this is sort of a US only thing; though, maybe other countries have some sort of reporting requirements that can be included.)

We'd like the ability to generate a customizable pdf letter/email that gives the details of each contribution made over a selectable period of time (usually last year).   The criteria should also include the ability to only include contribution types that are deductible.

A typical letter would have the person's name and address at the top (so it can be folded and stuck in windowed envelop) say something along the lines of  Dear so and so,  Thanks for you contributions totaling $X.  We bla bla bla and are a 501c or whatever for tax purposes.  Here are the details of your contributions:  then list each one with the date, type, amount.



It seems to me the requirement to list the details makes this harder to do.  If we just wanted to give the total for the year, we could do it now with a template and a hook for the tokens to give the total.   I'm not sure what ways we have for doing sort of a sub-report for each contact selected and then walking through each contribution each contact made, adding it to the letter and then starting a new letter for the next contact. 

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: IRS Tax Letter
December 12, 2011, 04:18:48 pm

might want to check this work and potentially use it and/or extend it:

http://wiki.civicrm.org/confluence/display/CRM/Canadian+Charitable+Receipts

Seems like for the below a custom search with a custom task (to generate that email) is one alternative

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • IRS Tax Letter

This forum was archived on 2017-11-26.