We are having trouble reconciling our Element Report to individual transactions in Tessitura and providing adequate back-up to prove this reconciliation. Ultimately, we want one report that aligns exactly with the Element report totals, which have been matching our bank deposits, but that also match Tessitura reports without manipulation. The Transactions by Posting has been the most useful Tessitura report so far, but it doesn't have the actual processing date, especially problematic for credit cards which we’re finding are posted on one day, but actually were charged on another. We also need to show the appropriate G/L codes as part of this reconciliation and gift (contribution) review. I'm looking for some financial perspective as the accountant handling this reconciliation, so if any accountants regularly handle posting from Tessitura to the G/L and reconciliation to the bank deposit and would share their experience, it would be much appreciated.
I am having the EXACT same problem. Please any guidance would be extremely helpful.
Hello Shawna,
Tessitura Network Consulting just published in the Shared Report area on TASK a suite of tools and reports to help with Element reconciliation. The item number on TASK is 350. This again is a shared solution if you need assistance installing or customizing the tools please contact Tessitura Network Consulting .
Thank you,
Jon
Jon,
I am following the installation directions for the EPS Data Tools and I'm at a point where I should see TR_EPS_SSIS_CONFIGURATION in system tables but it isn't there. I re-ran the install script which I see grants permissions to the table. The table appears in SSMS. I have run UP_POPULATE_REFERENCE_METADATA but still don't see it. Is it supposed to appear there or do I enter merchant data in the SQL table through SSMS? Also when I configured the SSIS package the DBUSERPASSWORD in not in the config file. Can you help?
Hi Gloria - are you logged into Tessitura in an Admin user group? If not, try looking in Security to add that system table to your user group.
Hi Gloria,
If you run :
[UP_POPULATE_REFERENCE_METADATA] 'tr_eps_ssis_config' The table should get added to the system tables. The value to replace DBUSERPASSWORD is in the EpsConfig.dtsConfig file at line 19.
Let me know how you make out.
Hi Brian,
Yes I am. Thank you.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Brian Pedaci Sent: Monday, October 12, 2015 1:06 PM To: Gloria Ormsby Subject: Re: [Tessitura Finance Forum] Element Reconciliation
From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> Sent: 10/12/2015 10:02:00 AM
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!
Ok. Thanks Jon. I’ll let you know. Deploying the reports now.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Jon Ballinger Sent: Monday, October 12, 2015 1:50 PM To: Gloria Ormsby Subject: Re: [Tessitura Finance Forum] Element Reconciliation