Landed Cost Allocation Model – Excel Template
55.59 $Landed Cost Template: Captures freight, duties, insurance, and other import costs and allocates them to items (by value/weight/volume) to update unit cost. Delivers more accurate inventory valuation and COGS for import and costing teams at month-end.
Serial/Lot/Expiry Tracker – Excel Template
42.29 $Lot & Expiry Tracking: Records batch/serial numbers and expiry dates with near-expiry reporting and FEFO application. Delivers batch traceability and lot-level movement tracking for inventory and quality control of sensitive items.
Inventory Count & Variance Resolution – Excel Template
55.59 $Inventory Stocktake Template: Organizes planning, counting, review, variance analysis, approvals, and posting of adjustment entries by variance reason. Delivers variance reports and approved stocktake minutes for periodic or annual counts.
Cycle Count Plan & Variances – Excel Template
42.29 $Cycle Count Template: Builds an ABC cycle count plan and records count results, variances, root causes, and adjustment minutes. Delivers inventory accuracy reporting and operational improvement insights beyond annual stocktakes.
Inventory Write-off Template – Excel Template
55.59 $Inventory Scrap & Write-Off Template: Documents scrap/damage, disposal reasons, approval limits, write-off journals, and linkage to warehouse/item. Delivers disposal minutes and monthly scrap reporting for inventory teams and chief accountants.
Returns & COGS Impact – Excel Template
55.59 $Inventory Returns Template: Manages customer/vendor returns from request to receipt (quarantine/inspection), then CN/DN issuance, COGS reversal, and inventory updates. Delivers a complete returns register with full accounting impact for month-end close.
FIFO & Weighted Average Valuation – Excel Template
63.56 $Inventory Valuation (FIFO/Weighted Average): Calculates cost layers or weighted average, highlights pricing variances and revaluations, and prepares accounting entries. Delivers auditable inventory value and consistent COGS for costing teams at month-end.
COGS Reconciliation – Excel Template
42.29 $COGS Reconciliation: Ties sales to purchases, inventory and returns using the inventory equation (opening/closing) to validate gross margin. Delivers a COGS variance report with explanations for CFO review before approving monthly statements.
Slow-Moving & Obsolete Inventory Provision – Excel Template
55.59 $Slow-Moving & Obsolete Inventory: Analyzes aging and days on hand, classifies slow/idle items, and calculates impairment allowance with defined rules. Delivers liquidation/markdown candidates and a monthly provision schedule to reduce cash tied up in stock.
Inventory Aging & DOH Dashboard – Excel Dashboard
63.56 $Inventory KPI Dashboard: Displays aging, days on hand, turnover, slow-mover alerts, and stockout risk by item/category/warehouse. Delivers weekly trackable KPIs for inventory and purchasing to optimize replenishment and liquidation.
Sell-through Analysis Model – Excel Template
55.59 $Sell-Through Analysis: Links sales to available/received inventory to measure sell-through velocity by item, category, and channel. Delivers reorder candidates and markdown/liquidation candidates based on actual demand.
Costing & Cost-Plus Pricing – Excel Template
63.56 $Costing Model (Costing Template): Consolidates direct and indirect costs and applies overhead absorption to produce unit cost or service cost. Delivers cost-plus pricing based on target margin for costing and finance leaders when pricing new products/services.
Gross Margin Bridge – Excel Template
55.59 $Gross Margin Bridge Analysis: Breaks margin movement into price/volume/mix/cost/discounts/returns drivers. Delivers variance-driver reporting by product or channel for management review and month-end performance analysis.
Shrinkage Control – Excel Template
42.29 $Shrinkage Monitoring: Compares book vs physical inventory and classifies loss drivers by site/item/movement type with follow-up controls. Delivers shrinkage reporting and corrective action tracking for inventory and internal audit teams.
Pricing & Markdown Tracker – Excel Template
42.29 $Product Pricing Tracker: Monitors list prices, promotions, markdowns, minimum margin thresholds, and an approval log for price changes. Delivers pricing impact analysis on profitability and sell-through for retail sales and finance decisions.
Employee Custody Register – Excel Template
34.31 $Employee Advances/Imprest Management Template is a comprehensive Excel program to manage employee advances efficiently, providing accurate reports and analytics to strengthen financial control—especially as headcount and advance spending grow.
Employee Custody Policy & Settlement – Word & Excel Files
55.59 $Imprest/Advance Settlement Template: Captures expenses with receipts, allocates them to cost centers, and records refunds of unspent balances with settlement limits and deadlines. Delivers settlement journals and an open-advances register for expenses and treasury teams before month-end close.
Expense Claims Template – Excel Template
42.29 $Employee Expense Claims Template: Manages claims with receipts, categorization, cost center/project allocation, and an approval workflow. Delivers approved claim reports and allocation journals to control travel, hospitality, and petty purchases.