Skip to main content

Trade Promotion Management (TPM) - How it Works

How It Works — Comprehensive Reference Guide

D
Written by Dom Kang

1. What Is the Trade Module?

The five core purposes of TPM in Confido — and how they connect.

The Trade module in Confido serves as the commercial and financial backbone of your trade promotion process. It is where all retailer and distributor promotions, funding agreements, and allowances live — and where they connect to your sales forecast, trade liability, deduction validation, and performance reporting.

There are five core purposes of the Trade module:

Purpose

What It Means

System of Record

All retailer and distributor promotions, contracts, and funding agreements live here — with dates, products, rates, and supporting documents attached.

Trade Spend Forecasting

As promotions are entered, Confido uses volume and funding rate to forecast total trade spend — keeping your gross-to-net sales forecast accurate.

Trade Liability Management

Confido maintains a real-time view of your outstanding trade liability — what you have accrued but not yet been charged for — so it can tie to your balance sheet at any point in time.

Deduction Validation

When deductions come through from customers, they are matched against promotions in the trade calendar. Valid deductions are tied out against the relevant accrual; invalid ones are flagged for dispute.

Performance Improvement

Confido tracks whether promotions executed as planned — did the retailer hit the right price point, was it compliant, how incremental was it? This data improves future planning.

2. The Trade Calendar

Navigating the different views of your promotional calendar.

The Trade Calendar is your source of truth for all active, upcoming, and historic trade agreements. There are four views to choose from, each serving a different purpose.

2.1 List View (Group by Event)

The default and most commonly used view. Shows every promotional event as a single row — even if that event has multiple promotion lines within it. You can expand an event to see all of its underlying lines.

From this view you can filter by planning group, PPG, promotion type, financial period, or any other attribute to hone in on what you need. You can also add custom columns (e.g., last updated date, contract ID) and export the full list to Excel.

Tip: Most users start here — search for an event, click into it, and review or edit the underlying lines. The Group by Promotion view (which shows every single line individually) is available but tends to be less practical for day-to-day navigation.

2.2 Calendar View

A visual timeline showing when different promotions are running throughout the year. You can zoom in to a weekly view or out to a quarterly view. Hovering over a promotion shows high-level details.

Useful for quickly spotting gaps or overlaps in your promotional calendar, or for sharing a visual overview of upcoming activity. You can filter to a single planning group using the quick filter at the top.

Note: When filtering by financial period, promotions that span two periods (e.g., starting in P1 and ending in P2) will appear in both period views — the filter shows any promotions with overlapping dates, not just those whose start date falls in the period.

2.3 Board View (Approval Workflow)

The board view shows the lifecycle stages of all promotions in a Kanban-style layout. This view becomes most useful if your organization sets up an approval workflow. The stages are:

Stage

What It Means

Draft

Promotion has been created but not submitted. Does not show up in trade spend forecast or accruals. A placeholder only.

Awaiting Approval

Promotion has been submitted and is pending review by a designated approver. Only appears if an approval rule is configured.

Approved

Promotion is confirmed, accruals are generated, and it appears in the forecast and trade spend views.

Executing

Today's date falls within the promotion's date range. Automatically moves here — no manual action needed.

Historic

Promotion dates have passed. Automatically moves here after executing.

Canceled

Promotion has been manually canceled.

Missed

Created retroactively from a deduction — used when a promotion was not entered in advance but a valid deduction arrived for it.

Note: When creating a promotion, you choose to either 'Save as Draft' or 'Create Promotion' (which immediately submits it). If an approval rule applies, it will go to Awaiting Approval. If not, it goes straight to Approved. You can always move a live promotion back to Draft status if needed.

2.4 Approval Workflows

Approval rules can be configured to require sign-off before certain promotions become active. Common examples:

  • Any promotion involving slotting fees requires approval

  • Any promotion above a certain dollar threshold requires approval

Approvers can review and approve promotions directly in the board view, or from the promotion detail page. Once approved, the promotion flows into the forecast and accruals automatically.

3. Creating Promotions

How to enter promotions — including planning group vs. ship-to level, common promotion types, and retailer-specific nuances.

Promotions are created from the Trade Calendar using the New Promotion button. Before entering the lines, there are two key decisions to make: the planning level and the promotion structure.

3.1 Planning Group Level vs. Ship-to Level

Every promotion is created at one of two levels, which determines what volume it is based on and which date type drives its lifecycle:

Level

Planning Group (Retailer)

Ship-to (Distributor/OI)

Volume basis

In-store consumption or distributor depletions

Shipment volume to the customer

Date type

In-store execution dates (when the promo runs on shelf)

Shipment dates (when product leaves your warehouse)

Use for

Scan backs, TPRs, BOGOs, ads, end caps, coupons, MCBs, fixed fees tied to retail execution — any retailer-facing promo

OIs (off-invoice discounts), buy allowances, distributor deals — anything funded per unit shipped rather than per unit scanned

Note: Best practice for OIs: even if you plan retailer-level promotions (e.g., Sprouts) at the planning group level, create OI programs (e.g., a 15% UNFI buy allowance) as a single ship-to promotion for the total distributor. Confido will apportion the OI cost back down to individual retailers in trade rate reporting based on their volume share within the distributor.

3.2 Events and Promotion Lines

A promotion event is the top-level container. Within one event, you can have multiple promotion lines. Use separate lines when:

  • Different PPGs have different funding rates

  • You have both a scan-based component and a fixed fee within the same promotion (e.g., TPC + end cap fee)

  • A subset of stores receives additional placement (e.g., a TPR in all stores plus a co-space in 200 stores)

If you have a promotion that runs across two different periods (e.g., P1 and P2), you can either enter it as one event and use the auto-split rule to split by period, or manually use the 'Split by Period' button when creating. Each split generates its own line in the accruals view.

3.3 Common Promotion Fields

When creating a promotion line, the key fields are:

  • Promotion type — scan, TPR, BOGO, coupon, MCB, ad, slotting, fixed fee, OI, etc. Retailer-specific shortcut buttons (e.g., Target Circle, Target Digital Accrual, Whole Foods Off-Shelf) auto-populate the most common settings for that type.

  • Product (PPG) — the product family or PPG this line applies to. Multiple PPGs can be included on one line if they share the same funding rate.

  • Funding rate — what you are paying to the retailer: dollars per unit scanned, a percentage, or a flat dollar amount.

  • Promoted price — the target retail price during the promotion. Used to estimate lift via historical comparisons.

  • Promoted stores — if the promotion only runs in a subset of stores (e.g., 50% of locations, or a specific store count), enter it here. Confido will scale baseline volume and lift expectations proportionally.

  • Lift / incrementality — how much additional volume you expect the promotion to generate above baseline. Can be entered manually, selected from a historical bump chart, or auto-projected by entering the promoted price.

  • Contract ID — a unique identifier from the retailer's contract or portal. Entering this significantly improves deduction auto-matching on the back end.

  • Contract attachment — drag and drop the actual deal sheet or contract PDF. Confido can also read a contract and help pre-fill promotion details.

Tip: Drag a contract or deal sheet onto a promotion at any point in the creation process. Confido will read it and help pre-fill fields like dates, PPGs, and funding rates. You can also forward contracts to a Promo Inbox email address and Confido will create a draft promotion from the document.

3.4 Scan Back Days Before and After

Some retailers (notably Whole Foods, and occasionally Kroger) charge scan back fees for additional days before and after the actual promotion window — even though no promotion tag is on the shelf during those days. Enter these in the 'Scan back days before' and 'Scan back days after' fields at the top of the promotion creation screen.

This ensures your trade spend forecast captures the full cost of those extra scan days, even though no lift is expected from them.

3.5 Whole Foods Promotions — A Detailed Example

Whole Foods promotions have a specific structure that differs from most other retailers. The recommended approach for a standard Whole Foods promotion event is to create three lines:

  • Line 1 — Regular scan: The base scan allowance for all shoppers (e.g., $1.00/unit). Enter your lift here — this is where all incremental volume should be captured.

  • Line 2 — Prime scan: Duplicate the regular scan line. Change the funding rate to the prime-member-only rate (e.g., $0.20/unit additional). Add a redemption rate (typically 85–90%, representing the proportion of purchases made by Prime members). Do NOT enter lift on this line — it has already been captured on Line 1.

  • Line 3 — Flat fee: The off-shelf or TPR fee (a fixed dollar amount). No lift — that was captured on Line 1.

Important: Only enter lift on one line per promotion event (typically Line 1, the regular scan). If you enter lift on both the regular scan and the prime scan, you are counting the same incremental volume twice, resulting in a significantly over-stated lift estimate.

The scan back days before and after are also commonly used for Whole Foods: typically 2 days before and 5 days after the promotion window.

3.6 Year-Long / Rate-Based Promotions

For customers where you plan trade at a flat rate rather than event-by-event (e.g., a distributor with a 25% annual trade rate, or a retailer with a year-long EDLP allowance), you can create a single promotion spanning the full year:

  • Set the dates to cover the full year or agreement period.

  • Select all relevant PPGs — Confido will only pull in forecasted volume for products you actually sell to that customer, even if other PPGs appear in the dropdown.

  • Enter the percentage (or per-unit rate) and Confido will calculate total spend based on volume.

  • Use 'Split by Period' (or configure the auto-split rule) to break the single event into individual period lines in the accruals view.

Note: Trade rate promotions (rate-based, non-event) reduce the ability to auto-match deductions, since there is no specific event for the system to match against. Deductions against these promotions typically require more manual tagging by the deductions team.

3.7 Duplicating Promotions

Once a promotion is created, you can duplicate it to multiple other periods or copy it to the following year — without having to re-enter all the details. To do this, select the event in the list view and click Duplicate Event.

The duplicate will:

  • Copy all funding rates and promotion line details

  • Update the baseline volume to reflect whatever is forecasted in the target weeks (so it uses your current forecast, not the original)

  • Hold the lift percentage flat (so the incremental units will adjust as baseline volume changes, but the lift % stays the same)

  • Take a pass at the new dates, which you can adjust if needed

Tip: Duplicating promotions is especially useful for recurring events — a retailer that runs the same scan allowance four times a year, or a BOGO that repeats each quarter. Create it once, then duplicate it out to all future occurrences in a single step.

Draft status copies forward: if the original promotion is in draft, the duplicates will also be in draft and will not affect the forecast or accruals until submitted.

4. The Accruals Module

How promotions generate accruals, how to manage them month-to-month, and how deductions tie out against them.

When a promotion is created and approved, it generates accrual lines — one per promotion line per period. The Accruals module is where your team manages, books, adjusts, and closes these accruals as part of the monthly trade liability process.

4.1 When Accruals Are Generated

Accruals are only generated when:

  • The promotion is not in Draft status (must be Approved or beyond)

  • The promotion type is configured to generate accruals. Some types — such as off-invoice discounts, cash discounts, or early payment discounts — can be set to 'non-accruing' in Trade Calendar Settings. These still appear in the trade spend forecast but do not create accrual lines.

The accrual date is configurable per promotion type. The default is the buy-in date (i.e., when product ships, not when the promotion runs on shelf). This aligns the accrual with the shipment timing that drives your P&L recognition. You can also configure certain promotion types to accrue on the in-store event date if that better matches your accounting methodology.

4.2 The Accruals List View

Each accrual line in the list view shows:

  • Promotion description and period

  • Planning group, PPG, and promotion type

  • Forecasted promotional spend — what the promotion is expected to cost based on the current volume forecast and funding rate

  • Deductions — the total deductions that have been tagged to this promotion line

  • Booked accrual — the amount locked in at month-end (populated after you book the accrual)

  • Adjustment — any manual upward or downward adjustment made after booking

  • Open accrual balance — what is still outstanding (booked amount minus deductions minus any adjustments)

  • Status — open, closed, or flagged with a recommendation

4.3 Booking the Monthly Accrual

At month-end, once all deductions have been tagged and the trade liability view looks accurate, you book the accrual. This is the point-in-time snapshot that gets posted to your ERP (e.g., SAP).

When you book an accrual:

  • The current forecasted promotional spend moves to the 'Booked Accrual' column

  • The booked amount is locked — it will never change, even if the sales team later edits the promotion

  • All future changes to the promotion only affect the 'Forecasted Spend' column, not the booked amount

  • Full version history is maintained — you can always look back at what was booked in any prior period

Note: If you need to adjust a booked accrual after the fact (e.g., new intel suggests the cost will be meaningfully different), use the Adjustment column rather than editing the promotion directly. This keeps a clean audit trail of the original booking and the subsequent adjustment.

4.4 Accrual Recommendations

Confido generates accrual recommendations to flag items that may need attention. These are configured in Trade Calendar Settings under 'Accruals Recommendations Logic.' The two main trigger types are:

  • Age-based: If an accrual has been open for longer than a configured threshold (e.g., 4 or 6 months since the promotion ended), Confido flags it as a candidate for closure.

  • Variance-based: If the latest estimate of what the promotion will cost (from the sales forecast or syndicated data) has deviated significantly from the booked amount — by more than a configured percentage (e.g., 25%) — Confido flags it for review and potential adjustment.

Recommendations appear at the top of the Accruals view as a count (e.g., '3 medium recommendations'). They are also highlighted in the Status column on the relevant rows. You can filter the list to show only recommended items, review them, and bulk-accept to close multiple at once.

Tip: Monthly best practice: before closing the books, filter the accruals list to untagged deductions first, make sure everything is tagged, then switch to the recommendations view to work through flagged items. This ensures your liability is accurate before you book.

4.5 Closing an Accrual

When you are satisfied that all deductions have been received and tagged, and the open balance is at or near zero, you close the accrual. Closing sets the open balance to $0 and moves the accrual to closed status.

After an accrual is closed, the trade reporting views (trade P&L, trade rate) reflect only the actual deductions received — not the original forecasted amount. This allows you to see your true favorability or overspend versus your original plan.

Important: As long as a promotion's accrual remains open, the trade reporting views use the forecasted spend amount (not actual deductions). Once closed, only actual deductions are reflected. This means closing accruals promptly is important for accurate trade rate and P&L reporting.

4.6 Deduction Tagging in the Accruals View

Deductions that arrive and are matched to a promotion are visible in the Accruals view under each promotion line. If a deduction was not auto-matched, you can manually tag it here.

The Deductions sub-view (accessible from within the Trade module) shows all deductions by period and lets you filter for untagged items. This is the primary tool for bulk tagging at month-end — filter to your relevant trade types and period, identify untagged deductions, and tag them to the appropriate promotion lines in bulk.

Note: Deductions must be tagged to a promotion line before they appear in the 'Deductions' column of the Accruals view. Until a deduction is tagged, it does not reduce the open accrual balance. Always ensure deductions are fully tagged before reviewing your month-end liability position.

5. Deduction Timing Intelligence

An AI-powered view that learns the typical lag between promotion execution and deduction arrival — to help you manage accruals more proactively.

The Deduction Timing view is an AI-powered feature within the Trade module that builds over time as deductions get tagged to promotions. Its purpose is to help your team understand how long it typically takes for a deduction to arrive after a promotion ends — by retailer — and use that to make smarter decisions about when to close accruals.

5.1 What It Shows

  • Average lag — the typical number of days between a promotion's end date and the first deduction arriving for that customer

  • Deduction count — whether customers typically send one deduction per promotion or multiple

  • Forward-looking estimates — for promotions currently executing or recently completed, Confido can estimate when you should expect to see the deduction arrive

This view becomes more accurate over time as more deductions are tagged to promotions. Early in implementation, the data will be sparse; after several months of usage it becomes a meaningful planning tool.

5.2 How It Helps

The deduction timing data feeds into accrual recommendations — specifically the age-based threshold. If Confido knows that Target typically sends deductions within 18 days of a promotion ending, and it has been 60 days since your promotion ended with no deduction, it can flag the accrual as overdue and recommend closing it.

It also helps the trade team set realistic expectations for when deductions will arrive, reducing the need to manually track promotion status in spreadsheets.

6. Trade Reporting

Key reporting views for monitoring trade spend, performance, and liability.

The Trade module includes several reporting views that give your team visibility into how trade spend is tracking versus plan — and how your promotions are performing.

6.1 Trade Summary (P&L) View

The Trade Summary view shows your gross-to-net sales structure — revenue, trade spend by type, and net sales — at any level of the hierarchy (total brand, retailer, PPG). This is your primary view for monitoring trade rate and comparing to your AOP or target.

While a promotion accrual is open, it holds the original forecasted spend amount. Once the accrual is closed, only actual deductions are reflected. This means trade rate reporting becomes most accurate after accruals for a period have been fully reviewed and closed.

6.2 Promotion Performance

The promotion performance view shows, for each promotion: what volume was planned, what actually scanned (from syndicated data), what lift was expected, what lift was observed, and what it cost versus what was forecasted. This is used for post-event analysis to inform future lift assumptions.

This view can be filtered and grouped by retailer, PPG, promotion type, or time period. It feeds directly into the historical bump chart used when setting lift expectations for new promotions.

6.3 Accruals Reporting View

A period-based view (as opposed to the list-based Accruals module) showing what was booked versus what actually came through for each period — column by column across the year. This view is more suited to retrospective reporting and month-over-month comparisons than to day-to-day accrual management.

7. Frequently Asked Questions

Common questions from training sessions and onboarding calls.

Q: When should a promotion be at the planning group level vs. ship-to level?

A: Planning group for anything tied to in-store execution: scan backs, TPRs, BOGOs, end caps, ads, MCBs, and fixed fees related to retail activity. Ship-to for anything funded per unit shipped: OIs, buy allowances, and distributor-level agreements. OIs should always be ship-to, even if all your other promotions for that retailer are planning group level.

Q: Can one event have both a planning group promotion and a ship-to promotion?

A: No — each event is at one level. If you need both a retailer-facing scan promotion (planning group) and an OI for the same distributor, create them as separate events.

Q: What is a 'Missed Promotion' and when do I use it?

A: A missed promotion is created retroactively — typically when a deduction arrives and there is no existing promotion in the system to match it to. Rather than leaving it unmatched, you (or the deductions team) can create a missed promotion from within the deduction, which creates a backdated event in the trade calendar. This allows the deduction to be tied out against an accrual and keeps your liability view clean.

Q: Does a draft promotion affect my forecast or accruals?

A: No. Draft promotions are invisible to the forecast, trade spend views, and accruals module. They are personal placeholders only. The promotion must be submitted (and approved, if an approval rule applies) before it affects any financial or planning data.

Q: For Whole Foods promotions, where should I enter the lift?

A: Only on the regular scan line (Line 1). Do not enter lift on the prime scan or the flat fee lines. Because all three lines reference the same underlying volume, entering lift on more than one line causes Confido to count the same incremental volume multiple times.

Q: What happens if a deduction is not tagged to a promotion before I book the accrual?

A: The deduction will not reduce the open accrual balance, so your liability will appear higher than it actually is. Always ensure deductions are tagged (either auto-matched or manually tagged) before reviewing and booking your month-end accrual. The Deductions sub-view in the Trade module lets you filter for untagged items to resolve them quickly.

Q: Can I use a trade rate (percentage) approach for some customers and event-based for others?

A: Yes. Confido supports both approaches within the same system. The trade-off is that rate-based promotions have less auto-matching capability on the deductions side — since there is no specific event for the system to match against, more manual tagging is required by the deductions team. Event-based promotions provide the best auto-matching and accrual accuracy.

Q: Can the system auto-split promotions that cross two periods?

A: Yes. You can configure an auto-split rule in Trade Calendar Settings so that any promotion entered with dates spanning multiple periods is automatically split into one line per period. Alternatively, you can manually use the 'Split by Period' button when creating a promotion. Period-split lines appear as separate rows in the Accruals view — one per period — which aligns with how accruals are typically booked monthly.

Q: How does the OI from a distributor agreement get allocated back to individual retailers in reporting?

A: When you create a ship-to promotion for a total distributor (e.g., a 15% UNFI buy allowance), Confido apportions that cost back to the individual retailers within UNFI based on their volume share. This means the Meijer planning group view, for example, will reflect its proportional share of the UNFI OI in the trade rate report — even though the OI was set up as a single distributor-level agreement.

Confido Trade Promotion Management — Internal Reference

For questions, contact your Confido onboarding team.

Did this answer your question?