Our accounting software requires us to breakdown which GLs are being credited when posting revenue to a bank account. For example, if $1,000 was debited to the cash bank account GL number on the Tessitura Posting report, which GLs were credited to total the $1,000 (e.g., ticket sales, annual fund, fees, etc.). Same is true for our credit card bank account GL number.
Unfortunately, none of the standard reports provide this level of drill down and I haven't yet been able to figure out how to write a custom report that will either. Any guidance is greatly appreciated. Thanks!
We do the same. We have 5 separate accounts broken down by card MC/V Box Office, MC/V Online, Amex/Disc Box Office, etc. Each GL Account corresponds to a specific bank account where revenue is deposited. These are also reconciled against the bank and merchant statements. We do not use pivot table currently. However, we also are not reconciling daily tickets and fees but rather lump sum batches. I suspect the procedures will need to be upgraded once we get to that point (we’re just beginning our third season.) Batches are posted daily and our finance department uses each GL line in the GL summary report to post to our accounting software.
Michelle Wiesel
Ticket Services Manager
310-746-4000 (O)
michelle@thewallis.org
www.TheWallis.org
9390 N. Santa Monica Boulevard Beverly Hills, CA 90210
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Julie Hamre Sent: Tuesday, July 21, 2015 5:20 AM To: Michelle Wiesel Subject: RE: [Tessitura Finance Forum] Breakdown of "GL Summary for All Batches" section on Posting Report
Perhaps I am misunderstanding what you need, but I think the GL Summary Report does exactly that. Set your parameters to include all of your GL accounts. If you have multiple bank accounts as we do (one for ticket office, one for development, one for the gift shop, etc.) then you can set up batch types to correspond to each bank account.
____________________________
Julie P. Hamre
Staff Accountant
Strathmore
5301 Tuckerman Lane
North Bethesda, MD 20852-3385
www.strathmore.org
301-581-5136
jhamre@strathmore.org
In office Monday-Thursday
Support what you love. Strathmore Stars enjoy
10% off Strathmore performance tickets, advance
ticket purchase, discounts in the Shops at
Strathmore and in Tea Room, and access to special events.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Sara Nemeth Sent: Monday, July 20, 2015 5:00 PM To: Julie Hamre Subject: [Tessitura Finance Forum] Breakdown of "GL Summary for All Batches" section on Posting Report
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!