Purplle Fee Verification and Marketplace Reconciliation

Purplle fee verification is a recurring finance task for sellers that need to confirm whether marketplace charges, commissions, and deductions align with expected values. When order volumes grow, manual review in Excel becomes slow and difficult to audit. Cointab helps finance teams set up a structured reconciliation workflow so they can compare expected fees against Purplle-reported data, review exceptions, and export audit-ready reports.

How Purplle fee verification works in Cointab

Cointab uses a Side A and Side B reconciliation model.

• Side A contains the records your business expects to be correct, such as internal order data, SKU-level pricing, and expected fee calculations.
• Side B contains the external Purplle reports that show the actual charges, deductions, and settlement values.

Instead of manually checking every row, finance teams upload the relevant files once, map the required fields, and run reconciliation. The system then matches records using identifiers, amount logic, and comparison rules.

For Purplle fee verification, this usually means comparing:

• order-level data from internal systems
• payment or settlement data from Purplle
• rate card information used to calculate expected commissions or charges
• SKU master or product mapping data used for enrichment and fee calculations

Reports commonly used for Purplle reconciliation

A Purplle fee verification workflow can use multiple reports and supporting files.

Primary reports

• Order report: Contains order IDs, item details, quantities, and order values from the seller’s internal records.
• Purplle payment or settlement report: Shows the actual amounts paid, fees deducted, and settlement-related values reported by Purplle.
• Rate card: Provides the fee rules or percentage logic used to calculate expected marketplace charges.

Supporting data

Supporting data is optional, but it makes fee verification more accurate and easier to audit.

Common supporting files include:

• SKU master: Helps map product-level attributes or pricing logic
• Product master: Useful for enriching item-level records
• Mapping file: Helps align marketplace fields with internal identifiers
• Tax or fee reference file: Useful when expected values depend on additional rules

Supporting data is not reconciled directly. It is used to enrich, merge, calculate, or prepare the primary data before reconciliation.

What Cointab checks during fee verification

Cointab can calculate expected fee values using the data you upload, then compare them with the actual Purplle charges. The platform supports derived columns, so finance users can create calculated fields without building formulas manually.

Typical checks include:

1. Expected fee calculation

   • Use order data, SKU data, and rate card rules to calculate the expected charge.

2. Fee comparison

   • Compare the calculated amount with the fee shown in the Purplle report.

3. Discrepancy review

   • Flag orders where the charged amount differs from the expected amount.

4. Exception classification

   • Separate fully matched, partially matched, unmatched, and skipped records.

5. Open item analysis

   • Use AI-assisted review for unresolved transactions where simple rules are not enough.

Result categories in a Purplle fee reconciliation

Cointab makes it easy to review the output by separating records into clear categories.

Fully matched

These records match as expected. The fee calculated from the internal data aligns with the Purplle-reported amount.

Partially matched

These records are related, but the amounts do not align exactly. Partial matches are useful when the order or reference matches, but the fee needs review.

Unmatched

These are records that appear on one side but not the other. For fee verification, that may mean an internal order has no corresponding marketplace entry, or a marketplace deduction cannot be tied back cleanly to internal records.

Skipped

These are rows excluded from reconciliation because they are incomplete, invalid, duplicated, or missing required data.

This classification helps finance teams focus on exceptions instead of reviewing every transaction manually.

Why manual spreadsheet checks are difficult

Purplle fee verification can become repetitive when teams rely on Excel formulas, VLOOKUPs, and copy-paste workflows. Common problems include:

• formulas breaking as files change
• inconsistent calculations across team members
• large files becoming difficult to manage
• unclear audit trails
• open exceptions staying unresolved for too long
• repeated setup work every month

Cointab replaces that with a reusable reconciliation setup. Once the workflow is configured, teams can use it for future periods without rebuilding the same logic every time.

How teams can handle exceptions

After reconciliation, users can review discrepancies and take the next step more quickly.

Cointab supports:

• filtering matched and unmatched records
• viewing transaction-level details
• analyzing why a fee may have been overcharged or undercharged
• manually matching records when business context is clear
• refreshing the report if a file was missed and uploaded later

This is especially useful for marketplace operations teams and finance teams that work with delayed reports or changing settlement files.

Reuse for future Purplle periods

A major advantage of Cointab is reuse. Once a Purplle fee verification workflow is created, the same setup can be used for future periods such as monthly or quarterly reconciliation.

For recurring runs, teams typically only need to:

• select the reconciliation
• choose the period
• upload or receive the required files
• run reconciliation
• review the report

This helps reduce repeat work and keeps the process consistent across accounting cycles.

Automation for recurring marketplace reconciliation

For teams that reconcile Purplle data regularly, Cointab can support automated data input and scheduled reconciliation runs through email, SFTP, or API-based workflows.

That means the reconciliation can move from a manual upload process to a recurring finance operation where files are received, validated, matched, and reported with less manual effort.

Automated output can also be pushed back to downstream systems through email, SFTP, or API, depending on the team’s workflow.

Why Purplle fee verification matters for finance teams

Marketplace fee verification is not only about checking individual charges. It also supports broader finance control across settlement review, revenue accuracy, exception handling, and month-end close.

With a structured reconciliation process, teams can:

• validate marketplace charges against expected values
• identify overcharges or undercharges early
• review deductions in a clear format
• keep an audit-ready record of matched and unmatched items
• reduce dependency on manual Excel work

For marketplace sellers, that means fee review becomes a controlled, repeatable process rather than a one-off spreadsheet exercise.

Common data fields used in the workflow

For Purplle fee verification, teams often map fields such as:

• order ID
• transaction ID
• SKU
• item amount
• settlement amount
• commission or fee amount
• payment reference
• date
• quantity

Cointab also supports derived columns for values such as clean order IDs, net amounts, or calculated fee amounts when the logic needs to be normalized before reconciliation.

What finance users see after reconciliation

The reconciliation dashboard shows the completed run, along with the report status and key summary totals. Users can review matched, partially matched, unmatched, and skipped records, then drill into transaction-level tables for more detail.

The output is designed to be easy to review internally and suitable for audit follow-up, partner clarification, and finance reporting.

Frequently asked questions

What is Purplle fee verification?

Purplle fee verification is the process of comparing expected marketplace fees with the actual charges and deductions shown in Purplle reports. It helps sellers confirm whether commissions and other fees were applied correctly.

Which files are needed for Purplle reconciliation?

A typical workflow uses an order report, a Purplle payment or settlement report, and a rate card. Teams may also use SKU master or other supporting files to enrich the data before reconciliation.

Can Cointab help with fee differences that are not exact matches?

Yes. Cointab can separate fully matched, partially matched, unmatched, and skipped records so finance teams can review differences clearly and focus on exceptions.

Can the same Purplle reconciliation setup be reused?

Yes. Once configured, the same reconciliation can be reused for future periods instead of rebuilding the workflow every time.

Can Purplle fee verification be automated?

Recurring workflows can be automated through email, SFTP, or API-based data input, along with scheduled reconciliation runs and downloadable reports.