See the exact profit or loss on every sold jewelry piece. Cost in, price out, and net PnL per barcode with full transaction traceability and date range filtering.
Knowing your total sales figure tells you what came in. Knowing your total purchase cost tells you what went out. But knowing the profit or loss on every individual piece of jewelry you have sold — at the barcode level — tells you which items are actually making you money and which are not. EasyJewelry's Making PnL by Barcode report does exactly this, comparing the cost of every item when it entered your jewelry inventory against the price it sold for, and calculating the net profit or loss per piece with full transaction references linked directly to the source records.
The report covers every sold barcode-tagged item and shows the complete financial picture for each one. The In Type column shows how the piece entered your inventory — Metal Purchase, Metal Exchange, or Metal Opening. The In ID and Invoice ID link directly to the source transaction records so you can trace exactly where the piece came from and where it went. Cost is what was paid to acquire it. Price is what it sold for. PnL is the difference. A positive PnL means the piece was profitable. A negative PnL means it was sold at a loss. The date range filter lets you run the report for any period, giving you profitability visibility by day, week, month, or any custom range in your jewelry ERP software.
Every column in the report has a specific role in understanding the profitability of each individual jewelry piece sold.
The unique barcode of the piece and the item code that identifies what type of piece it is. Together these give you item-level granularity — not just which category sold profitably but which specific piece.
How the piece entered your jewelry inventory — Metal Purchase, Metal Exchange, or Metal Opening. This tells you the origin of the piece, which is useful when analyzing whether pieces from certain sources are more or less profitable than others.
Clickable references to the source transaction that brought the piece in and the sales invoice it left on. This makes the report fully traceable — you can jump directly to the purchase record or the sales invoice for any piece showing an unexpected profit or loss.
Quantity in pieces, gross weight in grams, and pure weight in grams. The weight columns let you understand the metal content of each piece alongside its financial performance, which is important for making charge analysis in your jewelry management software.
What the piece cost your business when it entered inventory — the purchase price, exchange value, or opening balance cost. This is the denominator in the profitability calculation and reflects what you actually paid to acquire the metal and the piece.
What the piece sold for on the sales invoice, including the making charge. This is the revenue figure for that specific piece at the time it left your jewelry inventory system.
Price minus Cost. A positive figure is profit. A negative figure is a loss. The PnL column is the bottom line for every individual piece your jewelry business has sold, calculated automatically from the transaction records in EasyJewelry.
In most jewelry businesses, profitability is tracked at the total level — total sales minus total cost of goods. This tells you whether the business is profitable overall but it tells you nothing about which items are driving that profit and which are eroding it. A jewelry store that sells 200 pieces a month might have 40 pieces that account for 90 percent of the profit while 160 pieces are breaking even or losing money.
The Making PnL by Barcode report in EasyJewelry exposes this at the individual piece level. You can see which item codes are consistently profitable, which In Types produce the best margins, and which specific pieces sold at a loss — and then trace those losses directly back to the purchase or exchange that set the cost basis too high.
For jewelry retailers and wholesalers managing making charges as a revenue component, this report is particularly important. Making charges are the profit margin on top of the metal cost in jewelry retail. A piece with a high making charge that sells quickly is your most profitable item type. A piece with a low making charge that sits for months and eventually sells close to cost is a problem. The PnL report quantifies both situations precisely, giving your jewelry inventory management software real analytical power beyond just stock tracking.
Understand which pieces and item types are actually profitable. Use the PnL data to inform buying decisions, making charge adjustments, and promotional pricing for slow-moving items.
Analyze profitability by In Type to see whether pieces from Metal Purchases versus Metal Exchanges generate different margins. Identify which source transactions produce the most profitable inventory.
Run the report for any date range to see profitability by period. Compare month-on-month PnL trends and identify whether margins are improving or declining across your jewelry business.
Review PnL data per branch to understand which locations are generating the best margins and which need pricing or buying strategy adjustments.
The cost is pulled from the transaction that brought the piece into your jewelry inventory — the purchase price on the metal purchase bill, the valuation on the exchange record, or the cost set on the opening balance. This is the actual cost basis for that specific barcode.
The price is the amount the piece sold for on the sales invoice in EasyJewelry, including the making charge applied at the time of sale. The Invoice ID column links directly to that invoice.
Yes. The date range filter at the top of the report lets you set a From and To date and filter to show only pieces that sold within that period. This gives you period-specific profitability visibility.
A negative PnL means the piece was sold for less than it cost to acquire. This can happen when a piece is discounted below cost, when a return adjustment affects the final price, or when the cost basis was set too high relative to the market rate at the time of sale.
Yes. The full report exports to CSV, Excel, and PDF with all columns included. It can also be printed directly from the screen, making it suitable for formal management reviews and investor reporting.
Total revenue and total cost are useful numbers. But the Making PnL by Barcode report gives you something more powerful — the profit or loss on every individual piece your jewelry business has sold, with full traceability back to the source transaction. This is the kind of item-level financial intelligence that separates businesses that know they are profitable from businesses that know exactly why they are profitable and which items are driving that result.
