# Bill Item Wise Sale
Item-line level sale invoice data with bill header details — one row per item on each sale invoice, with a clickable invoice number for drill-down.
Overview
Go to Sales → Reports → Bill Item Wise Sale.
Report title in ERP: Bill Item Wise Sale
What it shows. Every item line on sale invoices, repeated with the parent bill header — invoice date, number, customer, payment mode, employee in charge, and tax registration. Each row includes item details, quantity, rate, taxable value, tax breakdown, and line total.
When to use it. Use when you need item-level sales detail tied to a specific invoice — for audits, customer bill verification, tax reconciliation, or comparing rates across bills for the same item.
Report view
Filtration — Cancelled / Not Cancelled
Filtration — Employee
Filtration — Date range
Filtration — Item
Use Cases
- Invoice audit — Verify that each customer bill line matches the physical invoice, including quantity, rate, and tax.
- Item rate comparison — Filter by item and date range to see how the selling price varied across different customer invoices.
- Tax compliance review — Export item lines with taxable value and tax amount for VAT/GST filing support.
- Sales accountability — Filter by employee in charge to review sales handled by a specific salesperson or staff member.
Filters
Date, Status (All / Cancelled / Not Cancelled), PayMode, Employee, Item. Advanced Filter: Customer, Customer Group, Branch, Center, Item Group, Brand, Form Type.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Date | Sale invoice date. |
| Inv No. | Invoice number. Click to open the sale invoice. |
| PayMode | Payment mode (Cash, Bank, Credit, etc.). |
| Center | Billing center or branch. |
| InCharge | Employee responsible for the sale. |
| Customer | Customer name. |
| Tax Reg. No | Customer tax registration number. |
| Item Name | Name of the sold item. |
| HSN Code | Harmonized System of Nomenclature code. |
| Item Group | Category the item belongs to. |
| Brand | Brand of the item. |
| Qty | Quantity sold on this line. |
| Unit | Unit of measure. |
| Rate | Price per unit. |
| Taxable Value | Amount subject to tax for the line. |
| Tax Amount | Tax calculated on the line. |
| Total | Line total including tax. |
| Bill Total | Total amount of the parent invoice. |
Actions
- Generate — run the report for the selected filters
- Export / Export All — export to Excel (including Tally format where enabled)
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
- Inv No. link — open the source sale invoice
FAQ
How is this different from Bill Wise Sale?
Bill Wise Sale shows one row per invoice. Bill Item Wise Sale expands each invoice into one row per item line.
Why does Bill Total repeat on every line?
Bill Total is a header field shown alongside each item line so you can see the full invoice value while reviewing individual items.
Can I filter inventory vs service items?
Yes. Use the Item or Item Group filter, or Advanced Filter to narrow by item type.
Are credit notes included?
No. This report covers sale invoices only. Use Sale Return Report for returns and credit notes.
Are cancelled invoices included?
No. Only approved sale invoices in the selected date range appear unless the filter explicitly includes other statuses.
When should I use this vs Item Wise Sale Report?
Use this report when you need bill header fields on every line. Use Item Wise Sale Report for item totals without repeating bill headers.