Expense Landed Cost Summary
📄 Expense Landed Cost Summary Report
The Expense Landed Cost Summary Report provides a consolidated overview of all additional expenses incurred in the process of procuring goods, allocated across various purchase transactions. Unlike the Purchase Landed Cost Summary Report, which focuses on the total cost of goods, this report emphasizes the breakdown and summary of cost components (freight, customs, insurance, handling charges, etc.) to analyze their overall impact on procurement and operations.
🎯 Purpose of the Report
-
To summarize all landed cost expenses across a selected period.
-
To track where money is being spent in the procurement cycle apart from base product costs.
-
To help in cost control by identifying high-cost categories.
-
To assist in supplier negotiations and budgeting.
📌 Key Data Fields
| Field | Description |
|---|---|
| Expense Type | Category of expense (Freight, Customs Duty, Insurance, Handling, etc.). |
| Purchase Order No | Linked PO where the expense was allocated. |
| Supplier Name | Vendor related to the purchase. |
| Expense Vendor Name | Service provider charging the expense (e.g., freight company). |
| Expense Invoice No | Invoice reference for the expense. |
| Expense Date | Date when the expense was recorded. |
| Reference Item(s) | Products associated with the landed cost allocation. |
| Total Expense Amount | Total cost for the expense line. |
| Allocated Purchase Value | How much of the expense is attributed to a specific purchase. |
| Remarks / Notes | Additional details about the expense. |
🔍 Filter & Search Options
-
Date range.
-
Expense type.
-
Supplier name.
-
Expense vendor name.
-
Purchase order number.
📊 Insights Provided
-
Total landed costs by expense type (e.g., total freight cost for the month).
-
Supplier-wise landed cost distribution.
-
Period-wise trends in procurement expenses.
-
Impact of specific expenses on product cost over time.
📤 Export & Integration
-
Export to Excel, CSV, or PDF for reporting.
-
Integrates with Purchase Module for cost allocation.
-
Connects with Accounts Payable for expense tracking and vendor payments.
✅ Benefits
-
Improves visibility into hidden procurement costs.
-
Helps in cost optimization by highlighting high-impact expenses.
-
Aids in accurate inventory valuation and profitability analysis.
-
Strengthens budgetary control by comparing planned vs. actual expenses.
📈 Example Layout
| Expense Type | Expense Vendor | PO No | Supplier | Expense Date | Expense Invoice No | Total Expense Amount | Allocated to Purchases | Remarks |
|---|---|---|---|---|---|---|---|---|
| Freight | FastShip Ltd | PO-1023 | Global Steel | 02-07-2025 | EXP-889 | ₹5,000 | ₹5,000 | Shipment from port |
| Customs Duty | Customs Dept | PO-1024 | ABC Tools | 03-07-2025 | EXP-890 | ₹2,000 | ₹2,000 | Import clearance |
| Insurance | SecureCover | PO-1025 | Steel World | 05-07-2025 | EXP-891 | ₹1,200 | ₹1,200 | Transit insurance |