Internal Compressed Report vs Swiggy Report Reconciliation: A Complete Guide for Finance Teams

Internal compressed report vs Swiggy report reconciliation is the process of comparing a company’s internal consolidated or compressed sales report with the transaction report received from Swiggy.

For restaurant chains, QSR brands, cloud kitchens, and food businesses selling through Swiggy, the internal report may contain outlet-wise orders, sales, taxes, discounts, cancellations, refunds, and expected receivables. The Swiggy report may contain platform-side order values, commission deductions, delivery charges, packaging charges, discounts, cancellations, GST on fees, TDS, TCS, and final settlement values.

This reconciliation helps finance teams answer:

• Are all Swiggy orders recorded internally available in the Swiggy report?
• Are all Swiggy report entries supported by internal sales records?
• Do order values, taxes, discounts, cancellations, and refunds match?
• Are Swiggy commissions, fees, deductions, and settlements calculated correctly?
• Are outlet-wise and order-wise receivables accurate?
• Which records are missing, mismatched, duplicated, short-settled, or pending review?

For finance teams, this reconciliation supports food delivery receivable accuracy, outlet-wise sales validation, deduction review, settlement control, month-end close, and audit readiness.

What Is Internal Report vs Swiggy Report Reconciliation?

Internal report vs Swiggy report reconciliation compares the company’s internal order or sales records with Swiggy’s platform-side report.

Side A: Internal Compressed Report
This represents the business-side view. It may include outlet name, order ID, order date, sale value, tax amount, discount, cancellation value, refund value, payment mode, and expected receivable.

Side B: Swiggy Report
This represents the Swiggy-side view. It may include Swiggy order ID, restaurant ID, settlement ID, gross order value, customer discount, restaurant discount, commission, delivery fee, packaging fee, GST on fees, TDS, TCS, cancellation charges, refund adjustments, and net settlement value.

The goal is to confirm whether the internal sales records and Swiggy records show the same financial outcome for each order or settlement cycle.

Matching is usually based on:

• Swiggy order ID
• Internal order ID
• Outlet or restaurant ID
• Order date
• Settlement date
• Gross order value
• Tax amount
• Discount amount
• Cancellation amount
• Refund amount
• Commission amount
• Deduction amount
• Net settlement amount
• Payment reference

If the order reference, amount, tax, deduction, and settlement logic match across both sides, the transaction can be treated as reconciled. If the reference matches but the amount differs, it becomes a mismatch. If a record appears only on one side, it becomes an exception.

Why This Reconciliation Matters

Food delivery reconciliation is different from simple sales matching. Swiggy may deduct commission, delivery-related fees, packaging charges, cancellation charges, customer support adjustments, GST on fees, TDS, TCS, penalties, and other recoveries before settlement.

At the same time, internal systems may store daily outlet sales in a compressed or consolidated format. This means finance teams may need to compare detailed platform records with summarized internal records. Without proper reconciliation, differences can remain hidden at order level or outlet level.

Without reconciliation, finance teams may face issues such as:

• Internal sales not available in Swiggy records
• Swiggy orders missing in internal reports
• Outlet-wise sales differences
• Order amount mismatches
• Discount and tax differences
• Cancellations or refunds not adjusted correctly
• Excess commission or fee deductions
• Settlement value not matching expected receivable
• Duplicate orders or settlement entries
• Month-end close delays and audit queries

A structured reconciliation process helps finance teams validate Swiggy sales and settlements before closing receivables.

Reports Involved

Side A: Internal Compressed Report

The internal compressed report represents the company’s internal consolidated sales-side view.

Common fields may include:

• Internal order ID
• Swiggy order ID
• Outlet name or outlet code
• Restaurant location
• Order date
• Order status
• Gross sale value
• Discount amount
• Taxable value
• GST amount
• Net sale value
• Cancellation value
• Refund value
• Expected receivable
• Payment mode

This report shows what the company has recorded internally as food delivery sales, cancellations, refunds, and expected collections.

Side B: Swiggy Report

The Swiggy report represents the platform-side order and settlement view.

Common fields may include:

• Swiggy order ID
• Restaurant ID
• Outlet name
• Order date
• Settlement date
• Gross order value
• Customer discount
• Restaurant-funded discount
• Commission amount
• Platform fee
• Delivery charge
• Packaging charge
• Cancellation charge
• Refund adjustment
• GST on platform fees
• TDS amount
• TCS amount
• Net settlement amount
• Settlement reference

This report shows what Swiggy has recorded, deducted, adjusted, settled, or kept pending.

How Matching Typically Works

Internal compressed report vs Swiggy report reconciliation usually works by comparing order-level or outlet-level records with Swiggy’s transaction and settlement values.

A typical process looks like this:

1. The internal compressed report is uploaded.
2. The Swiggy report is uploaded.
3. Order IDs, outlet codes, dates, amount fields, tax fields, and settlement references are mapped.
4. Internal sales are matched with Swiggy order records.
5. Cancellations, refunds, and discount values are compared.
6. Swiggy commission, platform fees, GST on fees, TDS, TCS, and other deductions are reviewed.
7. Net settlement is compared with expected receivable.
8. Records are categorized as matched, partially matched, unmatched, or skipped.

For example:

• The internal report shows a Swiggy order of ₹850.
• The Swiggy report shows the same order with gross order value of ₹850.
• Swiggy deducts commission, taxes on fees, and applicable charges before settlement.
• If the deductions are valid and the net settlement calculation is correct, the order is reconciled.

Another example:

• The internal report shows an order as completed.
• The Swiggy report shows the same order as cancelled or refunded.
• This becomes a status or amount mismatch and should be reviewed.

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

If a Swiggy order exists but no internal record is found, it becomes a Swiggy-only exception.

Common Exceptions in Internal Report vs Swiggy Report Reconciliation

1. Internal Order Missing in Swiggy Report

This happens when the internal report contains a Swiggy order, but the Swiggy report does not show the same order.

Possible reasons include:

• Swiggy report period is incomplete
• Order ID format differs across systems
• Order was cancelled before platform reporting
• Internal file contains non-Swiggy orders
• Outlet mapping is incorrect
• Wrong Swiggy report was uploaded

This exception should be reviewed to confirm whether the order was actually recorded by Swiggy.

2. Swiggy Order Missing in Internal Report

This happens when the Swiggy report contains an order, but the internal compressed report does not show a matching entry.

Possible reasons include:

• Internal report export is incomplete
• Order sync failed
• Outlet mapping is missing
• Order was recorded under another outlet
• Order belongs to a different date range
• Manual correction is pending

This exception is important because it may indicate missing sales in internal records.

3. Order Amount Mismatch

Order amount mismatch occurs when the order appears on both sides, but the value differs.

Possible causes include:

• Discount treatment difference
• Tax calculation difference
• Packaging charge included on one side
• Cancellation or refund impact
• Rounding difference
• Wrong amount column selected
• Item-level adjustment not reflected internally

Amount mismatches affect sales reporting, receivable calculation, and settlement validation.

4. Discount Difference

Food delivery platforms may apply customer discounts, restaurant-funded discounts, platform-funded discounts, or promotional adjustments.

Common issues include:

• Internal report shows full order value while Swiggy shows discounted value
• Restaurant-funded discount not recorded internally
• Platform-funded discount treated incorrectly
• Discount reversed in a later settlement
• Promo adjustment linked to the wrong order

Discount differences should be reviewed separately from commission and fee deductions.

5. Cancellation or Refund Difference

Cancellations and refunds reduce the expected receivable.

Common issues include:

• Internal report shows completed order but Swiggy shows cancelled order
• Swiggy refund adjustment is missing internally
• Internal cancellation is not reflected in Swiggy
• Partial refund creates amount difference
• Refund appears in a later settlement cycle
• Refund linked to the wrong order

These differences should be reviewed before accepting settlement values.

6. Commission or Platform Fee Difference

Swiggy may deduct commission, platform fees, delivery-related fees, packaging charges, or other service charges.

Possible issues include:

• Commission charged at a different rate
• Platform fee not recorded internally
• Packaging charge treated incorrectly
• Fee charged on cancelled or refunded order
• GST on fee not mapped correctly
• Multiple fee lines grouped together

These deductions should be supported by Swiggy report details before posting them to books.

7. TDS, TCS, or GST Difference

Swiggy reports may include statutory deductions and tax-related values.

Possible issues include:

• TDS not recorded internally
• TCS amount differs from expectation
• GST on platform fees not mapped correctly
• Product tax amount differs from internal report
• Tax reversal missing for cancelled or refunded order
• Tax posted in another period

Tax differences are important for statutory reporting and audit support.

8. Settlement Amount Mismatch

Settlement mismatch occurs when the final amount settled by Swiggy does not match the expected receivable after valid deductions.

Possible causes include:

• Commission difference
• Refund adjustment
• Cancellation charge
• Prior-period recovery
• Outlet-level adjustment
• Tax deduction difference
• Bank settlement timing difference
• Manual recovery or penalty

Settlement mismatches should be traced back to order-level and deduction-level details.

9. Duplicate Order or Settlement Entry

Duplicates may appear in either report.

Examples include:

• Same internal order repeated
• Same Swiggy order repeated
• Same outlet transaction duplicated
• Same settlement reference repeated
• Duplicate cancellation or refund entry
• Duplicate file upload

Duplicates can overstate sales, refunds, deductions, or receivables if not identified.

10. Outlet Mapping Difference

For multi-outlet restaurant businesses, outlet mapping is a common source of reconciliation issues.

Possible causes include:

• Same outlet name written differently
• Restaurant ID missing internally
• Swiggy outlet mapped to wrong internal location
• Order posted under another outlet
• Consolidated internal report not split correctly
• Outlet code changed during the period

Outlet mapping differences should be corrected before final settlement review.

Why Manual Excel Reconciliation Is Difficult

Many finance teams reconcile internal food delivery reports and Swiggy reports manually in Excel.

The usual process includes:

1. Exporting the internal compressed report.
2. Downloading the Swiggy report.
3. Cleaning order IDs, outlet names, dates, and amount fields.
4. Matching internal records with Swiggy records.
5. Comparing gross sales, discounts, taxes, cancellations, refunds, deductions, and settlement values.
6. Reviewing unmatched and mismatched records.
7. Preparing exception reports for finance and operations teams.

This becomes difficult as order volumes and outlet counts increase.

Common Excel challenges include:

• Compressed internal data compared with detailed platform data
• Different order ID formats
• Outlet names not matching exactly
• Multiple fee and tax columns
• Refunds adjusted in later settlement cycles
• One settlement covering many orders
• Duplicate records missed
• Broken lookup formulas
• Manual copy-paste errors
• No clear audit trail

A structured reconciliation workflow reduces these risks and creates a repeatable process for every settlement cycle.

What a Good Internal vs Swiggy Reconciliation Process Should Include

A reliable process should include:

• Complete internal compressed report
• Complete Swiggy report
• Order-level matching
• Outlet-level mapping
• Date and settlement period validation
• Gross order value comparison
• Discount comparison
• Tax comparison
• Cancellation and refund matching
• Commission and fee review
• TDS, TCS, and GST comparison
• Net settlement validation
• Internal-only exception reporting
• Swiggy-only exception reporting
• Amount mismatch reporting
• Duplicate detection
• Audit-ready output

The output should clearly show which orders matched, which outlet-wise differences exist, which deductions were valid, and which records need follow-up.

How Cointab Helps

Cointab can help finance teams automate internal compressed report vs Swiggy report reconciliation by comparing internal food delivery records with Swiggy platform records in a structured workflow.

Finance teams can map order IDs, outlet names, restaurant IDs, date fields, amount fields, tax fields, fee fields, refund fields, deduction fields, and settlement references once and reuse the setup for future periods.

Cointab helps teams:

• Upload internal compressed reports and Swiggy reports
• Match internal sales with Swiggy order records
• Compare order values, discounts, taxes, cancellations, refunds, and settlements
• Validate commissions, fees, GST on fees, TDS, and TCS
• Identify fully matched transactions
• Highlight internal-only and Swiggy-only exceptions
• Show amount mismatches and outlet mapping issues
• Detect duplicate orders and settlement entries
• Download audit-ready Excel reports
• Reuse the workflow for recurring reconciliation

This reduces manual Excel work and gives finance teams better visibility into food delivery platform settlements and receivables.

Business Value

Internal compressed report vs Swiggy report reconciliation helps finance teams:

• Validate Swiggy marketplace sales
• Track outlet-wise receivables
• Identify missing or duplicate orders
• Confirm cancellations and refund adjustments
• Validate commissions and platform fees
• Improve settlement accuracy
• Reduce Swiggy payment disputes
• Support tax and audit review
• Speed up month-end close
• Reduce manual reconciliation work

It also helps finance, restaurant operations, marketplace operations, and accounting teams resolve order-level and outlet-level issues faster.

Best Practices

Finance teams should follow these best practices:

• Reconcile Swiggy orders and settlements regularly
• Use Swiggy order ID, outlet code, restaurant ID, and settlement reference wherever available
• Standardize outlet names before matching
• Review discounts separately from commissions and platform fees
• Match cancellations and refunds before validating net settlement
• Track timing differences separately from true mismatches
• Check duplicate orders, refunds, and settlement references
• Maintain period-wise reconciliation history
• Document manual corrections clearly

Conclusion

Internal compressed report vs Swiggy report reconciliation helps finance teams confirm whether food delivery sales, discounts, cancellations, refunds, commissions, taxes, settlements, and receivables are properly aligned.

Because this reconciliation depends on internal records, Swiggy records, order IDs, outlet mapping, discounts, tax fields, deductions, refunds, and settlement timing, manual Excel reconciliation can become slow and error-prone as order volumes grow.

With Cointab, finance teams can automate internal report vs Swiggy report reconciliation, reduce manual Excel work, identify missing or mismatched records faster, and generate audit-ready reports for review.

Start your 14-day free trial with Cointab and automate internal compressed report vs Swiggy report reconciliation without relying on manual Excel work. No credit card required.

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