Popular reconciliation template
Sales vs Zepto Reconciliation
Reconcile internal sales records with Zepto reports to match orders, SKUs, delivered quantities, cancellations, returns, refunds, commissions, platform fees, discounts, deductions, taxes, settlements, bank credits, and open items in one structured workflow.
View demo reportReconcile internal sales with Zepto reports
Zepto reports can include order-level, SKU-level, payout-level, return, refund, fee, discount, deduction, and tax information that may not directly match internal sales or ERP records. Cointab helps bring these records into one clear reconciliation report.
The Sales vs Zepto Reconciliation template helps finance, marketplace operations, eCommerce, retail, D2C, and accounting teams compare internal sales records with Zepto reports.
This helps teams answer questions such as:
- Which internal sales orders are correctly present in Zepto reports?
- Which Zepto orders are missing from internal sales or ERP records?
- Which orders, SKUs, invoices, quantities, and values differ between internal records and Zepto?
- Which Zepto orders were cancelled, returned, refunded, short-delivered, adjusted, or deducted?
- Which commissions, platform fees, service fees, fulfilment fees, logistics fees, advertising fees, penalties, or claims explain the payout difference?
- Which Zepto discounts, coupons, promotional deductions, seller-funded discounts, or platform-funded discounts need review?
- Which Zepto settlements were received in the bank?
- Which Zepto payouts were short-paid, delayed, overpaid, reversed, or adjusted?
- Which items need Zepto follow-up, ERP correction, marketplace operations review, finance review, or accounting correction?
This template is useful for D2C brands, FMCG brands, grocery sellers, retail brands, marketplace sellers, Zepto sellers, quick commerce teams, eCommerce finance teams, marketplace operations teams, controllers, CFOs, and accounting firms that need a repeatable Sales vs Zepto reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around common internal sales reports, Zepto order reports, Zepto settlement reports, payout reports, commission files, return reports, refund files, deduction reports, bank statements, ERP exports, and supporting eCommerce finance data.
| Data source | Example records |
|---|---|
| Internal Sales / Order Report | Used as the internal source-of-truth report containing order IDs, invoice numbers, customer IDs, SKU details, product names, order dates, dispatch dates, delivered quantities, gross sales, discounts, taxes, net sales, cancellation status, return status, and accounting status. |
| Zepto Order Report | Used as the Zepto-side order report containing Zepto order IDs, item IDs, SKU codes, product details, order dates, delivery status, accepted quantities, cancelled quantities, returned quantities, item value, discounts, tax values, and order status. |
| Zepto Settlement / Payout Report | Used to compare settlement IDs, payout dates, gross sales, commissions, platform fees, discounts, penalties, refunds, claims, taxes, deductions, net settlement amounts, and payout status. |
| Zepto Commission / Fee Report | Optional, but useful where Zepto commission, platform fees, marketplace fees, service fees, fulfilment fees, logistics fees, advertising fees, payment fees, packaging fees, or subscription fees need to be reconciled. |
| Zepto Returns / Refunds Report | Optional, but useful where customer returns, refund adjustments, quality issues, damaged goods, cancelled orders, return-to-origin, expired items, short delivery, or Zepto-side refund claims affect settlement. |
| Zepto Deductions / Claims Report | Optional, but useful where Zepto penalties, short delivery claims, inventory mismatch claims, service-level penalties, damage deductions, expired stock deductions, promotional deductions, and dispute adjustments need to be reviewed. |
| Inventory / Dispatch Report | Optional, but useful where dispatched quantity, delivered quantity, accepted quantity, rejected quantity, returned quantity, and stock movement need to be compared with Zepto records. |
| Tax Report | Optional, but useful where GST, VAT, TCS, TDS, tax collected, tax deducted, taxable value, tax reversal, and invoice-level tax values need to be compared. |
| Bank Statement | Optional, but useful where Zepto payouts need to be compared with actual bank statement credits. |
| ERP / Accounting Export | Optional, but useful if sales, customer receivables, Zepto receivables, commission expenses, deductions, tax entries, refunds, settlements, bank entries, and accounting postings are maintained in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another accounting system. |
| Supporting Data | Optional supporting files can be used for order mapping, SKU mapping, Zepto mapping, store mapping, warehouse mapping, invoice mapping, settlement mapping, tax mapping, GL mapping, entity mapping, or other enrichment. |
What Cointab matches in Sales vs Zepto reconciliation
Cointab compares internal sales records with Zepto reports across orders, SKUs, quantities, values, commissions, discounts, refunds, returns, deductions, taxes, payouts, bank credits, and optional accounting data.
Internal sales and Zepto orders
Match internal sales orders with Zepto order records.
Order and invoice references
Compare internal order IDs, Zepto order IDs, invoice numbers, item IDs, SKU codes, product IDs, store IDs, warehouse IDs, shipment references, and settlement references.
SKU and quantity details
Compare SKU codes, product names, ordered quantity, invoiced quantity, dispatched quantity, accepted quantity, delivered quantity, cancelled quantity, returned quantity, and adjusted quantity.
Sales values
Compare gross sales, item value, net sales, taxable value, discount amount, tax amount, customer paid amount, Zepto reported value, and expected receivable.
Zepto commissions and fees
Match commission, platform fee, service fee, fulfilment fee, logistics fee, payment fee, advertising fee, packaging fee, and other Zepto commercial deductions.
Discounts and promotions
Compare seller-funded discounts, Zepto-funded discounts, coupon discounts, promotion deductions, marketing support, freebie adjustments, and campaign-level discounts.
Returns, refunds, and cancellations
Match customer returns, Zepto refunds, cancellation reversals, refund adjustments, RTO, damaged goods, expired stock, short-delivery claims, and quantity differences.
Deductions and penalties
Compare penalties, claims, short delivery deductions, service-level deductions, damage deductions, inventory mismatch deductions, dispute adjustments, and other Zepto charges.
Settlement and bank credits
If settlement and bank files are included, compare Zepto payout values with actual bank statement credits.
Accounting postings
If ERP or accounting data is included, compare sales revenue, Zepto receivables, commissions, deductions, refunds, tax entries, bank receipts, and journal postings.
Common Sales vs Zepto reconciliation exceptions
Cointab helps finance teams focus on Zepto differences instead of manually reviewing every order, SKU, commission, refund, return, deduction, and payout line.
Internal sale not found in Zepto report
An internal sale or invoice exists, but no matching Zepto order is found.
Zepto order not found internally
A Zepto order appears without a matching internal sales or ERP record.
Order amount mismatch
The order reference matches, but internal sales value and Zepto-reported order value differ.
SKU mismatch
Order-level references match, but SKU code, product name, item ID, or product mapping differs.
Quantity mismatch
Internal quantity, Zepto quantity, delivered quantity, accepted quantity, returned quantity, or cancelled quantity does not match.
Cancellation mismatch
An order is cancelled on one side but shown as delivered, invoiced, payable, or settled on the other side.
Return mismatch
A return or refund appears in the Zepto report but is missing or recorded differently internally.
Refund mismatch
A customer refund, Zepto refund adjustment, cancellation refund, or settlement refund differs across reports.
Commission mismatch
Zepto commission, service fee, fulfilment fee, logistics fee, payment fee, or commercial fee differs from expected values.
Discount mismatch
Seller-funded discount, Zepto-funded discount, coupon discount, promotional deduction, or campaign support amount does not match.
Deduction mismatch
Zepto deductions, short delivery claims, damaged goods deductions, service-level penalties, expired inventory charges, or dispute adjustments require review.
Tax mismatch
GST, VAT, TCS, TDS, taxable value, tax collected, tax deducted, or tax reversal differs across internal and Zepto reports.
Settlement mismatch
Expected Zepto receivable does not match net settlement after commissions, discounts, refunds, taxes, penalties, and deductions.
Bank credit mismatch
The Zepto settlement report shows payout, but the actual bank credit is missing, delayed, short, excess, or posted in another period.
Duplicate order
The same order ID, Zepto order ID, invoice number, SKU, customer, amount, or settlement line appears more than once.
Wrong store or platform allocation
An order, refund, deduction, payout, SKU, or invoice is mapped to the wrong platform, store, city, warehouse, entity, GL account, or business unit.
Missing or unclear reference
Order ID, Zepto order ID, invoice number, SKU, item ID, settlement ID, payout reference, UTR, or narration is missing, incomplete, or inconsistent.
Skipped record
A row cannot be reconciled because required data is missing, invalid, duplicate, incomplete, or unusable.
How this ready-made reconciliation works
Cointab pre-configures the workflow so your team does not need to rebuild the Sales vs Zepto reconciliation setup every period.
Select the template
Choose Sales vs Zepto from popular reconciliations.
Select the period
Choose the day, week, month, quarter, order cycle, payout cycle, settlement cycle, financial year, lifetime period, or custom period you want to reconcile.
Upload internal sales and Zepto reports
Upload the internal sales report, Zepto order report, and any required settlement, payout, commission, return, refund, deduction, inventory, tax, bank, ERP, or supporting files.
Validate file format
Cointab checks whether the uploaded files match the expected structure and highlights missing or incorrect columns.
Run reconciliation
Cointab applies predefined data preparation and matching logic for sales, Zepto order, SKU, settlement, commission, refund, return, deduction, tax, bank, and accounting data.
Review output
View fully matched, partially matched, unmatched, refunded, returned, deducted, and skipped records.
Download or automate
Download the Excel report, or automate future data input and output through email, SFTP, or APIs.
Structured matching first, AI assistance for difficult cases
Cointab applies structured reconciliation logic first, then uses AI to help with difficult open records where fixed rules are not enough.
Structured matching
Structured matching can use:
Matching scenarios
One-to-one
One internal sales order matches one Zepto order.
One-to-many
One internal order maps to multiple Zepto item lines, SKU lines, fee lines, refund lines, return lines, deduction lines, tax lines, or settlement entries.
Many-to-one
Multiple internal orders are grouped into one Zepto payout, settlement batch, bank credit, or accounting entry.
Many-to-many
Multiple internal sales records, Zepto order records, commission lines, return lines, refund lines, deduction lines, settlement entries, and bank entries are grouped and compared together.
Partial matching
Identifiers match, but sales value, quantity, discount, tax, commission, refund, deduction, settlement value, or status differs.
SKU-level matching
Order-level and SKU-level quantities, values, discounts, returns, refunds, and taxes are compared together.
Settlement-level matching
Orders, commissions, discounts, refunds, returns, penalties, taxes, deductions, settlement IDs, payout values, and bank credits are compared together where required.
Platform-level matching
All orders, deductions, refunds, returns, settlements, and bank credits for Zepto, a store, city, or business unit are grouped and compared.
Net and contra matching
Sales, cancellations, returns, refunds, commissions, discounts, platform fees, penalties, claims, tax deductions, settlement adjustments, and bank credits are netted where required.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- References are incomplete
- Order IDs are missing or formatted differently
- Zepto order IDs are embedded inside narration fields
- SKU names differ across internal and Zepto files
- Product codes are mapped differently
- One order has multiple SKU-level Zepto lines
- One settlement contains many orders and deductions
- Refunds or returns do not clearly link to original order lines
- Zepto deductions are described inconsistently
- Settlement narration is messy
- Bank narration is unclear
- Amounts require business context
- Multiple possible matches exist
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.
Audit-ready Sales vs Zepto reconciliation reports
Cointab gives your team a clear report showing which internal sales, Zepto order, SKU, return, refund, deduction, settlement, bank, and accounting records matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Internal sales and Zepto records where identifiers, quantities, statuses, and amounts match.
Partially matched
Records where identifiers match but sales value, SKU value, quantity, discount, tax, commission, refund, deduction, or settlement amount differs.
Unmatched in internal sales
Zepto orders or settlement entries that do not clearly match internal sales records.
Unmatched in Zepto report
Internal sales records that do not clearly match Zepto records.
SKU and quantity differences
Records where SKU mapping, item quantity, accepted quantity, delivered quantity, returned quantity, or cancelled quantity requires review.
Commission and fee differences
Records where Zepto commission, service fee, fulfilment fee, logistics fee, payment fee, advertising fee, or other commercial fee requires review.
Refund and return differences
Records where customer refunds, returns, cancellation reversals, refund adjustments, or return quantities require review.
Discount differences
Records where seller-funded discount, Zepto-funded discount, coupons, promotions, or campaign deductions require review.
Deduction and claim differences
Records where penalties, short delivery claims, damage claims, inventory mismatch deductions, expired stock charges, or dispute adjustments require review.
Tax differences
Records where GST, VAT, TCS, TDS, taxable value, tax collected, tax deducted, or tax reversal requires review.
Settlement and bank differences
Records where settlement amount, payout date, settlement ID, UTR, bank credit, or payout status requires review.
Accounting differences
Records where sales revenue, Zepto receivable, commission expense, deduction expense, tax entry, refund entry, bank posting, or journal entry requires review.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Order-level filters
- SKU-level filters
- Zepto store filters
- City-level filters
- Settlement-level filters
- Refund and return filters
- Deduction filters
- Difference amounts
- Zepto payout view
- Matched transaction drill-down
- Manual match
- Undo manual match
- Excel export
- Audit-friendly output
Automate recurring Sales vs Zepto reconciliation
Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.
Bring data into Cointab
Data can be received or pulled through:
Run automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Matched sales orders
- Matched Zepto orders
- Matched SKU lines
- Matched settlement records
- Matched bank credits
- Unmatched internal sales records
- Unmatched Zepto orders
- Order amount differences
- SKU quantity differences
- Commission differences
- Discount differences
- Return differences
- Refund differences
- Deduction differences
- Claim differences
- Tax differences
- Settlement differences
- Bank credit differences
- Wrong store allocation records
- Timing differences
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View a Sales vs Zepto demo report
See how Cointab presents Sales vs Zepto output with matched, partially matched, refunded, returned, deducted, unmatched, and skipped records.
Sales vs Zepto Demo
Explore a sample report showing internal sales, Zepto orders, SKU lines, commissions, discounts, returns, refunds, deductions, taxes, settlement payouts, bank credits, and open items.
View demo reportExplore related quick commerce and marketplace reconciliations
Cointab supports other quick commerce, marketplace, sales, payment gateway, bank, refund, return, books, ERP, and finance reconciliation workflows.
Sales vs Quick Commerce Platform
Reconcile internal sales records with quick commerce platform reports across orders, payouts, commissions, discounts, refunds, returns, deductions, and settlements.
View templateBook vs Zepto Quick Commerce Reconciliation
Reconcile books or ERP records with Zepto quick commerce reports across sales, payouts, deductions, refunds, returns, taxes, and bank credits.
View templateSales vs Blinkit
Reconcile internal sales records with Blinkit reports across orders, SKUs, commissions, discounts, returns, refunds, deductions, and settlements.
View templateMarketplace Sales vs Settlement
Reconcile marketplace sales with settlement reports across commissions, fees, returns, refunds, deductions, and payouts.
View templateSales vs Payment Gateway
Reconcile internal sales records with payment gateway transactions across successful payments, failed payments, refunds, and gateway fees.
View templateBank Statement vs Books
Compare bank statement entries with accounting or books records.
View templateBuilt for teams reconciling sales with Zepto reports
This template is useful for teams that regularly reconcile internal sales, Zepto orders, SKU quantities, commissions, discounts, returns, refunds, deductions, settlement payouts, bank credits, and accounting records.
D2C brands
For D2C brands selling on Zepto and reconciling orders, commissions, discounts, refunds, returns, deductions, and payouts.
FMCG brands
For FMCG businesses reconciling SKU-level Zepto sales, quantity movement, platform deductions, promotions, claims, taxes, and settlements.
Grocery brands
For grocery and food brands reconciling Zepto sales, returns, expired stock deductions, short delivery claims, promotions, and payouts.
Retail brands
For retail brands reconciling Zepto sales with ERP records, inventory reports, settlement files, and accounting ledgers.
Marketplace sellers
For sellers managing high-volume Zepto orders and needing clear payout, deduction, return, and refund visibility.
eCommerce finance teams
For teams preparing recurring Zepto reconciliation reports for daily review, month-end close, reporting, and audit.
Marketplace operations teams
For teams reviewing Zepto deductions, claim disputes, SKU mismatches, return differences, and settlement follow-ups.
Inventory teams
For teams reviewing dispatched quantity, accepted quantity, returned quantity, stock deductions, and Zepto-reported quantity differences.
Accounting teams
For teams reconciling sales revenue, Zepto receivables, commission expenses, deductions, refunds, tax entries, bank credits, and journal postings.
Controllers
For controllers who need visibility into settlement gaps, Zepto deductions, refund differences, tax mismatches, SKU-level issues, and bank posting gaps.
CFOs
For finance leaders who want stronger control over Zepto revenue, platform receivables, deduction leakage, payout accuracy, accounting accuracy, and audit readiness.
Accounting firms
For CA, CPA, or outsourced accounting teams handling eCommerce, D2C, FMCG, retail, marketplace, Zepto, and quick commerce reconciliation for multiple clients.
Trusted by teams handling Zepto reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across sales systems, Zepto, quick commerce platforms, marketplaces, payment gateways, banks, inventory systems, books, ERP systems, and internal systems.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
Sales vs Zepto FAQs
Start Sales vs Zepto Reconciliation
Use Cointab's ready-made Sales vs Zepto reconciliation workflow to match orders, SKUs, commissions, discounts, returns, refunds, deductions, taxes, payouts, bank credits, accounting postings, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported