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.

A screenshot of a report

Description automatically generated

A screenshot of a report

Description automatically generated

A close-up of a number

Description automatically generated

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