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
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
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
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. 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!