Sales Tax report
The Sales Tax report shows the sales tax charged to guests on the sale date (accrual basis) across services, products, and liabilities -- a comprehensive view for tax accounting and compliance.
Before you begin
- Services are recorded based on the date of performance; non-service items are recorded based on the invoice creation date.
Permission: Sales Tax Report under Financial in the Reports(V2) section of the security role β required to open this report.
Navigation: Open the Reports dashboard, type the report name in Search Report, and select Sales Tax.
Report details
| Aspect | Detail |
|---|---|
| Purpose | Analyze sales tax on services, products, and liabilities for accounting and compliance |
| Filters | Date range, Center, Item type, Payment type, Invoice status |
| View scope | Center, Organization |
Loyalty point handling
Zenoti allows loyalty point (LP) redemptions to be treated as non-taxable redemptions. When configured this way, the LP portion of a sale is excluded from tax calculations, similar to a discount.
For example, a guest pays for a $100 service using $20 worth of loyalty points. If LPs are non-taxable, tax is calculated only on $80. LP redemptions then sit in the discount totals rather than in Sales (excl. Tax).
This feature is off by default. Contact your Customer Success Manager to enable it. It applies only to businesses that have enabled the Pre-tax amount configuration for loyalty points (Organization > Loyalty program > Loyalty settings).
Columns
| Column | Description |
|---|---|
| Invoice# | Unique number generated for the appointment or POS entry. |
| Sale Date | Date the payment was made or a liability instrument was redeemed. |
| Center Code | Short code identifying the center where the transaction was performed. |
| Center Name | Center where the transaction was performed. |
| Item Name | Name of the item sold on the invoice. |
| Item Category Code | Short code identifying the category of the item sold. |
| Item Category | Category of the item (Service, Product, etc.). If the item has no category (for example, a gift card), this column shows "Not Defined." |
| Sales | Total amount charged for the item including tax. When redemption is selected as the payment type, this column also shows the redemption as a sale. |
| Taxable Amount | Portion of the sale subject to tax. If the item was paid using a redemption and the liability was purchased without tax, the sale amount is taxable. If the liability was purchased with tax, the entire sale amount becomes non-taxable and this column shows zero. For partial cash + liability payments, the taxable amount is calculated proportionally. |
| Non-Taxable Amount | Portion of the sale exempt from tax. If the item was paid using a tax-paid liability, the entire amount is non-taxable. For partial cash + liability payments, the non-taxable amount is calculated proportionally. |
| Total Tax | Total tax payable on the item. Total Tax = Taxable Amount x Tax rate. |
| Receipt# | Receipt number issued when the invoice was closed. Open invoices show 0. |
| Item Code | Unique identifier for the item. |
| Taxable Amount Exempted | Portion of the taxable amount exempted due to the invoice's exemption status. When an invoice is tax-exempted, this value matches the Non-Taxable Amount. |
| Amount Paid | Total amount paid by the guest toward the invoice. |
| Invoice Status | Open or Closed. |
| Payment Type | Payment method used (cash, card, etc.). |
| Tax redeemed by loyalty points | Tax paid through loyalty point redemption. Visible only when tax-inclusive pricing is enabled. |
| Tax redeemed by gift card | Tax paid through gift card redemption. Visible only when tax-inclusive pricing is enabled. |
Membership revenue recognition (IRR/MRR/SCR)
When the organization-level Include membership IRR, MRR, and SCR values in reports setting (Configuration > Reports) is enabled, this report's redemption, sales, and collection calculations use the Initial Revenue Recognition (IRR), Monthly Revenue Recognition (MRR), and Service Credit Revenue (SCR) values defined in membership settings. This is disabled by default.
When enabled, if the setting's Value checkbox is not selected, the Value column (left side) and Sales Realized column (right side) are not shown in this report.
Tips
- For redemption-payment items where the liability was bought tax-paid, expect Taxable Amount to be zero and the entire sale to appear under Non-Taxable Amount.