Sales Invoice - Details
📋 Sales Invoice – Details Report
The Sales Invoice – Details Report offers a line-by-line breakdown of each sales invoice generated within your ERP system. Unlike summary reports, this report includes detailed product/service-level data, such as quantity, rate, tax, discount, and total for every item listed in an invoice. It helps users analyze sales activity at a granular level, track individual product performance, and ensure invoice-level accuracy.
✅ Purpose of the Report
-
To display detailed item-wise information from all sales invoices.
-
To analyze what products/services are being sold, in what quantity, and at what price.
-
To support GST/tax reporting with accurate line-level data.
-
To validate billing accuracy and detect anomalies or errors.
📌 Key Data Fields
| Field | Description |
|---|---|
| Invoice Number | Unique ID of the sales invoice. |
| Invoice Date | Date the invoice was generated. |
| Customer Name / Code | Customer to whom the invoice was issued. |
| Item / Product Name | Name of the product or service billed. |
| Item Code / SKU | Stock Keeping Unit or product ID. |
| HSN/SAC Code | Applicable tax code for goods/services (for GST compliance). |
| Quantity | Number of units sold. |
| Rate | Unit selling price. |
| Discount | Discount applied per line (flat or percentage). |
| Tax (%) | GST/IGST/CGST/SGST percentage. |
| Tax Amount | Computed tax value for the line item. |
| Line Total | Total amount for the item (after discount + tax). |
| Invoice Total | Grand total for the entire invoice. |
| Salesperson / Branch | Sales rep or location responsible for the transaction. |
| Payment Status | Paid, Unpaid, Partially Paid. |
📆 Filter & Search Options
-
Date Range (Invoice Date)
-
Customer Name or ID
-
Product / SKU / HSN Code
-
Invoice Number
-
Salesperson / Branch
-
Payment Status (Paid / Unpaid / Partially Paid)
-
GST Type (B2B / B2C / Export)
🧾 Sample Entry
| Invoice No | Date | Customer | Item Name | Qty | Rate | Tax % | Tax Amt | Line Total |
|---|---|---|---|---|---|---|---|---|
| INV-10045 | 05-Aug-2025 | XYZ Traders | Product A | 5 | ₹500 | 18% | ₹450 | ₹2,950 |
📈 Use Cases
-
Sales Teams: Analyze best-selling products, identify demand patterns.
-
Accounts Department: Reconcile invoices with payments and ledger entries.
-
Tax Consultants: Generate GST-compliant reports with line-level accuracy.
-
Management: Review pricing, discount trends, and margin insights.
📎 Benefits
-
Ensures accuracy in billing and taxation.
-
Provides complete transparency of what was sold and how.
-
Assists in resolving invoice disputes or mismatches.
-
Enables deep sales and profitability analysis.
📤 Export Options
-
Export as Excel, PDF, or CSV.
-
Print full invoice detail reports for review or audit.
🔐 Access Control
-
Accessible by roles such as Sales Admin, Accountant, and Management.
-
Sensitive fields like discounts and margins can be access-controlled.