How do you work with Grants in Tessitura? any advise

Hi Sharon,

We are new to Tessitura this fall and working with version 16. I found this thread and wanted to see if over the past year you had any headway. I am trying to find the best way to apply grants that the Museum has already received to apply to student group Tessitura ticket orders, rather than track the actually development process of applying for grants. We have a number of different grants that are set up as payment tenders in Tessitura and our finance and Education team keep track of balances in Sage and spreadsheet tracking. Our auditors require the grant payment tender to be applied on the school visit date. Our issue is that when we send out the advance confirmation/invoice to the schools detailing the balance due, the grant funding is not applied, and therefor full balance appears in our HTML confirmation. We currently write a note in the booking notes field that details the grant and what the school REALLY owes, but school payable's staff pretty much hate this and we have had to create a few "faux" invoices manually in Excel which can show the exact amount due in order for the school to approve. The Maritime Aquarium in Norwalk who we chatted with also uses the Booking notes option to much the same response from schools. We are working with our onboarding team to see if there is a way we can use either a dummy Grant Payment tender type for the confirmation, send, and then reverse back i the order...or somehow play with the HTML code to allow a negative fee to be applied so we get a true balance due. Just wondering if in the last year you came up with a workable solution. Thanks for any insight you could provide.

Hi Sharon,

We are new to Tessitura this fall and working with version 16. I found this thread and wanted to see if over the past year you had any headway. I am trying to find the best way to apply grants that the Museum has already received to apply to student group Tessitura ticket orders, rather than track the actually development process of applying for grants. We have a number of different grants that are set up as payment tenders in Tessitura and our finance and Education team keep track of balances in Sage and spreadsheet tracking. Our auditors require the grant payment tender to be applied on the school visit date. Our issue is that when we send out the advance confirmation/invoice to the schools detailing the balance due, the grant funding is not applied, and therefor full balance appears in our HTML confirmation. We currently write a note in the booking notes field that details the grant and what the school REALLY owes, but school payable's staff pretty much hate this and we have had to create a few "faux" invoices manually in Excel which can show the exact amount due in order for the school to approve. The Maritime Aquarium in Norwalk who we chatted with also uses the Booking notes option to much the same response from schools. We are working with our onboarding team to see if there is a way we can use either a dummy Grant Payment tender type for the confirmation, send, and then reverse back i the order...or somehow play with the HTML code to allow a negative fee to be applied so we get a true balance due. Just wondering if in the last year you came up with a workable solution. Thanks for any insight you could provide.