Scholarships in Tessitura

I am verying interesting in learning how other organizations are handing Scholarships. We have ours set up as editable price types.

When we interface to the G/L we group the price up to the full base price for to credit the class and place the scholarship amount into an offset account where we can track the amount.

Our problem is when a Constituent has both a Scholarship and a Discount. First we must apply the discount and then the Scholarship. I can not sell a class with two price types and if I go with Payment methods I will have hundreds of scholarship method of payments depending on the class that is being sold.

 

  • Do you have different GLs for each type of scholarship? Or each class' scholarship? Is that why you'd need so many scholarship payment methods?

     If the scholarships are all coming from the same account and the concern is just keeping track of how much scholarshipping happened for each class (I am assuming each class is a perf?) you could use Performance Transaction Detail to report on that. Then you'd just sell the person the class with the discount price type, and pay part of it with the scholarship payment method.

  • Hi Robert –

     

    Our financial aid process works as follows:

    ·         Class is sold to the parent, special requested to the student as usual.

    ·         We have a Financial Aid price type which pulls the standard price, but assigns to a different GL. Our GL’s are set up by session (fall, winter, spring, spring break, summer)

    ·         The amount paid by the parent, if any, is applied as usual using cash/check/credit card pmt methods

    ·         We have pmt methods by semester where the financial aid is applied.

    ·         For reporting purposes, we have a custom screen on the parent constituent record called “Payment Assign” where we can tell Tessitura which lineitem in the order each scholarship payment was for.

     

    I’m happy to provide more information if need be.

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    First Stage
    325 West Walnut Street

    Milwaukee, WI 53212
    (414) 267-2970 direct

    (414) 267-2976 fax

     

    Website: www.FirstStage.org | Facebook: www.facebook.com/firststage | Twitter: twitter.com/firststage
    YouTube:  www.youtube.com/user/firststage | Blog: firststagechildrenstheater.blogspot.com

     

  • Thank You - Do you offer discounts on top of the financial aid too?
     
    Thank you for answering my question
    Bob


    From: Tessitura Education Forum [mailto:forums-education@tessituranetwork.com] On Behalf Of Patrick Schley
    Sent: Friday, January 27, 2012 1:17 PM
    To: Robert Taulty
    Subject: RE: [Tessitura Education Forum] Scholarships in Tessitura

    Hi Robert –

     

    Our financial aid process works as follows:

    ·         Class is sold to the parent, special requested to the student as usual.

    ·         We have a Financial Aid price type which pulls the standard price, but assigns to a different GL. Our GL’s are set up by session (fall, winter, spring, spring break, summer)

    ·         The amount paid by the parent, if any, is applied as usual using cash/check/credit card pmt methods

    ·         We have pmt methods by semester where the financial aid is applied.

    ·         For reporting purposes, we have a custom screen on the parent constituent record called “Payment Assign” where we can tell Tessitura which lineitem in the order each scholarship payment was for.

     

    I’m happy to provide more information if need be.

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    First Stage
    325 West Walnut Street

    Milwaukee, WI 53212
    (414) 267-2970 direct

    (414) 267-2976 fax

     

    Website: www.FirstStage.org | Facebook: www.facebook.com/firststage | Twitter: twitter.com/firststage
    YouTube:  www.youtube.com/user/firststage | Blog: firststagechildrenstheater.blogspot.com

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Education Forum. You may reply to this message to post to the Education 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 have a subscriber discount, but not for families who for financial aid. Our community partnership coordinator works with FA families on what dollar amount they are able to contribute to the tuition, and then we are typically able to cover the rest with financial aid.

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    First Stage
    325 West Walnut Street

    Milwaukee, WI 53212
    (414) 267-2970 direct

    (414) 267-2976 fax

     

    Website: www.FirstStage.org | Facebook: www.facebook.com/firststage | Twitter: twitter.com/firststage
    YouTube:  www.youtube.com/user/firststage | Blog: firststagechildrenstheater.blogspot.com

     

  • Hi Robert,

    Here at the Science Museum, we have a process similar to others that have been posted. We start by creating the order at the standard pricing, then click the Price Details button and use the discount functionality to reduce the amount to the price the family will be paying. (This is the same way we offer staff discounts on our classes.)

    Throughout the season we use a custom report that reviews discount transactions and calculates the original price, the amount paid by the families, and the amount covered by the scholarship fund. We use accounting paperwork outside of Tessitura to reconcile the difference at the end of the season.

    Could you use a combination of Price Types and Discounts to allow your scholarship families to get scholarships on top of discounts?

    -Michael