Breakdown of "GL Summary for All Batches" section on Posting Report

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 Theater
Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202
414.224.1761 tel | 414.224.9097 fax | Email:  lfillingham@milwaukeerep.com 
Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep

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!

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!

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 Theater
Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202
414.224.1761 tel | 414.224.9097 fax | Email:  lfillingham@milwaukeerep.com 
Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep

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!

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!