GRN Analysis Report

GRN Analysis Report - User Guide

1. Introduction đŸ“Ļ

The GRN (Goods Received Note) Analysis Report is a vital operational and financial audit tool. It tracks the physical entry of materials into the plant, their quality inspection results, and the subsequent billing status.

â„šī¸

Purpose of this Report:

  • Material Audit: Reconcile physically received quantities against supplier challans and purchase indents.
  • Accounting Control: Identify “Goods Received but Not Billed” (GRNI) to manage accruals.
  • Quality Monitoring: Track rejection rates and inspection throughput.
  • Vendor Benchmarking: Objective scoring of vendors based on lead times and delivery accuracy.

This module is used daily by Store In-charges, Quality Inspectors, and Accounts Payable teams.


2. Report Types & Analysis Use Cases 🚀

Option A: Pending GRN Report

  • Purpose: Identifies materials that have been received at the warehouse but have not yet been linked to an authorized Purchase Bill.
  • Best For: Month-end Accruals. Helps the Finance team identify liabilities for goods received but not yet invoiced by the vendor.
  • Key Filter: Consider Bill Date Upto — Allows filtering out bills created after a specific accounting cutoff date to reconcile historical balances accurately.

Option B: GRN Register Report

  • Purpose: A complete chronological register of all material receipts within the organization.
  • Best For: Total Inward Logistics Audit.
  • Key Data: GRN Number, Challan Details, Transporter, Store Location, specific Item/Brand, and connectivity to the original Indent.

Option C: QA (Quality Assurance) Report

  • Purpose: Focuses on the inspection status of incoming materials.
  • Analysis: Tracks the throughput of the inspection team and the rejection rate across items and suppliers.
  • Key Data: QA Report Number, Accepted vs. Rejected Qty, Test Certificate (TC) status, and Inspector remarks.

Option D: Vendor Performance Report

  • Purpose: Scores vendors objectively based on historical delivery performance to support procurement negotiations.
  • Key Metrics:
    • Quantity Rating: Accepted Quantity vs. Received Challan Quantity (Quality score).
    • Delivery (Qty): Supplier Challan Quantity vs. the original Indent Quantity.
    • Delivery (Date): Measures “On-Time” delivery against the required delivery date from the Indent.
    • Delay Days: Quantitative measure of vendor lead-time variance.

3. Data Visibility & Insights 🔍

Data CategoryKey Fields Visible
Material EntryGRN No, Challan No, Challan Date, Unit Code, and Store Name.
Quality AuditQA OK (Yes/No), Rejected Qty, TC Status (Yes/No), and Inspector Name.
FulfillmentOriginal Indent No, Indent Date, Pending Qty (for Billing), and Ordered Qty.
RatingsQty Rating, Delivery Rating, and Delay in Days.

4. Source Transactions 🔄

The GRN reporting engine synthesizes data from:

  1. Goods Receipt Note Module: The primary entry point for physical stock and receiving records.
  2. Purchase Indent Module: Compares ordered commitments against received quantities.
  3. Purchase Bill Module: Tracks which goods receipts have been invoiced and identifies unbilled balances.
  4. Quality Inspection Records: Captures accepted and rejected material pools and inspector notes.

5. Report Options & Filters đŸ› ī¸

  • Report Option: Choose from Option A (Pending GRN), Option B (GRN Register), Option C (QA Report), or Option D (Vendor Performance).
  • Unit Filter: Consolidate receipts from “All Units” or focus on a specific factory location.
  • Filter By: Narrow analysis by All (0), Party Group (1), Vendor / Party (2), Item Group (3), or Item Name (4).
  • Consider Bill Date Upto: (Available for Option A) Sets the financial cutoff date for recognizing bills, essential for reconciling Accounts Payable with warehouse inventory.

6. Best Practices / Tips 💡

  • Close the Loop: Use the Pending GRN Report weekly to ensure that vendors are submitting bills promptly for all items received at the gate.
  • Monitor Quality Trends: In the QA Report, if a specific item has a high rejection rate across multiple vendors, it may indicate a design or specification issue rather than a vendor issue.
  • Objective Vendor Selection: Use the Vendor Performance Report during contract renewals. Vendors with high “Delay Days” or low “Qty Ratings” should be flagged for improvement or replaced.
  • Store Accuracy: Ensure the Store Name is correctly selected in the register to maintain accurate sub-inventory tracking.