Item-wise Sales Register

Item-wise Sales Register breaks each Sales Invoice down to its lines: item code and name, item group, quantity, rate, amount and the tax on that line, with the customer, invoice number and date repeated on each row. It answers which products or services actually bring in the money, something the invoice level Sales Register cannot show. A tour company sees which packages sell; a trader sees which item groups move. Because VAT is applied per line through Item Tax Templates, this report also shows which items were charged 13 percent, 5 percent or zero, useful when the IRD questions a rate. The demo shows a Rs 32,000 tour package line with Rs 4,160 VAT on ACC-SINV-2026-00004.

Line amount = Quantity x Rate; Line tax = Amount x Item tax rate; invoice total = Sum of lines + taxes

1. 01Go to Financial Reports > Item-wise Sales Register.
2. 02Set Company, From Date and To Date; optionally Item Group, Item, Customer or Warehouse.
3. 03Read Item Code, Qty, Rate, Amount and the tax columns on each line.
4. 04Group by Item Group using the column menu to see totals per product line.
5. 05Check that zero rated lines are genuine exports or Schedule 1 exempt items.
6. 06Export with Menu > Export for the sales analysis meeting.

Open to see which products or services bring in the sales.

A Pokhara tour package line of Rs 32,000 with Rs 4,160 VAT on invoice ACC-SINV-2026-00004.