Sales Reports with GST broken out

Ah, ok thanks Tim.  Possibly wasn’t quite clear enough.  Also, wasn’t involved in building the tickets, but I do think Price Layers are being used.

I’m looking for a report something like:

Event                    Sales (ex GST)     Total GST

For a specific period

In other words – something that can show me (in one report), total Sales, total GST, by a number of Events, by a date range (usually a YTD to EOM).

It may well prove to be the case that without a custom designed report, I will need to run a number of different reports – and the one you suggest will at least give me an accurate total GST figure.

Thanks again

Anne

Anne MacDonald

Finance Administrator

Australian National Academy of Music (ANAM)
210 Bank St
SOUTH MELBOURNE VIC 3205
AUSTRALIA
E: accounts@anam.com.au

P: +61 3 9645 7911

W: anam.com.au

Find out more about ANAM’s Gala Concert

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tim Chandler
Sent: Tuesday, 26 July 2016 12:11 PM
To: Anne MacDonald <accounts@anam.com.au>
Subject: Re: [Tessitura Technical Forum] Sales Reports with GST broken out

Hi Anne,

This might depend on how your ticket prices are built. If you use price layers then you could use a Ticket sales by Period report and only select the GST layer.

Dear all,

I'm looking for a report that will

a) allow date filtering

b) show me results for sales in this date period, with the GST (tax) clearly distinguished from the total.

Currently we are having to use about 3 reports that are then manually manipulated to back out the GST.  This becomes trickier when we have a ticket that is part GST applicable and part Donation (GST Free).

Has anyone come across a report that can fulfill these requirements that is in the standard report set?

Kind regards

Anne MacDonald - Australian National Academy of Music

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Thank you Brian

I’ve had another look at the Ticket Sales by Period which seems to be able to give me this break out.

I’m sorry, not aware what “My Daily Tickets Shared report #321” is?

Thank you

Anne

My Daily Tickets Shared report #321 creates a warehoused table broken out by price category, if this is how your GST is stored.

BWG

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tim Chandler
Sent: Monday, July 25, 2016 10:12 PM
To: Brian W. Grundstrom
Subject: Re: [Tessitura Technical Forum] Sales Reports with GST broken out

Hi Anne,

This might depend on how your ticket prices are built. If you use price layers then you could use a Ticket sales by Period report and only select the GST layer.

Dear all,

I'm looking for a report that will

a) allow date filtering

b) show me results for sales in this date period, with the GST (tax) clearly distinguished from the total.

Currently we are having to use about 3 reports that are then manually manipulated to back out the GST.  This becomes trickier when we have a ticket that is part GST applicable and part Donation (GST Free).

Has anyone come across a report that can fulfill these requirements that is in the standard report set?

Kind regards

Anne MacDonald - Australian National Academy of Music

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Oops Brian, timely reminder.  Had not checked this out yet, but I will today and let you know.

Thanks

Anne

Were you able to get this ok?  Please let me know if any of the pieces are missing.

BWG

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Bryan Evans
Sent: Friday, August 05, 2016 10:15 AM
To: Brian W. Grundstrom
Subject: RE: [Tessitura Technical Forum] Sales Reports with GST broken out

Hi Anne,

Brian is referring to Solution 321 in the Shared Reports workspace in TASK.  This is a report that Brian created and shared with the community.  You can find instructions for accessing Shared Reports here:

http://www.tessituranetwork.com/Community/forums/p/16322/49409.aspx

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Hello again

I followed the instructions given by Bryan Evans

Got as far as this step – there was no such drop down or ability to find Shared Reports.

To be honest, the number of clicks and steps you have to go through (and log ins) just to look at a shared report (which should be available easily to all) is ridiculous.

Anyway – didn’t have any more time to keep trying to work out how to get “here”.

Thanks anyway

Anne MacDonald

4. Click the TASK Login button

5. Find “You are in the User Support Tickets workspace” and click User Support Tickets

6. From the dropdown that appears, choose Shared Reports

Were you able to get this ok?  Please let me know if any of the pieces are missing.

BWG

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Bryan Evans
Sent: Friday, August 05, 2016 10:15 AM
To: Brian W. Grundstrom
Subject: RE: [Tessitura Technical Forum] Sales Reports with GST broken out

Hi Anne,

Brian is referring to Solution 321 in the Shared Reports workspace in TASK.  This is a report that Brian created and shared with the community.  You can find instructions for accessing Shared Reports here:

http://www.tessituranetwork.com/Community/forums/p/16322/49409.aspx

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Thanks Bryan – got there!

Regards

Anne

Anne MacDonald

Finance Administrator

Australian National Academy of Music (ANAM)
210 Bank St
SOUTH MELBOURNE VIC 3205
AUSTRALIA
E: accounts@anam.com.au

P: +61 3 9645 7911

W: anam.com.au

Find out more about ANAM’s Gala Concert

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Bryan Evans
Sent: Friday, 19 August 2016 11:21 PM
To: Anne MacDonald <accounts@anam.com.au>
Subject: RE: [Tessitura Technical Forum] Sales Reports with GST broken out

Hi Anne,

The dropdown only appears when you click on the words User Support Tickets in the sentence "You are in the User Support Tickets workspace."  When you click on User Support Tickets, that phrase will be replaced by the dropdown menu.

Thanks,
Bryan

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!