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