Sales - Accrual report (v2)

Sale Date

Date on which the business activity was performed

Invoice#

Number generated for the appointment or point of sale entry

Guest Name

Name of the guest on the invoice

Guest Code

Unique identifier of the guest

Center Name

Name of the center where the business activity was performed

Item Name

Name of the item that was sold on the invoice

Item Code

Unique identifier of the item

Qty

Number of items sold on the invoice

Sales (Exc.Tax)

Total amount payable by the guest

While generating the report, you can see the redemption amount as sale if you selected a liability as the payment type.

If the redemption is through non-taxable loyalty points (LPs), then the LP portion is excluded from Sales (Exc. Tax) and appears under Discount.

Tax

Tax levied on the guest for purchasing the item

Sales (Inc.tax)

Total amount payable by the guest including tax

If the item was paid using liability and the liability was purchased at a taxed price, the guest will not be levied with another tax to purchase the item. In this case, the tax is zero.

Redeemed

Amount redeemed by the guest using a liability

Collected

Amount paid by the guest by using cash, card, check, or custom (financial or non-financial) payment types

Due

Amount that is yet to be received from the guest

Due = Sales (Inc.Tax) - Collected

Invoice Date

Date on which the invoice was created

Receipt#

Number generated by Zenoti when the invoice was closed after full payment

For open invoices, the receipt number is 0.

Item Category

Category of the item

If the item, does not have a category defined, you will see Not Defined in this column.

Item Subcategory

Subcategory to which the item belongs

This column is applicable to only services and products.

Business Unit

Business unit to which the item belongs

Item Type

Type of the item: Service, Product, Packages, Membership, Gift Card, or Prepaid Card

Discount Name

Name and type of the discount that is applied on the invoice

For LP redemptions treated as non-taxable, the applied discount name appears here, helping track such redemptions along with other discounts.

Discount

Amount of discount applied on the invoice including membership and package redemptions.

If loyalty points are configured as non-taxable, the LP redemption amount is also included in this column, treated similarly to other discount types. This ensures LPs do not contribute to the tax calculation.

Taxable Redemption

Amount paid for an item using a liability that was purchased without tax

Example: A $100 item with a tax of $10 was purchased using two gift cards. $40 was paid using a gift card (purchased with tax) and $60 was paid using another gift card (purchased without tax). The taxable redemption is $60.

Non-Taxable Redemption

Amount paid for an item by using a liability that was purchased with tax

Example: A $100 item with a tax of $10 was purchased using two gift cards. $40 was paid using a gift card (purchased with tax) and $60 was paid using another gift card (purchased without tax). The non-taxable redemption is $40.

Sales(Exc. Redemption)

Total amount payable by guest excluding redemptions

Sales(Exc. Redemption) = Sales(Exc. Tax) - Taxable Redemption - Non Taxable Redemption

Payment Type

Payment option that was used to pay for the item

Sale Type

Room

Name of the room in which the service was performed

This column is applicable to only services.

Equipment

Name of the equipment that was used to perform the service

This column is applicable to only services.

Closed By

Name of the employee who last closed the invoice

If the invoice is reopened and closed, this column is updated with the new employee's name.

Invoice Closed Date

Date on which the invoice was last closed

If the invoice is reopened and closed, this column is updated with the new date.

Provider

Name of the employee who performed the service

This column is applicable to only services.

Sold By

Name of the employee that was selected by the front-desk staff during the sale

If the commissions are split, you can see multiple employee names separated by a comma.

Created By

Name of the employee who created the invoice

Status

Current status of the invoice

Invoice Notes

Helpful suggestions or comments about the guest or transaction added by the front-desk staff for the invoice

Referral Source

Referral source selected by the front-desk staff while creating the guest profile

Example: If the guest has visited after seeing an advertisement, you can see Advertisement in this column.

Referred By

Name of the existing guest who referred this guest

Member

Indicates if the guest has an active membership with a Yes or No

First Visit

Indicates if this visit was the guest’s first visit with a Yes or a No

Base Invoice#

For refunds, this number is the invoice on which the item was sold. For other sale types, this column is blank.

Invoice Source

Source from which the item was bought

Price

List price of the item

Vendor

The vendor associated to the product at the center level. It is unrelated to the purchase order. This field is only displayed if the Item Type is filtered by Product. If another Item Type is selected, it will display NA. If multiple vendors are associated to the product, it will display Multiple. If there are no vendors associated, it will display Not Specified.

Brand

The brand associated to the product.

Service shop cost

Predefined expense for a specific service configured from the General tab while creating services.

Gender

Gender identity of the guest.

Nationality

Guest's country of citizenship.

Bundle name

Name of the bundle that has a collection of products and services. If you do not see this column, please contact your Zenoti Customer Success Manager.

PAN provided?

Indicates whether the guest has submitted their Permanent Account Number (PAN) details.