Gross Sales and Net Sales
A lot of confusion arises when reporting on gross sales and net sales. This is because different organizations have varying methods for calculating these numbers. Qu has recognized this and developed a method that allows you to define gross and net sales based on your organization’s needs.
Report Calculations
Qu gives administrators the ability to set their own calculations for Gross and Net sales. This configuration is completed at the enterprise level, granting an admin control over the calculations completed at their corporate and franchise locations
To configure your gross and net sale, navigate to Enterprise Configuration in EI, and Click on Reporting.
From there select the items that factor into your calculation
If Net Sales = Item Sales – Discounts + Services Charges, you would check Item sales, Discounts and Service Charges, since all three factor into the equation (even though discounts are a negative value). Note:
|
Most Commonly used Calculations
Because the same terms are sometime used differently, the calculation steps for the most common definition has been outlined below. The next section contains the steps necessary to configure your own calculations.
The calculations found here are used to calculate the amounts found in the various reports in EI. However, in most case the Summary Report will be used as the reference point for all other calculations.
First there are several values that are used to calculate these amounts and are listed below:
- Total Item Sales
- Discounts
- Service Charges
- Taxes
- Gift Cards Sold
- Tips
The table below shows the calculations for Gross Sales, Net Sales, and Tender Amount.
Name |
Calculation |
Total Item Sales (Item Group) |
= Subtotal of All items sold |
Net Sales |
= Total Item Sales - Discounts + Service Charges |
Gross Sales |
= Net Sales +Taxes |
Tender Amount |
= Gross Sales + Gift Cards Sold + Tips |
The above values are displayed in Summary report and are used as a reference point for other reports. The below table serves as a tool to compare the report values with those of the summary report and to show the calculations of those where no such comparison exists.
Report Name |
Name of Value in Report |
Name of Value in Summary Report or Report Calculation |
---|---|---|
Summary |
Item Group (Total Item Sales) |
|
Net Sales |
Item Group - Discounts + Service Charges |
|
Gross Sales |
Net Sales + Taxes |
|
Tender |
Gross Sales + Gift Cards (Sold) + Tips |
|
Check Summary |
Total Amount Due |
Gross Sales |
Total Amount Paid |
Gross Sales + Charged Tips |
|
Order Type |
Total |
Item Group |
Store Comparison |
Net Sales |
Net Sales |
Discounts |
Discounts |
|
Taxes |
Taxes |
|
Voids |
Void Amount |
|
Labor Cost |
Total Labor $ |
|
Tender |
Total Amount Paid |
Gross Sales + Charged Tips |
Total Amount Tendered |
Tender |
|
Tip Track |
Total Receipts |
Gross Sales + Charged Tips + Cash Tips |
Total Direct Tips |
Charged Tips + Cash Tips |
There are several Dashboards that are available for use. However, only one of them takes several different reported values and calculates a new one so is important that it is listed here.
Dashboard Name |
Name of Value in Dashboard |
Report Calculation |
Payments |
Payments |
Gross Sales + Charged Tips + Cash Tips |
Comments