Delhivery Bill Reconciliation

Drop the Delhivery invoice Excel here

Delhivery One → Finance → Invoice → download Excel · .xlsx / .csv · you can drop multiple billing periods

AWB	Order	SKU	Zone	Status	Mode	Chg. wt (g)	Billed wt (g)	Box	Exp. freight	Exp. COD fee	Expected ₹	Billed ₹	Variance ₹	Bucket

SKU standard weights

Dead + volumetric weight per SKU (grams). Chargeable weight = higher of the two. The master catalogue (969 SKUs) ships built-in and is locked — everyone reconciles against the same master. Unlock (password) to import/edit in this browser; lock again to revert to the shipped master.

Import expects columns like SKU / style code, dead weight, volumetric weight and/or a box dimensions column (L*B*H in cm). Weights read as grams; fractional values under 30 (like 0.5) read as kg. Missing volumetric is computed from dimensions: L×B×H ÷ 5000 kg.

SKU / style code	Dead (g)	Volumetric (g)	Chargeable (g)

Box volumetric reference

Standard packing boxes (from "All Box Dimensions") — volumetric weight = L × B × H (cm) ÷ 5000 kg

Box	Dimensions (cm)	Volume (cm³)	Volumetric wt (g)

Poly-bag shipments have negligible volumetric weight — dead weight governs.

Rate card (₹ per shipment)

From the KT doc. Edit if the agreed card changes — saved locally. DL = forward delivery · RTO leg is added on top of forward freight · DTO = customer return pickup.

Slab	A	B	C1	C2	D1	D2	E	F

COD fee = higher of ₹ or % of order value (zone-independent). Prepaid = nil.

Settings

Applied instantly to the whole reconciliation.

Variance tolerance (₹) — |variance| within this = Matched COD minimum fee (₹) COD % of order value Billed amounts include GST — gross up expected by (%) Apply COD fee on RTO / DTO shipments (KT default — untick if Delhivery reverses it) Chargeable weight source

Try it — expected charge for any shipment

Uses the live rate card and settings — edit those and this recalculates.

g ₹ order value