Skip to main content

Disputes Report: Track Dispute Outcomes and Reconcile Statuses

Written by Carter King

Once a deduction is disputed, your team needs to know what happened to each attempt: was it approved, denied or still pending, and who filed it. The Disputes Report is a dataset in Report Builder built to answer that question.

What is the Disputes Report?

The Disputes Report is a dataset in Report Builder where each row represents one dispute attempt, not a deduction and not a payment. If a deduction was disputed three times, it appears as three rows. It answers the question "What was done about it?"

Use it when you need to:

  • Reconcile dispute statuses against your ERP or other internal systems

  • Measure recovery performance, such as approved vs. denied amounts, by retailer, solution or RevLoss type

  • Spot dispute patterns, such as how many attempts it takes to win a dispute

  • Separate disputes filed through SPS from disputes filed outside SPS

Which report should I use?

Report Builder has three datasets. Each one answers a different question, so pick the one whose row matches what you are counting.

Dataset

One row is

Answers

Best for

RevLoss

One deduction

What was lost?

Total exposure across retailers, claim codes and date ranges; measuring dispute opportunity

Disputes

One dispute attempt

What was done about it?

Recovery performance, dispute patterns, SPS vs. self-disputed, reconciling dispute statuses in other systems

Recoveries

One payment or mitigation

What did we get back?

Payment matching and cash application

Where to find it

  1. From the Home menu, go to Reporting.

  2. On the Datasets tab, find the Disputes card.

  3. Click Build a Disputes Report, or select the Disputes tab from the top navigation.

Building your report

The Disputes Report builder has three sections. You can download with the default (widest) filters to get everything, or narrow the results first.

1. Customer Information

Field

What it does

Report Title

Names your export file. Special characters (: * / ? < > , ; \) aren't allowed.

Supplier(s)

Choose which supplier/retailer accounts to include.

RevLoss Types

Limit the report to specific types of revenue loss. Defaults to All Types.

2. Date Information

Field

What it does

Date Type

Determines which date the report filters on. Defaults to Dispute. Options are Dispute, Approved, Denied and Last Updated.

Date Range

Toggle between Rolling (a relative window such as All Time) and Custom (a specific start and end date).

Timeframe (Rolling)

Select a preset window. Defaults to All Time.

Start Date / End Date (Custom)

Enter a specific date range.

3. Amount Information

Field

What it does

Amount Types

Choose which amount to filter on. Defaults to All. Options are Dispute, Approved and Denied.

Minimum / Maximum

Set a dollar range for the selected amount type. These fields stay disabled until you select an amount type.

Disputed with SPS

Check this box to limit results to disputes filed through SPS.

As you adjust filters, the record count at the bottom of the form updates so you know roughly how many rows to expect before you download.

Downloading

  • Clear Filters resets the form to its widest defaults.

  • Download Report exports your results as a file you can open in Excel or import into your ERP or reconciliation tool.

  • Schedule Report sets up a recurring export.

What's in the export

The export has 28 columns. Each row is one dispute attempt, with the details you need to match it to your own records.

Account and identifiers

Column

What it shows

Unique ID

Unique identifier for this row (one dispute attempt). Helpful for knowing when to create or update records in other systems.

Recovery Action ID

SPS reference for the dispute record.

Organization Name

Your organization.

Supplier Name

The supplier/retailer account the dispute belongs to.

Retailer

The retailer the dispute was filed with.

Currency Code

Currency of all amount columns.

What was disputed

Column

What it shows

Solution

The type of recovery work: deductions, overages, open invoices, co-ops, chargebacks, etc.

RevLoss IDs

Reference to the deduction or other record being disputed.

RevLoss Types

The type of revenue loss/deduction, such as the retailer's claim code or reason.

PO Numbers

Purchase order number(s) for the revenue loss/deduction item tied to the dispute.

Invoice Numbers

Invoice number(s) for the revenue loss/deduction item tied to the dispute.

Invoice Dates

Date(s) of those invoices.

Validity Judgement

An SPS-made assessment of whether the deduction is valid, such as Likely Invalid or Validity Unclear.

Dispute details

Column

What it shows

Dispute Source

Where the dispute originated: revenue-recovery or external.

External Dispute ID

The retailer's own reference for the dispute, when one exists.

Dispute Date

Date this dispute attempt was filed.

Dispute Method

How the attempt was filed, such as Individual, Bulk, Auto, Auto MDC or Manual.

Dispute Description

The note or reason submitted with the dispute.

Dispute Attempt #

Which attempt this row is for (1 = first dispute, 2 = second, and so on).

Dispute Status

Current status of the attempt: Approved, Denied, Pending Retailer or Supplier Action.

Amounts and outcome

Column

What it shows

Disputable Amount

The amount that could be disputed at the time the dispute was filed.

Dispute Amount

The amount disputed in this attempt.

Approved Date

Date the retailer approved (all or part of) the dispute.

Approved Amount

Amount approved by the retailer.

Denied Date

Date the retailer denied (all or part of) the dispute.

Denied Amount

Amount denied by the retailer.

Paid

Whether any of the approved amount has been paid/remitted (true or false).

Last Updated

Date this record last changed. Helpful for updating records in other systems.

Things to know when reading the export

Because every row is one attempt, a few patterns in the data are expected.

  • One deduction can appear on several rows. Each re-dispute adds a row with a higher Dispute Attempt #. To follow one deduction through its attempts, group by RevLoss IDs and sort by Dispute Attempt #.

  • Don't add up Dispute Amount across attempts for the same deduction. Each attempt could repeat the amount at stake, so summing every row counts the same dollars more than once. Use the latest attempt for a deduction-level view.

  • Some columns can be blank. External Dispute ID is empty when the retailer doesn't issue one. Dispute Description is empty for some solutions. Approved Date and Denied Date are empty until the retailer decides.

  • Some cells hold more than one value. Columns such as Invoice Numbers can list several values separated by a pipe ( | ). Most commonly when one dispute is associated with multiple revloss items/deductions.

  • Disputes filed outside SPS are included. Use the Dispute Source column, or the Disputed with SPS filter, to separate them.

Using it to reconcile dispute statuses

A typical workflow looks like this.

  1. Set Date Type to the date your team reconciles against, and choose the period you're closing out.

  2. Leave Amount Types set to All on your first pass to see the full picture.

  3. Download the report and match each row by an identifier such as PO Numbers and Invoice Numbers against the open items in your ERP.

  4. Compare each row's Dispute Status, Approved Amount and Denied Amount to what your system shows, and update anything that is out of date.

  5. Use the Disputed with SPS checkbox to separate disputes SPS filed from those filed outside SPS, if your team tracks them separately.

  6. Repeat on a recurring basis, for example weekly or monthly as part of your close process.

Related features

  • Scheduled Reports: Once you've set the filters you want, check the Scheduled Reports tab to see whether a recurring export can keep this data flowing into your process without a manual re-download.

  • RevLoss Report: Still the right tool for measuring total deduction exposure across retailers, claim codes and date ranges.

  • Recoveries Report: Use it when you need to match payments, check numbers and cash application rather than dispute statuses.

Did this answer your question?