Inventory tax report
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
- Run the report
- Filter reference
- Column reference
- Worked example
- Tips
- Troubleshooting
- Related articles
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
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory.
- Select the Tax Details report.
- Set the date range and additional filters from the Filter reference.
- 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.
- Set Date range: 2026-04-01 to 2026-04-30.
- 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. |