Hopscotch Fee Reconciliation Software for Finance Teams

Hopscotch fee reconciliation helps finance teams and marketplace sellers compare internal order records with Hopscotch payment, debit note, and fee data. The goal is to confirm what was charged, what was settled, and where differences need review.

Cointab gives this process a structured workflow. Teams upload the relevant reports, map the required fields, run reconciliation, and review matched, partially matched, unmatched, and skipped transactions in one place. The result is a clearer view of fee deductions, settlement differences, and open items that need follow-up.

What Hopscotch fee reconciliation covers

Hopscotch fee reconciliation is not just about checking whether a commission was applied. It usually involves comparing several reports that together explain the full transaction lifecycle.

For finance teams, that can include:

• Order details from the internal sales or marketplace operations report
• Payment or settlement records from Hopscotch
• Debit notes or adjustment files for returns and cancellations
• Fee or commission verification data based on the expected rate structure
• Supporting lookup files such as SKU master, order metadata, or mapping files

This workflow helps teams see whether every order was settled correctly and whether any deductions, refunds, or fee differences need investigation.

Typical reports used in the workflow

Cointab supports CSV, XLS, and XLSX files. Teams can map the relevant header row, date column, amount column, and reference fields such as order ID, transaction ID, settlement ID, or SKU.

How Cointab handles Hopscotch fee reconciliation

Cointab is designed to make recurring reconciliation repeatable instead of rebuilding the same spreadsheet logic every month.

1. Upload and map the files

Users start by uploading the reports required for the reconciliation. Each file is mapped once so the system knows which fields to use for matching.

2. Add supporting data where needed

If the order report needs enrichment, teams can upload supporting files to look up missing values, merge datasets, or calculate a derived amount before reconciliation begins.

3. Create derived columns when business logic is needed

Some fee checks require calculated fields. For example, a team may want to compare an expected commission amount with the actual fee deducted.

Cointab supports derived columns, including AI-assisted formula creation, so finance users can create calculated fields without manually writing formulas from scratch.

4. Run reconciliation

Once the setup is ready, Cointab applies structured matching logic to compare Side A and Side B records. The engine supports common finance matching patterns, including one-to-one, one-to-many, many-to-one, many-to-many, and partial matching.

5. Review the reconciliation report

After the run completes, users can review the output in a report dashboard and filter transactions by status, amount differences, reference fields, and other criteria.

6. Handle open items

If the system cannot confidently resolve a transaction, the item remains open for review. Users can manually match records where the totals tally and the business context is clear.

What finance teams look for in the report

A Hopscotch fee reconciliation report usually separates transactions into clear categories so the team can focus on exceptions.

• Fully matched: The order and settlement records align as expected.
• Partially matched: The reference matches, but the amounts differ and need review.
• Unmatched: The record appears on one side but not the other.
• Skipped: The row was excluded because of missing data, invalid values, or another file issue.

This structure helps finance teams quickly identify whether an issue is caused by a missing file, a return or cancellation adjustment, a fee difference, or an internal data problem.

Common fee difference scenarios

Hopscotch fee reconciliation is useful when finance teams need to understand why a transaction does not tie out.

Common scenarios include:

• The fee charged is higher than expected
• The fee charged is lower than expected
• The settlement amount differs from the order value
• A return or cancellation affects the final amount
• The payment or reference identifier is incomplete
• A record exists in the order report but not in the settlement report
• A record exists in the settlement report but not in internal books

Instead of checking every row manually in Excel, teams can isolate only the exceptions that need investigation.

Why this matters for finance operations

Hopscotch fee reconciliation is often part of a wider monthly close or marketplace accounting workflow. A structured approach helps teams:

• Reduce repetitive spreadsheet work
• Standardize how fees and settlements are reviewed
• Keep an audit-ready record of matched and unmatched items
• Reuse the same reconciliation setup for future periods
• Bring late or missed files back into the same workflow and refresh the report
• Share a common workspace across finance and operations teams

For teams handling multiple marketplaces or multiple report types, the main advantage is consistency. The reconciliation setup can be reused, while the period or file inputs change.

Reusable workflow for recurring periods

Cointab supports recurring reconciliation runs for monthly, quarterly, yearly, or custom periods. Once the Hopscotch workflow is configured, teams can use the same setup again for future periods instead of repeating the configuration process.

That makes it easier to manage recurring fee checks, settlement reviews, and exception tracking across the financial year.

Reporting and audit readiness

Once reconciliation is complete, teams can download Excel-based reports for internal review, follow-up, or audit preparation. The report includes the reconciliation summary and transaction-level detail, which helps teams trace how each item was categorized.

This is useful when finance needs to explain fee differences, settlement gaps, or unresolved items to internal stakeholders or partner teams.

When a custom setup is useful

Hopscotch fee reconciliation is usually configured as a custom workflow because each business may use different source files, identifiers, and fee logic.

A custom setup is helpful when:

• The internal sales report has a unique format
• Multiple supporting files are required
• Fee calculation depends on SKU, category, or product mapping
• Returns, cancellations, or debit notes need to be included
• The team wants the workflow reused every period

With the setup in place, finance teams can move from manual file comparison to a repeatable reconciliation process that is easier to review and maintain.