Purchase Landed Cost Summary

📄 Purchase Landed Cost Summary Report

The Purchase Landed Cost Summary Report provides a consolidated view of the total cost of purchased goods, including not just the supplier's invoice price but also additional expenses like freight, customs duties, insurance, and other handling charges. It helps finance, procurement, and inventory teams accurately determine the true cost of goods for pricing, profitability, and inventory valuation.

🎯 Purpose of the Report

To capture the full landed cost of purchased items.
To ensure accurate inventory valuation by including all procurement-related expenses.
To analyze cost distribution across different purchases or suppliers.
To support better pricing decisions and profitability analysis.

📌 Key Data Fields

Field	Description
Purchase Order No	Unique reference for the purchase transaction.
Purchase Invoice No	Invoice number from the supplier.
Supplier Name	Vendor from whom the goods were purchased.
Purchase Date	Date of the purchase transaction.
Item Code / Name	Product purchased.
Quantity	Number of units purchased.
UOM	Unit of Measure for the product.
Base Purchase Price	Price per unit before additional costs.
Freight Charges	Transportation costs.
Customs / Import Duty	Government charges for import.
Insurance Cost	Cost of insuring the shipment.
Handling & Other Charges	Packaging, port handling, clearance fees, etc.
Total Landed Cost	Base cost + all additional expenses.
Landed Cost per Unit	Total landed cost divided by quantity purchased.

🔍 Filter & Search Options

Purchase order number.
Supplier name.
Date range.
Item code / category.
Cost type (freight, customs, insurance, etc.).

📊 Insights Provided

Total landed cost per purchase and per unit.
Percentage contribution of freight, customs, and other charges to overall cost.
Supplier-wise cost comparisons.
Trend analysis of landed cost changes over time.

📤 Export & Integration

Export to Excel, CSV, or PDF.
Integrates with Inventory Module for real-time product cost updates.
Links with Accounts Payable for expense tracking.

✅ Benefits

Ensures accurate product costing for pricing and profitability analysis.
Helps identify high-cost suppliers or shipping methods.
Improves budgeting and procurement planning.
Reduces risk of underpricing by missing hidden costs.

📈 Example Layout

PO No	Supplier	Purchase Date	Item Code	Item Name	Qty	UOM	Base Price	Freight	Customs	Insurance	Other Charges	Total Landed Cost	Landed Cost/Unit
PO-1012	Global Steel	01-07-2025	ITM-001	Steel Rod	100	pcs	₹500	₹5,000	₹2,000	₹1,000	₹500	₹58,500	₹585
PO-1013	ABC Tools	03-07-2025	ITM-002	Drill Set	50	set	₹1,200	₹3,000	₹0	₹500	₹250	₹64,750	₹1,295

📄 Purchase Landed Cost Summary Report​

🎯 Purpose of the Report​

📌 Key Data Fields​

🔍 Filter & Search Options​

📊 Insights Provided​

📤 Export & Integration​

✅ Benefits​

📈 Example Layout​