Hopscotch Marketplace Reconciliation With Cointab

Cointab helps Hopscotch sellers reconcile sales, settlements, payments, debit notes, and bank entries in one structured workflow. Instead of comparing spreadsheets manually, finance teams can upload the required reports, map key fields once, run reconciliation, and review matched, partially matched, unmatched, and skipped transactions in an audit-ready report.

For marketplace businesses, reconciliation is not limited to one report. A seller may need to compare internal sales data against Hopscotch invoices, payment summaries, settlement reports, debit notes, and bank credits. Cointab is built to handle that kind of recurring, multi-report workflow with reusable setup and clear exception tracking.

Why Hopscotch reconciliation becomes time-consuming

Marketplace reconciliation often involves several moving parts:

• Sales orders recorded in internal systems
• Invoice or payment reports received from the marketplace
• Settlement files showing deductions, fees, returns, or adjustments
• Debit notes for cancellations or reversals
• Bank statements showing the final credit received

When these files are checked manually, teams usually rely on Excel formulas, VLOOKUPs, filters, and repeated file comparisons. That makes the process slow and difficult to audit. It also makes it easy to miss partial payments, deductions, returns, or settlement differences.

Cointab replaces that manual work with a repeatable reconciliation workflow that is transparent enough for finance teams and flexible enough for marketplace operations.

What Cointab reconciles for Hopscotch sellers

A Hopscotch reconciliation workflow can use different records on Side A and Side B depending on the process being checked.

Side A: your internal records

Side A usually includes the records your business expects to be correct, such as:

• Internal sales report
• Order report
• ERP export
• Ledger data
• Receivable report
• Settlement working file

Side B: Hopscotch and other external records

Side B includes reports received from the marketplace or downstream systems, such as:

• Hopscotch invoice report
• Hopscotch payment report
• Settlement report
• Debit note report
• Bank statement

If needed, Cointab can also work with supporting files such as product masters, fee-rate files, return reports, SKU mapping files, or customer and vendor master data.

Typical reports used in Hopscotch marketplace reconciliation

Different teams may structure the workflow in different ways, but these are common inputs:

Cointab lets users map the required fields for each report, such as order ID, invoice number, settlement ID, transaction date, amount, or reference number.

How the reconciliation workflow works

A typical workflow follows a simple sequence:

1. Upload the Hopscotch and internal reports.
2. Map the required fields once.
3. Optionally upload supporting data for lookups or enrichment.
4. Create derived columns when a value needs to be cleaned, combined, or calculated.
5. Run reconciliation manually or on a schedule.
6. Review live progress while the engine processes the files.
7. Inspect matched, partially matched, unmatched, and skipped records.
8. Download the Excel reconciliation report.

This workflow is designed to be reusable. Once a Hopscotch reconciliation is configured, the same setup can be used for future periods with new files.

Matching logic for marketplace and settlement records

Cointab uses structured matching logic to compare records across both sides. This is useful when marketplace data does not line up one-to-one with internal records.

The reconciliation engine supports:

• One-to-one matching
• One-to-many matching
• Many-to-one matching
• Many-to-many matching
• Net-to-net matching
• Contra matching
• Partial matching

That matters in marketplace reconciliation because one order may be split across multiple adjustments, or multiple records may need to be grouped before the amounts can be compared.

The engine also supports different comparison styles, including exact matches, subset matches, and partial identifier matching. If a transaction cannot be matched confidently, it remains open rather than being forced into a weak match.

How Cointab helps with exceptions

Hopscotch sellers usually care most about the differences that need follow-up. Cointab separates exceptions clearly so finance teams can focus on what needs review.

Fully matched

Fully matched transactions are those where the relevant identifiers and amounts align according to the configured rules.

Partially matched

Partially matched transactions usually have a shared reference, but the amounts do not fully align. For example, the order may match, but the received amount may differ because of a fee, deduction, return, or short shipment adjustment.

Unmatched

Unmatched transactions appear on one side but not the other. For marketplace workflows, that could mean a sale that has not appeared in the settlement file, or a settlement credit that cannot be traced back to an internal order.

Skipped

Skipped records are excluded from reconciliation because they are incomplete, invalid, duplicated, or missing required fields. These records remain visible so the team understands why they were not processed.

AI support for reconciliation teams

Cointab uses AI in practical, finance-friendly ways.

AI formula builder

Users can describe a calculation in plain language and generate an Excel-style formula for a derived column. This is useful when Hopscotch reports need cleaning, normalization, or consolidation before matching.

AI-assisted open-item analysis

After structured rules run, AI can help analyze open items where the match is not obvious. It may help identify likely reasons for a difference, such as a fee, return, deduction, or missing file.

AI reason and action analysis

For unresolved items, AI can help finance teams understand what to investigate next. It can surface possible reasons for the mismatch and suggest whether another file may be missing, whether the partner should be reviewed, or whether an internal record needs correction.

Reusable setup for recurring periods

Hopscotch reconciliation is usually a recurring finance process. Cointab is designed so teams do not need to rebuild the workflow every month.

Once the setup is in place, users can:

• Select the reconciliation
• Choose the period
• Upload the new files
• Run reconciliation
• Review the report

Users can reconcile monthly, quarterly, yearly, lifetime, or custom periods depending on how the business tracks marketplace activity.

Automation for recurring marketplace workflows

For teams that do not want to upload files manually each time, Cointab can support automated data flow through email, SFTP, or API.

That means reports can be received automatically, validated, loaded into the correct reconciliation, and processed on a schedule. Output can also be pushed back to internal systems through email, SFTP, or API when needed.

This is useful for teams that want reconciliation to become part of daily finance operations rather than a one-time spreadsheet exercise.

Manual review, missed files, and audit readiness

Real-world reconciliation often involves late files or incomplete data. Cointab supports that workflow too.

• If a file was missed, it can be uploaded later under the same reconciliation.
• The report can then be refreshed.
• Users can manually match items that the system could not resolve.
• Manual matches are clearly marked for audit visibility.

The final output is designed to support finance review and audit preparation. Teams can download Excel reports with the reconciliation summary and transaction-level detail.

Why this matters for Hopscotch sellers

For sellers operating on Hopscotch, reconciliation is not just about checking totals. It is about understanding where money moved, what was deducted, what was delayed, and what still needs review.

Cointab helps finance teams do that with a structured workflow that is easier to repeat, easier to review, and easier to audit than spreadsheet-based matching.

By keeping the reconciliation process transparent, teams can reduce manual effort, focus on exceptions, and maintain cleaner reporting across sales, settlements, payments, and bank entries.