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