ZenotiHelp

Inventory tax report

ZTZenoti Docs Team Updated September 4, 2026 4 min readReference

Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.

Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.

Audience: Inventory manager, finance manager, accounting analyst

The inventory tax report shows tax amounts captured on inventory procurement transactions — taxes recorded on PO receipt and tax-related adjustments. Use this report to reconcile inventory taxes against vendor invoices and as a reference for tax-period reporting.

This is a legacy report available under the classic reporting framework.

Note: Tax components reflect your org's configured tax framework. The CGST / SGST / IGST example below applies to India-GST-enabled organizations; US sales tax, UK / EU VAT, Canada HST, and Australia GST organizations will see different component breakdowns. The columns and groupings adapt to the configured framework.

Note: The cross-reference to Cost of goods report is for total-procurement-cost-with-tax analysis (run both reports for the same period and reconcile).

Data refresh: Real-time on Refresh.

Tax-filing disclaimer: This report supports inventory-tax reconciliation and is suitable as a reference for tax filing. It is not a substitute for an accountant or legal review of regulatory compliance in your jurisdiction.


On this page


Before you begin

  • Tax setup prerequisites — Products must have Tax Group assignments, and tax groups must be configured with rates per applicable tax components, before this report shows meaningful data. See your tax-configuration article (Manage taxes).
  • Enable the report for your organization under Configuration > Reports > List of reports.

Permission: Taxes under View Inventory Reports in the Inventory Manager section of the security role — Required to access the Inventory tax report.

Run the report

  1. Select the center for which you want to run the report.
  2. Navigate to Reports > Inventory.
  3. Select the Tax Details report.
  4. Set the date range and additional filters from the Filter reference.
  5. Click Refresh.

To export the report, click the Excel or CSV icon.

Filter reference

Filter Values Description
Date range From / To dates Filters by procurement date. The exact anchor (PO date, delivery received date, or invoice date) depends on your organization's procurement configuration; confirm with your Zenoti representative before relying on the filter for period-close reconciliation.
Product Type Retail / Consumable / Both Three-state classification: Retail, Consumable, or Both.
Category / Sub-Category Configured Limits to a category.
Vendor Configured vendors Filter by source vendor for procurement transactions.
Tax Group Configured tax groups Filter to a specific tax group.

Column reference

Column Type Description
Date Date The procurement transaction date.
Vendor Text The vendor on the procurement transaction.
Product Code / Name Text The product on the line.
Tax Group Text The tax group assigned to the product.
Tax Rate Percent The aggregate tax rate from the tax group.
Taxable Amount Currency The line value to which tax applied (gross procurement value before tax).
Tax Amount Currency Total tax for the line. For multi-component frameworks (e.g., GST), this is the sum of components.
Tax Component Breakdowns Currency Per-component columns (e.g., CGST / SGST / IGST for India-GST orgs; State Tax / County Tax / City Tax for US-multi-jurisdiction orgs). The exact columns depend on the configured framework.
Total Currency Taxable Amount + Tax Amount.

Tax-by-category and tax-group breakdowns in the live report are surfaced as toggleable views, separate sections, or grouped totals, depending on your configuration. The underlying data is the column set above.

Worked example

A center wants to reconcile India-GST taxes for the month.

  1. Set Date range: 2026-04-01 to 2026-04-30.
  2. Click Refresh.

Sample (3 procurement lines):

Date Vendor Product Tax Group Tax Rate Taxable Amount CGST SGST IGST Tax Amount Total
2026-04-05 Vendor X Shampoo A GST 18% 18% $500 $45 $45 $0 $90 $590
2026-04-12 Vendor Y Hair Oil C GST 18% 18% $800 $0 $0 $144 $144 $944
2026-04-22 Vendor X Conditioner B GST 12% 12% $300 $18 $18 $0 $36 $336

Insight: Vendor X (intrastate) splits tax across CGST/SGST. Vendor Y (interstate) shows IGST instead. April CGST liability: $63; SGST: $63; IGST: $144; combined GST: $270.

Tips

  • Run monthly to support GST/sales-tax filing. Cross-check the total tax against vendor tax invoices.
  • Reconcile vendor tax invoices against PO tax amounts. Mismatches surface when the vendor invoice tax differs from what was recorded at PO receipt.
  • For multi-region orgs, scope the report to one center at a time when the centers operate in different tax jurisdictions; jurisdiction-specific tax groups don't cross-aggregate cleanly.

Troubleshooting

Issue Cause Resolution
Tax columns are blank Products lack Tax Group assignments OR tax groups lack configured rates. Open the product from Inventory > Products and verify its Tax Group assignment; verify tax-group rate configuration.
Tax on Adjustments shows non-zero with no obvious cause A stock adjustment with reversal of tax (e.g., write-off of damaged stock that had recorded tax) was recorded. Inspect the adjustment record. Most stock adjustments do NOT carry tax; verify whether the line refers to a write-off scenario.
Currency mismatch The org has multi-currency vendors and the report displays values in the org's base currency only. Reconcile against vendor invoices in the org's base currency, or scope the report to centers that share the vendor's currency.
Tax data missing for a center The center's tax jurisdiction is not yet configured OR the report scope is org-level (vs. center-level). Verify the center's tax-group configuration, then re-run the report scoped to that center.
Permission denied The user role lacks Taxes under View Inventory Reports. Confirm the role permission.
Was this article helpful?
Your feedback helps us improve our documentation.