Understanding your sales report
A guide to understanding your sales report
Chris avatar
Written by Chris
Updated over a week ago

We have recently updated the way our sales report is displayed to ensure consistency across all platforms. Here is a guide to help you understand your sales report.

Sample sales report

Term used

Definition

Calculation

Gross sales

Sum of all your product and modifier's original price excluding GST

If your product price is $10.00 and you are GST exclusive, the Gross sale amount will be $10.00

If your product price is $10.00 and you are GST inclusive, the Gross sale amount will be

$10/1.07 = $9.35

Total Discount Given

Sum of all item level and bill level discount

If you have a $2 discount on your product and your total bill discount is an additional $5, your total discount given will be

$2 + $5 = $7

Total Service Fee

Sum of all transactions' service fee

*Do note that service fee is only applicable for Dine in transactions. If you have a takeaway product on your Dine in transaction, that product will be excluded from your service fee calculation.

i.e

Product A = $10

Product B (Takeaway) = $5

Service fee will only be on product A which will be $10 x 10% = $1.00

Net Sales

Net sales is the sum of gross sales and service fee minus discounts including

Net sales = Gross sale - Total discount + service fee

As in the example report above:

$18.50 (Gross sale) - $3.65 (Total discount given) + $1.49 (service fee) = $16.34 (Net sales)

Total GST

Sum of all transactions' GST.

*The transaction GST (for both exclusive and inclusive) is stated on the receipt and transaction record

Total Redeemed Point Amount

Total point value redeemed by customers.

*Only for users with Loyalty points enabled

For example a customer uses 20 points to redeem $2 to pay for their total bill. The redeemed point amount will be $2

Total Cash Rounding

For cash payments only.

For Singapore users, all cash rounding will be a negative value as system will round down total payable to closest 5 cents.

For Malaysia users, cash rounding can be positive or negative value as system will round up or down total payable to closest 5 cents.

For example a total bill of $50.02. The customer pays with cash, the system will automatically round down the total amount to $50.00.

Total cash rounding in this case is -$0.02

Total Sales

Total sales is the sum of nets sales and Total GST minus Total redeemed point amount and total cash rounding.

Total sales = Net sales + Total GST - Total redeemed point amount - total cash rounding

*Total sales should equal your total settlement IF the user does not have Credits and Packages sold. Total sales also does not include tipping amount.

As in the example report above:

$16.34 (Net sale) + $1.14 (Total GST) - $2.00 (total redeemed point amount) - $0 (Cash rounding) = $15.48 (Total sales)

Did this answer your question?