ZenotiHelp

Sales-Accrual report

ZTZenoti Docs Team Updated October 12, 2026 5 min readReference

The Sales-Accrual report shows revenue on an accrual basis β€” it records revenue at the time of sale, regardless of when the payment is collected. This report is essential for organizations that follow accrual accounting standards and need to recognize revenue when it is earned rather than when cash is received.

Audience: Finance managers and center owners who reconcile accrual-basis revenue.


On this page


Before you begin

Permission: Sales(Accrual) Report under Financial in the Reports(V2) section of the security role β€” required to open this report.

  • Select the centers and date range for the report. You can run the report for a single center or across multiple centers in the organization.

Go to Reports, then search for and select Sales-Accrual.

How the report calculates prices

The Sales-Accrual report uses the price at the time of sale, not the current price. This distinction is critical for understanding the report's values:

  • Standard invoices β€” The report shows the price that was on the invoice when it was created and closed. This is typically the same as the current price unless the price has changed since then.
  • Package redemptions β€” When a guest redeems a service from a package, the accrual report shows the original sale price of that service as configured when the package was sold. If the service price has since been updated, the current price and the accrual price differ.
  • Membership credit redemptions β€” Similar to packages, the accrual value reflects the credit value at the time the membership was sold, not the current service price.
  • Promotional or discounted sales β€” The report shows the actual amount charged to the guest (after discounts), not the list price.

Note: If you see $0 values in the Sales-Accrual report for redeemed services, this typically means the service was part of a package or membership that was sold at a different price (potentially $0 for included benefits). This is expected behavior β€” the accrual report reflects what was economically recognized at the time of the original sale.

Filters

Filter Description
Sale Date The sale date range. Revenue is attributed to the date the sale occurred, not the collection date.
Centers One or more centers to include.
Sale Type Filter by item type: services, products, memberships, packages, gift cards.

Column descriptions

Column Description
Sale Date The date the sale was made (accrual date).
Invoice# The invoice number associated with the sale.
Guest Code The unique code identifying the guest.
Guest Name The name of the guest associated with the sale.
Center Code The unique code identifying the center where the sale occurred.
Center Name The name of the center where the sale occurred.
Item Code The unique code identifying the item sold.
Item Name The service, product, membership, or package sold.
Item Category The category of the item sold.
Qty The quantity of the item sold.
Sales (Exc. Tax) The sale amount, excluding tax, at the price recorded at the time of sale.
Tax The tax amount calculated on the sale.
Sales(Inc. Tax) The total sale amount, including tax.
Redeemed The amount of the sale redeemed against a package, membership, or gift card.
Taxable Redemption The portion of the redemption amount that is taxable.
Non Taxable Redemption The portion of the redemption amount that is not taxable.
Sales (Exc. Redemption) The sale amount excluding any redemption value applied.
Collected The amount collected against the sale.
Due The outstanding balance still due on the sale.
Invoice Closed Date The date the invoice was closed.
Invoice Notes Any notes recorded on the invoice.
Item Subcategory The subcategory of the item sold.
Invoice Source The source through which the invoice was created (for example, front desk or online booking).
First Visit Indicates whether the current invoice is the guest's first invoice. Displays Yes or No. The determination is based on the guest's first invoice regardless of what was purchased β€” for example, if the guest's first invoice is for a gift card, that invoice is counted as the first visit even though no service was booked.
Base Invoice# For refund transactions, displays the invoice number of the original sale. For all other sale types, this field is blank.
Tax redeemed by loyalty points The tax amount paid by the guest through redemption of loyalty points.
Service Shop Cost The shop cost associated with the service on the invoice.

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.

Data freshness and batch processing

The Sales-Accrual report depends on intraday batch processing. Data typically refreshes several times throughout the day, but the exact timing varies. If the batch job fails, several unrelated reports may appear empty at the same time.

Triage rule: If multiple centers and multiple report surfaces all show empty data within the same time window, the cause is almost certainly a platform-level batch condition rather than a configuration problem at your center. Check the platform status page before changing any settings. If only one center or one report is affected, investigate center-specific configuration.

Important: Do not change report settings or center configuration in response to an empty report until you have confirmed that the platform batch is healthy. A configuration change during a batch failure can introduce unintended side effects that persist after the batch recovers.

Export as a diagnostic tool

Clicking Export downloads the full result set matching your current filters as an XLSX or CSV file, regardless of how many rows are visible on screen.

You can use the export as a diagnostic step in its own right: if the report grid appears empty but the exported file contains every expected row, the problem is in the rendering layer β€” not in the underlying data. In that case, the exported file is the usable copy while the rendering issue is investigated. Report the discrepancy to your administrator or Zenoti Support so the display issue can be resolved separately.

Tips

  • Use this report alongside the Accounting report and Collections report for full financial reconciliation. See Reconcile accounting reports for a step-by-step guide.
  • When comparing the Sales-Accrual report to other reports, remember that price differences for package and membership redemptions are expected β€” the accrual report intentionally uses the original sale price.
  • Click Export and use pivot tables to group by sale type or center for trend analysis.
  • Use the First Visit column to identify new-guest revenue in any date range. Because the column reflects the guest's first invoice of any type, and not only service invoices, it gives a complete picture of first-time guest activity.
  • Use the Base Invoice# column to trace refund transactions back to their originating sale. Filter for rows where Base Invoice# is populated to see all refund activity in the selected period.
  • Use the Tax redeemed by loyalty points column to track how much of the tax liability was offset by loyalty point redemptions. This is useful when reconciling net tax collected against loyalty program activity.
Was this article helpful?
Your feedback helps us improve our documentation.