More articles:

Finance sets a sales and margin target for next season. Merchandising builds a buy plan from the range they actually want to sell. The two numbers rarely match on the first pass, and what follows is a familiar routine: a spreadsheet flies between departments, someone adjusts a growth assumption to close the gap, someone else quietly pads a buy to protect a category, and by the time the plan is signed off nobody is entirely sure which version reflects reality. It is the exact failure mode that disciplined merchandise planning is meant to prevent.

That back-and-forth is not a people problem. It is what happens when top-down financial targets and bottom-up merchandise plans are built in separate spreadsheets with no shared source of truth. This article sets out what good merchandise planning actually reconciles, who in the business relies on it, and the signs that a spreadsheet-based merchandise planning process has quietly become the biggest bottleneck in the trading calendar.

‍

Why Top-Down and Bottom-Up Rarely Agree on the First Pass

Top-down targets usually start with finance: last year's actuals, a growth ambition, a margin expectation the board has already signed off on. Bottom-up plans start somewhere else entirely, built line by line from the range merchandising wants to buy, the intake needed to support it, and the stock cover planners think the business can carry. Both are reasonable starting points for merchandise planning. Neither was built with the other in the room.

The result is a reconciliation exercise that happens in spreadsheets, over email, under deadline pressure, usually more than once a season. Whoever has the most political capital in that conversation tends to win, which is not the same as whichever number is commercially correct. Properly run merchandise planning closes that gap by design, not by whoever pushes hardest in the meeting, and it is a discipline PlanIT has built its platform around after three decades working inside merchandising teams rather than watching them from the outside.

‍

What Merchandise Financial Planning Actually Reconciles

Good merchandise planning is not a single spreadsheet or a single number. It is the discipline of keeping several linked plans in sync, so a change on one sideshows up automatically on the other instead of surfacing three weeks later in a trading meeting. The table below sets out what typically gets reconciled in a well-run merchandise planning process, and what a properly connected process produces instead of two competing versions of the truth.

‍

Once those four areas are reconciled continuously rather than rebuilt every budget cycle, merchandise financial planning software stops being a once-a-season exercise and becomes the working layer both finance and merchandising actually plan from. PlanIT's WSSI is built around exactly this kind of reconciliation, keeping top-down targets and detailed bottom-up forecasts in the same place so a change to one flows straight through to the other instead of waiting for the next manual update. The MFP module in our Visual Assortment Plan follows the same principle: disaggregating top-down finance targets through both merchandise and location hierarchies, and tracking bottom-up item plans against targets at every step.

‍

Who Actually Relies on This, and Why

Merchandise planning rarely has a single owner, which is part of why it breaks down so easily when it lives in spreadsheets. The table below sets out what a properly reconciled process gives each of the teams who touch it, because a business case for MFP retail software only holds up once it is clear what changes for everyone in the room, not just the planning team.

‍

Once every role can see the same reconciled numbers, merchandise planning stops being something the planning team does on everyone else's behalf and starts being a shared discipline the whole trading calendar runs on.

‍

Signs Your Merchandise Planning Process Has Outgrown Spreadsheets

Most retailers do not decide to fix their merchandise planning process in the abstract. Something specific keeps happening that makes the cost of staying on merchandise planning spreadsheets obvious. A handful of signs come up again and again in conversations with mid-market fashion and lifestyle retailers.

• The trading meeting starts with an argument about whose numbers are right, not a discussion about what to do next.
• Reforecasts take days to turn around because every change has to be manually rebuilt across three or four linked spreadsheets.
• Nobody can say with confidence which version of the plan is the current one, especially once more than two people have edited it.
• OTB decisions get made on gut feel because the bottom-up detail behind the top-down number is too slow to interrogate in the moment.
• The finance team and the merchandising team each keep their own shadow version of the plan, just in case.

Any one of these is manageable on its own. Three or four of them together usually mean the spreadsheet has stopped being a planning tool and started being the constraint on how fast the business can move.

‍

What Good Merchandise Financial Planning Looks Like in Practice

Picture a typical autumn/winter plan. Finance asks womenswear for 8% sales growth at a 58% intake margin. Merchandising's bottom-up buy plan, built from the options the team actually wants to carry, lands at 5% growth because two new categories carry lower margins and longer lead times. In a spreadsheet process, that three-point gap turns into a week of emails and a quiet uplift to the growth assumption, so the numbers match on paper but not in the stockroom.

In a reconciled process, the gap shows up the moment the buy plan is entered, broken down by category and month. The team can see the shortfall sits almost entirely in the two new categories, test whether bringing intake forward or adding depth to proven continuity lines closes it, and agree a plan both sides can defend before anything is ordered. The conversation moves from whose number is right to which lever to pull.

The same logic extends into range and option planning too. PlanIT's Visual Assortment brings the MFP layer together with product selection, volumes and size curves in one place, so a financial target and the range built to hit it are always looking at the same numbers rather than being reconciled after the fact.

None of this requires a full ERP replacement to get started, which is usually the biggest hesitation once a retailer accepts spreadsheets have become the bottleneck. It simply requires treating merchandise planning as one connected process rather than a set of documents passed between departments.

‍

Where This Leaves Finance and Merchandising Teams

The tug-of-war between top-down targets and bottom-up forecasts is one of the oldest problems in merchandise planning. Fixing it does not mean picking a side. It means building a merchandise planning process where finance and merchandising are already working from the same reconciled numbers before the trading meeting starts, not arguing their way toward them inside it. Retailers wanting a clearer sense of what a reconciled approach to merchandise planning would be worth in practice can use PlanIT's benefit calculator to estimate the likely financial impact before committing to anything.

‍

Talk Through Your Own Merchandise Planning Gap

If finance and merchandising are still reconciling targets and buy plans by hand, PlanIT's team can walk through what a properly connected approach to merchandise planning would look like for your business. Get in touch to arrange a conversation.

Frequently Asked Questions

What is merchandise financial planning (MFP)?

Merchandise financial planning is the process of setting and reconciling sales, margin, intake and stock targets at a category or department level, connecting top-down commercial goals with the bottom-up detail of the range and buy plan so both sides are working from one number rather than two. It sits at the centre of how mature merchandise planning teams run their trading cycle.

How is MFP different from a WSSI or a demand forecast?

A demand forecast predicts what is likely to sell. A WSSI tracks sales, stock and intake weekly against plan. Merchandise financial planning sits above both, setting the financial targets those operational tools are then measured against, which is why the three are meant to work together rather than replace one another.

What does merchandise financial planning software actually need to do?

At minimum, it needs to keep top-down financial targets and bottom-up, line-level plans reconciled automatically, so a change on one side is reflected on the other without a manual rebuild. Anything that requires exporting to a spreadsheet to check whether the numbers still agree is not really solving the merchandise planning problem it was bought to fix, whatever the vendor calls it.

Do we need to replace our ERP to implement a proper MFP process?

No. A merchandise financial planning layer typically sits above the ERP, reconciling commercial targets and merchandise plans without requiring a wider systems overhaul, which is usually what makes better merchandise planning a realistic near-term fix rather than a multi-year programme.