A D2C business can sell through its own website, Amazon, Flipkart and other channels while storing goods across multiple locations. The difficulty is not merely knowing the total number of units sold; it is connecting each SKU's accounting stock movement with reliable purchasing, sales, returns, transfers and approved adjustments.
Without that connection, the P&L and stock valuation may be based on incomplete or inconsistent records.
What is SKU-wise inventory accounting?
An SKU (stock keeping unit) identifies a distinct product variant. Accounting stock records associate each agreed SKU with opening balance, purchases, sales, returns, transfers, approved adjustments and closing quantity/value under an accounting policy.
A product available in three pack sizes or colours may require separate SKUs. The business should maintain a consistent SKU master or documented mapping between marketplaces, warehouse reports and financial accounts.
The basic movement calculation
At a simplified quantity level:
Closing stock = Opening stock + receipts + eligible returns in + transfers in − sales/dispatches − transfers out − approved losses or adjustments.
The categories must be tailored to the actual flow. Sales and dispatch may occur on different dates, and returns may be financially refunded before units return to saleable stock.
Consider an illustrative SKU with 200 opening units, 100 received, 240 dispatched, 20 saleable customer returns and 5 approved damaged units. Closing quantity would be 75 units (200 + 100 − 240 + 20 − 5). This is an accounting movement result; only an authorised physical check can confirm the actual stock at a warehouse.
Five records your business should connect
- SKU/item master: unique IDs, variants, descriptions and units.
- Purchases and receipts: supplier bills, inward quantities and dates.
- Sales and dispatches: channel order IDs, SKU, quantities and period cutoffs.
- Returns and transfers: whether goods are saleable, damaged, in transit or moved between locations.
- Approved stock adjustments: authorised write-offs, corrections and any physical-count reconciliations.
Where these records originate in different systems, mappings and reconciliation rules are essential. Avoid inventing missing transactions simply to make the closing quantity look positive.
Why negative stock deserves attention
A negative balance can result from late purchase recording, incorrect SKU codes, stock movements posted in the wrong period or a genuine operational discrepancy. It is a signal to investigate—not evidence of one particular cause.
Similarly, a large valuation swing may arise from changed purchase costs, an inconsistent accounting policy, a wrong unit conversion or a missing return. Document the reason before interpreting the change as a margin trend.
Accounting inventory is not a stocktake
A remote accounting team can reconcile quantities and values using complete client-supplied movement records and approved adjustments. That does not mean it has counted goods in the warehouse. Physical counts, damaged-goods classification and actual dispatch operations remain with the operational team unless a separate arrangement expressly covers them.
How inventory links to marketplace profitability
Reliable SKU data enables more meaningful comparisons of revenue, cost and returns. However, full channel profitability may also need an agreed method for allocating advertising, logistics, marketplace fees and other indirect expenses. SKU-wise records provide a foundation; they do not automatically supply a complete profitability model.
How PROFINZO handles the boundary
PROFINZO Accounts Growth Commerce can cover agreed marketplace settlements and SKU-wise accounting stock records from complete client-supplied movements. Channel count, platforms, stock complexity, software and reporting are defined in the written proposal. Physical stock verification and warehouse management are separate responsibilities.
Frequently asked questions
Can one product have multiple SKUs? Yes. Different pack sizes, variants or channel-specific mapping can create distinct SKUs or require controlled cross-references.
Why can a marketplace show different stock from accounts? Timing, channel reserves, returns, transfers or master-data differences may be involved; reconcile source detail to identify the cause.
Does an inventory report prove stock exists? No. It records information based on sources and adjustments; physical verification is separate.
Do all businesses use the same stock valuation method? No. The applicable accounting policy and evidence should be assessed for the specific business and consistently applied.
Next step: Discuss SKU accounting and settlement reconciliation with PROFINZO.
