Reports - Sales

The Sales Report in Spark provides a real-time overview of all processed transactions. It’s a critical tool for accounting reconciliation, monitoring daily revenue, tracking seller performance, and reviewing refunds and customer payments. With flexible filtering options and multiple views, this report can be tailored to meet a wide range of operational and financial needs.

Spark location: Commerce > Reports > Sales

Sales Report Overview

  1. Filters
  2. Report View Dropdown
  3. Active Filters/Graph
  4. Display Options (Active Filters/Graph)
  5. Print, Export, Share

Filters

The filters on the left can be expanded and collapsed as needed by clicking on the following arrows.

There are a wide variety of configurations that can help you customize your report by Date/Time, Categories, Product Types, Sellers, Locations, Channels, Payment Types, and Transaction Types.

We've included the most commonly used date ranges: Today, Yesterday, Last 7 days, & Last 30 days.

After you've chosen all of your desired filters click the Apply button to generate the report.

When filtering by location, you will only see locations at which a sale has already been made. If you have created a new location, you not see it in the selection list until there has been at least one historical sale from that location.

Report View Dropdown

This dropdown above the active filters lets you choose how you'd like to view your sales data. Each option is designed for a specific purpose—here’s a quick look at what each one is best for:

Sales > Transaction

  • Overview:

    Quick snapshot of total revenue, broken down by source (Delivery, Fees, Products, Commerce).

    Use for revenue at a glance or to match batches to your bank.

  • By Date:

    Shows daily revenue totals within your selected date range.

    Use to monitor trends or compare weekdays vs. weekends.

  • By Location:

    Revenue segmented by SaffireTix Locations or source (website user or Spark revisions).

    Ideal for staffing insights or comparing gate performance.

  • By Seller:

    Totals for each SaffireTix seller.

    Used for seller reconciliation and balancing.

  • By Fee:

    Breakdown of all collected fees.

    Useful for fee transparency.

Sales > Payment

  • By Payment Type:

    Breakdown of methods of payment.

    Great for understanding how customers pay (cash, credit, check, or custom Payment Types).

Sales > Product

  • By Product:

    Shows product-level sales and credits.

    Go-to for inventory planning and tracking what’s popular.

  • By Product Fee & Tax:

    Detailed view of all fees and taxes applied to each product.

    Note: This can be a long report. Adjust print scale settings accordingly.

Sales > Other

  • Seller Reconciliation:

    If enabled, this report will be where you can review all overages/shortages for your SaffireTix sellers.

    At a glance you can see how much cash an individual is holding.

    Overages and shortages are driven by cash deposits recorded.

If you would like to have Seller Reconciliation enabled, contact support@saffire.com.

Marketing > Location

Useful for targeting promotions or understanding geographic trends.

  • Breaks down data by:
    • State/City
    • State/City/Postal Code
    • Postal Code

Invoices

Used for invoice auditing or resolving disputes.

  • Only available for sites with Invoicing enabled. Similar breakdowns are available by:
    • Transaction Overview
    • Seller
    • Product

If you would like to enable invoicing, navigate to Commerce > SaffireTix > Payment Types. Set the Active filter to All, hover over the Invoice option and click Activate.

Active Filters

Once filters are applied, they appear above the table or graph for reference. These active filters can be included when you export or print so the report can be reproduced later.

Display Options

The first thing you'll see is a graph of your sales over a given period of time that you can specify (in the top left corner of the page). You will also see a drop down menu where you can choose how you want your sales to show: By Product, Location, Date, User, Tender Type or User Reconciliation. The Filters drop down menu allows you to filter the Sales Report by Category or Channel (Online, Box Office, or Pre-Printed). This will help you narrow down your results.

Below the graph, you'll see all the detailed information with regards to your filtered parameters. Sort the report (the report below is sorted as sales " By Product"), then you will see a breakdown of products purchased, redemption (in number and percentage), as well as your revenue breakdown and customer fees.

To change from Active Filters to Graph view, click the icons at the top right:

Toggling on/off the Active Filters & Graph on the Sales Report

Sharing Options

Click the printer icon in the top-right corner to print the report. The filter panel on the left won’t appear in the printout, but the printed report will match your on-screen view and include the name of the Spark Admin who generated it.

Export to Excel

When you export the report to Excel, the file will include two tabs: one with the full report data, and another with all applied filters. This makes it easy to reference or recreate the report later for audits or support.

Email

No need to print or export, you can send the report directly to stakeholders from Spark.

URL

Fun Fact! Every time you apply a set of filters, a new URL is generated which you can copy/paste to share. You can also bookmark the pre-configured report for ease of access in the future. Visiting the URL will require logging into Spark to see the full report, so if you need to share with a non-admin, consider using the export option or print to a PDF to share.

Sales Report Troubleshooting

"None" Payment Type

When you view the Sales Report, you can see the 'Credits' made within the date range you selected. However, not all Credits resulted in a refund to the customer. Some credits are assigned to the 'None' payment type. This occurs when we edit/revise an order.



Let’s say someone originally purchased a ticket for a Saturday event but decides they would rather come on Sunday. We edit the order to make that exchange by removing the Saturday ticket from the order and adding the Sunday ticket. In the sales report, you’ll see a credit for the ticket that was removed (returned), but it will be assigned to the 'None' payment type. This means no actual refund occurred — the system is just logging that credit as part of the product exchange.


On the other hand, if a Credit is assigned to the Credit Card, Cash or Check method of payment, we know the Credit resulted in a true refund back to the assigned method of payment.


As a reminder, the Sales Report only shows Paid Orders. Invoices are not included in the sales totals, and therefore canceling or editing an invoice will not be reflected in the Sales Report.


A good way to see only Credits that resulted in refunds is to filter the 'Payment Types' on the left side of the Sales Report to just Card, Cash and Check and the 'Transaction Types' to Credit. This will remove the "None" payment type and just show credits that resulted in a refund.


Totals Don't Match Redemption Report

Sometimes you may find that the redeemed ticket totals in your sales report do not match with the totals in the redemptions report, even when the same dates are entered. If you see this, you may have your dates filtered to the days your event was going on as those are the days you were getting redemptions. However, the Sales Report will only show redemptions on sales that happened within that same time period, rather than going all the way back to when tickets went on sale. If you update the dates on both reports to make sure that they go back to when your tickets first went on sale, you may be able to reconcile these two reports accurately.