SpeedPlus9
Feature Inventory & items

Stock and sale statement for a company

Opening, purchase, sale and closing of one company's items: the statement a stockist sends. Stockists and distributors send each company a statement: opening, purchase, sale and closing of its items. The Stock Report makes it with a few clicks.

On this page

6.13Stock and Sale Statement for a Company

Stockists and distributors send each company a statement: opening, purchase, sale and closing of its items. The Stock Report makes it with a few clicks.

  1. Press Ctrl+U. Keep From Date on the first day of the financial year and set To Date to the last day of the month.
  2. Click Search. Keep Stock Report as Per on Item Name. In Search By choose ItemCompanyName and type the company in Search For What.
  3. Keep Qty + Free ticked so free goods are counted. Tick Only Show Items Sold in this Period if the company wants only the items that moved.
  4. Click Search. Read Op.Qty, Pr.Qty, Sale Qty and Cl.Bal., then click Excel and send the file.

With the year's first day as From Date, the purchase and sale columns show the year so far, and the closing stock is right. If the company asks for one month's sale alone, run the report to the end of this month and to the end of last month, and take the difference in Sale Qty.

Example For a biscuit company, the report from 1 April to 31 October shows one item with Op.Qty 40, Pr.Qty 600, Sale Qty 575 and Cl.Bal. 65 cartons (40 + 600 − 575 = 65). The run to 30 September showed Sale Qty 490, so October's sale was 575 − 490 = 85 cartons.
Tip Stock Report as Per = Company Wise gives one line per company with no item detail, useful for your own overview. Every item needs its Company filled in the item master (3.4).

A ready statement: Stock & Sales Analysis

Stock Reports → Stock & Sales Analysis (just below Stock Report) makes the same statement in one screen, with the company or supplier name and the period in the heading, ready to print or send.

  1. Set From date and To date.
  2. Choose the manufacturer in Item company (manufacturer), or the party in Supplier (party we bought from). Leave the other box on All.
  3. Tick Include zero-stock, no-movement items only if the company wants every item, even those that did not move. Press Show report (Enter).
  4. Each item shows Opening Qty, Opening Value, Purchase Qty, Purchase Value, Sale Qty, Sale Value, Closing Qty and Closing Value, with a TOTAL row.
  5. Print (Ctrl+P), PDF or Excel (Ctrl+E). The file name carries the company and the dates.
Example Before placing the next order with a biscuit company, the distributor runs Stock & Sales Analysis for October with that company. One item shows Opening Qty 40, Purchase Qty 300, Sale Qty 95 and Closing Qty 245 cartons. With 245 cartons left after selling 95 in a month, he leaves that item off this order and shows the PDF to the company's officer.

Read every step in the guide: Stock Management, section 6.13

Questions and answers

The company wants a monthly stock and sale statement. How?

Stock Report from the year's first day to the month end, Search By ItemCompanyName with the company's name, then Excel (6.13).

Is there a printable stock and sale statement for one supplier?

Yes. Stock Reports → Stock & Sales Analysis → choose the Supplier (or the Item company) and the dates → Show report → Print, PDF or Excel (6.13).

How do I give a company's representative his near-expiry list?

Stock Reports → Expiry Register → 90 Days → Search → type the company name → Search → Print (6.12).

A company recalled one batch. How do I find who bought it?

Stock Reports → Sub Item Wise Stock → Item Name → batch number (or its barcode) in Sub Item → dates → OK. Every customer of that batch is listed; double-click to open the bill (6.3).

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.