Sales Summary Report

By Kelsey

Follow

The Sales Summary Report provides detailed insight from daily sales, including fees, discounts, taxes, liabilities, and payments.


Contents


Sales Summary Report Tour

The components of the Sales Summary Report are:

  1. Filters button: Click this to choose POS stations, Employees, Online Orders, and Inclusions settings:

  2. ... Icon: Click this to export your Sales Summary report in various formats:

  3. Overview Video: Click the link to view an overview of the Sales Summary Report.
  4. Sales Graph: The graph at the top of the report displays the sales for your selected time range (click date on top left side of header to select range). Each bar signfies a particular day. Hover over a bar to see the date along with the Net To Account For amount.
  5. Net Sales: Gross Sales - Total Discounts. Pre-taxed. Click the arrow to see:
    • Gross Sales: Total Product Sales (taxable and non-taxable sales) + Total Service Fees. Includes voids and returns. Excludes discounts. Pre-tax. Expand to see:
      • Total Product Sales: The total of Taxable Sales, Non-Taxable Sales, and Service Fees. Pre-discount. Pre-tax. Includes Voids and Returns. Expand to see:
        • Taxable Sales: Total taxable sales pre-discount, pre-tax. Includes voids and returns.
        • Non-Taxable Sales: Total non-taxable sales pre-discount, pre-tax. Includes voids and returns.
        • CRV Charges (included to sales): Total CRV (California Redemption Value) applied to sales total.
      • Total Service Fees: The total from both Taxable Product sales + Non-Taxable Service Fees. Expand to see:
        • Taxable Service Fees: Total amount of taxable service fees applied. Includes voids and returns.
        • Non-Taxable Service Fees: Total amount of non-taxable service fees that were applied. Includes voids and returns.
      • Total Discounts: Total of Item Discounts + Order Discounts. Does not reflect amount taken off tax. Expand to see:
        • Item Discounts: The total amount of item discounts placed. Does not reflect amount taken off tax.
        • Order Discounts: The total amount of order discounts placed. Does not reflect amount taken off tax.
  6. Total Tax and Surcharges: Total taxes and surcharges, including rounding deltas and CRV accounted as tax. Expand to see:
    • Sales Tax: Total amount of sales tax charged after discounts, voids, and returns.
    • Surcharges: Total amount of surcharge charged after discounts, voids, and returns.
    • CRV Charges: Total amount of CRV (California Redemption Value) charged after discounts, voids, and returns.
  7. Liabilities: Total activity affecting liabilities. Both activities that increase liabilities (including the sale of gift cards or the taking of a deposit on an invoice) and activities that decrease liabilities (including the use of gift cards or payments against house accounts). Expand to see:
    • House Account: Total house account activity, including payments made with and against house accounts. Expand to see:
      • Payments Against House Accounts: All payments, including refunds, made against house accounts. The tender of the payment is reflected below in Payments.
      • Payments With House Accounts: All payments made using Credit +> House Accounts.
    • Gift Cards: Total activity related to the sale and use of Gift Cards. Credit +/ Gift Payments are here, too.
      • Sold Value: Total value of gift cards sold. Gift cards must be of the class GIFT to be reported as liabilities.
      • Redeemed Value: Total value of gift cards redeemed either through a gift card payment or Credit +/ Gift.
    • Store Credit: Total activity related to accruing and redeeming Store Credit. Expand to see:
      • Accrued: Total amount of accrued store credit, for returns, exchanges, etc.
      • Redeemed: Total amount of redeemed store credit.
    • Deposits: Total activity related to deposits on invoices. Expand to see:
      • Deposit Payments: Total amount of payments accepted as deposits on invoices, including refunds. The tender of the payment is reflected below in Payments.
      • Applied Deposits: Total applied deposits, including refunds. Deposits are considered applied when the invoice is changed into an order, causing the sales to be realized.
    • Net to Account For: Total of Net Sales + Taxes + Liabilities. Below is a breakdown of all payment types accepted:
      • Cash: Total cash payments including refunds and excluding tips.
      • Credit: Sum total of all credit payments including refunds and excluding tips. Credit+ payments for AmEx, Discover, MasterCard, and Visa are here, too.
      • Checks: Total checks payments including Refunds and excluding Tips.
      • Custom Payments: Total of Custom Payments, including refunds and excluding tips.
    • Total Payments: Total of all payments, including refunds and excluding tips:

The components of the Analytics section are:

  1. Total Transactions: The number of orders opened during the reporting period.
  2. Total Invoices: The number of invoices opened during the reporting period.
  3. Average Order: The average sales per order during the reporting period.
  4. Tips- Expand to see breakdown of tips by payment type:
    • Cash: Total cash tips.
    • Credit: Total credit tips.
    • PayPal: Total PayPal tips.
    • Custom Payments: Total Custom Payment tips.
    • All Other: Total of tips from all other payment types.
    • Total: Total of all tips associated with non-deposit payments.
    • Liability Tips: Total amount of tips from liability payments, including gift cards, house accounts, and applied deposits.
  5. Total Credit Payments by Status- Expand to see:
    • Accepted: Total payments sent to processor that have not yet been captured.
    • Captured: Total payments captured and deposited to your bank.
    • Declined: Total payments declined by processor.
  6. Adjustments- Expand to see:
    • Voided Items: The total number and value of voided items.
      • Total Number: Total number of voided items.
      • Total Sales Value: Total sales value of voided items. Does not reflect discounts or tax.
    • Returned Items: The total number and value of returned items.
      • Total Number: Total number of returned items.
      • Total Sales Value: Total sales value of returned items. Does not reflect discounts or tax.
    • Comps Items: The total number and value of Comps items.
      • Total Number: Total number of comps items.
      • Total Sales Value: Total sales value of comps items. Does not reflect discounts or tax.
    • Exchanged: Total number and value of exchanged items.
      • Total Number: Total number of exchanged items.
      • Total Sales Value: Total sales value of exchanged items. Does not reflect discounts or tax.
    • Refunds: The total number and value of all refunded payments.
      • Total Number: Total number of refunds.
      • Total Sales Value: Total sales value of returned items. Does not reflect discounts or tax.
  7. Till Transactions- Expand to see:
    • Payins: Total number and value of payins to the till.
      • Total Number: Total number of payins.
      • Total Value: Total value of payins.
    • Payouts: Total number and value of payouts to the till.
      • Total Number: Total number of payouts.
      • Total Value: Total value of payouts.
    • Safe Drop: Total value of safe drops from tills.
  8. Cash Due: The amount of money owed to employee(s) by the house or vice versa. If the amount is negative, it is owed to the house. If it is positive, it is owed to employees. Generally speaking, it is non-cash tips less cash, but may also include payins and payouts according to report settings. Expand to see:
    • Non-Cash Tips: Total amount of non-cash tips collected during reporting period.
    • Cash Payments: Total amount of cash payments:

 

Please note: If you see balances listed in parentheses, that means it is a negative balance. Liabilities will show as a negative balance and Cash Due will often show as a negative balance. 


Warning Message

Occasionally, you will see the following warning message appear at the top of your Sales Summary Report:

  1. This Reporting Period Includes Orders Which are Currently Unpaid: This may occur because:
    • There are outstanding orders that did not receive payment on the Point of Sale.
    • The business is currently open and the unpaid orders reflect orders that are being processed at that moment.
    • Invoices are open because payment has not been made in full:



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Still have questions? Contact our friendly Support team

Version 2.31 is here! See what changed and what's new in the latest release.