Nykaa Fashion Marketplace Reconciliation

Brands selling on Nykaa Fashion often need to reconcile internal order data with marketplace payout, settlement, and bank records. Cointab gives finance teams a structured workflow to upload reports, map fields once, run reconciliation, and review matched, partially matched, unmatched, and skipped transactions in an audit-ready report.

What a Nykaa Fashion marketplace reconciliation workflow covers

Side A: your internal records

Side A contains the records your business expects to be correct. For a Nykaa Fashion workflow, this often includes internal sales exports, order reports, ERP data, receivables working files, and finance-led transaction summaries.

Side B: external marketplace records

Side B contains the records received from Nykaa Fashion and related external sources. This may include payout reports, settlement reports, and bank statements that show what was actually remitted.

Supporting data for enrichment

Some reconciliations also need supporting files before matching begins. These do not get reconciled directly, but they help prepare the primary data.

Typical supporting files can include:

• Product masters
• Fee or commission reference files
• Return or cancellation reports
• GST or tax mapping files
• Store or marketplace mapping files
• Customer or vendor reference files

How the reconciliation runs

1. Upload the required Side A and Side B files in CSV, XLS, or XLSX format.
2. Map the required fields such as date, amount, and order or payment reference.
3. Add optional supporting data if enrichment or lookup is needed.
4. Create derived columns when values need to be cleaned, combined, or calculated.
5. Run reconciliation manually or on a schedule.
6. Review the output by match status and exception type.
7. Download the Excel report or send the output to downstream systems.

This workflow keeps the reconciliation transparent. Finance users can see what data was used, what rules were applied, and where the differences remain open.

What finance teams typically compare

Order vs payout reconciliation

Many Nykaa Fashion workflows start with internal order data on one side and payout records on the other. Cointab matches the records by identifiers and amount logic, then highlights transactions that are fully paid, underpaid, overpaid, refunded, or still open.

Settlement vs bank reconciliation

Settlement reports show what should have been remitted, while the bank statement shows what actually reached the account. Comparing these two sides helps teams confirm that remittances were received correctly and understand differences caused by deductions, timing gaps, or missing entries.

Exception tracking

Not every transaction can be closed immediately. Some entries remain open because a reference is missing, the amount differs, a return has changed the payable value, or a file has not yet been received. Cointab keeps these exceptions visible so teams can focus on the unresolved items first.

Reconciliation result categories

Fully matched

Fully matched transactions are those where identifiers and amounts align according to the reconciliation logic. These are the cleanest records in the report and typically need no further action.

Partially matched

Partially matched transactions are related records where the identifier matches but the amount does not fully agree. This status is useful when the order or settlement is likely correct, but the difference needs review.

Unmatched

Unmatched transactions exist on one side but not the other. In a Nykaa Fashion workflow, that could mean an order is present in internal records but not in the payout report, or a remittance appears in the bank statement but not in the expected settlement file.

Skipped

Skipped records are rows that were not included in reconciliation because of file issues, missing required data, invalid values, or other configuration rules. Keeping skipped rows visible helps teams understand what was excluded and why.

Handling discrepancies and open items

Marketplace reconciliation is usually about more than just matching rows. Finance teams also need to understand why a difference exists.

Cointab helps review open items such as:

• Missing payouts
• Short payments
• Overpayments
• Refunds and reversals
• Fees and deductions
• Settlement timing differences
• Missing or late reports

When structured rules are not enough, AI can assist with open-item analysis and suggest possible reasons or actions. If the evidence is not strong enough, the item can remain unmatched rather than forcing a weak match.

Manual match for exceptions

Some discrepancies need human review. Cointab provides a manual match option for cases where the business context is known but the system cannot confidently match the transaction.

Manual matching is useful when:

• Identifiers are incomplete
• A report arrives in a different format
• A one-off exception needs review
• A partial match needs to be resolved by the finance team

Manual matches remain clearly marked so the reconciliation history stays auditable.

Why this helps marketplace finance teams

A structured Nykaa Fashion marketplace reconciliation workflow reduces repeat spreadsheet work and makes reconciliation easier to review.

Key benefits include:

• Less reliance on Excel formulas and repeated manual checks
• A reusable setup for future periods
• Clear separation of matched, partially matched, unmatched, and skipped records
• Faster review of open transactions and discrepancies
• Audit-ready Excel reports for internal review and follow-up
• Better visibility into order, payout, settlement, and bank differences

For finance teams, this also supports cleaner month-end and period-end close because the same workflow can be reused instead of rebuilt every cycle.

Automating recurring Nykaa Fashion reconciliations

Once the workflow is configured, Cointab can support recurring reconciliation runs without requiring the same manual effort every time.

Data can be received or pushed through:

• Email
• SFTP
• API

This makes it easier to run daily, weekly, or monthly marketplace reconciliation, depending on how often the reports are available. If a file is missed, the user can upload it under the same reconciliation and refresh the report.

Team collaboration and audit readiness

Marketplace reconciliation is rarely a one-person task. Controllers, accounting teams, marketplace operations, and audit teams may all need visibility into the same workflow.

Cointab supports team workspaces so multiple users can work in one shared environment with roles, access control, and reconciliation history. The dashboard keeps past runs available for reference, including status, run date, and report access.

That makes it easier to keep reconciliation transparent, reviewable, and ready for internal follow-up or audit review.

Common data issues in Nykaa Fashion reconciliation

A marketplace reconciliation workflow often needs to handle real-world data issues such as:

• Different naming conventions across reports
• Missing or delayed remittance files
• Settlement deductions that change the expected amount
• Return or cancellation adjustments
• Reference fields that need cleanup before matching
• Transactions that must be grouped or netted before comparison

Cointab is designed to support structured matching across these kinds of differences while still keeping the logic understandable to finance users.

When to use a custom Nykaa Fashion reconciliation

For Nykaa Fashion, the most practical setup is usually a custom reconciliation workflow. That is useful when your business needs to compare internal sales or order data against marketplace payout, settlement, and bank reports in a repeatable way.

A custom workflow lets you define:

• Which files belong on Side A and Side B
• Which columns are used for date, amount, and identifiers
• Whether supporting data should be merged in first
• Whether a derived column is needed for matching
• Which rules should drive the final reconciliation output

Once configured, the same setup can be reused for later periods without rebuilding the workflow from scratch.

FAQs

What reports are needed for Nykaa Fashion marketplace reconciliation?

Usually, teams compare internal order or sales data with Nykaa Fashion payout or settlement reports, and then verify the final remittance against the bank statement. Supporting files such as return reports or fee mappings can also help.

Can Cointab reconcile both order-to-payout and settlement-to-bank workflows?

Yes. The platform is designed to compare any two sides of financial or operational data, so both payment reconciliation and bank reconciliation can be handled within the same structured workflow.

What if one report is missing?

If a file was received late or missed during the original run, it can be uploaded under the same reconciliation and the report can be refreshed. That helps finance teams work with real-world reporting delays.

Can the same reconciliation be reused for future periods?

Yes. Once the Nykaa Fashion workflow is configured, it can be reused for future months or other periods by uploading the new files and running the reconciliation again.

Can exceptions be reviewed manually?

Yes. Cointab supports manual match for cases where business context is needed and the system or AI cannot confidently resolve the transaction.