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.