Assuming one uses the batch report to record deposits in the Cash account on Quickbooks (or any GL system) is there a report or group of reports that will assist in reconciling credit card activity to the posting on the bank statement.
I was told that the Tessitura Posting by Transaction (in March there were over 9,000 entires mainly due to a conversion) and a batch total report from Transcend would be the link, but that is not apparent to me.
I am sure the finance people at Tessitura's licencees have a procedure they follow to do something as basic as a bank rec.
Thx
One report that seems to work well for a daily reconciliation is the income by payment method report in the finance folder within Tessitura - It will show all monies collected by payment method within given parameters (such as the date range you're looking for)...and one of the nice things about this report is that it has an option to show all money, whether it has been posted in Tessitura yet or not.
We use the Posting Report instead of batch reports to record deposits. The Transactions by Posting captures the post number too. We export the data from Transactions by Posting and manipulate it in Excel using a pivot table. We are able to sort the data by card type to make the journal entries. This works for us because our settled credit card batches closely match our Posting Report totals.
Jean J. RiversControllerSan Jose Repertory Theatre
I reconcile the posting report numbers from Tessitura to the Batch Details by Card Type report in Transcend. The Transcend numbers reflect what actually goes into the bank. There are sometimes temporary variances to the Tess numbers for web sales due to late night purchasers and different cut-off times.
LESLIE FILLINGHAM | Finance Director | Milwaukee Repertory Theater Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202 414.224.1761 tel | 414.224.9097 fax | lfillingham@milwaukeerep.com Website: www.milwaukeerep.com
On stage at The Rep...
The Bomb-itty of Errors | March 18-May 8 | Stackner Cabaret
Death of a Salesman | April 12-May 8 | Quadracci Powerhouse
Buy tickets today! Visit www.milwaukeerep.com or call 414.224.9490.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Jean Rivers Sent: Thursday, April 07, 2011 1:32 PM To: Leslie Fillingham Subject: RE: [Tessitura Finance Forum] Reconciling Credit Card Activity to Posting on the Bank Statement
Jean J. Rivers Controller San Jose Repertory Theatre
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!
This is also how I reconcile as well.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Leslie Fillingham Sent: Thursday, April 07, 2011 2:12 PM To: Jon-Paul Eddings Subject: RE: [Tessitura Finance Forum] Reconciling Credit Card Activity to Posting on the Bank Statement
Hi Jean, I just got access for Tessitura on my computer and would like to know what reports you use to do the day to day recording of acltivity on the GL. I only have been allowed to get a handful of reports that a non-accountant thinks I need, but I would prefer to say "Here is what I need".
Also, you say you use the Posting Report to record deposits, do you get the Posting Report from the Finance folder in Tessitura?
Thanks much,
Fred Witte 978-546-7391 x104
PS I was orignially logged in as Megan Hinckley since I was not registered until today.
Fred -
These are some good basic reports I'd recommend: (from the Finance folder)
GL Posting Summary Report by Day
GL Summary Report
Transactions by Posting
Income by Payment Method
The important thing to note about the first three reports is that they are based on POSTING which usually happens at the end of the box office day (or the following day depending on your business practices). Income by Payment Method is real-time live data.
HTH,
HeatherSeattle Rep
The transaction by posting report is an awesome report that shows everything in detail. When you save it as an excel file it looks a bit daunting, but once you sort the columns it’s a very useful report.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Heather Kraft Sent: Friday, April 08, 2011 2:58 PM To: Jon-Paul Eddings Subject: RE: [Tessitura Finance Forum] Reconciling Credit Card Activity to Posting on the Bank Statement
Heather Seattle Rep
From: Fred Witte <bounce-fredwitte1105@tessituranetwork.com> Sent: 4/8/2011 1:22:16 PM