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)
|