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!

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!