Sales Balance Report
The Sales Balance report is a consolidated report that provides information on multiple areas of the POS system such as employees, tenders, checks, meal period, and sales transactions. This report is not applicable for VAT mode.
Summary
This section of the report provides a high-level summary of all transactions applicable to the selected parameters for the report, such as the reports date range.
|
Field |
Description |
|---|---|
|
Gross Revenue |
The amount of revenue on the check minus the returns and refunds prior to discounts, tax, tip, gratuity, and service charges calculated. If an item is tax inclusive, the tax is not considered while calculating the gross revenue. |
|
(–) Discounts |
Total amount of discounts on the checks. |
|
(=) Net Revenue |
Gross revenue minus discounts and taxes. |
|
(+) Tax Collected |
The sum of the tax collected. |
|
(+) Gratuity |
The dollar amount of all the gratuities calculated on the checks |
|
(+) Service Charge |
The dollar amount of all the service charges calculated on the checks. |
|
(+) Tips Collected |
The total tip amount collected. |
|
(=) Total |
The sum of the net revenue, service charge, gratuity, and tax collected. |
|
(+) Refund Amt |
The total refund amount. |
|
(+) Return Item Amt |
The total value of all returned items. |
|
(=) Gross Receipts |
Aggregate summary of all check total for a given period, not including refunds. Gross Receipts = Net Revenue + Taxes + Gratuities + Service Charges + Charged Tips |
|
Gross Revenue Outstanding* |
The sum of the gross revenue in the open checks. The revenue for the period in which this report is run is considered. |
|
Total # of Checks |
The quantity of the closed checks. |
|
# of Refund Checks |
The total number of checks containing a refund flag. Negative checks without a refund flag, (that is, those with returned items) are not included as refund checks. |
|
Net Checks |
The number of non-refunded checks. Net Checks = Total Checks – 2*Refund Checks |
|
Return Item Qty |
The sum of all the returned items. |
|
Void Amt |
The sum of all the void checks’ total. |
|
Void Qty |
The total number of checks voided. |
|
Avg./Check |
Net Revenue divided by the number of checks. |
|
# of Covers |
The total cover quantity of the net checks. |
|
Avg./Cover |
The average net revenue amount per net cover. |
|
Disc % |
The percent of gross revenue given as a discount. If $100 of gross revenue is recorded, and $10 in discounts were applied by the cashier, the Discount % is 10% (100¸10). |
|
Discount Quantity |
The total number of discounts applied on the check. |
|
No Sale Qty |
The number of No Sales performed by the cashier. Every time a cash drawer is opened without the check being tendered is considered a no-sale. A cashier usually does this to make change. The number of times this happens is displayed here. |
|
Cash Tender |
The difference between the total tenders and the non-cash tenders. Cash Tender = Total tender – Non-Cash Tender |
|
(+) Noncash Tenders |
The sum of the non-cash tenders. |
|
(–) Loans |
The total amount of all loans taken during the shift. |
|
(+) Withdrawals |
Funds removed from the system via the Withdrawal function. |
|
(–) Tips Paid Out |
The total amount of the tips paid out. Tip payouts are automatically subtracted from the current cashier’s accountable cash. |
|
(–) Breakage |
The sum of the breakage amount across tenders. |
|
(–) Change |
The sum of the change given out while tendering. |
|
(=) Net Tenders |
The amount of all tenders (both cash and non-cash) after change, loans, withdrawals, and tips have been processed. |
|
Total Cash Drop |
The total cash drop amount. This value is updated after the Shift Reset function is performed. |
|
(–) Account. Cash |
The expected amount of physical cash tenders on hand that the cashier or server-banker is responsible for. Accountable cash = (Total Tenders – Change) + Loans – Withdrawals – Tips Paid – Non-cash Tenders |
|
(=) Over/Short |
Amount of cash that is either missing from the drawer or is extra in the drawer. Over/Short = Cash Drop Amount – Accountable Cash |
|
Pending Tips |
The remaining tips available in the cash drawer after the tip payout. Pending tips = Tips paid out – Tips available in the cash drawer at the end of the business period. |
Sub Reports
The following sub-reports form the Sales Balance report:
-
Tender
-
Check type
-
Meal period
-
Gross sales, Tax & Discount
-
Job code summary
Tender
This report breaks up the transactions according to the tender.
|
Field |
Description |
|---|---|
|
Tender |
The name of the configured tender. This field is same as the Tenders field in the Tender report. |
|
Qty |
The number of times the tender is applied. This field is same as the Quantity field in the Tender report. |
|
Amount |
The total dollar amount of tenders entered in the POS system by the user. For example, if a user takes a $10.00 bill from customer on a $5.00 transaction, the tender amount is $10.00. This field is same as the Tender Amount field in the Tender report. |
|
Breakage |
Breakage is the difference between the tender received and the check total, but only when this difference is configured to go to the breakage account for the tender. This field is same as the Breakage field in the Tender report. |
|
Change |
The total dollar amount of tenders received after change is provided to the customer. This field is same as the Change Amount field in the Tender report. |
|
Tips |
The total dollar amount of tenders received after change is provided to the customer. This field is same as the Change Amount field in the Tender report. |
|
% of Total |
The ratio of amount tendered to the total tender. |
Check Type
This report breaks up the transactions according to the check type.
|
Field |
Description |
|---|---|
|
Check type |
The name of the check type. |
|
# of Checks |
The total number of checks processed including refunds or checks closed. This field currently exists in Sales summary with Revenue Detail report. |
|
# of Covers |
Quantity of covers that were on closed checks. |
|
Net Revenue |
Total of all financial activity associated with the sale of unrefunded/undiscounted goods. In other words, net revenue is positive revenue calculated after discounts. Net Revenue = Gross Revenue – Discounts |
|
% in Total NR |
Ratio of Net Revenue with total net revenue. |
|
% in Net Checks |
Ratio of total checks for check type in context with sum of total checks. |
|
Avg./Check |
Net Revenue divided by the number of checks. |
|
Avg./Check |
Net Revenue divided by the number of checks. |
|
Avg. Open Time |
Net Revenue divided by the number of checks. |
Meal Period
This report breaks up the transactions according to the meal period.
|
Field |
Description |
|---|---|
|
Meal Period |
The name of the meal period in context. This field is same as the Meal Period Name field in the Sales Summary with Revenue Detail Report Grouped by Meal Period report. |
|
# of Checks |
The total number of all sales transactions including refunds. This field is same as the # of Checks field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
# of Covers |
The total number of covers that were on closed checks. This field is same as the # of Covers field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
# of Refund Checks |
The total number of checks containing a refund flag. Negative checks without a refund flag, (i.e. those with returned items) are not included as refund checks. This field is same as the # of Refund Checks field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
# of Voided Checks: |
The number of voided checks for the meal period in context. This field is same as the Void Check Quantity field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
Net Revenue |
The total of all financial activity associated with the sale of unrefunded/undiscounted goods. In other words, net revenue is positive revenue calculated after discounts. Net Revenue = Gross Revenue – Discounts. This field is same as the Net Revenue field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
Avg. / Check |
The average dollar net revenue amount per net check. This field is same as the Avg/Check field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
Avg. Cover |
The average net revenue amount per net cover. This field is same as the Avg Cover field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
|
Discounts |
The discount applied on the meal period in context. This field is same as the Discounts field in the Sales Summary with Revenue Detail Report Grouped By Meal Period report. |
Gross Sales
|
Field |
Description |
|---|---|
|
Revenue Category |
The name of the revenue category. This field is same as the Revenue Category field in the Sales Summary with Revenue Detail report. |
|
Gross Revenue |
The gross sales minus refunds, returns, and allowances. This field is same as the Gross Revenue field in the Sales Summary with Revenue Detail report. |
|
% of Revenue |
The ratio of revenue for the respective revenue category with the gross sales amount. |
Tax
This report breaks up the transactions according to the discounts.
|
Field |
Description |
|---|---|
|
Tax |
The name of the tax configured in the IGCM. This field is same as the Tax Name field in the Tax Summary report. |
|
Amt Collected |
The sum of all the tax amount collected under the tax in context. This field is same as the Tax Amount field in the Tax Summary report. |
|
% of Tax |
The ratio of tax collected for the tax in context with the total tax amount collected. |
Discount
This report breaks up the transactions according to the discounts.
|
Field |
Description |
|---|---|
|
Discount |
The name of the discount. This field is same as the Discount Name field in the Discount Summary report. |
|
Qty |
The number of times the discount is applied. This field is same as the Discount Quantity field in the Discount Summary report. |
|
Discounted Amt |
The total amount discounted. This field is same as the Discount Amount field in the Discount Summary report. |
Job Code
This report breaks up the transactions according to the job code.
|
Field |
Description |
|---|---|
|
Net Revenue |
The total of all financial activity associated with the sale of unrefunded/undiscounted goods. In other words, net revenue is positive revenue calculated after discounts. Net Revenue = Gross Revenue – Discounts. This field is same as the Net Revenue field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
Tips |
The total tip amount collected. This field displays the tip according to the job code of the employee currently logged in. This field is same as the Tips field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
Gratuity |
The total gratuity earned. This field is similar to the Gratuity field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
Service Charge |
The total service charge earned. This field is same as the Service Charge in the Sales Summary with Revenue Detail Report Grouped By Job Code. |
|
Tips paid out |
The funds removed from the system via the Tip Payout function. The tip payout value is updated only 25 seconds after the Shift Reset function is applied. This field is same as the Tips paid out field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
To be Paid Out |
The sum of tips, gratuity, and service charge minus the tip paid out. This field is same as the Tips Balance field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
# of Checks |
The total number of checks closed. This field is same as the # of Checks field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
# of Covers |
The total number of covers in the closed checks. This field is same as the # of Covers field in the Sales Summary with Revenue Detail Report Grouped By Job Code report. |
|
Grouping Levels |
Sorting Choices |
Filters |
|---|---|---|
|
Profit Center |
None |
Store Check Type Profit Center Meal Period Job Code |