How do you Actually track JBP commitments?

9:18

JBP season is around the corner. You know it because the calendar invites are already landing and because a familiar knot is forming in your stomach.

Before you walk into that room, you need to answer three questions that sound simple and are anything but:

What have we spent toward our commitment so far this year?
How does that compare to last year?
How is upcoming year shaping up?

If your honest answer involves the phrase "let me pull that together," this post is for you. Because "pulling it together" is a two-week side project involving four planners, eleven spreadsheet tabs, and at least one late-night argument with a pivot table. And it happens every single time, your sales, finance, procurement partner or your own VP asks where you stand.

The problem isn't your team. The problem is that commitment tracking is structurally harder than it looks, and the tools most teams use were never built for it.

Commitments don't live where your budgets live

Here's the core issue: JBP and retail media commitments cut across your budget structure, not along it.

Your budgets are probably organized by category or brand, or by funding type, or by key initiatives. But your Kroger commitment doesn't care how your budgets are organized. It's a promise that spans multiple brands, multiple tactics, multiple planners’ desks, and multiple funding sources. So when someone asks "where are we against the Kroger number," there's no single place to look. Someone has to go collect the answer manually, from everyone who touches Kroger, and hope nothing was missed, double-counted, or recategorized since last quarter.

And here's the wrinkle that makes even a careful roll-up unreliable: there is no standardized definition of what counts. "Retail media" and "JBP-eligible spend" mean different things at different retail accounts. One retailer counts only its network's onsite media toward the commitment. Another includes offsite programs run through its network. A third folds in-store activation or shopper programs into the number. Your team, meanwhile, has its own internal taxonomy that maps cleanly to none of them. So two people can pull "spend toward the Kroger commitment" from the same plans and get two different but equally defensible answers. Many leaders have quietly realized this. Almost none have a solution for it, because the fix isn't a better definition memo; it's a system where the counting rules for each commitment are explicit, agreed upon, and applied automatically.

That's the first structural problem. The second one is worse.

Nobody's calendar matches anybody's calendar

Your internal fiscal year probably runs July to June, or October to September, or some other schedule that made sense to your CFO's predecessor's predecessor.

Your retail partners? Each has their own. Walmart's fiscal year starts February 1 and runs on a 4-5-4 retail calendar where weeks begin on Saturday, which means Walmart's fiscal months rarely match the months on your wall calendar, and "Q1" means something completely different to your Walmart team than it does to your finance team. Meanwhile, your retail media plan may be discussed in calendar-year quarters even as your merchant conversation runs in Walmart weeks. Target starts its year in the first full week of February. Kroger has its own rhythm. So does Albertsons. So does Costco.

Now multiply.

If you run JBPs with six retailers, you are effectively maintaining seven different views of the same spending (six retailer calendars plus your internal fiscal year), and every commitment conversation requires repackaging your plans into whichever calendar the person across the table thinks in. The time suck isn't linear. It's exponential. Each new retailer, each new commitment, each new "can you cut this by their fiscal quarter instead?" adds another translation layer between what your team actually planned and what you can confidently present.

And year-over-year comparisons that every JBP meeting demands require doing this translation twice, for two different years, and trusting that both were done the same way.

The Excel and PowerPoint trap

We've watched smart, capable teams try to solve this with the tools they have: a commitment tracker in Excel, a QBR template in PowerPoint, a heroic analyst who "owns the Kroger view."

It works… right up until anyone asks a new question.

Because the underlying data structure was never addressed, every view is a hand-built artifact. The Excel tracker knows how to answer the question it was built to answer. Ask to see the commitment summarized differently, by brand instead of tactic, in the retailer's fiscal quarters instead of yours, with last year restated on the same basis, and the team goes back into scramble mode, manually reformatting, re-pulling, and re-reconciling. The deliverable gets rebuilt, but the capability never accumulates. Next quarter, same scramble.

This is the hidden cost: not the hours themselves, but the fact that your team's analytical energy is consumed by reformatting instead of thinking. You walk into the JBP meeting with numbers you assembled, not numbers you trust, and the difference shows.

It's not just retailers holding you to a number

Retail partners aren't the only ones you've made promises to. Most shopper and omnichannel teams also carry contractual commitments to media vendors and service providers, or minimum spend levels negotiated in exchange for rates, added value, or preferred terms.

Miss those, and there are real consequences. Reporting on Walmart's recent JBP push found that brands falling short of spending commitments risk losing negotiated benefits, or things like data fee discounts, sponsorship opportunities, and early access to reporting. More broadly, under-delivering against a vendor commitment can mean forfeiting the rates you negotiated, entering next year's negotiation from a weaker position, or owing makegoods.

Which is why every December features the same ritual: someone discovers a commitment is short, and the team frantically replans, moving money at the worst possible time, into whatever can still be executed, not into what would perform best. That's not planning. That's damage control with a purchase order attached.

What proactive commitment tracking actually requires

None of this is solved by better templates. It's solved by fixing the layer underneath, i.e. the data structure that templates sit on top of. Practically, that means:

Commitments defined as first-class objects, not tabs. A commitment should exist in your planning system with its own target, timeframe, and rules, not as a formula someone maintains on the side.

Rules that define what counts. The system should know which spend counts toward the Kroger JBP. It should document commitments by retailer, by tactic, by funding source, whatever the deal says, so the roll-up happens automatically as planners plan, rather than through quarterly archaeology.

Progress that's visible continuously, not assembled on demand. If you can see allocated spend against each commitment at any moment, "where are we against the commitment?" becomes a glance, not a project. Shortfalls surface in July, when you can still do something graceful about them, instead of in December.

Targets that can cascade. An organization-level commitment should be assignable, in whole or in part, to specific retailers and planning teams, so accountability is distributed instead of ambient.

One source of truth that renders into many calendars. If your plans live in a structured system of record, restating them into a retailer's fiscal calendar is a view, not a rebuild.

Get this foundation right, and the downstream benefits compound. Replanning ( which, let's be honest, is not an annual event but a constant condition) stops being a fog of "wait, if we move this, does it break the commitment?" and becomes a confident adjustment against visible targets. And when the JBP meeting arrives, prep time collapses, because the year-over-year story has been quietly maintaining itself all along.

Where Shopperations fits

This problem is exactly why we built Goals in Shopperations. Goals let teams define spend targets that cut across their budget structure: JBP commitments, vendor minimums, strategic initiatives. When setting goals, marketing leaders specify which fields and values count toward each target, and let the platform track allocated budgets against those Goals continuously as plans evolve. Organization-level Goals can be cascaded to specific retailers and planning spaces, so every planner knows the number they own. It's the system-of-record approach to commitment tracking: define it once, and stop rebuilding the answer every time someone asks.

If JBP prep at your company still means a spreadsheet scramble, we'd love to show you a calmer way to walk into that room.