ZenotiHelp

Monthly Finance Summery Consolidated

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Consolidated summary table storing monthly financial metrics per center including ticket counts, sales figures, discounts, refunds, and appointment statistics.

Columns

Column Name Data Type Nullable Description
center name VARCHAR(256) YES Name of the center. Sourced from DimCenter.center_name.
zone name VARCHAR(256) YES Name of the zone. Sourced from DimZone.zone_name.
organization account name VARCHAR(256) YES Account name of the organization. Sourced from DimOrganization.organization_account_name.
dt DATE YES Reporting date for the financial summary.
invoicece source VARCHAR(256) YES Source of the invoice (e.g., Center, Online).
employee hours FLOAT YES Total employee hours worked.
male tickets INTEGER YES Number of tickets for male guests.
female tickets INTEGER YES Number of tickets for female guests.
unkonwn tickets INTEGER YES Number of tickets for guests with unknown gender.
total tickets INTEGER YES Total number of tickets across all genders.
total guest visits INTEGER YES Total number of guest visits.
new guest tickets INTEGER YES Number of tickets for new guests.
new guest visits INTEGER YES Number of visits by new guests.
service sales FLOAT YES Total service sales revenue.
service discount FLOAT YES Total discount applied to services.
service refund value FLOAT YES Total refund value for services.
product sales FLOAT YES Total product sales revenue.
product discount FLOAT YES Total discount applied to products.
product refund value FLOAT YES Total refund value for products.
gift card sales FLOAT YES Total gift card sales revenue.
gift card discount FLOAT YES Total discount applied to gift cards.
gift card refund value FLOAT YES Total refund value for gift cards.
day package sales FLOAT YES Total day package sales revenue.
day package discount FLOAT YES Total discount applied to day packages.
day package refund value FLOAT YES Total refund value for day packages.
membership sales FLOAT YES Total membership sales revenue.
membership discount FLOAT YES Total discount applied to memberships.
membership refund value FLOAT YES Total refund value for memberships.
package sales FLOAT YES Total package sales revenue.
package discount FLOAT YES Total discount applied to packages.
package refund value FLOAT YES Total refund value for packages.
total sales FLOAT YES Grand total of all sales.
total tax FLOAT YES Total tax collected.
total discount FLOAT YES Grand total of all discounts applied.
delete app count INTEGER YES Count of deleted appointments.
redo app count INTEGER YES Count of redo appointments.
look and walk app count INTEGER YES Count of look-and-walk (walk-in) appointments.
cuts app count INTEGER YES Count of cuts appointments.
cash added FLOAT YES Total cash added to registers.
cash paid FLOAT YES Total cash paid out from registers.
Production Hours FLOAT YES Total production hours recorded.
male tickets excluding cn INTEGER YES Male ticket count excluding credit notes.
female tickets excluding cn INTEGER YES Female ticket count excluding credit notes.
unknown tickets excluding cn INTEGER YES Unknown gender ticket count excluding credit notes.
new guest tickets excluding cn INTEGER YES New guest ticket count excluding credit notes.
new guest visit excluding cn INTEGER YES New guest visit count excluding credit notes.
total tickets excluding cn INTEGER YES Total ticket count excluding credit notes.
total guest visits excluding cn INTEGER YES Total guest visit count excluding credit notes.
redo source app count INTEGER YES Count of redo source appointments.
service sales excluding cn FLOAT YES Service sales excluding credit notes.
service discount excluding cn FLOAT YES Service discount excluding credit notes.
total sales excluding cn FLOAT YES Total sales excluding credit notes.
total tax excluding cn FLOAT YES Total tax excluding credit notes.
total discount excluding cn FLOAT YES Total discount excluding credit notes.
giftcard value FLOAT YES Total gift card redemption value.
loyalty point redemption amount FLOAT YES Total loyalty point redemption amount.
loyalty point redemption amount CN FLOAT YES Loyalty point redemption amount on credit notes.

Primary Key

No explicit primary key defined. Composite of dt, center name, and invoicece source uniquely identifies a record.

Foreign Keys

  • center name references DimCenter
  • zone name references DimZone
  • organization account name references DimOrganization

Enumerator Values

Column Name Known Values
invoicece source Invoice source values (e.g., Center, Online)

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.