8Q Estimated Landed Cost +
What the 8Q ELC+ Application Does
Gain complete visibility
over landed costs for accurate profit margins
Avoid surprises
by posting estimated costs when inventory is received
Eliminate guesswork
in calculating true product costs
8Q ELC+ Key Features
- Automated Landed Cost Estimation: Using customizable native NetSuite Landed Cost Templates and Cost Categories, it estimates charges like freight, duties, and other shipping costs to integrate into inventory valuation.
- GL Accounts and Landed Cost Categories Setup: Allows users to set specific GL accounts and create landed cost categories that align with their financial and operational needs.
- Item and Cost Tracking: Keeps item receipts, vendor bills, and landed costs cross-linked within NetSuite for seamless reference and auditing.
- Template-Based Allocation: Enables custom allocation methods (e.g., by quantity, weight, volume) and multiple landed cost templates for items to reflect specific shipping scenarios.
- Variance Reconciliation: Once actual landed cost bills are received, it compares estimates to actuals, letting users reconcile variances and adjust inventory or cost of goods sold (COGS) as necessary. Journal Entries are created for estimated costs and variances.
- Estimates/Quotes: Suggested Retail Price is calculated based on an editable Desired Retail % Margin. Estimated Landed Cost is taken into consideration. On Estimates, the Sales Rep can change the Retail % Margin and/or change the Landed Cost template, with the Retail Price shown being automatically adjusted.
Container Tracking (New in ELC+)
- Tracks container location and status for both ship and air freight.
- Includes estimated and actual dates (and times for air freight) of events such as: Loaded, Left Port, Arrived at Destination, Offloaded. Purchase Orders' “Available” dates are updated when dates become actual. A real-time map shows the location of the freight.
- Shows container utilization by calculating fill percentages based on item dimensions and volume, allowing users to monitor and optimize space efficiency. If containers are underfilled, users can adjust their packing methods, minimizing costs associated with unused space.
Benefits for Clients
Business Benefits
By automatically updating inventory values with estimated landed costs upon receipt, the application improves cost transparency and inventory valuation accuracy.
Automates routine processes, such as estimating and allocating costs, to minimize manual data entry errors and the time required to handle landed cost accounting.
Offers an efficient method to manage and reconcile differences between estimated and actual costs, with options to clear variances directly to COGS or revalue inventory, depending on business needs.
With the ability to define custom landed cost categories, templates, and automation settings, the application can be tailored to fit each business’s unique import processes and cost allocation preferences (Volume is added to native NetSuite Allocation Methods).
Centralizes and links all records associated with a transaction, making it easier for finance teams to track expenses, reconcile accounts, and prepare for audits.
By calculating container fill percentages, the Container Tracking feature allows businesses to monitor space utilization. This visibility helps users reduce costs associated with shipping underfilled containers.
Knowing the estimated date of arrival allows Sales Reps to keep customers informed of availability.