FirstCry Reconciliation for Marketplace Sellers

FirstCry reconciliation helps marketplace sellers compare their internal sales records with marketplace settlement, payout, fee, and return data. For finance teams, the challenge is rarely just matching order values. It is also about tracking commissions, shipping deductions, refunds, promotions, chargebacks, and delayed settlements across multiple reports.

Cointab helps teams handle this as a structured reconciliation workflow. Users upload the required files, map fields once, run reconciliation, and review fully matched, partially matched, unmatched, and skipped transactions in an audit-ready report.

Why FirstCry reconciliation is difficult

Marketplace reconciliation becomes time-consuming when multiple charges and adjustments appear between sale and settlement. Common issues include:

• Commission deductions that vary by product or category
• Refunds and returns that do not align cleanly with the original sale
• Settlement differences caused by fees, penalties, or promotional adjustments
• Missing payout references or delayed remittances
• Multiple reports that need to be compared before the numbers can be trusted

Manual Excel checks can work for small volumes, but they become harder to audit as transaction counts grow. Repeated formulas, VLOOKUPs, and copy-paste checks also make it difficult to keep one consistent process across periods.

What Cointab reconciles for FirstCry sellers

Cointab is not limited to one report type. It can be used to compare the records you expect to be correct with the reports received from the marketplace.

Side A: your records

Side A typically includes internal or source-of-truth data such as:

• Sales report
• Order report
• Books or ERP export
• Revenue working file
• Internal settlement tracker

Side B: external marketplace records

Side B typically includes FirstCry-related external reports such as:

• Settlement report
• Payout report
• Refund report
• Return report
• Fee or commission statement
• Any other marketplace file used to confirm financial activity

This Side A / Side B model keeps the reconciliation transparent. Finance users can see exactly which data was compared and why a transaction matched or stayed open.

How the reconciliation workflow works

Cointab is designed for reusable reconciliation setup, not one-time spreadsheet checks.

1. Create a new FirstCry reconciliation or use a custom marketplace workflow.
2. Upload the required files on both sides.
3. Map key fields such as date, amount, and order or reference identifiers.
4. Add supporting data if needed, such as product mapping or fee lookup files.
5. Create derived columns when calculations are needed, such as net amount or cleaned references.
6. Run reconciliation manually or schedule it to run automatically.
7. Review the report and focus on exceptions.
8. Download the Excel report for review, audit, or follow-up.

If a file is missed, it can be uploaded later under the same reconciliation and the report can be refreshed.

What the matching engine can handle

FirstCry seller data often needs more than simple one-to-one matching. Cointab’s reconciliation engine supports structured matching logic across common marketplace scenarios, including:

• One-to-one matching
• One-to-many matching
• Many-to-one matching
• Many-to-many matching
• Net-to-net matching
• Partial matching
• Contra and grouped matching where relevant

The engine can also compare identifiers using rules such as equals, contains, and similar. This helps when marketplace references, order IDs, or settlement references appear in different formats across reports.

How AI helps in reconciliation

AI supports the reconciliation process in practical finance ways.

AI formula builder

If a finance user knows what needs to be calculated but does not want to write the formula manually, AI can help create Excel-style formulas for derived columns.

AI-assisted open-item analysis

After structured matching is complete, AI can review open transactions and help identify possible reasons for exceptions such as missing files, refunds, returns, fees, or differences in references.

AI reason and action analysis

For unresolved items, AI can help users understand:

• Why a transaction may be unmatched
• Whether a report may be missing
• Whether the difference could be explained by fees, refunds, or deductions
• What follow-up action may be needed

AI remains conservative. If the evidence is not strong enough, the transaction should stay open for review.

Reconciliation output finance teams can review

Once the run is complete, users can work from a clear dashboard rather than searching through spreadsheets.

The report includes:

• Total summary
• Fully matched transactions
• Partially matched transactions
• Unmatched transactions
• Skipped transactions
• Filters for deeper analysis
• Transaction-level detail
• Downloadable Excel output

This makes it easier to isolate only the exceptions that need attention instead of reviewing every row manually.

Fully matched

These are records where the order, reference, and amount match according to the configured logic.

Partially matched

These records are related, but the values do not align completely. For example, the order identifier may match while the settlement amount differs because of a fee, refund, or other deduction.

Unmatched

These are records present on one side but not found on the other side. For marketplace teams, unmatched records often point to missing settlements, unrecorded refunds, or data gaps.

Skipped

Skipped rows are visible so users can see what was excluded and why, such as invalid amounts, missing required fields, or unusable records.

Supporting data and derived columns

Marketplace reconciliation often needs lookup files and calculated fields before matching can begin.

Cointab supports optional supporting data for tasks such as:

• Product mapping
• Fee rate lookup
• Return data enrichment
• Store or SKU mapping
• Order metadata enrichment

Users can also create derived columns on both sides. Examples include:

• Clean order ID
• Net amount
• Refund amount as negative
• Normalized settlement reference
• Amount after fee

This helps teams prepare data once and reuse the setup in future periods.

Manual match and exception handling

Some transactions need human review even after structured matching and AI analysis. Cointab includes a manual match option so finance teams can match records when the business context is known but the data is incomplete.

This is useful when:

• A reference is missing
• A partner report is delayed
• Multiple items need to be grouped together
• A one-off exception needs audit-visible treatment

Manual matches are clearly marked so the reconciliation remains transparent.

Recurring FirstCry reconciliation with automation

For teams that reconcile regularly, Cointab can reduce repetitive work by automating parts of the workflow.

Automation can include:

• Receiving files through email, SFTP, or API
• Running reconciliations on a schedule
• Validating incoming file formats before processing
• Pushing output back to internal systems through email, SFTP, or API

This is useful for daily, weekly, monthly, or period-end marketplace operations where the same reconciliation setup is reused again and again.

Why finance teams use Cointab for marketplace reconciliation

Cointab is designed for teams that need control, clarity, and repeatability in financial reconciliation. For FirstCry sellers, that means:

• One shared workspace for finance and operations teams
• Reusable reconciliation setup for future periods
• Clear visibility into matched and unmatched items
• Audit-ready Excel reports for review and follow-up
• Better handling of fees, refunds, returns, and settlement differences
• Less dependency on manual spreadsheets

The result is a more structured reconciliation process that fits everyday finance operations instead of adding another Excel burden.

Common FirstCry reconciliation use cases

Typical use cases include:

• Sales vs settlement reconciliation
• Order vs payout reconciliation
• Fee and commission reconciliation
• Refund and return reconciliation
• Marketplace vs books reconciliation
• Internal sales report vs external marketplace report comparison

These workflows can be configured once and reused across future runs, which helps teams maintain consistency across reporting periods.

What a finance team should expect from the process

A good marketplace reconciliation workflow should make it easy to answer three questions:

1. What matched?
2. What did not match?
3. What needs action?

Cointab is built around that idea. It gives finance teams a structured way to compare marketplace records, review exceptions, and keep reconciliation reports available for future reference.