On this page
5.23Why the profit figure changes: cost method, free goods, batches
"Last month's profit was Rs 82,000. Today the same report says Rs 79,500." Nothing was edited. The cost of goods depends on the method in Calculate Cost as per, and some methods look at today's purchases.
| Calculate Cost as per | Cost of one piece is | Good to know |
|---|---|---|
| Last Purchase Rate (Bill Wise Profit) | The latest purchase line of that item and batch: taxable value ÷ (qty + free). | Uses the latest purchase up to today, even for an old bill. A new purchase changes old months. |
| Average Purchase Price | The average of your purchases of the item and batch. | Moves slowly; good for comparing months. |
| PurchasePrice | The Purchase Price saved on the batch. | Only as right as that field. |
| Opening Stock Value / Qty | The batch's opening value ÷ opening quantity. | For stock carried from last year. |
| SalePrice, Basic Price, Minimum Sale Rate, SelfVal | That price of the batch. | Not your cost; use only for special checks. |
The report opens with a method taken from your stock valuation setting (6.9). Do not trust the method shown when the report opens: press Search and look at Calculate Cost as per before you read any figure. Item Wise Profit and Daily Profit have a shorter list with the same ideas (there it is called Last Purchase Price). Pick one method, write it on the printout, and use it every month.
Free goods lower your real cost. With Last Purchase Rate the free quantity of the purchase line is counted: a 10 + 1 scheme at Rs 100 costs 1,000 ÷ 11 = Rs 90.91 a piece. This works only when the free piece is typed in the Free column of the purchase (Chapter 9).
Two batches, two profits. Item Wise Profit makes one line per item and batch, so a new, costlier batch sold at the old rate shows as a separate line with a minus profit. The batch number is not printed; tell the lines apart by the Cost column.
Read every step in the guide: Sale Billing, section 5.23
Questions and answers
Last month's profit is different today. Did someone change a bill?
Usually not. With Last Purchase Rate the cost of old bills follows your latest purchase. Use Average Purchase Price and keep the same method every month (5.23).
Bill Wise Profit shows 25% and Item Wise Profit shows 20% for the same sale. Which is right?
Both. Bill Wise shows profit on cost (markup), Item Wise shows profit on sale (margin). Rs 20 on a Rs 80 cost is 25% markup and 20% margin.
How much profit did I make today, and why does it differ from Margin Leak?
Ctrl+Shift+P says "cost missing on 2 items". What does it mean?
Two lines have Purchase Price 0 on their batch, so they were counted at no cost and the profit looks too high. Fill the Purchase Price of those batches in the item master.