| Column Name | Purpose |
|---|---|
Billing Date |
Date of billing — used for month grouping and FOC date matching |
Billing Document No. |
Unique bill number — used for cross-lot netting |
Sales office desc |
Regional office name |
Sold-to Party |
Customer code |
Sold-to-Part Name |
Customer name |
Material |
Material code — first 4 digits used as brand code |
Material Description |
Used for pack size filtering and brand description |
Mrp Lot |
MRP lot code — matched against approved FOC records |
Net Value of Billing item |
Zero = Free goods, Non-zero = Billed goods |
Volume |
Quantity in litres — used for FOC % calculation |
Customer Group 2 |
Must be A12 — only these records are processed |
📤 Upload Sales Data
Choose the monthly Excel file to generate the compliance report.