Purchase Analysis
On this page
The Purchase Analysis report shows what you bought of each product in a period: the HSN code, the units, the net amount and the average price. Use it to see where your buying money goes, product by product, or to check the average price you paid for a product.
Open the report
Press Alt+6 for Analytical Reports, then I. The report opens for the financial year from its first day to today, with one line for each product, in product name order.
Each line is one product. Acephate 75 Sp 500 Gm was bought in 240 units for 1,24,800.00, an average of 520.00.
What it lists
One line for each product bought in the period. The report reads:
- purchase bills, each on the day it was received (the Recd. date on the bill), as in Day to Day Purchases. Both the From and To days count.
- the item lines of those bills with a quantity above zero. Charges are not items and are not counted.
- goods received without a bill (Goods In / Out, 1 P): receipts for a purchase, dated in the period, whose units are not yet billed on the To date. Only the units not yet billed count, on the day they were received.
Purchase returns are not read, so the units and amounts are not reduced by them. A product has one line for each HSN code its lines carry, so a product bought under two HSN codes has two lines.
A received line with no Quoted price has its units counted and its amount is nil. The status line then says how many such lines there are.
Columns
| Column | What it shows |
|---|---|
| S.No | The line’s number in the current order. Hide it with Columns. |
| HSN code | The HSN code on the bill lines, in capitals. Hide it with Columns. |
| Page | The product’s Reg. page, from the item’s details. It is shown only when at least one product in the list has one. Hide it with Columns. |
| Product | The product’s name. |
| Units | The quantity bought, added up over the bill lines and the goods received. |
| Net amount | The amount bought, added up as described under How the figures are worked out. Shown in bold. |
| Avg. price | The net amount divided by the units. |
The totals line under the grid counts the products, adds up the Units and Net amount, and gives the average price of the whole list. The status line repeats the count, the units and the net amount.
Choices
| Choice | What it does |
|---|---|
| Category | Only the products of this category. The default is * All. |
| From, To | The period, both days included. Both dates must fall in the financial year. |
| Find | Shows only the products whose name, HSN code, page or code matches what you type. Every word must be found in one of these; a word of three or more letters also matches when its letters appear in that order close together. |
There is no Payment, GST or Tax choice on this report. Everything bought in the period is counted.
The choices of the report as it opens.
Sort
Click the title of HSN code, Page, Product, Units, Net amount or Avg. price to sort by it, and click it again to reverse the order. Shift+click adds a second column for lines that tie. The first click on Units, Net amount or Avg. price puts the largest first. Here the list is sorted by Net amount: Dap 18-46-0 50 Kg is first, with 800 units and 9,90,000.00.
Sorted by Net amount. The arrow on the title shows the column the list is sorted by.
Category
Choose a category to see only its products. Here FERTILIZERS has 8 products: 3,720 units for 32,43,004.00, an average of 871.78.
Only the products of the FERTILIZERS category are listed and totalled.
Find
Type in Find to narrow the list. Here the word acephate leaves one product, with its 240 units and 1,24,800.00.
Find searches each product’s name, HSN code, page and code.
How the figures are worked out
For each product, SimplyERP reads the item lines of the purchase bills received between From and To (both days counted), with a quantity above zero, and the goods received in the period that are not yet billed:
- Units = the quantity on those lines, and the unbilled units of those receipts, added up.
- Net amount = each line’s amount, added up. A bill line’s amount is its taxable value, after discounts and without GST, when the bill is from a supplier with a GSTIN. For any other supplier it is the billed amount, which includes GST. The amount of goods received without a bill is their unbilled units times the Quoted price on the receipt.
- Avg. price = Net amount ÷ Units, shown to two decimals. The total line divides the total net amount by the total units. It is not an average of the product averages.
There is no GST or Tax choice, so the Net amount total can add up one supplier’s amount before GST and another’s amount with GST. Purchase returns are not taken off.
The totals line adds up the products; the status line repeats the count, the units and the net amount.
Open, mark, print and export
- Enter on a product opens the Purchase Statement for that product, with the same period. It lists the product’s purchase lines. Alt+← returns to the list, with the cursor on that product.
- F2 marks a product and F8 marks every product on the screen. When any are marked, F10 prints only those, and the print says Marked products only.
- F10 prints the report as it is on the screen, under the title PURCHASE ANALYSIS. Its heading gives the period, the category and what you typed in Find. The print has the same columns with their own headings, and puts Avg.Price before Net Amount: S.No, HSN Code, P.No, Product Name, Pur.Qty, Avg.Price, Net Amount. A column hidden with Columns is left out of the print too.
- F12 saves it as an Excel workbook.
- Alt+Enter gives the whole window to the list.
Updated 4 November 2026.