Sales

Item Price List

A list of all products with their selling/purchase prices

Definition

An item price list is a structured record of all products or goods in a business along with their associated selling prices, purchase prices, MRP (Maximum Retail Price), and sometimes wholesale or dealer prices. It serves as a quick reference for sales staff, distributors, and customers, ensuring consistent pricing across all transactions. In Indian businesses, maintaining an accurate price list is particularly important because of GST — the selling price determines the taxable value, and any mismatch between the price list and invoiced amount can lead to discrepancies during GST audits. A well-maintained price list also includes details like HSN code, unit of measurement, applicable GST rate, and any trade discounts. For businesses dealing with multiple customer segments — such as retail, wholesale, and distributor — separate price tiers may exist within the same price list. Price lists need regular updates to reflect changes in raw material costs, supplier pricing, government taxes, or market competition. Indian businesses in sectors like FMCG, hardware, auto parts, and textiles often share printed or digital price lists with their dealers and distributors at the start of each quarter or financial year.

How It Works

  1. 1You add each item to the system with its purchase price, selling price, MRP, and applicable GST rate. You can also define multiple price tiers for retail, wholesale, and distributor customers.
  2. 2When creating a sales or purchase invoice, the system automatically picks the correct price from the price list based on the selected item and customer type, reducing manual entry and errors.
  3. 3If a supplier increases the purchase price, you update the price list once, and all future transactions automatically use the new rate. Historical invoices remain unchanged for audit accuracy.
  4. 4You can generate and export the complete price list as a PDF or Excel file to share with your sales team, dealers, or distributors, ensuring everyone works with the latest prices.

Example

Meena runs a stationery wholesale business in Chennai. She maintains a price list for her top products: Classmate Notebook (200 pages) — Purchase Price: Rs. 45, Selling Price (Retail): Rs. 60, Selling Price (Wholesale): Rs. 52, MRP: Rs. 65, GST: 12%. Cello Butterflow Pen (pack of 10) — Purchase Price: Rs. 68, Selling Price (Retail): Rs. 90, Selling Price (Wholesale): Rs. 78, MRP: Rs. 100, GST: 18%. When her salesman creates a sales invoice in Stock Register, the selling price auto-fills based on whether the customer is a retail or wholesale buyer, ensuring the correct rate and GST are applied every time. This avoids manual errors and maintains her margins at 15-20%.

How Stock Register Handles This

  • Maintain a centralised price list with purchase price, selling price, MRP, and GST rate for every item — accessible to your entire team
  • Auto-fill prices in sales and purchase invoices based on the item selected, eliminating manual data entry and pricing errors
  • Export your complete item price list as a PDF or Excel report to share with dealers, distributors, or sales representatives
  • Track price changes over time and analyse how purchase price fluctuations impact your selling margins

Related Terms

Related Guides

Frequently Asked Questions

Can I set different selling prices for different customers?

Yes, in Stock Register you can define multiple price tiers — such as retail price, wholesale price, and distributor price — for each item. When you create a sales invoice, the system picks the appropriate price based on the customer type or price tier assigned to that party, ensuring consistent and accurate pricing across all your sales channels.

How does the item price list help with GST compliance?

The item price list stores the HSN code and GST rate for each product. When you create an invoice, these details are automatically applied, ensuring the correct tax is charged. This reduces the risk of GST mismatches during filing and makes it easier to reconcile your GSTR-1 and GSTR-3B with your actual sales data.

What happens to old invoices when I update a price in the price list?

Updating the price list only affects future transactions. All previously created invoices retain the price at which the transaction was originally recorded. This ensures your historical records remain accurate for audit purposes and comply with GST regulations, which require invoices to reflect the actual transaction value at the time of sale.

Ready to Get Started?

Manage inventory, billing, and accounting effortlessly.