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 Category | Key Fields Visible |
|---|---|
| Material Entry | GRN No, Challan No, Challan Date, Unit Code, and Store Name. |
| Quality Audit | QA OK (Yes/No), Rejected Qty, TC Status (Yes/No), and Inspector Name. |
| Fulfillment | Original Indent No, Indent Date, Pending Qty (for Billing), and Ordered Qty. |
| Ratings | Qty Rating, Delivery Rating, and Delay in Days. |
4. Source Transactions đ
The GRN reporting engine synthesizes data from:
- Goods Receipt Note Module: The primary entry point for physical stock and receiving records.
- Purchase Indent Module: Compares ordered commitments against received quantities.
- Purchase Bill Module: Tracks which goods receipts have been invoiced and identifies unbilled balances.
- 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.