Year End Tax Report

We are in the process of creating a Year End Tax report for our donors. I had posted a request to the shared reports forum to see if any one had such a report available.  However, it does not seem to be the case? Once I have ours , I am happy to share it if there is any interest.

While putting together the specifications I do have some questions though, that I was hoping to get some feedback on.

Do you ever get requests from donors for calendar year-end tax receipts, and how do you fulfill them?

When receipting a pledge with a non-dedcutible portion that spans multiple calendar years, do you account for the whole value of goods and services in the first year or do you pro-rate that?

thanks for your feedback!!

Monika

  • Monika,

    We do get requests for calendar year-end statements. And that was what I was hoping to get from your inquiry. So far we have not had any multi-year pledges with a cost of goods and services as a part of it. So I don’t have an answer for you. I supposed it would depend on when those goods and services were received. Keep me posted and thanks for touching base.

     

    Jennifer

     

    Jennifer J.E. Wampler, MBA, CFRE

    Director of Development

    Kansas City Ballet

    1616 Broadway St.

    Kansas City, Missouri 64108-1208

    P 816.931.2232 x309

    F 816.931.1172

    M 913.707.6956

    www.kcballet.org

     

    2009-10 Season

    featuring Carmen, Lambarena and Who Cares?

    Purchase Season Tickets at 816.931.2232

    or on-line at www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Monika Jouvert
    Sent: Thursday, May 28, 2009 10:02 AM
    To: Jennifer Wampler
    Subject: [Tessitura Development Forum] Year End Tax Report

     

    We are in the process of creating a Year End Tax report for our donors. I had posted a request to the shared reports forum to see if any one had such a report available.  However, it does not seem to be the case? Once I have ours , I am happy to share it if there is any interest.

    While putting together the specifications I do have some questions though, that I was hoping to get some feedback on.

    Do you ever get requests from donors for calendar year-end tax receipts, and how do you fulfill them?

    When receipting a pledge with a non-dedcutible portion that spans multiple calendar years, do you account for the whole value of goods and services in the first year or do you pro-rate that?

    thanks for your feedback!!

    Monika




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Since you can’t take a tax-deduction on a pledge, you don’t really need to “receipt”, or provide a detailed accounting of the benefits received for a pledge.  However, once the gifts are fulfilled, I would definitely go the route of pro-rating the goods/services value based on when the goods/services are provided.  If there isn’t a clear way of determining when the particular benefits accrue to the donor, perhaps you could ask the donor what she/he/they would prefer…?

     

    We are transitioning now to Tessitura.  With our previous system, we made a habit of providing annual calendar-year tax receipts to all donors who gave more than one or two gifts or payments within the calendar year.  It seemed a nice gesture to help simplify their paperwork.  Donors have been appreciative, and we plan to continue doing this, but I haven’t tackled how to pull it off in Tessitura yet.  It may involve a custom report or output set.

     

    Kirk Mortensen
    Individual Giving Manager
    tel: 650-463-7122
    fax: 650-463-1963
    kirk@theatreworks.org

     

    As summer approaches…
    TheatreWorks Youth Summer Camps and Conservatory are booking fast!
    To learn more, visit: http://www.theatreworks.org/educationcommunity/youthprograms/index.aspx

     


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jennifer Wampler
    Sent: Thursday, May 28, 2009 8:17 AM
    To: Kirk Mortensen
    Subject: RE: [Tessitura Development Forum] Year End Tax Report

     

    Monika,

    We do get requests for calendar year-end statements. And that was what I was hoping to get from your inquiry. So far we have not had any multi-year pledges with a cost of goods and services as a part of it. So I don’t have an answer for you. I supposed it would depend on when those goods and services were received. Keep me posted and thanks for touching base.

     

    Jennifer

     

    Jennifer J.E. Wampler, MBA, CFRE

    Director of Development

    Kansas City Ballet

    1616 Broadway St.

    Kansas City, Missouri 64108-1208

    P 816.931.2232 x309

    F 816.931.1172

    M 913.707.6956

    www.kcballet.org

     

    2009-10 Season

    featuring Carmen, Lambarena and Who Cares?

    Purchase Season Tickets at 816.931.2232

    or on-line at www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Monika Jouvert
    Sent: Thursday, May 28, 2009 10:02 AM
    To: Jennifer Wampler
    Subject: [Tessitura Development Forum] Year End Tax Report

     

    We are in the process of creating a Year End Tax report for our donors. I had posted a request to the shared reports forum to see if any one had such a report available.  However, it does not seem to be the case? Once I have ours , I am happy to share it if there is any interest.

    While putting together the specifications I do have some questions though, that I was hoping to get some feedback on.

    Do you ever get requests from donors for calendar year-end tax receipts, and how do you fulfill them?

    When receipting a pledge with a non-dedcutible portion that spans multiple calendar years, do you account for the whole value of goods and services in the first year or do you pro-rate that?

    thanks for your feedback!!

    Monika




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • Hi Monika,
     
    The Playhouse would be interested in your report.  Up until this year, we have prepared year-end tax receipts as personal accountants and donors call and request them--one at a time.  This year we have several pledges on monthly payment schedules so we've decided to acknowledge all of the payments at once at the end of the year.  I'm compiling a list of IDs as this donor type emerges in preparation.
     
    -Jayne

    Jayne Atkinson
    La Jolla Playhouse | Mgr of Development Operations 
    858| 550-1070 x 132

    $upport the Playhouse Today!



    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Monika Jouvert
    Sent: Thursday, May 28, 2009 8:02 AM
    To: Jayne Atkinson
    Subject: [Tessitura Development Forum] Year End Tax Report

    We are in the process of creating a Year End Tax report for our donors. I had posted a request to the shared reports forum to see if any one had such a report available.  However, it does not seem to be the case? Once I have ours , I am happy to share it if there is any interest.

    While putting together the specifications I do have some questions though, that I was hoping to get some feedback on.

    Do you ever get requests from donors for calendar year-end tax receipts, and how do you fulfill them?

    When receipting a pledge with a non-dedcutible portion that spans multiple calendar years, do you account for the whole value of goods and services in the first year or do you pro-rate that?

    thanks for your feedback!!

    Monika




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • We do print year-end acks for people who request them and generally handle those individually.  We run all of our monthly giving club acks in February, and have typically sent acks for each payment on a pledge.  Currently, we do have a report in place that is pulled once a week to ack all gifts for that week, but we export to Excel and mail merge.  We are presently working on a better system.

    As far as the FMV is concerned, we tell them when either the pledge is made or the first payment received what the FMV is on the membership and let the donor determine what is best for them with their tax advisor.

    Hope that is helpful.

  • Former Member
    Former Member $organization in reply to Jayne Atkinson

    Hello Jayne,

    Re your comment:

    This year we have several pledges on monthly payment schedules so we've decided to acknowledge all of the payments at once at the end of the year.  I'm compiling a list of IDs as this donor type emerges in preparation.

    With the acknowledgement are you able to generate one tax receipt for the total payments in the year?  We are moving to a monthly payment option, but so far I am stumped as to how to avoid generating tax receipts for each individual payment.  Any insight that you might have in this regard would be great!

    Thanks,

    Duane

  • I'd love to see what you come up with as well.

    Here's what we started doing this year:
    (The less complicated version)

    Gifts = Tax Receipt at time of gift
    Pledge or Pledge w/Payment = "Thank You" letter

    In the acknowledgement rules I have a separate letter designated to generate in the event of a pledge w/payment, first payment, payment or final payment.
    I plan to run the acknowledgement report at the end of the year on these and merge them into a word document thus creating an end of year itemized receipt for pledges.

    No idea yet if this will be a smooth process, I'm crossing my fingers.

  • if anyone is still interested:)

    we send out year end tax letters. we take the ammount of a pledg/gift that was paid during this tax year as a percentage of the whole pledge/gift and use that percentage to calculate the goods service for the same year. if you are interested ill post our report

  • Mendy,

    I would love to see your end of year tax letters.  We are looking at implementing this for all gifts. 

    Can you share out your report?

     

     

  • Hi, if this is something your still interested in email me at msudranski@mtc-nyc.org

     

    Mendy Sudranski

    IT Manager

    Manhattan Theatre Club

    311 West 43rd Street - 8th Fl

    New York, NY 10036

    Phone: (212) 399-3000 ext. 4105

    msudranski@mtc-nyc.org

     

  • i've read the thread on this, as we are wanting to send year-end tax summaries to our donors for Calendar Year 2017. I am wondering . . . 

    Does anyone have:

    -A customized report

    -Word Document for merging with Date of Payment, Description and Amount Received in columns for each CID that will merge with an excel export from Tessitura to separate pages for each CID?

    Miki

  • Former Member
    Former Member $organization
    Hi Miki,

    We don't have a custom report but are still sending the 2017 tax report with these steps:

    - Build list of 2017 donors
    - Build output set with information you detailed, export to Excel (one gift per line)
    - Use of lookupconcat UDF in excel to get all the gift fields in one string per constituent
    - Text-to-columns to get each field in their cell.  All 2017 gifts are now in one row
    - Remove duplicates
    - Merge to Word

    Is this enough detail? Feel free to ask for clarification.

    Good luck!

    Louis
    PS: I've found this letter to be a surprisingly good appeal, just adding something like "If at this time you would like to make your 2018 gift, then..."

    Louis Diez
    Director of the Annual Fund
    Baltimore Symphony Orchestra

  • Thank you Louis. When donors give at the end of December, but the payment goes into Tessitura in January, do you enter the check/payment date in Tessitura in order to make sure the payment is accounted for in the correct year?
    Miki

  • Former Member
    Former Member $organization
    My pleasure. We go by IRS rules for when you're allowed to credit year-end gifts.

    In a nutshell, it depends on how you received the check. If by USPS, you must use the postmark date. If by courier, it's the date the check was signed for or in your possession.

    Louis Diez
    Director of the Annual Fund and Business Operations
    Baltimore Symphony Orchestra



  • Hi Louis, Where do you put the postmark date/check signed date in Tessitura in order to produce a 2017 list of donors? We are running into an issue creating year-end letters and asking Tessitura for Jan 1 through Dec 31. Transaction date is sometimes the following January (date entered into Tessitura), so those gifts are not accounted for.
    Miki

  • Former Member
    Former Member $organization
    Hi Miki,
     
    I don’t do the gift processing in our office but can probably look up a current gift and share a screenshot.
     
    Feel free to email me at ldiez@bsomusic.org if that sounds doable.
     
    Thanks,
     
    Louis
     
     
    Louis Diez
    Director of the Annual Fund and Development Operations
    Baltimore Symphony Orchestra 
    p 410.783.8058 | f 410.783.8003 | ldiez@BSOmusic.org | BSOmusic.org
     
    Joseph Meyerhoff Symphony Hall | 1212 Cathedral Street | Baltimore, MD 21201
    The Music Center at Strathmore | 5301 Tuckerman Lane | North Bethesda, MD