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!
I’ve been doing a lot of pivot tables lately, so tried this: Save Transactions by Posting to Excel, create a pivot table with transaction_no for the rows and GL_no for the columns, with trn_amt summed in the body. Copy and paste values to a new sheet, sort by GL numbers, and subtotal the columns by your cash and credit GL’s. Very laborious – are you sure your accounting package requires this? J
LESLIE FILLINGHAM | Finance Director | Milwaukee Repertory TheaterPatty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202414.224.1761 tel | 414.224.9097 fax | Email: lfillingham@milwaukeerep.com Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Sara NemethSent: Monday, July 20, 2015 4:01 PMTo: Leslie FillinghamSubject: [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!
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
Someone else should confirm, but I believe this is not possible. That is, there is no hard link between an individual cent taken as payment, and the revenue line to which that cent is assigned.
This makes a little bit more sense when you think about how order payments work. If I have three products in my order with three different GLs, and I pay off that order with a combination of cash and card, nowhere in the client do you say that payment x is for product y. Instead, the products put the order value out of balance, and payments bring that balance to 0.
Of course, 90% of the time you can guess accurately: If an order only has a single payment, then you can unambiguously say where every cent of that payment is assigned. But, if more than one payment occurs, it becomes ambiguous which payment is for which product. Deciding how you will deal with that ambiguity is why this is a custom reporting issue and not built-in.
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
Hi Sara et al
Actually, it is theoretically possible to associate particular payments with the specific items they paid for, sort of.
When you take partial/multiple payments against an order, Tess applies the payments to actual items on the order in a specific sequence. (I don't recall what it is, but it's documented somewhere.) You can recover the associated payment/order item/s by linking at the transaction sequence / payment sequence / (sli detail/fee/contribution) level.
But it's a bit random - you have no control over which payment pays for what - and the code needed to pull the data reliably is not for the faint-hearted. The linking is not intuitive, and gets pretty complex. And there are a couple of caveats, as usual -
If my finance system insisted on that explicit link being made, I'd be looking for a new finance system, I think. It's unpleasantly inflexible, and not the accounting-correct way to do things. But I suppose that's not an option for you, Sara?...
Ken