• Replies 6 replies
  • Subscribers 220 subscribers
  • Views 87 views
  • Users 0 members are here
Related

Tessitura & Element Reconciliation Reporting

Carrie LaFerle Gergely
$organization

We are new to Tessitura & have been using Element as our gateway & CC processor. We have been having a very difficult time reconciling the credit cards on the GL Summary Report from Tess to the monthly statement from Element. Does anyone have a reliable & accurate way to make these match? 

We are aware of the  time zone issue, but the EPS Tool has not been accurate for us either. We are also trying to be more proactive about posting batches daily (we were doing it once a week before, since we do our main reporting for our Board by month) but not sure how helpful that will be.

Any advice, reports, or experience is welcome!  



[edited by: Carri Gergely at 2:23 PM (GMT -6) on 5 Sep 2014]
Parents
  • $organization
    Our finance person was having similar troubles, and it took us a while to figure out what we do now—and at least I think there’s no more confusion. We’re not reconciling with element’s statement; rather, with daily deposits into our bank account, but some of this may still apply.

    - Know that you can backdate batch postings. We never have a single batch with transactions that span two different days, so even if I have unposted batches for an entire week, I can backdate-post each day’s batches into a single posting timestamped with the date of those transactions.
    - We have two different merchant accounts which deposit to our bank account separately, so to sum up these deposits in the postings, our payment methods for a single merchant account are all assigned the same GL. So on the posting summary report, it comes out as one GL for e-commerce per day, and one GL for MOTO/Retail per day.

    Hope that helps!

    -Nick

    On Sep 5, 2014, at 3:20 PM, Carri Gergely <bounce-carrigergely1625@tessituranetwork.com> wrote:

    We are new to Tessitura & have been using Element as our gateway & CC processor. We have been having a very difficult time reconciling the crefit cards on the GL Summary Report from Tess to the monthly statement from Element. Does anyone have a reliable & accurate way to make these match? 

    We are aware of the  time zone issue, but the EPS Tool has not been accurate for us either. We are also trying to be more proactive about posting batches daily (we were doing it once a week before, since we do our main reporting for our Board by month) but not sure how helpful that will be.

    Any advice, reports, or experience is welcome!  




    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!

Reply
  • $organization
    Our finance person was having similar troubles, and it took us a while to figure out what we do now—and at least I think there’s no more confusion. We’re not reconciling with element’s statement; rather, with daily deposits into our bank account, but some of this may still apply.

    - Know that you can backdate batch postings. We never have a single batch with transactions that span two different days, so even if I have unposted batches for an entire week, I can backdate-post each day’s batches into a single posting timestamped with the date of those transactions.
    - We have two different merchant accounts which deposit to our bank account separately, so to sum up these deposits in the postings, our payment methods for a single merchant account are all assigned the same GL. So on the posting summary report, it comes out as one GL for e-commerce per day, and one GL for MOTO/Retail per day.

    Hope that helps!

    -Nick

    On Sep 5, 2014, at 3:20 PM, Carri Gergely <bounce-carrigergely1625@tessituranetwork.com> wrote:

    We are new to Tessitura & have been using Element as our gateway & CC processor. We have been having a very difficult time reconciling the crefit cards on the GL Summary Report from Tess to the monthly statement from Element. Does anyone have a reliable & accurate way to make these match? 

    We are aware of the  time zone issue, but the EPS Tool has not been accurate for us either. We are also trying to be more proactive about posting batches daily (we were doing it once a week before, since we do our main reporting for our Board by month) but not sure how helpful that will be.

    Any advice, reports, or experience is welcome!  




    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!

Children
No Data