Sales - Accrual report (v2)

Sale Date

Date on which the sale occurred.

Date on which the business transaction or sale activity occurred.

Invoice#

Unique number generated for the transaction.

A unique number generated for the appointment or point of sale transaction.

Guest Name

Name of the guest on the invoice.

Full name of the guest linked to the transaction.

Guest Code

System-generated unique identifier assigned to a guest.

A unique identifier assigned to the guest.

Center Name

Center where the transaction was done.

Name of the center where the business activity was performed.

Item Name

Name of the item sold.

Name of the product or service that was sold to the guest on the invoice.

Item Code

Unique code assigned to the item.

Unique identifier assigned to the item for transaction reference purposes.

Qty

Number of items sold on the invoice.

Number of items sold on the invoice.

Sales (Exc. Tax)

Total item value excluding tax and after applying discounts.

The total sale amount for the transaction, excluding tax amounts.

If a liability like a membership or package is used as apayment type, its redemption value may also be considered.

Tax

Tax applied to the item based on applicable tax rules.

The tax charged to the guest based on applicable regional or item-level tax rules for the sale.

Sales (Inc. Tax)

Total item value including tax.

The total sale amount for the transaction, inclusive of applicable tax. 

If the guest paid using a liability that was already taxed, the system will not add tax again.

Redeemed

Amount redeemed by the guest using a liability such as memberships, packages, or gift cards.

Amount redeemed by the guest using a liability such as memberships, packages, or gift cards.

Collected

The total amount received from the guest using all payment methods, including cash, card, check, or custom-defined modes.

The total amount received from the guest using all payment methods, including cash, card, check, or custom-defined modes.

Due

Unpaid balance amount yet to be received from the guest.

The remaining balance that is yet to be received from the guest for the transaction.

Due = Sales (Inc.Tax) - Collected

Invoice Date

Date the invoice was created.

The date when the invoice was created in the system. This may differ from the sale date depending on when the transaction was recorded.

Receipt #

Receipt number issued when payment for the invoice was completed.

A unique number generated by Zenoti when the invoice was closed after full payment.

For open invoices, the receipt number is zero.

Item Category

The primary category to which the item belongs, such as Service, Product, or Gift card.

The primary category to which the item belongs, such as Service, Product, or Gift card. 

If the item does not have a category defined, it will be marked as 'Not Defined'.

Item Sub Category

Specific subcategory of the item within its category.

A more specific subcategory to which the item belongs. 

This is only applicable to services and products.

Business Unit

Business unit associated with the sale.

Business unit to which the item or transaction belongs.

Item Type

Type of item sold such as Service, Product, Package, Membership, Gift Card, or Prepaid Card.

Type of the item sold in the transaction. Can include types such as Service, Product, Package, Membership, Gift Card, or Prepaid Card.

Discount Name

Name of the discount such as Manual discount, Price adjusted, or Waive off.

The display name or type of the discount that was applied to the item in the invoice. 

Type of discount:

Price adjusted: Sale price is manually adjusted on the invoice

Manual Discount : Discount is manually entered in the Discount field on the POS screen

Waive Off : Membership is waived off

Discount

Discount amount applied on the item that may include discounts from membership and package redemptions.

The total discount amount applied on the invoice. This includes discounts from memberships and package redemptions.

Taxable Redemption

Amount paid for an item using a liability such as a gift card, membership, or prepaid package, that was originally purchased without tax. 

Amount paid for an item using a liability such as a gift card, membership, or prepaid package, that was originally purchased without tax.Tax is applied at the time of redemption.

Non-Taxable Redemption

Amount paid for an item by using a liability that was already taxed at the time of purchase.

Amount paid for an item by using a liability that was already taxed at the time of purchase. No additional tax is applied at redemption.

Sales (Exc Redemption)

Sales value excluding redeemed amounts and taxes.

Total amount payable by the guest excluding any amounts redeemed using liability and taxes

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

Payment Type

Payment method used by the guest.

The payment method used by the guest to pay for the item

Sale Type

Type of transaction such as whether the item was sold, refunded, auto-charged through a membership, or charged as a fee.

The type of transaction that took place. 

It shows whether the item was sold, refunded, auto-charged through a membership, or charged as a fee.

Sale types:

Sale: Item is sold

Refund: A returned transaction, paid back using a prepaid card or refund method

Recurring: An automatic payment triggered by a recurring membership or subscription

Fees: A charge applied for policy-based reasons such as no-show, cancellations, shipping, or membership freezes

Room

Room where the service was performed.

Name of the room where the service was performed.

This is only applicable to services.

Equipment

Equipment used during the service.

Name of the equipment used to perform the service.

This is only applicable to services.

Closed By

Employee who closed the invoice.

Name of the employee who most recently closed the invoice

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

Invoice closed date

Date when the invoice was last closed.

The date when the invoice was last closed in the system.

If an invoice is reopened and closed again, this field is updated with the new date.

Provider

Employee who performed the service.

Name of the employee who performed the service.

This is only applicable to services.

Sold By

Employee credited with the sale.

Name of the employee who made the sale.

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

Invoice Created By

Employee who created the invoice.

Name of the employee who created or generated the invoice in the system.

Invoice Status

Current status of the invoice such as Open, Pending, or Closed.

Current status of the invoice such as Open, Pending, or Closed.

Invoice Notes

Notes or comments added by staff for the invoice.

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

Referral Source

Source from which the guest was referred.

The method or platform through which the guest was referred to the business. It is selected by the front-desk staff while creating the guest profile.

Referred By

Name of the existing guest who made the referral.

Name of the existing guest who referred this new guest.

Member

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

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

First Visit

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

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

Base Invoice#

For refund transactions this is the invoice number of the original sale. For other sale types, this field is blank.

For refund transactions this is the invoice number of the original sale. For other sale types, this field is blank.

Invoice Source

Channel through which the item was purchased.

The channel through which the item or service was purchased.

Price

Original list price of the item before discounts.

List price of the item before any discounts are applied.

Vendor

Supplier from whom the product was procured.

The vendor linked to the product at the center level. This is not related to purchase orders.

The field shows only when Item Type is set to Product. If another Item Type is selected, it shows NA. If multiple vendors are associated to the product, it shows Multiple. If there are no vendors associated, it will display Not Specified..

Brand

Brand name of the product sold.

The brand associated to the product sold.

Service Shop cost

Internal cost incurred to deliver the service.

Predefined cost set for a service in the General tab when the service is created.

The value shown for shop cost in reports is based on the shop cost recorded at the time of appointment creation.

For day packages, the shop cost is split across each service in the package 

Calculation: (Service Price / Total Service Price of Day Package) * Shop Cost Defined at Day Package Level.

In payroll, shop costs are calculated at the end of the pay period. 

However, in this report, shop costs are recorded at the time of appointment creation. As a result, shop costs in the report may not match those in payroll.

Additionally, in payroll, employee shop costs take precedence over service shop costs. Therefore, shop costs in this report may not exactly match payroll and should be used only for estimating expenses.

The shop cost of a service or item on an invoice updates dynamically whenever the quantity changes, until the invoice is closed.

For example, in an invoice, if the shop cost of service S1 is $5 per unit and the quantity is updated to 2, the report will display an updated shop cost of $10.

Gender

Gender of the guest receiving the service.

The gender identity of the guest as recorded during profile creation.

Nationality

Nationality of the guest.

The country of citizenship of the guest.

Bundle name

Name of the bundle that has a collection of products and services.

Name of the bundle that has a collection of products and services. 

If you do not see this column, contact your Zenoti Customer Success Manager.