# Bill Item Wise Profit Report

Item-line profit analysis — sale value, cost, profit amount, and profit percentage for each item line on every sale invoice.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Sales → Profit Report → Bill Item Wise Profit Report. Report title in ERP: Bill Item Wise Profit Report

What it shows. Each item line on sale invoices with sale amount, actual cost, profit amount, profit percentage, and bill header details. Loss lines appear on a pink label.

When to use it. Use for granular profit analysis at the item line level — more detailed than Bill Wise Profit Report.

How amounts are calculated. Profit = Sale amount minus actual cost per item line. Actual cost comes from the inventory costing method.

Returns. This report reads sale invoice item lines only—returns (credit notes) are not netted here. For margin after returns, use the Item Wise Profit Report (net profit) or Bill Wise Profit Report (return amount/cost per bill).

Use Cases

Filters

Date, Customer, Employee, Item. Advanced Filter: Item Group, Brand, Branch, Center, Sort By (Date, Profit, Loss, Profit%, Loss%).

Columns

| **Column** | **Description** | |------------|-----------------| | Date | Sale invoice date. | | Inv No. | Invoice number. Click to open. | | Customer | Customer name. | | Item Name | Item on the line. | | Qty | Quantity sold. | | Sale Amount | Line sale value. | | Actual Cost | Inventory cost for the line. | | Profit Amount | Sale Amount minus Actual Cost. | | Profit % | Profit as percentage of sale amount. | | Bill Total | Parent invoice total. |

Actions

FAQ

How is this different from Bill Wise Profit Report?
Bill Wise Profit Report shows one row per invoice. This report expands each invoice into item-line profit detail.

Why are some lines pink?
Pink labels indicate a loss — sale amount is less than actual cost.

Where does actual cost come from?
From the inventory costing method (FIFO, average, etc.) at the time of sale.

Do I need special permission?
Yes. Your user role must include access to profit reports.

Why is line profit negative?
Discount, under-cost sale, or missing estimated margin on the item. Check Estimated Cost Margin.

Are returns deducted here?
No. This report shows sale invoice item-line profit only; credit notes/returns are not netted. Use the Item Wise or Bill Wise Profit Report for margin after returns.

How is this different from Bill Wise Profit?
Bill Wise Profit Report is header total. This report is line-level on each invoice.