We are new to Tessitura, converted from Blackbaud products. Our Finance Department is still using Financial Edge for bookkeeping. I wonder if any organization on the Network established an export procedure to transfer data from Tessitura to Financial Edge? (All contribution and ticketing revenues). Thank you very much.
We do just that here at Strathmore. Happy to chat offline.
____________________________
Julie P. Hamre
Staff Accountant
Strathmore
5301 Tuckerman Lane
North Bethesda, MD 20852-3385
www.strathmore.org
301-581-5136
jhamre@strathmore.org
In office Monday-Tuesday-Thursday
Support what you love. Strathmore Stars enjoy
10% off Strathmore performance tickets, advance
ticket purchase, discounts in the Shops at
Strathmore and in Tea Room, and access to special events.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Joe Hsu Sent: Tuesday, January 20, 2015 12:04 PM To: Julie Hamre Subject: [Tessitura Finance Forum] Export to Financial Edge
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance 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 also use Financial Edge. I will have Vanessa our Assistant Controller reach out.
Dear Sadie,
Thank you so much. Your notice went to my spam and I just realized you replied. I'd love some information on Tess to FE if you wouldn't mind sharing.
Thank you very much.
Joe at CMS
Could you please ask your controller to contact me. We are just getting ready to work on the integration as well.
We are also moving to NXT
Jason Song
Scottsdale Arts
Jasons@scottsdaleArts.org
480-425-5340
Jason - I have been successfully import financial information to FE - only for Development. I will be happy to share with you the method I am using now.
Whatever you can share would be great!
IT Manager
T: 480-425-5340 C:480-529-4653
ScottsdaleArts.org
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Joe Hsu Sent: Tuesday, November 15, 2016 12:27 PM To: Jason Song <jasons@scottsdalearts.org> Subject: Re: [Tessitura Finance Forum] Export to Financial Edge
From: Jason Song <bounce-jasonsong6569@tessituranetwork.com> Sent: 11/15/2016 1:30:48 PM
Hi Joe,
Did you get an answer that worked for you?
We have an export procedure from Tessitura to FE, it's not 100% automatic. We still do some manual work but we are able to export data out of Tessitura (using the Transactions by Posting report) to Excel, then filter, pivot, and format the data to upload into FE as a manual journal entry.
Feel free to contact me if you have any other questions. I'm happy to help!
We also have FE and several years ago we had a custom report built that would export data from Tessitura to be imported into FE. Our problem is that it isn't always accurate. The people that built it for us didn't really know how to utilize Tess and we were brand new (didn't know any better!).
I am planning on doing a complete rewrite later this year that we hope will be much more user friendly and accurate.
Our issues stem from items that aren't pulled by Transactions by Posting. For example, we identify our performances by GL plus Project Code. To save on created a million GLs for all the variations of this we have our Project Code in the performance content tab. Now that we know better, I'd like to move this to Designation. But that still doesn't pull in Transactions by Posting (to my knowledge). The biggest issue is GST. We couldn't justify all the extra work with adding multiple price layers and fees to split out GST is all appropriate places so we flagged our performances and fees as GST yes (and to which GL it goes) or no. Then the custom report does the calculations and backs it out for us.
If anyone else has created something custom (similar to Transactions by Posting but with extra things) I would love to hear about it as well!
Dear Vanessa,
Thank you for reaching out. I got help from the team in Austin Theatre and found a way to export entries from Tess to FE using Plug-Ins. And also taking data from the Transactions by Posting report. It’s also not 100% automatic but it’s very convenient and easy.
I’d love to share the experience if you’d like. It’s very kind of you to check in.
Thank you very much and have a great weekend!.
Joe
Joe Hsu
212.875.5781
jhsu@chambermusicsociety.org
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Vanessa Lokan Sent: Thursday, March 30, 2017 5:37 PM To: Joe Hsu <jhsu@chambermusicsociety.org> Subject: Re: [Tessitura Finance Forum] Export to Financial Edge
From: Joe Hsu <bounce-joehsu1335@tessituranetwork.com> Sent: 1/20/2015 11:58:49 AM
I am in this same boat of working on the FE / Tessitura integration. Is it possible that someone could setup a goto meeting where we could all chat about this?
T: 480-425-5340 C: 480-529-4653
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Joe Hsu Sent: Friday, March 31, 2017 7:09 AM To: Jason Song <jasons@scottsdalearts.org> Subject: RE: [Tessitura Finance Forum] Export to Financial Edge