Does anyone know of any reliable CC processing programs that we can switch from Transcend? We're having issues reconciling because they split their batches, and it posts to our bank in separate sums with delays of up to a month. Which is especially difficult to track because we can't print detailed transactions that are contained within these sums to reconcile with either.
According to the customer service reps, this should not be happening, but it is and there doesn't seem to be anything they know how or care to fix. Does anybody else experience the same issues?
Our finance dept has success with authorize.net but this unfortunately doesn't communicate with Tessitura. Something along that though, is what we're looking for.
Is it the TranScend application that is splitting the batches or your merchant processor that is causing the split? (and I realize that Intrix can be your processor too) We just switched merchant processors with no problems, but I am not aware of being able to use software other than TranScend in the US. It is always a bit of a headache to track down where the money goes after you hit authorize in Tessitura, but if you are stubborn enough you can usually connect the dots.
Good luck!
Boann
Sarah,
We encountered a similar problem when we switched merchant banks. We were able to adapt our general ledger entries to more closely reflect the bank activity. Additionally, we manually settle our batches. Now our posting reports match our credit card settlements. I realize that manual settlement is not the answer for every organization but it works for us.
One more thing, our payment methods also mirror the different types of transactions: web, moto. These markers were a great help in making the changes to our journal entry. I could send an example if you are interested.
Jean
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Sarah ParkerSent: Thursday, May 24, 2012 2:48 PMTo: jeanr@sjrep.comSubject: Re: [Tessitura Finance Forum] Alternative to Transcend?
From: Sarah Parker <bounce-sarahparker6350@tessituranetwork.com>Sent: 5/24/2012 4:36:11 PM
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!
The Phoenix Symphony uses Transcend. I am able to match every single deposit by aligning the Tessitura posting reports for the day the deposit was submitted. When depositing to our account, Transcend usually combines the Development Dept.credit card contributions with the Box Office credit cards purchases (that are made in the office or at the concert). Transcend will make a separate deposit for the Box Office web sales.
I am able to match the bank deposits with the posting reports every day. I am very happy with Transcend.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Sarah Parker Sent: Thursday, May 24, 2012 2:40 PM To: Pam Logan Subject: [Tessitura Finance Forum] Alternative to Transcend?
Does anyone know of any reliable CC processing programs that we can switch from Transcend? We're having issues reconciling because they split their batches, and it posts to our bank in separate sums with delays of up to a month. Which is especially difficult to track because we can't print detailed transactions that are contained within these sums so reconcile with either.
According to the customer service reps, they this should not be happening, but it is and there doesn't seem to be anything they know how to fix. Does anybody else experience the same issues?
Thank you everyone for your suggestions! Went with Boann's suggestion of checking our merchant account (Harbor Touch), and pulling the detail there, from their online website. Turns out this is a new functionality that didn't exist before it was United Bank.
We then ran a script to pull all the transactions from Tessitura for the same range we pulled the bank statements for:
selectT_PAYMENT.customer_no,T_ACCOUNT_DATA.act_name,T_PAYMENT.pmt_dt,sum(T_PAYMENT.pmt_amt) as total,TR_PAYMENT_METHOD.description,T_ACCOUNT_DATA.act_no_fourfrom T_ACCOUNT_DATAJOIN T_PAYMENT ON T_ACCOUNT_DATA.id = T_PAYMENT.act_idJOIN TR_PAYMENT_METHOD ON T_PAYMENT.pmt_method = TR_PAYMENT_METHOD.idwhere T_PAYMENT.pmt_dt >= '2011-11-01 00:00:00.000'AND T_PAYMENT.pmt_dt <= '2012-01-31 00:00:00.000'AND T_PAYMENT.pmt_method in (--insert all ID's from TR_PAYMENT_METHOD that is a credit card transaction)group byT_PAYMENT.customer_no,T_ACCOUNT_DATA.act_no_four,T_ACCOUNT_DATA.act_name,T_PAYMENT.pmt_dt,TR_PAYMENT_METHOD.description/*select * from T_ACCOUNT_DATAselect * from T_PAYMENTselect * from TR_PAYMENT_METHOD*/
Lastly, we are now in the process of cross-checking the two sheets against each other. We're doing this by creating two separate tables in SQL which I passed onto someone else from the DB to script. This will ultimately dupe transactions to see what's missing/duplicated. I'll post the script on here once we've got the method worked out.