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.
| Summary | One row per |
|---|---|
| Sale Summary : Item Wise | Item. Sort by most or least sold, or by value. |
| Sale Summary : Customer Wise | Customer account. |
| Sale Summary : City Wise | City of the customer. |
| Sale Summary : Company Wise, Sale Summary : Group Wise | Item company (brand) or item group. |
| Sale Summary : Account Group Wise | Account group of the customers. |
| Sale Summary : One Party - All Companies | Company, for one party you pick. |
| Customers Vs. Items Sales Summary, City Vs. Item Sales Summary, Group Vs. Items Sales Summary | Customer (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 Summary | Company (or group) with its customers, items, cities or groups under it. |
- Open the summary. Set From and To.
- 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).
- Run it, read the totals, and press Excel to work on it further or to send it to your sales staff.
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 Method | Value is |
|---|---|
| Actual Amount (Basic) | Qty × rate, before discount and tax. |
| Actual Amount (After Discount) | After the line discount, before tax. |
| Net Amount | The line total with tax, as billed. |
| As Per Sale Price, As Per Basic Price, As Per M.R.P., As Per Purchase Price | Qty × 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.
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).