# Month Wise Item Wise Purchase

Item-level purchase analysis by month. Shows quantity and amount purchased for each item across every month in the selected year or date range.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Purchase → Reports → Month Wise Item Wise Purchase. Report title in ERP: Month Wise Item Wise Purchase

What it shows. One row per item with paired Quantity and Amount columns for each month (January through December), plus yearly Total Quantity and Total Amount.

When to use it. Use for seasonal demand analysis, inventory forecasting, and identifying items with spiking or declining purchase volumes.

Screenshot pending — Month Wise Item Wise Purchase report view.

Use Cases

Inventory planner — Which items show seasonal purchase spikes before peak demand? Run annually when building procurement calendars.
Procurement analyst — How did purchase cost for a raw material change month by month? Run for key SKUs before contract renewal.
Store manager — Which fast-moving items need higher safety stock before high-volume months? Run with branch filter before replenishment planning.
Finance team — What is the year-to-date purchase value per item? Run at year-end for spend classification and budgeting.

Filters

Year or Date, Employee. Advanced Filter: Item, Item Group, Supplier, Branch, Center, Brand.

Columns

| **Column** | **Description** | |------------|-----------------| | Item | Item name or description. | | January – December (Quantity & Amount) | For each month, Quantity is units purchased and Amount is total purchase cost for that month. | | Total Quantity | Sum of monthly quantities for the year or selected range. | | Total Amount | Sum of monthly purchase amounts for the year or selected range. |

Actions

Generate — run the report for the selected filters
Export — export to Excel
Print — print the report
Advanced Filter — open additional filter fields
clear — reset active advanced filters

FAQ

Why are some months zero for an item?
No purchase invoices for that item were posted in those months within the selected year or date range.

Can I run this for part of a year?
Yes. Use Date to limit the range; month columns outside the range may show zero or be omitted per report layout.

How is this different from Item Wise Purchase Report?
Item Wise Purchase Report totals the whole period in one row. This report splits each item by month.

Are purchase returns deducted from monthly amounts?
This report summarizes purchase invoice lines. Use Purchase Return Report for return detail.

Which invoice statuses are included?
Approved and Closed purchase invoices only.

Why is my report empty?
No approved invoice lines match the year or date range and item filters.

Does the report use invoice date or order date?
Monthly columns are based on purchase invoice date in the selected period.