How to view HSN Code Wise Purchase Tax Report in Adempiere Retail

This report shows how much tax was paid on purchases, grouped by HSN codes (Harmonized System of Nomenclature — product classification codes).

User Access

Who Can Access

• Admin
• Back Office
• Purchase Manager
• Manager

What User Can Do

• Check Tax Paid on Different Product Categories
• Identify High-Value Purchases by Category
• Export and Share Reports

Pre-Requisite Activities

• Maintain Complete Purchase Records
• GST Details Capturing
• Date Range Definition
• User Access and Roles

Business Rules

• HSN Code Validation
• Transaction Date
• User Access
• Data Integrity
• No Negative Value

User Interface

STEP 1: Click Purchase Reports Folder.

STEP 2: Click HSN Code Wise Purchase Tax Report.

STEP 3: Choose Parameter From Date, To Date and Day Wise.

STEP 4: Show Columns Details.
1.Date Invoiced.
2.Tax Name.
3.HSN Code.
4.Purchase Quantity.
5.Taxable Amt.
7.CGST
8.SGST
9.CESS

STEP 5: Click Page Down Button Show Columns Details.
10.Total Amount.
11.HSN Description.

1.Date Invoiced.
The “Date Invoiced” refers to the specific date when an invoice is issued or generated. This date typically marks the point at which a business formally requests payment for goods or services provided. It is an important element for tracking payment terms, due dates, and the overall financial management of a business.

2.Tax Name.
The tax name should accurately reflect the tax regulation or law of the jurisdiction where the transaction occurs. This ensures compliance with local tax laws and helps both businesses and consumers understand the specific taxes being applied.

3.HSN Code.
The HSN code (Harmonized System of Nomenclature) is a standardized international system of names and numbers to classify traded products. The system was developed and is maintained by the World Customs Organization (WCO). It’s used by customs authorities around the world to assess tariffs, taxes, and other regulations related to imported and exported goods.

4.Purchase Quantity.
The purchase order quantity (PO quantity) refers to the amount of a product or material specified in a purchase order (PO) that a buyer requests from a supplier. It represents the number of units of goods or services that the buyer intends to acquire.

5.Taxable Amt.
The term taxable amount refers to the portion of an income or transaction that is subject to taxation by the relevant authorities, after accounting for exemptions, deductions, and other allowances.

7.CGST.
The rate of CGST depends on the GST slabs for different goods and services. The rates are categorized into 0%, 5%, 12%, 18%, and 28%.

8.SGST.
SGST is levied by the state government on the intra-state supply of goods and services (i.e., transactions that occur within the same state).

9.CESS.
The CESS tax refers to an additional levy or surcharge imposed on a specific tax, usually in the form of an additional percentage added to the base tax rate. It is most commonly seen in countries like India, where cess taxes are introduced to fund specific purposes such as education, health, or infrastructure.

10.Total Amount.
To calculate the total amount including tax, you’ll typically follow this formula:
Total Amount = LC Amount + (LC Amount × Tax Rate)

11.HSN Description.
An HSN (Harmonized System of Nomenclature) description refers to the standardized system used internationally to classify products in trade. It’s a coding system developed by the World Customs Organization (WCO) and is widely used by customs authorities and businesses to identify products for import/export purposes.