Tata CLiQ Sales vs Settlement Reconciliation: A Complete Guide for Finance Teams

Tata CLiQ sales vs settlement reconciliation is the process of comparing internal sales records with settlement reports received from Tata CLiQ.

For brands and sellers operating on Tata CLiQ, the sales report shows the order-level value recorded internally, while the settlement report shows the amount payable or paid by the marketplace. These two reports must be compared regularly to confirm whether marketplace sales are correctly settled.

This reconciliation helps finance teams answer:

• Are all Tata CLiQ sales reflected in settlement reports?
• Are all settlement entries linked to valid sales orders?
• Do sales amounts match seller payable amounts?
• Are GST-exclusive values compared correctly?
• Are settlement dates aligned with sales dates?
• Which orders are missing, mismatched, or pending settlement?

For finance teams, Tata CLiQ sales vs settlement reconciliation supports revenue accuracy, receivable tracking, marketplace payout validation, and audit readiness.

What Is Tata CLiQ Sales vs Settlement Reconciliation?

Tata CLiQ sales vs settlement reconciliation compares two sides of data.

Side A: Sales report
This represents the seller’s internal sales records. It contains order ID, sales date, and master price excluding GST.

Side B: Settlement reports
This represents marketplace settlement data. In this workflow, there are two settlement report formats: a settlement report and a 25–26 settlement report. These contain seller payable values, order ID, settlement date, and payment advice date.

The goal is to confirm whether each internal sales order is correctly reflected in marketplace settlement data.

Matching is mainly based on:

• Order ID
• Master price excluding GST
• Seller payable excluding GST or base value
• Sales date
• Settlement date or payment advice date

Because the values are compared excluding GST, finance teams need to ensure that the correct GST-exclusive fields are used on both sides.

Why This Reconciliation Matters

Marketplace settlements are not always equal to gross sales. Depending on the report and business process, settlement files may show seller payable values, deductions, adjustments, tax treatment, or payout timing.

Without reconciliation, finance teams may face issues such as:

• Sales orders not appearing in settlement reports
• Settlement entries without matching sales orders
• Seller payable values not matching sales values
• GST-exclusive amounts compared with GST-inclusive values
• Delayed settlement visibility
• Duplicate order entries
• Wrong settlement period selection
• Month-end close delays
• Audit queries due to missing support

Tata CLiQ sales vs settlement reconciliation helps finance teams verify order-level settlement accuracy instead of relying only on summary payout totals.

Reports Involved

Side A: Sales Report

The sales report represents the internal order-level record.

Important fields include:

• Order ID
• Date
• Master Price Ex GST

The order ID is the main matching reference. The master price excluding GST represents the sales value to be compared with settlement-side payable values.

This report shows what the seller expects to reconcile against marketplace settlements.

Side B: Settlement Reports

The settlement side contains two external settlement reports.

Important fields include:

• Order ID
• Seller Payable Positive Excl GST
• Seller Payable Positive Base
• Settlement Date
• Payment Advice Date

These fields show the marketplace-side payable amount and the relevant settlement or payment advice period.

Since there are two settlement report formats, both reports may need to be considered together to avoid missing settlement entries across periods or report versions.

How Matching Typically Works

Tata CLiQ sales vs settlement reconciliation usually works by comparing order ID, amount, and date.

A typical matching flow looks like this:

1. The sales report is uploaded.
2. Settlement reports are uploaded.
3. Sales order ID is compared with settlement order ID.
4. Master price excluding GST is compared with seller payable excluding GST or base value.
5. Sales date is compared with settlement date or payment advice date.
6. Records are categorized as matched, partially matched, unmatched, or skipped.

For example:

• Sales report shows an order ID with Master Price Ex GST of ₹1,000.
• Settlement report shows the same order ID with Seller Payable Positive Excl GST of ₹1,000.
• The transaction is treated as matched.

If the order ID matches but the amount differs, it becomes an amount mismatch.

If the sales order exists but no settlement entry is found, it becomes a sales-only exception.

If the settlement report contains an order ID not found in sales, it becomes a settlement-only exception.

Why GST-Exclusive Matching Is Important

This reconciliation uses GST-exclusive values such as Master Price Ex GST and Seller Payable Excl GST or base seller payable.

This is important because comparing GST-inclusive sales values with GST-exclusive settlement values can create false mismatches.

Finance teams should confirm:

• Whether both sides are excluding GST
• Whether marketplace payable values are net or gross
• Whether deductions are included in seller payable
• Whether tax values are reported separately
• Whether the same amount basis is used across both reports

Using the correct GST-exclusive fields improves reconciliation accuracy and reduces unnecessary exceptions.

Common Exceptions in Tata CLiQ Sales vs Settlement Reconciliation

1. Sales Order Missing in Settlement Report

This happens when a sales order exists in the internal sales report but is not found in any settlement report.

Possible reasons include:

• Settlement is pending
• Wrong settlement period was used
• Marketplace report is incomplete
• Order was cancelled or returned before payout
• Order ID format differs between reports
• Settlement is included in another report version

This exception should be tracked because the seller may be expecting a payout that has not yet been confirmed.

2. Settlement Entry Missing in Sales Report

This happens when the settlement report contains an order ID that is not found in the internal sales report.

Possible reasons include:

• Sales report is incomplete
• Settlement relates to an older order
• Order was recorded under another system
• Duplicate settlement entry exists
• Wrong sales period was used
• Adjustment entry is included in settlement

This exception needs review because settlement entries should be supported by order-level sales data.

3. Amount Mismatch

Amount mismatches occur when the order ID matches but the sales value and seller payable value differ.

Possible causes include:

• GST-inclusive and GST-exclusive values compared incorrectly
• Marketplace deduction or adjustment
• Partial settlement
• Return or cancellation impact
• Rounding difference
• Incorrect sales value
• Settlement value reported net of adjustments

Amount mismatches directly affect receivables, revenue reporting, and marketplace settlement control.

4. Settlement Timing Difference

The sales report uses order date, while settlement reports may use settlement date or payment advice date.

These dates may differ due to:

• Marketplace payout cycles
• Payment advice generation timing
• Order processing delay
• Return window impact
• Month-end cutoff
• Settlement posted in a later period

A timing difference may not always be an error, but it should be visible during reconciliation.

5. Duplicate Orders

Duplicate records may appear in either sales or settlement reports.

Examples include:

• Same order ID appearing twice in sales
• Same order settled twice
• Settlement report uploaded twice
• Order included in both settlement report formats
• Adjustment entry not separated clearly

Duplicate orders can overstate sales or payable values if not identified.

6. Report Version Differences

This workflow includes more than one settlement report format. If both formats are not handled carefully, finance teams may miss records or count the same order twice.

Report version differences may cause:

• Different amount column names
• Different date fields
• Different settlement period logic
• Duplicate order coverage
• Missing historical settlements

A good reconciliation process should map each report format separately while producing one clear output.

Why Manual Excel Reconciliation Is Difficult

Many finance teams reconcile Tata CLiQ sales and settlement reports manually in Excel.

The typical process includes:

1. Exporting the sales report.
2. Downloading settlement reports.
3. Cleaning order IDs.
4. Selecting the correct GST-exclusive amount fields.
5. Matching order IDs using lookup formulas.
6. Comparing sales value with seller payable value.
7. Reviewing missing and mismatched records.
8. Preparing an exception report.

This becomes difficult as order volumes increase.

Common Excel challenges include:

• Wrong amount column selected
• GST-inclusive and GST-exclusive values mixed up
• Settlement files not combined correctly
• Duplicate orders missed
• Broken lookup formulas
• Date format issues
• Manual copy-paste errors
• No clear audit trail

A structured reconciliation workflow reduces these risks.

What a Good Tata CLiQ Reconciliation Process Should Include

A reliable reconciliation process should include:

• Correct sales report selection
• Complete settlement report coverage
• Clean order ID matching
• GST-exclusive amount comparison
• Settlement date and payment advice date visibility
• Sales-only exception reporting
• Settlement-only exception reporting
• Amount mismatch reporting
• Duplicate detection
• Period-wise reconciliation history
• Audit-ready output

The output should clearly show which orders matched, which are pending, and which need marketplace follow-up.

How Cointab Helps

Cointab can help finance teams automate Tata CLiQ sales vs settlement reconciliation by comparing internal sales data with multiple marketplace settlement reports.

Finance teams can map order ID, date, and amount fields once and reuse the same workflow for future periods.

Cointab helps teams:

• Upload sales and settlement reports
• Match records using order ID
• Compare Master Price Ex GST with seller payable values
• Identify fully matched orders
• Highlight amount mismatches
• Show sales-only and settlement-only exceptions
• Review skipped or invalid records
• Download audit-ready Excel reports
• Reuse the setup for recurring marketplace reconciliation

This reduces manual Excel effort and improves visibility into marketplace payout differences.

Business Value

Tata CLiQ sales vs settlement reconciliation helps finance teams:

• Validate marketplace payouts
• Improve sales and receivable accuracy
• Track pending settlements
• Detect amount differences
• Avoid duplicate settlement reporting
• Improve month-end close
• Strengthen audit documentation
• Reduce manual reconciliation work

It also helps finance teams follow up with marketplace teams using order-level exception details.

Best Practices

Finance teams should follow these best practices:

• Reconcile sales and settlement reports regularly
• Use order ID as the primary matching reference
• Compare GST-exclusive values consistently
• Include all relevant settlement report formats
• Review amount mismatches separately
• Track sales-only orders by settlement period
• Check for duplicate order IDs
• Maintain period-wise reconciliation history
• Document manual adjustments clearly

Conclusion

Tata CLiQ sales vs settlement reconciliation helps finance teams confirm whether marketplace sales are correctly reflected in settlement reports.

Because this reconciliation depends on order IDs, GST-exclusive sales values, seller payable amounts, settlement dates, and payment advice dates, manual reconciliation can become slow and error-prone.

With Cointab, finance teams can automate Tata CLiQ sales vs settlement reconciliation, reduce manual Excel work, identify payout exceptions faster, and generate audit-ready reports for review.

Start your 14-day free trial with Cointab and automate Tata CLiQ sales vs settlement reconciliation without relying on manual Excel work. No credit card required.

Visit: https://www.cointab.net/