Every month we have trouble reconciling the credit card deposits in our bank account to our Tessitura batches. Does anyone know if there is a canned report or a way to pull a list of all credit card transactions for the month by card type?
Thank you,
Amanda Nash (Canadian Olympic Foundation)
Hi Amanda,
Have you tried running the "Transactions by Posting" report that lives in the Finance folder?
Good luck!
Cheers,
Tal
Young Centre for the Performing Arts
If you don't need the individual payments that are listed in the Transactions by Posting report, what we do is have separate GLs for card types that need to be reconciled on their own. Then the GL Summary report gives our finance people a day-by-day listing for each type of card. We use four "dummy GLs" in Tessitura to break out Visa/MC/Discover from Amex and also Web vs. Phone, even though all the income is technically going to the same place.
Have you tried the Income by Payment Method report? It gives you more than credit cards, but I find it helpful as it shows you if something hasn't been posted yet, which is often why our reconciliations are off.
Otherwise, I agree with Tal, the "Transactions by Posting Report" is fantastic. I love to save it in Excel and do a quick Pivot.
Good Luck!
Sarah Al-Atrakchi
LA Opera
Thanks for your help everyone! Looks like the Transactions by Posting Report will give us what we need. Very much appreciated!