Warehouse-Wise Accounting and Consolidated Reporting: How a Virtual CFO Improves Profitability

Table of Contents

Your business may be profitable overall—but are all your warehouses contributing to that profit?

For an e-commerce business operating across multiple warehouses, fulfilment centres or regional stock points, consolidated financial statements alone may not provide enough visibility to manage profitability effectively.

A business may report healthy overall revenue and EBITDA while one warehouse carries excess inventory, another operates at low utilisation and a third incurs disproportionately high fulfilment costs. If management only sees the combined numbers, these issues can remain hidden for months.

That is why warehouse-wise accounting and consolidated reporting are increasingly important for growing e-commerce businesses.

The objective is not to create a separate accounting system for every location. It is to build a reporting structure that shows how each warehouse contributes to sales fulfilment, inventory deployment, logistics efficiency, working capital and overall profitability.

A Virtual CFO helps design this framework, interpret the numbers and convert them into commercial decisions.

Why Consolidated Numbers Alone Are Not Enough

Consolidated financial statements tell management how the business is performing as a whole.

They do not always explain where the performance is coming from.

Consider an e-commerce company with warehouses in Ahmedabad, Mumbai and Bengaluru.

Overall revenue may be increasing, but the business could still have:

High rent in Mumbai
Slow-moving inventory in Bengaluru
Excess stock transfers between locations
High fulfilment cost per order in one warehouse
Inventory shortages in another
Unnecessary duplication of the same SKUs across locations

If these costs and operating patterns are merged into one P&L, the business may appear healthy even though one location is continuously destroying value.

Warehouse-wise reporting helps management identify which locations are supporting profitable growth and which require corrective action.

Build a Consistent Warehouse Accounting Structure

The first step is to create a clear reporting architecture.

Each warehouse should have an identifiable location code or cost centre in the accounting and inventory systems.

The reporting structure should distinguish between:

Legal entity
GST registration
Warehouse location
Marketplace
Product
SKU
Product category
Customer destination

These dimensions should not be mixed.

For example, a warehouse in Maharashtra may fulfil orders to several States, and the same SKU may be sold through Amazon, Flipkart and a D2C website. If the reporting system combines these dimensions incorrectly, management may draw the wrong conclusion about profitability.

The Virtual CFO should work with accounting, operations and technology teams to establish a consistent master-data structure.

The objective is to ensure that every important transaction can eventually be analysed by the dimensions that matter to management.

Capture the Complete Inventory Movement

Warehouse-wise profitability cannot be understood unless inventory records are reliable.

Each location should capture the complete inventory cycle, including:

Opening stock
Purchases
Inward receipts
Inter-warehouse transfers
Customer dispatches
Sales returns
Damaged stock
Write-offs
Adjustments
Goods in transit
Closing inventory

Different inventory statuses should also be identified separately.

For example:

Saleable stock
Returned stock pending inspection
Damaged inventory
Quarantined stock
Obsolete stock
Goods in transit

A returned item should not automatically become available inventory merely because it has physically reached the warehouse.

A basic quantity reconciliation can be expressed as:

Opening Stock + Purchases + Inward Transfers + Accepted Returns – Dispatches – Outward Transfers – Approved Losses = Closing Stock

This reconciliation should be performed at SKU and location level.

A consolidated inventory balance may appear correct even when one warehouse has an overstatement and another has a shortage. Warehouse-level reconciliation prevents such differences from cancelling each other out.

Attribute Revenue and Direct Costs Properly

Once inventory visibility improves, the next challenge is determining how revenue and expenses should be attributed.

Revenue attribution depends on the purpose of the report.

A dispatch-location view may help assess warehouse fulfilment economics.

A customer-destination view may help understand regional demand and delivery costs.

A marketplace view may help compare Amazon, Flipkart or D2C profitability.

Management may need all three—but they should not be confused with one another.

Direct warehouse costs may include:

Rent
Salaries
Utilities
Handling
Packaging
Local transport
Fulfilment expenses
Inventory losses

Shared costs may need allocation using appropriate drivers such as:

Number of orders
Square footage used
Weight handled
Transactions processed
Actual resource utilisation

The allocation policy should be documented and used consistently.

A warehouse that supports the entire business should not be made to look unprofitable merely because arbitrary corporate overhead has been assigned to it.

Measure Contribution Before and After Allocations

One of the most useful improvements in warehouse reporting is to show profitability at multiple levels.

For example:

Net Revenue Supported by Warehouse
Less: Product Cost
Less: Direct Fulfilment Costs
Less: Warehouse-Specific Costs
= Warehouse Contribution

Then:

Less: Allocated Shared Costs
= Reported Warehouse Profitability

This distinction is important.

Suppose a warehouse shows a loss after allocation of head-office expenses. Management should not immediately conclude that the location should be closed.

The business must first understand:

Which costs will actually disappear if the warehouse closes?
Which costs are committed?
Which costs will move to another warehouse?
Will logistics cost increase?
Will delivery time worsen?
Will customer conversion reduce?
Will additional inventory be required elsewhere?

A Virtual CFO therefore distinguishes avoidable costs from allocated costs before recommending closure, downsizing or expansion.

Keep Internal Stock Transfers Separate From External Sales

Inter-warehouse transfers often create confusion in management reports.

A movement of inventory from Ahmedabad to Mumbai is not an external sale for the consolidated business.

However, depending on the GST structure and accounting configuration, branch transfers may generate tax documents or internal accounting entries.

Management reports should ensure that these internal transactions do not inflate consolidated revenue or profit.

Where branch ledgers record transfer sales and purchases, the consolidated reporting process should eliminate:

Internal transfer revenue
Internal transfer purchases
Reciprocal balances
Internal mark-ups, where applicable

At the same time, stock transfers should not be ignored operationally.

Frequent transfers may indicate:

Poor demand forecasting
Incorrect initial stock placement
Regional demand shifts
Excess stock in one warehouse
Stock-outs in another

The accounting treatment and the operational interpretation should therefore remain separate but connected.

For the GST implications of these movements, refer to “Multi-State Warehousing & GST Compliance: The Hidden Compliance Minefield.”

Create a Disciplined Monthly Closing Process

Warehouse-wise reporting is only useful if it is timely.

A report prepared three weeks after month-end may explain the past but provide limited value for current decision-making.

A practical monthly close may include:

Days 1–3

Marketplace imports
Bank data
Warehouse movement data
Cut-off checks

Days 4–6

Inventory reconciliation
Stock transfers
Returns
Marketplace settlements
Key supplier reconciliation

Days 7–8

Accruals
Expense allocations
Inventory adjustments
Material exception review

Days 9–10

Final management pack
Forecast update
Management review meeting

The exact timetable will depend on transaction volume and data quality.

The principle is more important than the number of days: unresolved material differences should remain visible and assigned to an owner rather than being hidden through balancing entries.

Build a Warehouse-Wise Management Dashboard

A useful warehouse dashboard should go beyond revenue.

Management should monitor indicators such as:

Orders fulfilled
Net contribution
Fulfilment cost per order
Warehouse operating cost
Inventory held
Inventory days
Slow-moving stock
Stock accuracy
Return rate
Damage or shortage rate
Goods in transit
Budget versus actual cost
Capacity utilisation

The dashboard should also explain changes.

For example, a high-cost month may arise because:

The warehouse is newly operational
Capacity is temporarily underutilised
Product mix changed
Seasonal inventory was built in advance
Rent increased
Additional manpower was hired before peak demand

Numbers without context can lead to poor decisions.

The Virtual CFO helps management understand whether a variance is temporary, structural or a sign that the business model needs to change.

Consolidate Without Losing Location-Level Insight

Warehouse-wise accounting does not replace consolidated financial reporting.

Management needs both.

The consolidated report should combine all locations while removing internal duplication and reconciling with the books of account.

It should include:

Consolidated P&L
Balance sheet
Cash-flow position
Inventory exposure
Warehouse-wise contribution
Working-capital requirement
Settlement exceptions
Budget variance
Key operational KPIs

The report should also explain the bridge between profit and cash.

An e-commerce business may report profit while cash reduces because of:

Higher inventory purchases
New warehouse deposits
Capital expenditure
Slower marketplace settlements
Supplier advances
Additional working-capital investment

This is one of the areas where a Virtual CFO adds significant value—by connecting warehouse performance with the wider cash-flow position of the business.

Use Annual Review for Strategic Warehouse Decisions

Monthly reporting helps control operations.

Annual review helps decide the long-term role of each location.

The review should bring together:

Physical stock verification
Inventory valuation
Slow-moving and obsolete stock
Goods in transit
External fulfilment stock
Unprocessed returns
Recoverable claims
Lease commitments
Capacity utilisation
Actual versus planned warehouse economics

Management should compare the original business case with actual results.

Questions may include:

Did the warehouse generate the expected logistics savings?
Did regional demand develop as forecast?
Is inventory turnover acceptable?
Should the lease be renewed?
Should storage capacity be increased or reduced?
Should selected SKUs move to another location?

These decisions should be based on future cash flows and operational consequences—not historical accounting profit alone.

How a Virtual CFO Improves Warehouse Profitability

A Virtual CFO does more than produce warehouse reports.

The role is to convert those reports into action.

Typical areas of involvement include:

Designing warehouse-wise MIS
Reviewing cost allocation methods
Monitoring inventory ageing
Analysing fulfilment cost
Evaluating warehouse expansion
Reviewing working-capital impact
Identifying underperforming locations
Supporting pricing and stock-placement decisions
Updating forecasts
Tracking corrective actions

For example, if one warehouse has high cost and ageing stock, the answer may not be closure.

Management may instead consider:

Reducing warehouse space
Relocating slow-moving SKUs
Renegotiating fulfilment arrangements
Changing reorder quantities
Altering the product mix
Using the location only for fast-moving products

The objective is to improve the economics of the network as a whole.

Conclusion: Know Which Warehouses Create Value

Multi-location e-commerce businesses cannot rely only on consolidated profit numbers.

Management needs to understand:

Which warehouse is creating value?
Which location is blocking working capital?
Where are fulfilment costs increasing?
Where is inventory ageing?
And where should the next rupee of capital be invested?

Warehouse-wise accounting provides the visibility.

Consolidated reporting provides the overall financial picture.

A Virtual CFO connects the two and helps management convert financial data into decisions on inventory, pricing, capacity, working capital and expansion.

N Pahilwani & Associates works with growing e-commerce businesses on management reporting, warehouse-wise profitability, working-capital planning, inventory analysis and Virtual CFO advisory.

For the broader framework, read “Virtual CFO Services for E-Commerce Businesses in India: A Complete Guide to Profitable Growth.”

Post Views: 13