SpeedPlus9
Feature Profit & sale reports

Why the profit figure changes: the cost method

The cost of goods depends on the method you pick. Pick one, write it on the printout, use it every month. "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.

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 perCost of one piece isGood 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 PriceThe average of your purchases of the item and batch.Moves slowly; good for comparing months.
PurchasePriceThe Purchase Price saved on the batch.Only as right as that field.
Opening Stock Value / QtyThe batch's opening value ÷ opening quantity.For stock carried from last year.
SalePrice, Basic Price, Minimum Sale Rate, SelfValThat 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.

Example You bought 100 bags of cement at Rs 340 and later 100 bags at Rs 360. On 30 March you sold 10 bags at Rs 380 before tax: Value Rs 3,800. With Last Purchase Rate the cost is 10 × 360 = Rs 3,600 and the profit Rs 200. With Average Purchase Price the cost is 10 × 350 = Rs 3,500 and the profit Rs 300. In April you buy at Rs 370; with Last Purchase Rate the same March bill now shows cost Rs 3,700 and profit Rs 100.

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).

Example Verma Medical Agencies sells you Paracetamol strips, Qty 10, Free 1, Rate 100. You sell one strip at Rs 120. Bill Wise Profit with Last Purchase Rate shows Cost 90.91 and profit Rs 29.09. Had the free strip not been entered, the cost would show Rs 100, the profit Rs 20, and the stock would be one strip short.

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.

Example Cough Syrup batch CS-101 cost Rs 70 and batch CS-102 cost Rs 90. You sold 3 of the first and 2 of the second, all at Rs 85. Item Wise Profit shows two Cough Syrup lines: Cost 70, profit Rs 45; Cost 90, Profit/Loss -10. Time to raise the rate for the new batch.

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?

Open Sale Reports → Bill Wise Profit for today (5.22). It is profit on goods before expenses. Margin Leak only counts money lost on bad lines, and it works out cost its own way, so the two figures do not add up to each other (5.23).

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.

Watch it

True Cost of 10+1 Free Scheme Goods | Free Quantity in Speed Plus 9

Product overview·Short

Same Medicine, Two Batches, Different Profit | Batch-Wise Profit Report

Items & stock·Short

See this feature working.

Tell us your trade and how you bill today. We will show you the same work in Speed Plus 9, on a call or at your shop.