How to view HSN Code Wise GST Bill Report in Adempiere Retail

An HSN Code-wise GST Bill Report is a detailed summary of all GST invoices (bills), grouped and categorised by HSN codes, showing the sales value, taxable amount, and GST (CGST, SGST, IGST) collected for each type of product or service.

User Access

Who Can Access

  • Admin
  • Back Office
  • Purchase Manager
  • Manager

What User Can Do

  • View GST Collected by Product Type
  • Verify GST Rates
  • Track Sales by Product Category
  • Export and Share the Report

Pre-Requisite Activities

  • Assign HSN Codes to All Products/Services
  • GST Rates for Each HSN Code
  • Update Customer Details with GSTIN and State
  • Reporting Period (Date Range)

Business Rules

  • GST Rate Mapping
  • Taxable Value Calculation
  • HSN Summary Reporting
  • Sales Returns and Credit Notes Handling

User Interface

STEP 1: To select a HSN Code Wise GST Bill Report.

Tenthplanet-ADempiere-HSN Code Wise GST Bill Report

STEP 2: To enter a date invoiced in this field is mandatory.And then to click the start check box to run the process.

Tenthplanet-ADempiere-HSN Code Wise GST Bill Report-1

STEP 3: Once to complete the process to show the report based on the given data.

Tenthplanet-ADempiere-HSN Code Wise GST Bill Report-2
TenthPlanet-ADempiere-HSN-Code-Wise-GST-Bill-Report-3
Tenthplanet-ADempiere-HSN Code Wise GST Bill Report-4
Tenthplanet-ADempiere-HSN Code Wise GST Bill Report-5

STEP 4: Invoice number-is a unique identifier assigned to an invoice, which helps businesses keep track of transactions. It is usually a sequential or randomized number that distinguishes one invoice from another.

Invoice date– is the date on which the invoice is issued or generated. It represents when the transaction was officially documented, and it serves as the reference point for payment terms, due dates, and accounting purposes.

Customer– is an individual or organization that purchases goods or services from a business or company. Customers are the primary drivers of a company’s revenue, and their needs, preferences, and behaviors significantly influence business strategies and decisions.

GST number (Goods and Services Tax number) is a unique identification number assigned to businesses and entities that are registered under the Goods and Services Tax (GST) system in countries like India.

HSN code– (Harmonized System of Nomenclature) is a globally standardized system used to classify goods in international trade. Developed by the World Customs Organization (WCO), it is used to identify products in a systematic way for customs purposes, ensuring uniformity in the classification of goods across different countries.

HSN (Harmonized System of Nomenclature) description -refers to the detailed description or classification of goods based on a standardized international system.

Quantity– refers to the amount or number of units of a product or item. It is a fundamental measurement used in various contexts, including trade, inventory management, manufacturing, and everyday transactions.

Sale value 0,5,12,18,28– refers to the amount of money for which an item or service is sold. It is the price at which a transaction takes place between a buyer and a seller.

Total amount-generally refers to the sum or aggregate of various individual components. Its specific meaning depends on the context in which it’s used.

CGST 0,5,12,18,28 (Central Goods and Services Tax)- CGST is the tax levied by the Central Government on the supply of goods and services within a single state.

SGST 0,5,12,18,28 -(State Goods and Services Tax)- SGST is the tax levied by the State Government on the supply of goods and services within a single state.

IGST 0,5,12,18,28 (Integrated Goods and Services Tax)- IGST is the tax levied by the Central Government on inter-state transactions, i.e., when goods or services are supplied from one state to another. – IGST is used to ensure seamless flow of credit between states.

Cess is a type of tax or levy that is imposed on top of other taxes, usually for a specific purpose. It is typically earmar0.16ked for a particular fund or project, such as education, healthcare, or infrastructure development.