Maccaron Sales vs Settlement Reconciliation: A Complete Guide for Finance Teams

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

For brands and sellers using Maccaron as a marketplace or sales channel, the sales report shows the order-level value recorded internally, while the settlement report shows the sales or payable value reported externally. These two reports need to be matched regularly to confirm whether sales have been recorded and settled correctly.

This reconciliation helps finance teams answer:

• Are all Maccaron sales present in the settlement report?
• Are all settlement entries linked to valid sales orders?
• Do GST-exclusive sales amounts match across both reports?
• Are order numbers captured consistently?
• Are sales dates aligned with internal order dates?
• Are old and new settlement formats both handled correctly?
• Which orders are missing, mismatched, duplicated, or pending review?

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

What Is Maccaron Sales vs Settlement Reconciliation?

Maccaron sales vs settlement reconciliation compares two sides of transaction data.

Side A: Internal sales report
This represents the seller’s internal sales records. It contains the order date, cleaned order number, and vendor invoice amount excluding GST.

Side B: Settlement reports
This represents settlement data received from the external channel. In this workflow, there are two settlement formats: the existing settlement format and a new settlement format.

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

Matching is mainly based on:

• Cleaned order number
• Settlement order number
• Vendor invoice amount excluding GST
• Sales price excluding GST
• Order date
• Sales date

Because the reconciliation compares GST-exclusive values, it is important that both sides use comparable amount fields.

Why This Reconciliation Matters

Marketplace and channel settlement data may not always match internal sales records directly. A seller may record an order internally on one date, while the settlement report may show the same order under a different sales date, amount field, or report format.

Without reconciliation, finance teams may face issues such as:

• Sales orders not found in settlement reports
• Settlement entries not found in internal sales data
• GST-exclusive amount mismatches
• Duplicate order records
• Old and new settlement format confusion
• Missing settlement files
• Incorrect receivable tracking
• Delayed month-end close
• Audit queries due to missing transaction support

Maccaron sales vs settlement reconciliation gives finance teams order-level visibility into which sales are matched and which require follow-up.

Reports Involved

Side A: Sales Report

The sales report represents the internal sales view.

Important fields include:

• Order date
• Cleaned order number
• Vendor invoice amount excluding GST

The cleaned order number is the main matching reference. The vendor invoice amount excluding GST represents the sales value expected to match with settlement-side values.

This report shows what the business expects to reconcile against settlement data.

Side B: Settlement Reports

The settlement side contains two report formats.

The first settlement report includes fields such as:

• Order number
• Sales date
• Sales price excluding GST

The new settlement format includes fields such as:

• Order number
• Sales date
• Sales price excluding GST or base sales price

Both formats need to be handled correctly so that orders are not missed or counted twice.

How Matching Typically Works

Maccaron sales vs settlement reconciliation usually works by comparing order number, amount, and date.

A typical matching flow looks like this:

1. The internal sales report is uploaded.
2. Settlement reports are uploaded.
3. Cleaned order numbers from the sales report are compared with order numbers in the settlement reports.
4. Vendor invoice amount excluding GST is compared with sales price excluding GST.
5. Internal order date is compared with external sales date.
6. Records are categorized as matched, partially matched, unmatched, or skipped.

For example:

• The internal sales report shows order ORD123 with vendor invoice amount excluding GST of ₹1,000.
• The settlement report shows the same order number with sales price excluding GST of ₹1,000.
• The transaction is treated as matched.

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

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

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

Why GST-Exclusive Amount Matching Is Important

This reconciliation uses GST-exclusive values on both sides.

The internal side uses vendor invoice amount excluding GST, while the settlement side uses sales price excluding GST or a similar GST-exclusive sales amount.

This matters because comparing GST-inclusive values with GST-exclusive values can create false mismatches.

Finance teams should confirm:

• Both sides are using GST-exclusive values
• Settlement values are not net of unrelated deductions
• The correct amount column is selected from each settlement format
• Tax components are not accidentally included on one side
• Old and new settlement formats are mapped consistently

Using the correct GST-exclusive fields improves match accuracy and reduces unnecessary exception review.

Common Exceptions in Maccaron Sales vs Settlement Reconciliation

1. Sales Order Missing in Settlement Report

This happens when an internal sales order is not found in either settlement report.

Possible reasons include:

• Settlement is pending
• Wrong settlement period was used
• Settlement report is incomplete
• Order number format differs between reports
• Order was cancelled or adjusted
• Order is present in another settlement format or batch

This exception should be tracked because the seller may be expecting settlement for the order.

2. Settlement Entry Missing in Sales Report

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

Possible reasons include:

• Internal sales report is incomplete
• Settlement relates to an older order
• Order number was cleaned differently
• Duplicate settlement entry exists
• Adjustment entry is included in settlement
• Wrong sales period was used

This exception should be reviewed because every settlement entry should ideally be supported by an internal sales record.

3. GST-Exclusive Amount Mismatch

Amount mismatches occur when the order number matches but the GST-exclusive values differ.

Possible causes include:

• Wrong amount column selected
• GST-inclusive and GST-exclusive values mixed up
• Marketplace-side adjustment
• Partial settlement
• Return or cancellation impact
• Discount or price correction
• Rounding difference
• Incorrect internal invoice amount

These differences directly affect revenue and receivable accuracy.

4. Order Date and Sales Date Difference

The internal report uses order date, while settlement reports use sales date.

Date differences can occur due to:

• Settlement reporting delay
• Order processing cutoff
• Marketplace sales recognition timing
• Return or adjustment cycles
• Month-end period differences
• Report generation timing

A date difference is not always incorrect, but it should be visible in the reconciliation output.

5. Duplicate Orders

Duplicates may appear in either the sales report or settlement reports.

Examples include:

• Same order number appearing twice in sales
• Same order appearing in both settlement formats
• Duplicate settlement file upload
• Correction entry not separated clearly
• Same order included across overlapping periods

Duplicates can overstate sales or settlements if not identified.

6. Report Format Differences

This workflow includes both an existing settlement report and a new settlement format.

Format differences may create issues such as:

• Different amount column names
• Different date fields
• Different order number formatting
• Same transaction appearing in both formats
• Missing records due to report transition
• Incorrect mapping of old and new columns

A good reconciliation process should map both formats separately while producing one clear reconciliation output.

Why Manual Excel Reconciliation Is Difficult

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

The typical process includes:

1. Exporting the internal sales report.
2. Downloading settlement reports.
3. Cleaning order numbers.
4. Selecting GST-exclusive amount fields.
5. Matching order numbers using lookup formulas.
6. Comparing invoice amount with settlement sales price.
7. Checking old and new settlement formats.
8. Preparing an exception report.

This becomes difficult as order volumes increase or settlement report formats change.

Common Excel challenges include:

• Wrong amount field selected
• Cleaned order numbers not applied consistently
• GST-inclusive and GST-exclusive values mixed
• Duplicate records missed
• Settlement formats combined incorrectly
• Broken lookup formulas
• Manual copy-paste errors
• No clear audit trail

A structured reconciliation workflow reduces these risks.

What a Good Maccaron Sales vs Settlement Reconciliation Process Should Include

A reliable reconciliation process should include:

• Correct internal sales report selection
• Complete settlement report coverage
• Separate mapping for old and new settlement formats
• Clean order number matching
• GST-exclusive amount comparison
• Order date and sales date visibility
• Sales-only exception reporting
• Settlement-only exception reporting
• Amount mismatch reporting
• Duplicate detection
• Audit-ready output

The output should clearly show which orders matched, which are missing, and which require follow-up.

How Cointab Helps

Cointab can help finance teams automate Maccaron sales vs settlement reconciliation by comparing internal sales records with multiple settlement report formats.

Finance teams can map order numbers, GST-exclusive amount fields, and date fields once and reuse the same setup for future periods.

Cointab helps teams:

• Upload sales and settlement reports
• Match cleaned order numbers with settlement order numbers
• Compare vendor invoice amount excluding GST with sales price excluding GST
• Handle old and new settlement formats
• Identify fully matched orders
• Highlight amount mismatches
• Show sales-only and settlement-only exceptions
• Review skipped or invalid records
• Download audit-ready Excel reports

This reduces manual Excel work and helps finance teams identify settlement differences faster.

Business Value

Maccaron sales vs settlement reconciliation helps finance teams:

• Validate marketplace settlement accuracy
• Improve revenue and receivable tracking
• Identify missing or delayed settlements
• Detect GST-exclusive amount differences
• Avoid duplicate settlement reporting
• Reduce month-end close effort
• Strengthen audit documentation
• Reduce manual reconciliation work

It also helps finance teams follow up on settlement differences with order-level evidence.

Best Practices

Finance teams should follow these best practices:

• Reconcile sales and settlement reports regularly
• Use cleaned order number as the primary matching reference
• Compare GST-exclusive values consistently
• Map old and new settlement formats separately
• Review amount mismatches before closing the period
• Check for duplicate order numbers
• Track sales-only and settlement-only exceptions
• Maintain period-wise reconciliation history
• Document manual corrections clearly

Conclusion

Maccaron sales vs settlement reconciliation helps finance teams confirm whether internal sales records match settlement reports.

Because this reconciliation depends on cleaned order numbers, GST-exclusive invoice values, GST-exclusive settlement values, order dates, sales dates, and multiple settlement formats, manual reconciliation can become slow and error-prone.

With Cointab, finance teams can automate Maccaron 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 Maccaron sales vs settlement reconciliation without relying on manual Excel work. No credit card required.

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