SpeedPlus9
Feature Profit & sale reports

Sale Summaries: what sold, to whom, where

Fifteen reports that add up the period's sales one way each, with returns taken off. Sale Reports → Sale Summaries holds 15 reports. Each adds up the period's sales one way. Most show Qty, Value, Ret. Qty and Ret. Value (returns in the same period), and Net Qty and Net Value after returns, with totals at the bottom and Excel and Print buttons.

On this page

5.24Sale Summaries: what sold, to whom, where

Sale Reports → Sale Summaries holds 15 reports. Each adds up the period's sales one way. Most show Qty, Value, Ret. Qty and Ret. Value (returns in the same period), and Net Qty and Net Value after returns, with totals at the bottom and Excel and Print buttons.

SummaryOne row per
Sale Summary : Item WiseItem. Sort by most or least sold, or by value.
Sale Summary : Customer WiseCustomer account.
Sale Summary : City WiseCity of the customer.
Sale Summary : Company Wise, Sale Summary : Group WiseItem company (brand) or item group.
Sale Summary : Account Group WiseAccount group of the customers.
Sale Summary : One Party - All CompaniesCompany, for one party you pick.
Customers Vs. Items Sales Summary, City Vs. Item Sales Summary, Group Vs. Items Sales SummaryCustomer (or city, or group) with the items under it.
Company Vs. Customers Sale Summary, Company Vs. Items Sale Summary, Company Vs. City Sale Summary, Company Vs. Group Sale Summary, Group Vs. Customers Sale SummaryCompany (or group) with its customers, items, cities or groups under it.
  1. Open the summary. Set From and To.
  2. Press Search. In the panel choose the Valuation Method (5.25) and, in the "Vs." reports, All, One or Choose (tick the companies, groups, parties or cities you want).
  3. Run it, read the totals, and press Excel to work on it further or to send it to your sales staff.
Example A distributor of SHREE GANESH TRADERS sells two brands, Surya and Kiran. He opens Company Vs. Customers Sale Summary for April, chooses both companies and runs it. Under Surya he sees 18 retailers; under Kiran only 7. Eleven retailers buy Surya from him but no Kiran. That is next week's call list for the Kiran salesman.

Read every step in the guide: Sale Billing, section 5.24

5.25Valuation Method: discount below MRP and salt-wise sale

The Valuation Method in the Search panel of a summary decides which rupee figure goes into the Value columns.

Valuation MethodValue is
Actual Amount (Basic)Qty × rate, before discount and tax.
Actual Amount (After Discount)After the line discount, before tax.
Net AmountThe line total with tax, as billed.
As Per Sale Price, As Per Basic Price, As Per M.R.P., As Per Purchase PriceQty × that price from the item master, whatever rate was billed. Free pieces are not counted.

How much below MRP did each customer get? Run Sale Summary : Customer Wise twice for the same month: once with Net Amount, once with As Per M.R.P. MRP includes tax, and so does Net Amount, so compare those two. The difference in each customer's Value column is the discount below MRP that customer got.

Example For October, Gupta Kirana Store shows Value Rs 7,400 with Net Amount and Rs 8,732 with As Per M.R.P. Gupta got Rs 1,332 below MRP, about 15%. Another shop buying the same goods got only 8%. The owner now knows whose discount to look at.
Caution The MRP comes from the item master, not from the batch. If your batches carry different MRPs, the result is rough. Items with no MRP count as 0. Compare against Net Amount, not After Discount, because After Discount has no tax in it.

One salt, many brands (medical stores). In Sale Summary : Item Wise press Search, pick SaltName in a search box and type the first letters of the salt, for example Paracetamol. Set Sort By to Max Sold Items First and run it. Every brand of that salt is listed with its quantity, the best seller on top. The same boxes also search by ItemCompanyName, tax slab or agent (BrokerName).

Read every step in the guide: Sale Billing, section 5.25

Questions and answers

Which retailer buys which brand?

Sale Reports → Sale Summaries → Company Vs. Customers Sale Summary. Choose the companies and run it; each company lists its customers (5.24).

How much below MRP did each customer buy?

Run Sale Summary : Customer Wise with Net Amount and again with As Per M.R.P.; the difference in Value is the discount below MRP (5.25).

Which brand of a salt sells most in my shop?

Sale Reports → Sale Summaries → Sale Summary : Item Wise, Search by SaltName, Sort By Max Sold Items First (5.25).

Watch it

What Sold to Whom? Crystal Clear Sale Summaries in Speed Plus 9 POS Billing ERP Software

Billing & POS·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.